[dead] My guides + databases + server files repack -V2!

Dinh · 06:18 PM

Quote: Originally Posted by Darkcyde

Ok, now i got a few more issues to iron out.
First of all thanks Chumpy, your files and guides were the only ones i could understand and get my server up and running with..

I for some reason or another cant get Premium to take effect, ive tried through your GM tools app and manually editing the DB and no luck. no GPS warp sucks.

I also cant get the server rates to change through const.scp, I looked through the Saur0n const.scp and cant even find the rates so i reverted to original but no luck taking effect.

** with some thurough searching i found the premium issue and solved by using different premium values, both are set to 1 which gives premium no problem.. still cant figure out the server rate issue, Chumpy, would you like to shed some light on the subject :)

thanks for the help!

At least you go the server to connect to the database

. My problem is still the connection issue between CentOS and the SQL server.

Darkcycle,

How did you find your Database IP?? When I did the link server step, I tried "Gameserver", "localhost", and even my PC IP and still I am unable to connect to the database from CentOS. I'm ready to pull my hair out

. Any info would be helpful..and thanks in advance, especially Chumpy

Darkcyde · 10-21-2008, 08:48 AM

Quote: Originally Posted by Dinh

Darkcycle,

How did you find your Database IP?? When I did the link server step, I tried "Gameserver", "localhost", and even my PC IP and still I am unable to connect to the database from CentOS. I'm ready to pull my hair out

. Any info would be helpful..and thanks in advance, especially Chumpy

From what i can see in your log it looks like libtdsodbc.so.0 is missing, i had this exact same problem, i solved it by:
1 Googling the actual file name (libtdsodbc.so.0)
2. I found a download of the rpm (freetds .64-7)
ftp://rpmfind.net/linux/fedora/relea...7.fc8.i386.rpm
3. Once the rpm downloaded i moved it to the CentOS desktop by using winSCP.
4. in the centos machine i right clicked the rpm and opened it with archive manager.
5. once the rpm opened I extracted libtdsodbc.so.0.0.0 to the desktop and renamed it to libtdsodbc.so.0.
6. once it was renamed I moveed it to /root/ep2/usr/lib.
7. I cleared my logs and restarted the cabal services.

thats what stopped the DB connect errors for me..

The getq errors in my experience are a result of the DB errors, once the server is able to connect to your DB the getq and port listen errors (if you have any) should stop, if not a service cabal restart should fix it..

also i just fixed my provider string in SQL (as my earlier post describes) what i did was
DRIVER={SQL Server};SERVER="Windows IP Here";UID=;PWD=;

not too sure how much help i can be but im a quick learner and know how i fixed my own problems at least :P

Demonite · 10-21-2008, 02:35 PM

Ok, im at the WinSCP part... i cant connect to it and i think its cause i dont really understand the whole Centos IP stuff....

im using a modem and just use my normal IP wich i got from IPCONFIG..... thats what i put in the centos installer and when i do IFCONFIG in centos it gives the same ip as in IPCONFIG,

what do you guyz mean with "a un-used IP" ... how can i find my Un used ip?

Darkcyde · 10-21-2008, 02:54 PM

Quote: Originally Posted by Demonite

Ok, im at the WinSCP part... i cant connect to it and i think its cause i dont really understand the whole Centos IP stuff....

im using a modem and just use my normal IP wich i got from IPCONFIG..... thats what i put in the centos installer and when i do IFCONFIG in centos it gives the same ip as in IPCONFIG,

what do you guyz mean with "a un-used IP" ... how can i find my Un used ip?

Ive attached a simple tool to help you find an open IP address on your network. usually you can take a guess at the 253+ possibilities and come up with one no poblem. Just use an IP that nothing else on your network is using.

1. download and extract the tool
2. run the program
3. input your starting IP address
4. input your ending IP address
5. run the scan

Anything IPscan comes up with in red is an unused address..

Your SQL IP and CentOS IP cannot be the same, they must be different and must mbe unused addresses.

Demonite · 10-21-2008, 03:13 PM

Quote: Originally Posted by Darkcyde

Ive attached a simple tool to help you find an open IP address on your network. usually you can take a guess at the 253+ possibilities and come up with one no poblem. Just use an IP that nothing else on your network is using.

1. download and extract the tool
2. run the program
3. input your starting IP address
4. input your ending IP address
5. run the scan

Anything IPscan comes up with in red is an unused address..

Your SQL IP and CentOS IP cannot be the same, they must be different and must mbe unused addresses.

Thanks SO much man! ill try it now :D

Dinh · 10-21-2008, 04:13 PM

Quote: Originally Posted by Darkcyde

From what i can see in your log it looks like libtdsodbc.so.0 is missing, i had this exact same problem, i solved it by:
1 Googling the actual file name (libtdsodbc.so.0)
2. I found a download of the rpm (freetds .64-7)
ftp://rpmfind.net/linux/fedora/relea...7.fc8.i386.rpm
3. Once the rpm downloaded i moved it to the CentOS desktop by using winSCP.
4. in the centos machine i right clicked the rpm and opened it with archive manager.
5. once the rpm opened I extracted libtdsodbc.so.0.0.0 to the desktop and renamed it to libtdsodbc.so.0.
6. once it was renamed I moveed it to /root/ep2/usr/lib.
7. I cleared my logs and restarted the cabal services.

