SMF 1.1.2 Instilation error

dinodom000 · June 20, 2007, 12:20:01 AM

I am very new to forums and i came across an error i cant figure out.

Cannot connect to the MySQL database server with the supplied data.

If you are not sure about what to type in, please contact your host.
Can't connect to MySQL server on 'localhost' (10061)
Click here to try this step again.

I am very shure the information i put in is correct. Could someone help me out?

KGIII · June 20, 2007, 12:37:15 AM

Was it already working before you got this error?

dinodom000 · June 20, 2007, 12:41:41 AM

No it was not. I am instaling it for the first time.

dinodom000 · June 20, 2007, 12:51:35 AM

Still Fustrated

Anyone?

Sarge · June 20, 2007, 04:41:12 AM

Reupload all files from the Large Upgrade package (just make sure everything needed is there). After that, upload and run repair_settings.php:
What is repair_settings.php?

Triple check your database info. For some hosts you have to specify an IP address instead of localhost for the MySQL server -- contact your host about the proper info.

Also make sure that all paths are correct -- click on every "Recommended value" link and use www.yoursite.com instead of yoursite.com.

Remember to delete repair_settings.php from the server after clicking the Save button.

Does it help?

dinodom000 · June 20, 2007, 10:42:26 AM

Ok i ran repair_settings.php and confirmed all my settings.

Then i took it off my server. I tried to reinstall the forums and got the exact same error.

Didn't Help.

Any more ideas?

KGIII · June 20, 2007, 06:46:12 PM

Are you 100% certain the information is correct to connect to the database? Can you confirm this with your hosting company?

dinodom000 · June 20, 2007, 09:34:38 PM

Yes im very shure.

babjusi · June 20, 2007, 09:36:40 PM

Are you with a payed host or a free one?

dinodom000 · June 20, 2007, 11:10:21 PM

Payed. Its with EasyCgi.com

dinodom000 · June 23, 2007, 10:55:25 AM

Still need help.

Sarge · June 23, 2007, 11:08:12 AM

Can you post a link to phpinfo.php?
What is a phpinfo() file?

dinodom000 · June 23, 2007, 01:07:39 PM

http://www.runexus.com/phpinfo.php

Sorry about how long it takes. Im very new to this.

Thank you

dinodom000 · June 25, 2007, 09:34:28 AM

Someone help?

dinodom000 · June 25, 2007, 09:34:59 AM

Someone help?

babjusi · June 25, 2007, 09:55:43 AM

Quote from: dinodom000 on June 25, 2007, 09:34:59 AM
Someone help?

If you want pm all the info and I will try to take a look. But before you decide to trust me with the info have a look at this topic, as I am not a staff member here

http://www.simplemachines.org/community/index.php?topic=87130.0

dinodom000 · June 25, 2007, 11:33:22 AM

Sorry i dont think i can trust anyone else with the login info. But if you ask me questions i could give you answers. Provided i know how to do it.

babjusi · June 25, 2007, 11:35:53 AM

Quote from: dinodom000 on June 25, 2007, 11:33:22 AM
Sorry i dont think i can trust anyone else with the login info. But if you ask me questions i could give you answers. Provided i know how to do it.

No problem mate, I understand you. I would suggest that you follow KGIII''s advice a coupla posts above

dinodom000 · June 25, 2007, 11:54:58 AM

Sorry about that. Is there anything else you can do?

babjusi · June 25, 2007, 12:37:17 PM

Quote from: dinodom000 on June 25, 2007, 11:54:58 AM
Sorry about that. Is there anything else you can do?

I am afraid it isn''t anything else I can think of. If the info you filled in weren''t recognised by the smf installer, and you are sure you filled in the correct info, then double check with the host that you had indeeed the right info. Other than this nothing else comes to mind

KGIII · June 26, 2007, 04:47:11 AM

You can certainly trust Babjusi if you're in need of installation help.

I know... I showed him how to do it and also have seen his work in the past. If you can't follow the methods (which is NOT a bad thing) and have troubles beyond your means you will eventually need to ask for help and that help may require sharing a username and password. The trick is to ONLY allow access to those sections they NEED access to, not to post the information in public, and to ensure that you delete the users and passwords immediately after the work has been completed.

babjusi · June 26, 2007, 05:06:36 AM

Quote from: KGIII on June 26, 2007, 04:47:11 AM
You can certainly trust Babjusi if you're in need of installation help. I know... I showed him how to do it and also have seen his work in the past. If you can't follow the methods (which is NOT a bad thing) and have troubles beyond your means you will eventually need to ask for help and that help may require sharing a username and password. The trick is to ONLY allow access to those sections they NEED access to, not to post the information in public, and to ensure that you delete the users and passwords immediately after the work has been completed.

Thanks for the vote of confidence. And I wanted to thank you again for everything that you taught me. You are a great teacher bro.

KGIII · June 26, 2007, 05:57:48 AM

Not a problem. I wouldn't say so if it weren't true.

*chuckles*

I wouldn't have Babjusi out there writing code and setting database queries on their own just yet but, give him time - he'll be skilled enough to do that too at this rate. Soon he'll be asking questions I don't have the answer for.

babjusi · June 26, 2007, 06:02:38 AM

Quote from: KGIII on June 26, 2007, 05:57:48 AM
Not a problem. I wouldn't say so if it weren't true.

*chuckles*

I wouldn't have Babjusi out there writing code and setting database queries on their own just yet but, give him time - he'll be skilled enough to do that too at this rate. Soon he'll be asking questions I don't have the answer for.

Those things are still out of my leage, but with your help I think I will soon manage to learn them as well KGIII.

