[SOLVED] Installation Error: Database(Step 3)

[vangabond]

I keep getting an error when I try to set up the Database in Step 3 of the Installation process for version 1.2.5 of CMSMS. The error indicates that CMSMS could not connect to the Database and that I should check to see if the username and password are correct.

I am hosting through GoDaddy. I set up the database (mysql 5.0) and was able to specify my own username and password. (Godaddy has it that the Database Name and your Username are the same). When I enter this info into the Database Info fields in Step 3 of the CMSMS installation process, the error mentioned above is returned.

I notice that the Database Host Address field in the CMSMS installation defaults to 'localhost'. Does this need to be changed?

I notice that the Table Prefix field default in the CMSMS installation is 'cms_'. Does this need to be changed if the name of my table is, for example, 'davidtest1'?

About a month ago I was able to successfully install CMSMS version 1.2.4 without any problem, and I went through the same steps that I am going through now.  Unfortunately however, I am now attempting an install of 1.2.5 and I simply can not get Installation Step 3 to work.

One more question that may be related: During Step 1 of the installation process, CMSMS indicated that my PHP Memory Limit and Max Upload File Size should ideally be higher. CMSMS indicated that they are both above the minimum requirement, yet less than what is ideal. Can this have anything to do with the database troubles I am having with Step 3?

Any help would be greatly appreciated as I am obviously at a stand still until I can get the database properly setup.

[Pierre M.]

I notice that the Database Host Address field in the CMSMS installation defaults to 'localhost'. Does this need to be changed?

Who knows if not your database provider ? This is not CMSms specific. This is a question for your database provider support.

I notice that the Table Prefix field default in the CMSMS installation is 'cms_'. Does this need to be changed if the name of my table is, for example, 'davidtest1'?

You can set this how you want it.

Pierre M.

[vangabond]

still trying to resolve the issue. i have actually deleted all cmsms files in preparation for a fresh install. now, i first want to update my php.ini file to reflect the cmsms recommended php memory and upload size parameters. with regards to a table prefix, do i need one at all?

thanks.

[Dr.CSS]

With goduddy the Database Host Address is most likely not localhost, need to ask them if it didn't come up when DB was set up...

If you are using it, localhost, this may be why you are getting the error, cannot connect to DB...

The cms_ is what it will append, put in the front, to your DB tables which will be created when you install CMSMS, iirc, like so...

cms_additional_users

davidtest1 is most likely the name of the DB, when setting up DB it just makes space, names it, and user and password, CMSMS then fills the DB tables...

[vangabond]

mark - thanks again for your support. i am waiting to do a fresh install of cmsms until i can first resolve a php.ini issue. somehow my php.ini file was deleted. i contacted godaddy and they said that they were going to reload the root directory of my hosting account with a new, default php.ini file. this can take hours though (it still has not appeared after about 5 hours of waiting). i would have simply created the file myself, but i am not sure what parameters need to be in there so i figured i would wait for godaddy to reload the default file and then i would go in there and change the max upload limit from 8mg to whatever cmsms recomends (i forget off hand). once this is done i will then ftp all of the cmsms files to the server and see if i can finally make it through the installation process. if you (or anyone else) can advise me on creating a php.ini file from scratch that is appropriate for a godaddy linux account, that would be great. in any case, i thank you again for your interest and support. my limited experience with cmsms thus far has been pretty favorable -- at least, more favorable than with other cms offerings out there. i hope to get the newest release installed soon so that i can continue with the journey to become fluent with all of the product offerings.

[vangabond]

Ran through a fresh install and everything went through just fine. For those of you struggling with a similar issue, the resolution for me worked as follows:

In step 3 (setting up the database) of the CMSMS installation process, you must be sure to post the correct address in the Database Host Address field. The default value is 'Localhost'. This should be changed to the Host Name address associated with the GoDaddy database you have created for use with the CMSMS site. In your GoDaddy Hosting Control Center, navigate to your MySQL databases and then view the details for the CMSMS database that was created. The Host Name address will be listed in plain view. Copy that address and place it in the Database Host Address field on the CMSMS Database installation form.