DataBase not connecting

Bаne · 07/26/2011, 10:20

Heya everyone, I just moved overs PC's, (AGAIN Q.Q), this is was supposed to be dedicated to Co2, so I got the hellmouth sorce, seemed stable and I used it on my last PC, only probleme is I get a error message on the Hellmouth.exe saying it can't connect to the MySQL server, everything is correct on the settings file so I'm not very sure on why, and yes the DB is running ETC.

12k · 07/26/2011, 10:23

Hmm, have you checked the source code in the source to make sure the mysql connection is reading from the settings you set, or from a different location?

Bаne · 07/26/2011, 10:29

Quote:

Originally Posted by 12k

Hmm, have you checked the source code in the source to make sure the mysql connection is reading from the settings you set, or from a different location?

The hellmouth soruce does not require you to do so, but I double check the sockets ETC and no not that.

12k · 07/26/2011, 10:39

Ah gotcha. Downloaded the source code for hellmouth source. So you have changed the MySqlArgument values to the correct mysql info for ur mysql in the code, and debugged the solution, and u cant connect to mysql? o.o

#edit
The settings.txt isnt being used, incase you were using that.

Bаne · 07/26/2011, 10:41

Quote:

Originally Posted by 12k

Ah gotcha. Downloaded the source code for hellmouth source. So you have changed the MySqlArgument values to the correct mysql info for ur mysql in the code, and debugged the solution, and u cant connect to mysql? o.o

yes, the MySQL varibles in the settings file are all correct, so is the IP, when I run the debugger it start's the server successfuly, yet when I try to login game, I get the connection error.

12k · 07/26/2011, 10:43

It doesnt read off of the settings.txt file. It reads directly out of the source code. Thats why i was asking if u looked in the source code ^^. You will have to do it inside of visual C#.

Bаne · 07/26/2011, 10:45

Quote:

Originally Posted by 12k

It doesnt read off of the settings.txt file. It reads directly out of the source code. Thats why i was asking if u looked in the source code ^^. You will have to do it inside of visual C#.

Yes, I checked the source code, and it seemed correct, and I have never needed to edit any of the source to log in, in the past o.o

Spirited · 07/26/2011, 10:46

What's the error message?

Bаne · 07/26/2011, 10:48

Without starting the computer up, etc, the message was something along 'Cannot connect to MYSQL using user 'Root' (pass check YES)

12k · 07/26/2011, 10:49

Ahh woops, i retract my previous statement rofl. It does read from the settings.txt sry, didnt look at it that hard. I cant even find a instance of the MySqlHandler being created right now lol, to me it appears its just using structs. I must be too tired

bed time for me lol. sorry, i tried.

Spirited · 07/26/2011, 10:50

Quote:

Originally Posted by [GM]Bane

Without starting the computer up, etc, the message was something along 'Cannot connect to MYSQL using user 'Root' (pass check YES)

make "Root" lowercase --> "root" and u'll be good to go.
(taking that your password and database name are correct)

If that doesn't work, reinstall MySql Community Server using the official installation and set it up with information that will work. You might of typed something incorrectly.

Bаne · 07/26/2011, 10:52

I logged on and checked, it was already lowercase root, infact here it is

IP=127.0.0.1
USERNAME=root
PASSWORD=alpha675463
DATABASE=5310
DMGREDUCT=80

12k · 07/26/2011, 10:54

And you can login using a mysql GUI such as query browser or navicat with that information? o.o

Bаne · 07/26/2011, 10:54

Quote:

Originally Posted by 12k

And you can login using a mysql GUI such as query browser or navicat with that information? o.o

Yes I can o.o

Spirited · 07/26/2011, 11:09

DATABASE=5310 ?
What is the name of your database?