1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

1.7 Installation Problems Database Connection

Discussion in 'Installation Specific Questions' started by Wilfried Strecke, Dec 12, 2014.

  1. Wilfried Strecke

    Wilfried Strecke New Member

    Hello

    It's the first time I tried on Hotaru. I downloaded and followed the installation steps and everything went fine till after finishing step 2. Then a page appears (https://*****/hotaru/install/index.php?step=3) and says:

    Warning: mysqli::mysqli(): (HY000/2002): No such file or directory in *****/hotaru/libs/extensions/ezSQL/mysqli/ez_sql_mysqli.php on line 107 Warning: Error establishing mySQLi database connection. Correct user/password? Correct hostname? Database server running? in *****/hotaru/libs/extensions/ezSQL/mysqli/ez_sql_mysqli.php on line 112 Warning: Unexpected error while trying to select database in *****/hotaru/libs/extensions/ezSQL/mysqli/ez_sql_mysqli.php on line 157 Warning: mysqli::escape_string(): Couldn't fetch mysqli in *****/hotaru/libs/extensions/ezSQL/mysqli/ez_sql_mysqli.php on line 196

    yes,
    user/password is correct
    hostname is correct
    db server is running

    PHP-Version 5.4 (cannot roll back to 5.3)

    Thanks in advance for some help.
     
  2. shibuya246

    shibuya246 Hotaru Developer Staff Member Admin

    Is it possible that your server does not have the mysqli driver? The plain mysql driver has been deprecated on most servers for a while now
     
  3. Wilfried Strecke

    Wilfried Strecke New Member

    Thank you for your feedback. The information of the hosting shows that mysqli ist enabled.

    mysqli
    MysqlI Support: enabled
    Client API library version: mysqlnd 5.0.10

    Probably not the newest version (MySQL 5.1.59), but mysqli it's enabled...
     
  4. shibuya246

    shibuya246 Hotaru Developer Staff Member Admin

    I have 2 things we can try here

    First and maybe easiest lets try changing the setting for in the /config/settings.php file
    Code:
    define("DB_HOST", 'localhost');    
    to be
    Code:
    define("DB_HOST", '127.0.0.1');    
    the second suggestion which I am not personally familiar with is this one
    http://devin.la/blog/warning-mysqli-hy000-2002-no-such-file-or-directory

    I havent seen this error anywhere else and it does seem to be a mysqli error that is pre-connecting
    Would like to keep up with your challenge here and try to help. Let me know how you go with first 2 ideas
     
  5. valMETNG

    valMETNG Administrator Staff Member Admin

    I doubt this has anything to do with the problem, but I noticed you used https:// instead of http://. Can you also try reinstalling using http?
     
  6. Wilfried Strecke

    Wilfried Strecke New Member

    The first trial, changing 'localhost' to '127.0.0.1' did work for me. Amazing, I did not think that there is a difference. The installation worked perfectly now. Thank you for your help.

    Running the site with SSL (https instead of http) is not a problem, as long as the BASEURL is configured correctly, starting with https.

    I'll now have a closer look to the docs section. The 'welcome' and the 'faq' pages are not shown in the frontend. There seems something to be configured...
     
    valMETNG and shibuya246 like this.
  7. shibuya246

    shibuya246 Hotaru Developer Staff Member Admin

    Thats great news. I will add that to the instructions for those who may come across the same issue
     
  8. shibuya246

    shibuya246 Hotaru Developer Staff Member Admin

    you should be able to see them (if you have friendly urls) like

    http://YOURSITE/welcome
    http://YOURSITE/faq

    to edit them you can go direct to the content/pages folder and edit the existing ones, also add new ones

    if you have non-url friendly then it will be

    http://YOURSITE/index.php?page=welcome
     
  9. Wilfried Strecke

    Wilfried Strecke New Member

    Thank you, got it...
    ...Seems that I have to get familiar with the philosophy first.
     
    shibuya246 likes this.
  10. shibuya246

    shibuya246 Hotaru Developer Staff Member Admin

    Thanks. Happy to help with anything you need as you put your site together. Thanks for the positive review
     

Share This Page