View Single Post
  #11  
Old 07-26-2008, 10:10 PM
thepoetwarrior
Discordant
 
Join Date: Aug 2007
Posts: 307
Default

Bear with me, Im awake maybe 30+ hours now pulling my hair out. Making some progress.

Actually, I had map files in the correct place.

I didnt know about tail, but good to know!

I used chmod on start, persit_world, and stop. That fixed it.

I use ./start, then while logged in EQ Client as admin I do #worldshutdown, then after it shut down I do ./stop. So that part is working.

Now for the problems driving me crazy:

With EQServer working on Debian Linux, and imported the entire windows db from a sql file thru mysql, seems most of the db gets loaded when I do ./start such as peoples chars and inventory, except its not reading the rule_values table! Regen caps are not correct, corpses are poofing, and people can scribe spells up to 70 but lose their 66-70 spells when zoning which might be because of the default level 65 cap.

I went into mysql on LinuxPC and created an account for my windows pc, using the windows local ip 192.x.x.x, with made up user/pw. I've done this before between 2 window PC's so I know how to do that, to use editors like Georges tools or Navicat from a differnt PC. So I go on the WinPC to use GUI Editors to log into the LinuxPC, but connection failed! Weird.

So I do reverse. I make ip-user-pw account in mysql on window machine for the linux machine to use. I then edit the eqemu_config.xml on LinuxPC to reflect the database info (ip, user, pw, db name) for mysql to connect to the db on WindowsPC. Hope makes sense,

So what I get is EQ Server running on Debian Linux, and using the database from the WindowsPC, not from its own LinuxPC! At least i can now edit the database on windows with localhost for ip thru Navicat or Georges tools, etc.

So I double check database on LinuxPC to see that rule_values imported, and they did. So why is Linux not using the rule_values from the database off its own machine?

Also, why can LinuxPC log into the Windows DB but the WindowsPC cannot log into the LInuxPC DB? Seems like a 1-way street there almost. When in mysql Im creating accounts with the correct IP's (192.168.1.x) etc so I know how to do that, but seems to work in only 1 direction, Linux->Win.

1) My WinPC cant remote into LinuxPC but the Linux can remote into the WinPC.

2) rule_values I verified to be on LinuxPC by using mysqldump then viewing, but the Server is not reading those values. Its like Linux can only access most of its own database, just not rule_values.

Any ideas?

Did a lot for one day here.
Reply With Quote