EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   MySQL path not found, please add the path for automatic database upgrading to con... (https://www.eqemulator.org/forums/showthread.php?t=39877)

ahamilton634 07-23-2015 12:41 AM

MySQL path not found, please add the path for automatic database upgrading to con...
 
There appears to be a problem accessing the database. When I launch the server this is what pops up.

Quote:

[World Server] Loading server configuration..
[World Server] CURRENT_VERSION: 1.1.3
[World Server] Added loginserver login.eqemulator.net:5998
[World Server] Connecting to MySQL...
[World Server] HTTP world service disabled.
[World Server] Checking Database Conversions..
[Upgrade Script] No script update necessary
Perl Version is 5.12.3
MySQL path not found, please add the path for automatic database upgrading to continue...

Exiting...
[World Server] Loading variables..
[World Server] Loading zones..
[World Server] Clearing groups..
[World Server] Clearing raids..
[World Server] Loading items..
[World Server] Loading skill caps..
[World Server] Loading guilds..
[World Server] Loaded default rule set 'default'
[World Server] Loading EQ time of day..
[World Server] Loading launcher list..
[World Server] Reboot zone modes OFF
[World Server] Deleted 0 stale player corpses from database
[World Server] Loading adventures...
[World Server] Purging expired instances
[World Server] Loading char create info...
[World Server] Zone (TCP) listener started.
[World Server] Client (UDP) listener started.
[World Server] New TCP connection from 127.0.0.1:49337
[World Server] New TCP connection from 127.0.0.1:49339
[World Server] New TCP connection from 127.0.0.1:49340
[World Server] New TCP connection from 127.0.0.1:49342
When I try to connect using the client it just sits there and kicks me. It doesn't say I'm being added to the database.
I've triple checked to make sure the password/db name is correct and made sure the ports were forwarded. I tried changing the password but not updating eqemu_config.xml and it reacted differently so it sees the database but it has trouble accessing it and perhaps updating it? I'm somewhat new to this. I ran a server several months back and it worked just fine. I tried re-sourcing the database and it started doing this.
It's also having trouble connecting using the EOC but Navicat has no problem connecting using root@localhost.:???:

ahamilton634 07-24-2015 01:35 PM

My firewall on my virus protection says it's on but when I open it in the actual client it says it's off and won't let me turn it on and I cannot access any of the options. I installed Akka's Repack because it had everything I needed in a neat little package (although I am using a server I set up myself and the database provided with the repack did the same thing).
Does Akka's repack configure the firewall in such a way to where it doesn't interfere?

Akkadius 07-24-2015 02:41 PM

http://www.eqemulator.org/forums/sho...4&postcount=13

ahamilton634 07-24-2015 09:42 PM

Thanks Akkadius!
I went ahead and did that and now it lets me update in the world.exe window.

Unfortunately I'm still having trouble connecting. I tried options three and twenty and still when I try to connect it sits for a bit and disconnects me. I thought the problem was it was having trouble updating the database to create an entry for my account because the table is still empty.
I've checked to make sure the ports are forwarded, I've checked to make sure all of the privileges are granted for the appropriate mysql users, I've checked my firewall but it still doesn't let me log in.
I've also tried logging in using the eoc but it doesn't let me in. I've tried creating a user with the host '69.168.254.244' and granting all privileges but it still says:
"Cannot connect to server!
Cannot connect to database peq
"
The database is called peq and I can connect to it using Navicat on the computer its self using root@localhost.

Kingly_Krab 07-24-2015 09:44 PM

Go here and test your ports.

ahamilton634 07-25-2015 12:16 PM

Thanks for the help guys.
When I went to http://canyouseeme.org/ it'd just time out so I tried http://www.yougetsignal.com/ and it kept saying the port was closed. I went to NAT/Gaming and made quadruple and quintuple sure that the ports were forwarded to the PC I am trying to run the server on and even tried removing my virus protection but the issue still stands.
At this point I'm totally stumped and ready to give up. :confused:

Akkadius 07-25-2015 01:53 PM

Make sure 3306 is not being blocked by windows firewall

ahamilton634 07-25-2015 02:36 PM

That appears to have been the culprit. I didn't think it was because when I checked it it wasn't letting me turn it on or off and it wouldn't tell me if it was on or off. I also went into services.exe and it didn't say it was started so I disabled it completely and it seems to have fixed the issue.
I appreciate your guys' help. =)


All times are GMT -4. The time now is 02:23 AM.

Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.