thats what stopped the DB connect errors for me..

The getq errors in my experience are a result of the DB errors, once the server is able to connect to your DB the getq and port listen errors (if you have any) should stop, if not a service cabal restart should fix it..

also i just fixed my provider string in SQL (as my earlier post describes) what i did was
DRIVER={SQL Server};SERVER="Windows IP Here";UID=;PWD=;

not too sure how much help i can be but im a quick learner and know how i fixed my own problems at least :P

Darkcycle,

I really appreciate what you're doing for me. But it seems like Cabal, its brother and sister hates me

I followed your step and got the libtdsodbc.so.0 to the /root/ep2/usr/lib and did a service cabal restart. I clear the log file before the service cabal restart with > and when I view it again, I got the same message...but this time it adds the line: requires glibc 2.5 or later dynamic linker. If you have any suggestions, please please let me know. Thanks in advance. By the way, if I can connect to the database using my cabal login with Chumpy's GM too and are able to create account, does that mean my database is working??

akitoxakabane · 10-21-2008, 05:04 PM

i got the same problem with this error...

Quote:

Msg 515, Level 16, State 2, Procedure cabal_tool_registerAccount, Line 10
Cannot insert the value NULL into column 'Password', table 'ACCOUNT.dbo.cabal_auth_table'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Procedure cabal_tool_registerAccount, Line 16
Cannot insert the value NULL into column 'UserNum', table 'ACCOUNT.dbo.cabal_charge_auth'; column does not allow nulls. INSERT fails.
The statement has been terminated.

(1 row(s) affected)

how do we fix it?
is there a step-by-step way to do this?

Darkcyde · 06:19 PM

Quote: Originally Posted by Dinh

Darkcycle,

I really appreciate what you're doing for me. But it seems like Cabal, its brother and sister hates me

I followed your step and got the libtdsodbc.so.0 to the /root/ep2/usr/lib and did a service cabal restart. I clear the log file before the service cabal restart with > and when I view it again, I got the same message...but this time it adds the line: requires glibc 2.5 or later dynamic linker. If you have any suggestions, please please let me know. Thanks in advance. By the way, if I can connect to the database using my cabal login with Chumpy's GM too and are able to create account, does that mean my database is working??

Not nnecessarily, all the GM tool does is automate DB query tasks to avoid manual editing, it has nothing to do with the CentOS system. As a side note, id be willing to say that these errors arent leading me to believe there are DB problems. Your DB is more than likely fine just CentOS cant connect do to missing libraries. As for the remaining errors, what CentOS version are you running. Im running 4.6 and using the Chumpy installer script in the server files i had no real problem with RPM installs (other than the aformentioned libtdsodbs.so.0) Make sure the CentOS system can access the internet and try reinstalling the server files using Chumpy's commands (chmod 0777 ./cabal_install.sh - ./cabal_install.sh > follow all prompts! with CentOS 4.6 and active internet it will update the installer packages and make sure the most current is installed). If i had to guess id say you either arent running 4.6 and missing some dependencies OR the installer wasnt run properly (chmod 0777)

Like i said, i dont know too much but im glad to offer at least a little help :)

Quote: Originally Posted by akitoxakabane

i got the same problem with this error...

how do we fix it?
is there a step-by-step way to do this?

I had this problem as well to being with. How are you running the stored procedure? are you locating it in the DB and right clicking to execute or entering the DB query command? The way i got my accounts to properly register is by issuing the DB command.

Highlight ACCOUNT db and right click and select "new Query"
in the new windows type in:
EXEC cabal_tool_registerAccount 'UserName',Password' (replace username and password with whatever you prefer)
At the top of the window click Execute, at the bottom will be a confirmation of success or fail and a log.

Im assuming you tried to right click the SP and input the information there, i had problems with NULL values this way and had to issue the commands to get past it.

I had no luck adding accounts via Chumpys GM tool however i was able to test and see if the account I manually created was now entered in the DB. Simply enter the DB command and open Chumpys GM tool and search for the account you just created to make sure the tool finds it..

akitoxakabane · 10-21-2008, 06:12 PM

thnx darkcyde , that was quick....

i used the DB query command just like wat u did but still i got that error.. im reinstalling mssql atm and trying to check wer i got a mistake.,...

i will post my progress later...
thnx again

Darkcyde · 10-21-2008, 06:16 PM

Quote: Originally Posted by akitoxakabane

thnx darkcyde , that was quick....

i used the DB query command just like wat u did but still i got that error.. im reinstalling mssql atm and trying to check wer i got a mistake.,...

i will post my progress later...
thnx again

make sure you follow the "creat a user" section of the guide and take ownership of the database. If the user you are loggend in as doesnt have sufficient privlidges you will have errors all over the place :)

**cypher** · 10-21-2008, 06:19 PM

Moderator's Warning:

