EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Development::GeorgeS's Tools (https://www.eqemulator.org/forums/forumdisplay.php?f=674)
-   -   can't connect to DB with eqitems (https://www.eqemulator.org/forums/showthread.php?t=30264)

jsr 01-06-2010 02:01 AM

can't connect to DB with eqitems
 
Error =
MYSQL connection FAILED!- Check db.ini and did you install by ODBC drivers?

I have -

- unzipped the files
- ran eqitems.exe
- got the error
- found the mysql drivers
- installed
- ran eqitems.exe
- got the error
- read the readme.txt
- registered the OCX files
- ran eqitems.exe
- got the error

Searched forums and can't find next steps :-)

DB.ini--
host=(db IP)
user=(user)
password=(pass)
database=peq
everquest_folder=f:\eqemu\titanium

Drivers/OCX--
Downloaded drivers from: http://www.georgestools.eqemulator.net/ODBC_DRIVERS.zip
Registered OCX files

DB version--
Mysql 5.0.89

can connect via commandline with above details (and mysql query browser).

Anything I should look for next?

joligario 01-06-2010 06:52 AM

You used an ip? Are you trying to connect remotely?

pfyon 01-06-2010 01:11 PM

If the DB is on the same computer, you should use host=localhost, if it's on another machine, you have to make sure that a) the ports are forwarded properly, b) there isn't a firewall blocking access to the port, and c) that mysql is set up to allow remote connections.

jsr 01-07-2010 05:56 AM

Great advice, thanks guys :)

GeorgeS 01-07-2010 10:49 PM

In my tools download, I have a connection checker that you should try.

Otherwise, you have done what's needed. Sometimes port 3306 needs to be forwarded to you server pc.

GeorgeS


All times are GMT -4. The time now is 05:13 AM.

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