URL to your eFiction: http://www.lotrgfic.com
Version of eFiction: 3.5
Have you bridged eFiction, if so with what?: no
Version of PHP: 5.2.9
Version of MySQL: 5.0.67-community-log
Have you searched for your problem: yes
If so, what terms did you try: I've looked through the Installation forum
State the nature of your problem: see below
Do you have a test account for us? no
I am attempting to help a friend install eFiction on her site. I have followed the directions in the Admin Manual and on the wiki and everything has gone fine ... until I go to the site url, input the database information, and click to continue. Then I get this:
Warning: include(version.php) [function.include]: failed to open stream: No such file or directory in /home2/lotrgfic/public_html/install/languages/en.php on line 2
Warning: include() [function.include]: Failed opening 'version.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home2/lotrgfic/public_html/install/languages/en.php on line 2
Warning: mysqli_connect() [function.mysqli-connect]: (42000/1044): Access denied for user 'REMOVED'@'REMOVED' to database 'REMOVED' in /home2/lotrgfic/public_html/includes/mysqli_functions.php on line 7
A fatal MySQL error was encountered.
ERROR: Failed to connect to the database!
I thought that perhaps I had forgotten a step or done something wrong, so I scrapped everything and started again and got the same error. I am copying and pasting my database information directly from the host, so I know that I am not mistyping that.
I'd appreciate any suggestions anyone has. I've been working on this for a while now and have run out of things to try to get it to work! 🙂
Many thanks,
Dawn
ETA: I tried the advice found here:
https://efiction.org/forums/index.php?topic=6700.0
but I am still getting stuck after clicking "Continue." This is the error I'm getting now:
Warning: mysqli_connect() [function.mysqli-connect]: (42000/1044): Access denied for user 'REMOVED'@'REMOVED' to database 'REMOVED'' in /home2/lotrgfic/public_html/includes/mysqli_functions.php on line 7
A fatal MySQL error was encountered.
ERROR: Failed to connect to the database!
Okay, first thing. EDIT YOUR POST. Remove the references to your database name and username. (Put stars or something.) You'll probably want to remove the references to you directory name and such too. This is very sensitive information and can compromise the security of your site.
As for your problem.... Line 7 of includes/mysqli_functions.php:
$mysql_access = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
This means that some of the information in your config.php file is probably wrong. You can't connect to the database, so something's off. You've obviously got a database username and password in there and it's finding it, so if those are correct, then the password's probably wrong. Double-check with the host or through cPanel and make sure.
Ack, thank you, Lyndsie, for catching that! I copied and pasted everything from the host into the installation form when it didn't work the first time. I assumed that I was typing something incorrectly. It still does not work. I also downloaded the config.php file from the site and checked that everything was correct in there; again, everything is fine. The database and user names, password, and sitekey all look as they should.
I also checked the host's support documents that they use localhost, and they do.
Hmm, what's interesting to me is that the first instance of $mysql_access in install.php isn't until line 903, after all the table stuff. Anyway, before trying to see if it's something more complicated, it might be worth it to double-check that your host gave you the right info. It did look like you formatted it properly, though, at least.
Thanks again, Lyndsie, for taking your time with my troubles. 🙂 I set up the database myself, so I know it's correct; I think I'll get in touch with the host in the morning and see if they can offer any solutions. The odd thing is that I have installed and run for three years now an eFiction site of my own with the exact same host and never had a problem.
Thanks again! 🙂
The webhost was able to offer assistance in getting the database working. Many thanks to all who took the time to consider and offer advice on our problem! We really appreciate it. 🙂