One more double post here and i`ll start sharing infractions

tzinpo · 10-21-2008, 06:32 PM

chumpy

help....

how can i connect to cabal ? using GP client and sauron patch

the centos server is Running smoothly but when i try to login to cabal its always failed to connect y ?

and i can ping my windows ip and gateway in centos....

and also when i exit the cabal the vmware popping out with something error and it will shutdown the centos y ?

thanks

im using ur database and followed correctly your guide

my only prob is in client side and VMware

thanks

Dinh · 10-21-2008, 06:42 PM

Darkcycle,

I'm running CentOS 4.7. I'll try to run the (chmod 0777) again and restart the Cabal server. Thanks for the quick reply. I might have to try to catch Chumpy on MSN if this don't work out.

Demonite · 10-21-2008, 07:06 PM

Damnit! I still cant connect to WinSCP, i get the "Network error:Connection timed out".

My real IP = 83.81.40.46 , i used ANGRY IP CHECKER and saw that my unused ip = 83.81.40.50

so ... i did that with centos, my Centos IP = 83.81.40.50 so thats good right?

Now i do that in WinSCP (IP=83.81.40.50, root and my pass) but still gives me error.. is there any trick like something i forgot?

juliom · 10-21-2008, 07:24 PM

i ll try to set up . thks.

Dinh · 10-21-2008, 07:33 PM

Quote: Originally Posted by Demonite

Damnit! I still cant connect to WinSCP, i get the "Network error:Connection timed out".

My real IP = 83.81.40.46 , i used ANGRY IP CHECKER and saw that my unused ip = 83.81.40.50

so ... i did that with centos, my Centos IP = 83.81.40.50 so thats good right?

Now i do that in WinSCP (IP=83.81.40.50, root and my pass) but still gives me error.. is there any trick like something i forgot?

Your IP looks like a WAN IP. Is your computer connecting to a router? Or is your PC connecting to your cable modem (a direct connection from your ISP or WAN)?

Demonite · 10-21-2008, 07:34 PM

Quote: Originally Posted by Dinh

Your IP looks like a WAN IP. Is your computer connecting to a router? Or is your PC connecting to your cable modem (a direct connection from your ISP or WAN)?

Its a direct connection... im using cable internet with a modem.

Dinh · 10-21-2008, 08:08 PM

I assumed you know how to Ping..so the next question is, can your windows ping CentOS...and vice versa?

akitoxakabane · 10-21-2008, 08:32 PM

wat do i put in the <server name>?

DRIVER={SQL Server};SERVER=<servername>;UID=;PWD=";

is it GAMESERVER?
or windows ip?

do we make all true in the server options?

just want to clarify linked server settings.. ^_^

Demonite · 10-21-2008, 09:12 PM

Quote: Originally Posted by Dinh

I assumed you know how to Ping..so the next question is, can your windows ping CentOS...and vice versa?

How do you "Ping" centos with my windows and vice versa..?

;p sry man im really clueless at this part..

Darkcyde · 10-21-2008, 09:43 PM

Quote: Originally Posted by akitoxakabane

wat do i put in the <server name>?

DRIVER={SQL Server};SERVER=<servername>;UID=;PWD=";

is it GAMESERVER?
or windows ip?

do we make all true in the server options?

just want to clarify linked server settings.. ^_^

the only way i got it to work is by using the SQL Server IP :)

tzinpo · 01:43 PM

Quote: Originally Posted by tzinpo

chumpy

help....

How can i connect to cabal ? Using gp client and sauron patch

the centos server is running smoothly but when i try to login to cabal its always failed to connect y ?

And i can ping my windows ip and gateway in centos....

And also when i exit the cabal the vmware popping out with something error and it will shutdown the centos y ?

Thanks

im using ur database and followed correctly your guide

my only prob is in client side and vmware

thanks

edit

akitoxakabane · 10-22-2008, 01:40 AM

sql ip is 127.0.0.1 or the lan ip right? i got error wen i use lan ip....

thnx ...

trickstertik · 10-22-2008, 03:37 AM

Thank You For This Release.

felipeluzentti · 10-22-2008, 04:08 AM

my problem
GlobalDBAgent.log

Quote:

[Sat Feb 14 2015 12:31:34.725741 3064990608]: [##ERROR##] OnIPCAuthAccount fail (usernum: 0)
[Sat Feb 14 2015 12:31:34.725741 3064990608]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
[Sat Feb 14 2015 12:31:34.725741 3064990608]: [##ERROR##] DB ERROR(CODE) : 242
[Sat Feb 14 2015 12:31:34.725741 3064990608]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sat Feb 14 2015 12:31:34.725741 3064990608]: [##ERROR##] DB ERROR(SQLSTATE) : 22007
[Sat Feb 14 2015 12:31:34.725741 3064990608]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_auth( ? , ? , ? , ? )}
[Sat Feb 14 2015 12:31:34.821227 3064990608]: Database Connect success!
[Sat Feb 14 2015 12:31:34.821310 3064990608]: [##ERROR##] 'OnIPCAuthAccount' fail (Database/Auth.cpp:283)
[Sat Feb 14 2015 12:31:34.821542 3064990608]: [##ERROR##] UsrMap Fail : MainCmd(30) Ret(11B:0:283) Addr(127.0.0.1)