KGIII · June 26, 2007, 06:08:03 AM

Stop into the chat sometime. I'm not there now but, well, you know where to find me.

(Sorry for derailing the topic.)

babjusi · June 26, 2007, 06:09:31 AM

Sure thing bro

dinodom000 · June 28, 2007, 03:59:06 PM

Ok Babjusi i think ill trust you. the password i give will be changed after you are done. Is it ok if i private message you now?

babjusi · June 28, 2007, 04:06:37 PM

Quote from: dinodom000 on June 28, 2007, 03:59:06 PM
Ok Babjusi i think ill trust you. the password i give will be changed after you are done. Is it ok if i private message you now?

Sure dinodom000. Pm me the info and I can have a look, although I can not promise anything

babjusi · June 28, 2007, 04:52:51 PM

Your problem is, as I explained to you with the pm, that you have reached the number of databases allowed. When I tried to set up a database for you, I got the following message:

Error

You have reached your maximum number of MSSQL Databases

Please click here to purchase more.

Now I advice you to change the passwords you gave me

babjusi · June 28, 2007, 04:55:08 PM

P.s. I deleted the install.php file as well from the forum directory as it is a security risk to leave it there

Sarge · June 28, 2007, 05:13:36 PM

Quote from: babjusi on June 28, 2007, 04:52:51 PM
You have reached your maximum number of MSSQL Databases

MSSQL?

dinodom000 · June 28, 2007, 05:23:19 PM

I think it was a typo? But i think hes almost got it.

Sarge · June 28, 2007, 05:27:44 PM

Quote from: dinodom000 on June 28, 2007, 05:23:19 PM
I think it was a typo? But i think hes almost got it.

Just making sure I wasn't seeing things.

dinodom000 · June 28, 2007, 05:29:24 PM

Im still really confused $:-\$ ... Just hopeing this will all work out.

babjusi · June 28, 2007, 05:33:37 PM

Quote from: Sarge on June 28, 2007, 05:13:36 PM
Quote from: babjusi on June 28, 2007, 04:52:51 PM
You have reached your maximum number of MSSQL Databases

MSSQL?

Myssql, my bad. I misspelled it

babjusi · June 28, 2007, 05:57:18 PM

Sorry, I tried with all the info you send me and I couldn''t get it going. Ask your host to provide you with the correct info. I deleted the install.php file as it is a major security risk to leave it there

Sarge · June 28, 2007, 06:02:41 PM

Quote from: babjusi on June 28, 2007, 05:33:37 PM
Myssql, my bad. I misspelled it

And you managed to misspell it again.

dinodom000, have you tried deleting a database you don't need and recreating it for SMF to use?

dinodom000 · June 28, 2007, 06:17:55 PM

Um i have deleted and reset up the database many times.

If thats not the answer you where looking for then im confused.

babjusi · June 28, 2007, 06:21:45 PM

Quote from: dinodom000 on June 28, 2007, 06:17:55 PM
Um i have deleted and reset up the database many times.

If thats not the answer you where looking for then im confused.

As I said, contact the host and ask them about the mysql info and check them if they are the same with the ones you gave me

Douglas · June 28, 2007, 06:30:30 PM

First, you need to identify WHICH MySQL server you're on and use the proper name instead of localhost. ALWAYS remember to add a colon3306 ( :3306) after it.

mysql1.easycgi.com
mysql2.easycgi.com
mysql3.easycgi.com
mysql4.easycgi.com
mysql5.easycgi.com
mysql6.easycgi.com
mysql7.easycgi.com
mysql8.easycgi.com
mysql9.easycgi.com
mysql10.easycgi.com
mysql11.easycgi.com
mysql12.easycgi.com
mysql13.easycgi.com
mysql14.easycgi.com
mysql15.easycgi.com
mysql16.easycgi.com
mysql17.easycgi.com

If you don't have enough databases, you can use an existing one, just use the table prefix (I'd suggest smf_ or z_).

Sarge · June 28, 2007, 06:31:08 PM

Have you created both a database and a database user and associated (assigned) this user to that database? The database user must be assigned at least the following privileges on the database: SELECT, INSERT, UPDATE, DELETE, ALTER, and INDEX.

From the Online Manual: Server Requirements

babjusi · June 29, 2007, 11:07:40 PM

This topic can be marked as solved

dinodom000 · June 29, 2007, 11:14:04 PM

Thank you so much foreverything babjusi. Your the best. I would of never got that far without you. My forums are up and working and everything is good.

babjusi · June 29, 2007, 11:24:51 PM

You are welcome dinodom000. Anytime I can be of help to you don''t hesitate to ask me

dinodom000 · June 29, 2007, 11:26:20 PM

Will do!

Sarge · June 30, 2007, 03:37:24 AM

Quote from: babjusi on June 29, 2007, 11:07:40 PM
This topic can be marked as solved

Can you tell us how did you fix the problem?

Thanks for the support.

babjusi · June 30, 2007, 06:39:58 AM

Quote from: Sarge on June 30, 2007, 03:37:24 AM
Quote from: babjusi on June 29, 2007, 11:07:40 PM
This topic can be marked as solved

Can you tell us how did you fix the problem?

Thanks for the support.

The host was contacted, and dinodom000 was provided with the right Mysql info
Regarding the support, it was a pleasure

dinodom000 · June 30, 2007, 02:13:07 PM

Thanks to everyone that helped

News:

SMF 1.1.2 Instilation error

babjusi

babjusi

babjusi

babjusi

babjusi

babjusi

babjusi

babjusi

babjusi

babjusi

babjusi

babjusi

babjusi

babjusi

babjusi

babjusi