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 10-28-2014, 08:43 PM
Azuull
Sarnak
 
Join Date: May 2008
Location: No.
Posts: 21
Default GeorgeS's Tools - eqitems.exe

Okay, I haven't seen this issue with eqitems.exe.

Server is Debian 7.7.0 (virtual machine, same physical machine.) - 10.0.0.32
I am running Windows XP SP3 (for the tools, virtual machine.) - 10.0.0.34
Using peqbeta_* from September as the October release is missing tables.
I can successfully log into the server with EverQuest.

MySQL Workbench connects fine from LAN machine (another physical machine).
Fixed db.ini to reflect my requirements.
Registered all OCXs with no issue.
Installed MySQL Connector ODBC 3.51.2 32bit with no issue.
MySQL TEST: MySQL Connection SUCCESS.

I've tried the root user and the 'eq' user, with hostname and IP address (along with default 3306 port). 'eqitems.exe' just refuses to connect.
Firewall is disabled (no anti-virus on XP machine).

Within /etc/mysql/my.cnf -
#bind_address is commented out (tried from a Stack Overflow post about making MySQL on Debian available to remote connections.)

No bueno. :(

Any help would be greatly appreciated.
Reply With Quote
  #2  
Old 10-29-2014, 04:54 PM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default

Try uncommenting your bind address entry in my.cnf and setting it to the ip on your NIC (possibly your public IP, but may be a LAN IP if you are running behind a router from your home or something):

Code:
bind-address = x.x.x.x
(where x.x.x.x is your IP)

This allows mysql to listen on your external facing interface so connections can be allowed from there.

You then need to restart mysql for the changes to take effect.

If that works for you, then you can always lock stuff down later once you have basic connectivity work. It is always easier to work backwards from something that is working than it is to try to set tight security settings and make something work that isn't yet.
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote
  #3  
Old 10-29-2014, 08:25 PM
Azuull
Sarnak
 
Join Date: May 2008
Location: No.
Posts: 21
Default

Quote:
Originally Posted by trevius View Post
Try uncommenting your bind address entry in my.cnf and setting it to the ip on your NIC (possibly your public IP, but may be a LAN IP if you are running behind a router from your home or something):

Code:
bind-address = x.x.x.x
(where x.x.x.x is your IP)

This allows mysql to listen on your external facing interface so connections can be allowed from there.

You then need to restart mysql for the changes to take effect.

If that works for you, then you can always lock stuff down later once you have basic connectivity work. It is always easier to work backwards from something that is working than it is to try to set tight security settings and make something work that isn't yet.
Didn't seem to work. MySQL Connection Test still showing SUCCESS, eqitems.exe no-go. Tried the server's IP, the WINXP IP, even tried the '*' wildcard (no quotes).
Reply With Quote
  #4  
Old 10-30-2014, 04:49 AM
vsab's Avatar
vsab
Discordant
 
Join Date: Apr 2014
Location: United Kingdom
Posts: 276
Default

I get the same thing on my local machine- I can connect to my db programatically (using a .net program), via HeidiSQL, via EqEmu. The Test_Connection tool can connect but EqItems can't- although it does say something about the version missing in the variables table- so maybe we're just missing something it's looking for that it uses to validate the db?
Reply With Quote
  #5  
Old 10-31-2014, 08:11 PM
Azuull
Sarnak
 
Join Date: May 2008
Location: No.
Posts: 21
Default

Quote:
Originally Posted by vsab View Post
I get the same thing on my local machine- I can connect to my db programatically (using a .net program), via HeidiSQL, via EqEmu. The Test_Connection tool can connect but EqItems can't- although it does say something about the version missing in the variables table- so maybe we're just missing something it's looking for that it uses to validate the db?


I think we need George to weigh in.
Reply With Quote
  #6  
Old 11-07-2014, 07:53 PM
Azuull
Sarnak
 
Join Date: May 2008
Location: No.
Posts: 21
Default

Shameless bump.
Reply With Quote
  #7  
Old 11-08-2014, 05:10 PM
Azuull
Sarnak
 
Join Date: May 2008
Location: No.
Posts: 21
Default

Quote:
Originally Posted by vsab View Post
I get the same thing on my local machine- I can connect to my db programatically (using a .net program), via HeidiSQL, via EqEmu. The Test_Connection tool can connect but EqItems can't- although it does say something about the version missing in the variables table- so maybe we're just missing something it's looking for that it uses to validate the db?
I just reread what you said here; I don't even get to that point on my 'remote' machine.

Begrudgingly, I decided to place the tools on the local machine it's running on; I get that error. I turn off the music and it gets to the normal screen (after forcing it to run in Windows XP SP3 compatibility mode).

Hooray, right?!

No.

I click 'Load in Toons' and get: Run-tim error '3704': Operation is not allowed when object is closed.
EQItems.exe then closes.

I have never had this many problems with these tools before. Tried with Win Server 2008R2, Windows 7 Professional 64bit, and Windows XP SP3 Professional. Each of these had a fresh download of Akka's EQ Repack and the tools.

*Sigh*
Reply With Quote
  #8  
Old 01-25-2015, 03:30 PM
Azuull
Sarnak
 
Join Date: May 2008
Location: No.
Posts: 21
Default

Well, I loaded a new ESXi VMWare appliance (Windows 7 Professional 64bit), loaded Akka's repack, loaded a loginserver (<-- all on the ESXI box), made a toon, walked around for a minute, and logged out (<-- on my gaming box).

eqitems still throwing a run-time error:


I should mentioned that this is a fresh download of the tool and the audio for the tool is turned off. Also, I am using eqitems.exe on the same box the server is located (ESXi box.)
Reply With Quote
  #9  
Old 02-11-2015, 07:16 PM
Azuull
Sarnak
 
Join Date: May 2008
Location: No.
Posts: 21
Default

Shuffle bump.
Reply With Quote
Reply

Thread Tools
Display Modes

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 01:56 PM.


 

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