Database Install doesn't recoginize database name
Sat, 04/07/2009 - 02:04
I have tried chaning the database name serveral times and have had no luck. I have tried the followin combinations:
$db_url = 'mysql://neomlsra_hjadmin:password@localhost/neomlsra_hj';
$db_prefix = '';
$db_url = 'mysql://neomlsra_hjadmin:CoreData#01@localhost/hj';
$db_prefix = 'neomlsra';
The screen comes back and tells me that I can login but it can't get to the database. I have made sure the username is associated with the database and that the rights are full for the user specified.
Any ideas on what I need to do to resolve?
Sun, 05/07/2009 - 19:04
#2
After reading your post I
After reading your post I decided to try again with a fresh install. Here are the steps I took:
- I created a new site in a subdirectory named echn under my root web site.
- I used Filezilla to upload the files to the echn directory.
- I navigated to the sites/default directory.
- I copied the default.settings.php file to settings.php file.
- I changed the permissions on the settings.php file to 666
- I changed the permissions on the sites and default directory to 777.
- I typed in the url for the site and receive the following error:
Fatal error: Maximum execution time of 30 seconds exceeded in /home/neomlsra/public_html/echn/includes/file.inc on line 891
If I modify the settings.php file myself and change the mysql database connection string I get the errors that I posted in the beginning which is that it never sees my database but can connect.
Just for grins I installed based Drupal in another directory and it works fine. I can get through the complete install without any issues. I also looked at the settings.php file under Drupal and really didn't see any differences.
What should I try next?
Mon, 06/07/2009 - 12:06
#3
Increase your PHP max_execution_time
Hi,
You are running into the max_execution_time PHP setting. For some reasons, some Windows platforms require a much longer setting, so I'd suggest setting that to about 10 minutes (ie. 600 seconds). And then please try again, (making sure your database is completely empty prior to installation).
Tue, 07/07/2009 - 10:12
#4
Thanks for the advise, it
Thanks for the advise, it worked. Changing the max_execution_time to 60 did the job. The site is now installed and I can begin to do the rest to setup my site.
Reards,
neomlsra
Hi,
You shouldn't have to make any manual changes to the settings.php file. You only need to create the database and a mysql user for ProsePoint to use, and then the web installer takes care of the rest. When you enter in the database credentials into the installer, that then makes the necesssary changes to the settings.php file.