PDA

View Full Version : Connecting to the server 127.0.0.1:9000 failed:


KrackAdams
08-03-2008, 07:06 PM
Hi im using

http://www.eqemulator.net/wiki/wikka.php?wakka=DebianLinuxServer

i completed everthing but i get this eqemu_debug_27725.log:

[08.03. - 15:57:44] Starting Log: logs/eqemu_debug_27725.log
[08.03. - 15:57:44] [LAUNCHER__INIT] Loading server configuration..
[08.03. - 15:57:44] [NET__WORLD] WorldConnection connect: Connecting to the server 127.0.0.1:9000 failed: TCPConnection::Connect(): connect() failed. Error: Connection refused
[08.03. - 15:57:44] [LAUNCHER__ERROR] worldserver.Connect() FAILED! Will retry.
[08.03. - 15:57:44] [LAUNCHER__INIT] Starting main loop...
[08.03. - 15:57:44] [COMMON__THREADS] Starting TCPConnectionLoop with thread ID -1213654096
[08.03. - 15:57:50] [LAUNCHER__STATUS] Caught signal 15
[08.03. - 15:57:50] [COMMON__THREADS] Ending TCPConnectionLoop with thread ID -1213654096

and i have port forwarded 9000 can you please let me know what im doing wrong.

and i got this one too

27677 [08.03. - 15:57:29] Starting Log: logs/eqemu_debug_world.log
27677 [08.03. - 15:57:29] [RULES__CHANGE] Resetting running rules to default values
27677 [08.03. - 15:57:29] [WORLD__INIT] Loading server configuration..
27677 [08.03. - 15:57:29] [WORLD__INIT] Log settings loaded from log.ini
27677 [08.03. - 15:57:29] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEMu 0.7.0
27677 [08.03. - 15:57:29] [WORLD__INIT] Connecting to MySQL...
27677 [08.03. - 15:57:29] [WORLD__INIT_ERR] Cannot continue without a database connection.

clalrona
08-03-2008, 09:33 PM
Can you post all of your config files?

trevius
08-03-2008, 10:39 PM
It isn't his config file unless he is using the wrong username and/or password for his database in the config file.

Looks more like a mysql account issue. You might want to make the changes to the my.cnf file that I recommended in the Wiki for remote database access. It will allow connections other than just localhost. Make sure you restart the server or at least mysql after you make the changes. Otherwise, you might just be able to change your mysql account to make it work properly with it the way it is.

KrackAdams
08-04-2008, 01:43 PM
It isn't his config file unless he is using the wrong username and/or password for his database in the config file.

Looks more like a mysql account issue. You might want to make the changes to the my.cnf file that I recommended in the Wiki for remote database access. It will allow connections other than just localhost. Make sure you restart the server or at least mysql after you make the changes. Otherwise, you might just be able to change your mysql account to make it work properly with it the way it is.

I did the my.cnf change form the wiki and now mysql server will not start

trevius
08-04-2008, 05:13 PM
You restarted your PC? Mysql can be really nasty to get working again if you run into that problem where it won't start. Normally it is because your accounts are messed up, which was probably due to something you were changing around in the accounts before you stopped mysql, and the changes didn't really take effect until you stopped and tried to restart it.

You can always try setting the my.cnf back to what it was before and see what happens. If it works again, you will probably want to make additional accounts with with different host names to make sure it works once your mysql changes with the my.cnf change. You can make some with @'192.168.1.100', @'127.0.0.1', @'localhost', and one of those are bound to work lol. It all depends on what mysql thinks it is being ran from and where you are connecting from. Even though it is all still on the same PC, it can be a little tricky. If you are running multiple NIC cards, it can get even more complicated.

Mysql on Linux can definitely be a real pain sometimes. At one point, I had mine so messed up and wasted so much time trying to fix it that I wound up just formatting and reinstalling Linux from scratch again.

trevius
08-05-2008, 12:19 AM
You restarted your PC? Mysql can be really nasty to get working again if you run into that problem where it won't start. Normally it is because your accounts are messed up, which was probably due to something you were changing around in the accounts before you stopped mysql, and the changes didn't really take effect until you stopped and tried to restart it.

You can always try setting the my.cnf back to what it was before and see what happens. If it works again, you will probably want to make additional accounts with with different host names to make sure it works once your mysql changes with the my.cnf change. You can make some with @'192.168.1.100', @'127.0.0.1', @'localhost', and one of those are bound to work lol. It all depends on what mysql thinks it is being ran from and where you are connecting from. Even though it is all still on the same PC, it can be a little tricky. If you are running multiple NIC cards, it can get even more complicated.

Mysql on Linux can definitely be a real pain sometimes. At one point, I had mine so messed up and wasted so much time trying to fix it that I wound up just formatting and reinstalling Linux from scratch again.

trevius
08-05-2008, 12:20 AM
Ooops - double post from when the forums were down earlier I guess lol...