View unanswered posts | View active topics |



Print view
Previous topic | Next topic 

what is the change to mysql.xml?

Post new topic Reply to topic  Page 1 of 1
  [ 8 posts ] 
 
Author Message
Panther30
 Post subject: what is the change to mysql.xml?
PostPosted: Mon Oct 22, 2007 4:41 pm 
User avatar
Reduced to ashes

Current Scorched3D Rank: Unranked

Joined: Fri Sep 03, 2004 3:00 am
Posts: 657
Location: Litter box in Tipp City, Ohio, USA
Hi everyone,


I have a small issue with Scorched not wanting to log stats again, but I am using my old mysql.xml files to do so. I am missing the port information for mySQL I am running Linux (fedora core 5)) and I am unsure how to find the mysql port information. what do I do?
the true mark of a skilled player is the ability to adapt. If a player cannot adapt, then maybe that player wasn't all that skilled to begin with...
---Ebonite

You either grin and bear it, or go home. Deathbal

Top
 Profile  
 
Bobirov
 Post subject: Re: what is the change to mysql.xml?
PostPosted: Mon Oct 22, 2007 10:08 pm 
User avatar
Obliterated

Current Scorched3D Rank: Unranked

Joined: Sat Apr 24, 2004 6:52 am
Posts: 1393
Location: Florida, USA
Panther30 wrote:
Hi everyone,


I have a small issue with Scorched not wanting to log stats again, but I am using my old mysql.xml files to do so. I am missing the port information for mySQL I am running Linux (fedora core 5)) and I am unsure how to find the mysql port information. what do I do?


Add this to the mysql file:

<port>3306</port>
Undead.

Scorched 3D Documentation & Help

Top
 Profile  
 
Panther30
 Post subject:
PostPosted: Mon Oct 22, 2007 10:25 pm 
User avatar
Reduced to ashes

Current Scorched3D Rank: Unranked

Joined: Fri Sep 03, 2004 3:00 am
Posts: 657
Location: Litter box in Tipp City, Ohio, USA
Code:
- Created mysql stats logger.
Mon Oct 22 15:16:55 2007 - mysql stats logger failed to start. Error: Can't connect to local MySQL server through socket '3306' (2)
Mon Oct 22 15:16:55 2007 - mysql params : host localhost, user Anonymous, passwd , db Scorched3d
Mon Oct 22 15:16:55 2007 - Player connected dest="0" id="9000000" name="(Beast)Kota" unique=[VIOLATOR - computer - 1]
Mon Oct 22 15:16:55 2007 - mysql stats logger failed to start. Error: Can't connect to local MySQL server through socket '3306' (2)
Mon Oct 22 15:16:55 2007 - mysql params : host localhost, user Anonymous, passwd , db Scorched3d


This iis the error part of what I see in terminal when I run scorched as a server.
the true mark of a skilled player is the ability to adapt. If a player cannot adapt, then maybe that player wasn't all that skilled to begin with...
---Ebonite

You either grin and bear it, or go home. Deathbal

Top
 Profile  
 
Bobirov
 Post subject:
PostPosted: Mon Oct 22, 2007 11:04 pm 
User avatar
Obliterated

Current Scorched3D Rank: Unranked

Joined: Sat Apr 24, 2004 6:52 am
Posts: 1393
Location: Florida, USA
Err, its a bit different on linux, forgot about that. Try this instead of port 3306.

<port>/var/lib/mysql/mysql.sock</port>
Undead.

Scorched 3D Documentation & Help

Top
 Profile  
 
Panther30
 Post subject:
PostPosted: Tue Oct 23, 2007 12:36 am 
User avatar
Reduced to ashes

Current Scorched3D Rank: Unranked

Joined: Fri Sep 03, 2004 3:00 am
Posts: 657
Location: Litter box in Tipp City, Ohio, USA
okay that did the trick. Thank you.

Now there is one more thing but Ill have to test it myself. I'm having hte "can't connect to my own game server through my router" issue again. but I know wny: The cable router I am temprarily using as a switch between my room and the office is known to have an issue. it will have to be replaced before I can play.
the true mark of a skilled player is the ability to adapt. If a player cannot adapt, then maybe that player wasn't all that skilled to begin with...
---Ebonite

You either grin and bear it, or go home. Deathbal

Top
 Profile  
 
The AI
 Post subject:
PostPosted: Tue Oct 23, 2007 12:39 am 
Burned to a crisp
Not Signed Up For Stats

Joined: Mon Apr 30, 2007 7:40 pm
Posts: 275
heh, then it looks like we will all have to get on to keep the server warm for you. Great to see panthermod go 41.
Crunchlets? I have crunchlets?

Top
 Profile  
 
Bobirov
 Post subject:
PostPosted: Tue Oct 23, 2007 2:09 am 
User avatar
Obliterated

Current Scorched3D Rank: Unranked

Joined: Sat Apr 24, 2004 6:52 am
Posts: 1393
Location: Florida, USA
Panther30 wrote:
Now there is one more thing but Ill have to test it myself. I'm having hte "can't connect to my own game server through my router" issue again. but I know wny: The cable router I am temprarily using as a switch between my room and the office is known to have an issue. it will have to be replaced before I can play.

I discovered a little 'bug' of sorts after v41 release that if you happen to be playerid #1 in the stats database, it won't let you play basically. You can only connect and it goes straight to the score. Its been changed now though. Just be aware that if you are playerid #1 on your own server, you'll need to either move your stats to a different player id or rebuild your client with the playerid change.

If you're not playerid #1 in your database, then just ignore all that. ;)
Undead.

Scorched 3D Documentation & Help

Top
 Profile  
 
Panther30
 Post subject:
PostPosted: Tue Oct 23, 2007 3:34 am 
User avatar
Reduced to ashes

Current Scorched3D Rank: Unranked

Joined: Fri Sep 03, 2004 3:00 am
Posts: 657
Location: Litter box in Tipp City, Ohio, USA
yeah Im not player Id number 1. None of my computers on this switch or on the wireless in the office can connect. I beleive that hte problem is the switch. but there is one more option I can try. I will let you know how it goes.

problem is solved. I had to forward both for incoming and outgoing on both ports the scorched servers need forwarded. Everything is working now. I alos went ahed and replaced a problematic router with one that is pci card (you heard right) in my server until I can get a new external one.

thanks again
the true mark of a skilled player is the ability to adapt. If a player cannot adapt, then maybe that player wasn't all that skilled to begin with...
---Ebonite

You either grin and bear it, or go home. Deathbal

Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 1 of 1
  [ 8 posts ] 

Board index » Help » help and troubleshooting

Who is online

Users browsing this forum: No registered users and 1 guest

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group