Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::GeorgeS's Tools

Development::GeorgeS's Tools A forum just for GeorgeS's tools

Reply
 
Thread Tools Display Modes
  #1  
Old 01-06-2010, 02:01 AM
jsr
Hill Giant
 
Join Date: Aug 2008
Location: melbourne
Posts: 188
Default 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?
Reply With Quote
  #2  
Old 01-06-2010, 06:52 AM
joligario's Avatar
joligario
Developer
 
Join Date: Mar 2003
Posts: 1,490
Default

You used an ip? Are you trying to connect remotely?
Reply With Quote
  #3  
Old 01-06-2010, 01:11 PM
pfyon's Avatar
pfyon
Discordant
 
Join Date: Mar 2009
Location: Ottawa
Posts: 495
Default

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.
Reply With Quote
  #4  
Old 01-07-2010, 05:56 AM
jsr
Hill Giant
 
Join Date: Aug 2008
Location: melbourne
Posts: 188
Default

Great advice, thanks guys
Reply With Quote
  #5  
Old 01-07-2010, 10:49 PM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,475
Default

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
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 10:18 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3