PCs gone

[msulli1355]

I dropped the old db, yes.

michael@carter /home/work/dsp $ netstat -a | grep 54230
tcp 0 0 *:54230 *:* LISTEN
udp 0 0 *:54230 *:*
michael@carter /home/work/dsp $ netstat -a | grep 54231
tcp 0 0 *:54231 *:* LISTEN
michael@carter /home/work/dsp $ netstat -a | grep 54001
tcp 0 0 *:54001 *:* LISTEN
michael@carter /home/work/dsp $ netstat -a | grep 54002
tcp 0 0 *:54002 *:* LISTEN
michael@carter /home/work/dsp $

My server is running on 192.168.2.2. I've asked several times if my zoneip of 0033728704 is correct, but nobody's answered me. Is it correct?

[whasf]

try 3232236034
after you update zoneIP restart lobby and game servers (if they were running when you updated the db)

[msulli1355]

I updated zone_settings.zoneip and started the servers. Again, no characters. The Michael character does exist in the db though. I saw this output on the dsconnect screen:

[25/Nov 20:14][Info] login_parse:<msulli1355> was connected
[25/Nov 20:15][Debug] lobbyview_parse:Incoming Packet:<26> from ip:<192.168.2.100>
[25/Nov 20:15][Debug] lobbyview_parse:Incoming Packet:<1f> from ip:<192.168.2.100>
[25/Nov 20:15][Debug] lobbydata_parse:Incoming Packet:<a1> from ip:<192.168.2.100>
[25/Nov 20:15][Debug] lobbyview_parse:Incoming Packet:<24> from ip:<192.168.2.100>
[25/Nov 20:15][Info] lobbydata_parse: msulli1355 shutdown the socket
[25/Nov 20:15][Info] lobbydata_parse: msulli1355's login_session_data is deleted


192.168.2.100 is my Windows Vista laptop. It's what I play FFXI on.

[msulli1355]

I'm happy to say that as of today, DarkStar is up and running on my server box. It was a problem with the DB. Before today I couldn't create the dspdb DB user. My mysql server balked at the \' in the username. I had to call the user 'dspdb@localhost' instead of excluding the @ from the rest of the username with '. It works now. I am curious, though, how you are supposed to restore of backup of the several tables when the only real reason you would need to do that was if the table format had changed and a new file had to be sourced.

Ex: There is an update to chars.sql. One sources the new chars.sql and then reloads an old backup of chars.sql with data in it, thereby overwriting the new chars table in the DB. What is the point of this? Would there really be a new chars.sql file if the old one still worked?

[whasf]

I usually go in and manually update the schema for the chars* tables, that way i dont loose player data.

[msulli1355]

I guess that would work. It'd be easy with phpmyadmin...

[bluekirby0]

The only linux patches required are for the search server...the other fixes are in the svn.

I haven't given the linux version much attention in a while (barely given any to the project as a whole until the 12/12 version update). When this newest client update crisis is over with, I'll try to go back and take a look at the linux builds and see if they need some love.

[msulli1355]

Could you maybe add some function comments so I can find out where things I want to alter go? As it stands, I'm going to have to go through the program line by line to determine what exactly is going on to find where desired changes should go.

[bluekirby0]

That isn't a small undertaking. Sure, the comments should have been added as functions were implemented but they weren't always. It has taken me months to get to where I can find things as easily as I can, and even then I still have to do some hunting from time to time.

My suggestion would be to put in a request for new config options to be added instead of trying to hack in custom changes. It will both save you a lot of work and be potentially useful for many others.