Welcome to RaGEZONE - MMORPG Development Forums (sponsored by tfn.gr) Mark forums read | View Forum Leaders
RaGEZONE - MMORPG Development Forums (sponsored by tfn.gr)

Cabal Tutorials Discuss, [dead] My guides + databases + server files repack -V2! at Cabal Online forum; in my db agent log sir chumpy how to fix this.... [Thu Oct 30 2008 16:07:40.835403 3043953568]: [##ERROR##] DB ERROR(MSG) ...




Closed Thread
Thread Tools
[dead] My guides + databases + server files repack -V2!
 
 
Rock ON Cabal

Rank: Member


Blog Entries: 1
 
Join Date: Aug 2008
Location: cabalpilipinas....
Posts: 232
10-30-2008, 11:07 AM
 
in my db agent log sir chumpy how to fix this....

Quote:
[Thu Oct 30 2008 16:07:40.835403 3043953568]: [##ERROR##] DB ERROR(MSG) : [unixODBC][Driver Manager]Can't open lib '/usr/lib/libtdsodbc.so.0' : /usr/lib/libtdsodbc.so.0: cannot open shared object file: No such file or directory
[Thu Oct 30 2008 16:07:40.836281 3043953568]: [##ERROR##] DB ERROR(CODE) : 0
[Thu Oct 30 2008 16:07:40.836321 3043953568]: [##ERROR##] DB ERROR(VAR_INFO) :
[Thu Oct 30 2008 16:07:40.836350 3043953568]: [##ERROR##] DB ERROR(SQLSTATE) : 01000
[Thu Oct 30 2008 16:07:40.836347 3064933280]: [##ERROR##] DB ERROR(MSG) : [unixODBC][Driver Manager]Can't open lib '/usr/lib/libtdsodbc.so.0' : /usr/lib/libtdsodbc.so.0: cannot open shared object file: No such file or directory
[Thu Oct 30 2008 16:07:40.836732 3043953568]: [##ERROR##] DB ERROR(STM_TEXT) :
[Thu Oct 30 2008 16:07:40.837259 3043953568]: [##ERROR##] Database Connect Fail (uid=sa;pwd=*********;dsn=CabalGame02;APP=DBAgent_ 02)
[Thu Oct 30 2008 16:07:40.837376 3043953568]: [##ERROR##] check 'pDB' fail
[Thu Oct 30 2008 16:07:40.837413 3043953568]: [##ERROR##] 'OnIPCCensusNation' fail (Database/Nation.cpp:9)
[Thu Oct 30 2008 16:07:40.837785 3043953568]: [##ERROR##] UsrMap Fail : MainCmd(57) Ret(9:0:9) Addr(127.0.0.1)
[Thu Oct 30 2008 16:07:40.835685 3054443424]: [##ERROR##] DB ERROR(MSG) : [unixODBC][Driver Manager]Can't open lib '/usr/lib/libtdsodbc.so.0' : /usr/lib/libtdsodbc.so.0: cannot open shared object file: No such file or directory
[Thu Oct 30 2008 16:07:40.837958 3054443424]: [##ERROR##] DB ERROR(CODE) : 0
[Thu Oct 30 2008 16:07:40.838361 3054443424]: [##ERROR##] DB ERROR(VAR_INFO) :
[Thu Oct 30 2008 16:07:40.836841 3064933280]: [##ERROR##] DB ERROR(CODE) : 0
[Thu Oct 30 2008 16:07:40.838407 3054443424]: [##ERROR##] DB ERROR(SQLSTATE) : 01000
[Thu Oct 30 2008 16:07:40.838748 3064933280]: [##ERROR##] DB ERROR(VAR_INFO) :
[Thu Oct 30 2008 16:07:40.838773 3054443424]: [##ERROR##] DB ERROR(STM_TEXT) :
[Thu Oct 30 2008 16:07:40.838784 3064933280]: [##ERROR##] DB ERROR(SQLSTATE) : 01000
[Thu Oct 30 2008 16:07:40.838802 3054443424]: [##ERROR##] Database Connect Fail (uid=sa;pwd=;dsn=CabalGame02;APP=DBAgent_02)
[Thu Oct 30 2008 16:07:40.838812 3064933280]: [##ERROR##] DB ERROR(STM_TEXT) :
[Thu Oct 30 2008 16:07:40.838845 3064933280]: [##ERROR##] Database Connect Fail (uid=sa;pwd=;dsn=CabalGame02;APP=DBAgent_02)
[Thu Oct 30 2008 16:07:40.838852 3054443424]: [##ERROR##] check 'pDB' fail
[Thu Oct 30 2008 16:07:40.838907 3064933280]: [##ERROR##] check 'pDB' fail
[Thu Oct 30 2008 16:07:40.839302 3054443424]: [##ERROR##] 'OnIPCItemSerial0' fail (Database/ItemSerial.cpp:24)
[Thu Oct 30 2008 16:07:40.839318 3064933280]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Thu Oct 30 2008 16:07:40.839343 3054443424]: [##ERROR##] UsrMap Fail : MainCmd(50) Ret(18:0:24) Addr(127.0.0.1)
[Thu Oct 30 2008 16:07:40.839360 3064933280]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
LOGIN SCREEN on client
when im on the server selection and then selected the Venus server and choosing the channel i cannot connect to the channel what should be the fix for this ....

Last edited by Cath22; 10-30-2008 at 01:22 PM. Reason: added info
 
 
permalink
 

 
Certified PBKAC

Rank: Moderator


 
Join Date: Jun 2008
Location: 2 clouds to your right
Posts: 1,647
10-30-2008, 01:41 PM
 
FreeTDS isn't installed correctly. I have heard of a few reports of this problem but i cannot make it happen myself. I suspect there is an error showing up when cabal_install.sh is being run but i can't get anyone who has reported the problem to configm.

Try manually installing the freetds rpm.
 
 
permalink
 

 
Rock ON Cabal

Rank: Member


Blog Entries: 1
 
Join Date: Aug 2008
Location: cabalpilipinas....
Posts: 232
10-30-2008, 04:17 PM
 
sir what suppose to be the problem when im on the login screen on the client then ive already login and choosing the Server then in channel i cannot connect?
 
 
permalink
 

 
Certified PBKAC

Rank: Moderator


 
Join Date: Jun 2008
Location: 2 clouds to your right
Posts: 1,647
10-30-2008, 06:16 PM
 
My last post:

Quote: Originally Posted by chumpywumpy View Post
FreeTDS isn't installed correctly.
 
 
permalink
 

 
Newbie

Rank: Omicron


 
Join Date: Dec 2004
Location: Latvia
Posts: 9
10-30-2008, 10:40 PM
 
[Only Registered and Activated Users Can See Links. Click Here To Register...]

Guys , as u see i have WAN and LOCAL IP that are the same ... i couldn`t find any solutions by myself so i`m asking you to help me .
1) i`m using VMware on my pc (Vista and CentOS)
2) so , basicaly i have 2 different IP`s active on each OS ( .187 for vista nad .185 for CentOS)
3) If i change the IP on CentOS ( for example to 184 ( my ISP has some free IP`s lately ;) ) then both WAN and LOCAL ip adresses changes to ....184 .
Can someone tell me where is the problem ?
 
 
permalink
 

 
Rock ON Cabal

Rank: Member


Blog Entries: 1
 
Join Date: Aug 2008
Location: cabalpilipinas....
Posts: 232
10-31-2008, 05:24 AM
 
ok im now connected to my server i would like to thank chumpy for the files and the help and the patience in answering my question

next step is configuring the server

chumpy how can i edit the rates and also in your files what are things needed to be fix?

thank you sir for the files and all the people that help me....

also thanks to Joniver....

[Only Registered and Activated Users Can See Links. Click Here To Register...]

Last edited by Cath22; 10-31-2008 at 04:52 PM.
 
 
permalink
 

 
Certified PBKAC

Rank: Moderator


 
Join Date: Jun 2008
Location: 2 clouds to your right
Posts: 1,647
11-01-2008, 11:41 AM
 
Quote: Originally Posted by FAKIR View Post
[Only Registered and Activated Users Can See Links. Click Here To Register...]

Guys , as u see i have WAN and LOCAL IP that are the same ... i couldn`t find any solutions by myself so i`m asking you to help me .
1) i`m using VMware on my pc (Vista and CentOS)
2) so , basicaly i have 2 different IP`s active on each OS ( .187 for vista nad .185 for CentOS)
3) If i change the IP on CentOS ( for example to 184 ( my ISP has some free IP`s lately ;) ) then both WAN and LOCAL ip adresses changes to ....184 .
Can someone tell me where is the problem ?
At the top of the screenshot it is saying that "cabal" is an unrecognised service so something hasn't installed properly i think. If you type "service cabal status" it will probably be the same so try installing the cabal rpm manually. Your config looks ok as the centos machine has a direct connection to the internet which is perfect.

Quote: Originally Posted by Cath22 View Post
ok im now connected to my server i would like to thank chumpy for the files and the help and the patience in answering my question

next step is configuring the server

chumpy how can i edit the rates and also in your files what are things needed to be fix?

thank you sir for the files and all the people that help me....

also thanks to Joniver....

[Only Registered and Activated Users Can See Links. Click Here To Register...]
Check my sticky in the help section as it shows where to edit rates. In terms of fixes the biggest problem at the moment is durationidx's acting up and i will be working on that this weekend as i have been too busy this week to put much time into cabal :/ Using a plain GP client (or US + darkxl's login patch) and the const.scp and product.scp from darkxl's files on the server the durationidx's will be ok but you will run into a few d/c problems buying things and a few other areas, using SAUR0N's patch in the GP or US client will be more crash proof but durationidx's will act up.
 
 
permalink
 

 
Newbie

Rank: Omicron


 
Join Date: Dec 2004
Location: Latvia
Posts: 9
11-01-2008, 12:59 PM
 
Quote: Originally Posted by chumpywumpy View Post
At the top of the screenshot it is saying that "cabal" is an unrecognised service so something hasn't installed properly i think. If you type "service cabal status" it will probably be the same so try installing the cabal rpm manually. Your config looks ok as the centos machine has a direct connection to the internet which is perfect.
Thank you for your reply , chumpywumpy ! Do you have a guide to installing cabal rpm manually ?
 
 
permalink
 

 
Certified PBKAC

Rank: Moderator


 
Join Date: Jun 2008
Location: 2 clouds to your right
Posts: 1,647
11-01-2008, 01:42 PM
 
From a centos terminal or putty use the following command:
Code:
rpm -Uvh /root/cabal-chnserverCB-1.0-2.rpm
 
 
permalink
 

 
Member

Rank: Omicron


 
Join Date: Oct 2006
Location: Poland
Posts: 47
11-01-2008, 03:06 PM
 
Chumpy, i was cofigured as the write on GUIDES
and i can't create acconut on GM Tools :(
Also server works fine (if I write something pass, they show DON't MATCH)

How create acc?
Btw. I bad config xp.mod5.dll, how to fix that?

Please help me people, or you Great Chumpy :D
 
 
permalink
 

 
Certified PBKAC

Rank: Moderator


 
Join Date: Jun 2008
Location: 2 clouds to your right
Posts: 1,647
11-01-2008, 03:27 PM
 
A broken xp_md5 config will cause this as the account passsword isn't being stored correctly. Open your "master" database and find xp_md5 in the Extended Procedures folder and check the path to the .dll is correct, if not delete the entry and re-add it:

Code:
EXEC SP_ADDEXTENDEDPROC 'xp_md5','c:\xp_md5.dll'
Also check the permissions on the .dll file to make sure that the "everyone" group has read access to it at least as i have seen a few installs where that has caused problems.
 
 
permalink
 

 
Member

Rank: Omicron


 
Join Date: Oct 2006
Location: Poland
Posts: 47
11-01-2008, 03:45 PM
 
Alright, done, very very thank you.
Next question maybe last, please listen me and help :)

When i enter my pass, and login to server is nothing goin' on
They write "You have failed...." What's going on (i make everything ok, and all works fine) :(
 
 
permalink
 

 
Newbie

Rank: Omicron


 
Join Date: Dec 2004
Location: Latvia
Posts: 9
11-01-2008, 06:17 PM
 
Quote: Originally Posted by chumpywumpy View Post
From a centos terminal or putty use the following command:
Code:
rpm -Uvh /root/cabal-chnserverCB-1.0-2.rpm

Ok , so when i type this command i get :

error : failed dependencies
libcrypto.so.4 is needed by cabal-chnserverCB-1.0-2.rpm.i386
libsssl.so.4 is needed by cabal-chnserverCB-1.0-2.rpm.i386


googled it => downloaded a rmp install file => opened it on my CentOS => couldn`t install those because i`m missing some other files that needs to be installed before this pack .

Last edited by FAKIR; 11-01-2008 at 10:59 PM.
 
 
permalink
 

 
Member

Rank: Omicron


 
Join Date: Oct 2006
Location: Poland
Posts: 47
11-01-2008, 07:20 PM
 
Hi, it's me again ^.^
I was do it my self, i change permision on cabal sql login, and all is work 100%

I got problem/question:
How confige, where etc. and run new rates on server? :D

Plx answer me, thx for help :)
 
 
permalink
 

 
Your fate is sealed!

Rank: Moderator

1 Highscore

 
Join Date: Oct 2005
Location: Italy
Posts: 1,760
11-02-2008, 11:18 AM
 
Quote: Originally Posted by FAKIR View Post
Ok , so when i type this command i get :

error : failed dependencies
libcrypto.so.4 is needed by cabal-chnserverCB-1.0-2.rpm.i386
libsssl.so.4 is needed by cabal-chnserverCB-1.0-2.rpm.i386


googled it => downloaded a rmp install file => opened it on my CentOS => couldn`t install those because i`m missing some other files that needs to be installed before this pack .
use video guide
 
 
permalink
 

 
Banned

Status: Banned


 
Join Date: Nov 2008
Posts: 24
11-02-2008, 12:05 PM
 
Is it necessary to have the older CentOS version? Sounds stupid.
 
 
permalink
 

 
Certified PBKAC

Rank: Moderator


 
Join Date: Jun 2008
Location: 2 clouds to your right
Posts: 1,647
11-02-2008, 04:45 PM
 
Quote: Originally Posted by FAKIR View Post
Ok , so when i type this command i get :

error : failed dependencies
libcrypto.so.4 is needed by cabal-chnserverCB-1.0-2.rpm.i386
libsssl.so.4 is needed by cabal-chnserverCB-1.0-2.rpm.i386


googled it => downloaded a rmp install file => opened it on my CentOS => couldn`t install those because i`m missing some other files that needs to be installed before this pack .
My files are set up for centos 4.6 or later and it sounds like you are using centos 5 which has a lot of stuff missing by default. My install script specifically asks you if you are using the centos version it expects and if you say no it will use the centos 5 install method so i'm guessing you answered wrong when running cabal_install.sh.

Quote: Originally Posted by vpower View Post
Hi, it's me again ^.^
I was do it my self, i change permision on cabal sql login, and all is work 100%

I got problem/question:
How confige, where etc. and run new rates on server? :D

Plx answer me, thx for help :)
Check the stickies in this section. This has been answered many many times.

Quote: Originally Posted by hellfireisascam View Post
Is it necessary to have the older CentOS version? Sounds stupid.
The server was designed for centos 4 but you can use the later version. I tend to recommend it because centos 5 has much more missing on a default install and for centos 4 you only need CD 1 and CD 2 so the download is smaller as well as easier to set up the cabal files on. In fact you can use the most minimal install of centos 4 (without xwindows or any GUI) and the only extra thing you need to install is qt 3.3. It is just simpler which is a real benefit because many people here have no idea about linux dependencies or how to fix them.
 
 
permalink
 

 
Member

Rank: Omicron


 
Join Date: Sep 2008
Posts: 27
11-02-2008, 05:13 PM
 
why i got an error on SQL Server Management Studio Express
 
 
permalink
 

 
Member

Rank: Omicron


 
Join Date: Jun 2008
Posts: 28
11-02-2008, 05:38 PM
 
Inappropriate language and flame removed

Last edited by chumpywumpy; 11-03-2008 at 01:32 PM. Reason: Inappropriate language and flame removed
 
 
permalink
 

 
Member

Rank: Omicron


 
Join Date: Sep 2008
Posts: 27
11-02-2008, 05:56 PM
 
shhh...
 
 
permalink
 

 
Member

Rank: Omicron


 
Join Date: Jun 2008
Posts: 28
11-02-2008, 05:58 PM
 
metrix how did u get ur .000 files working? -.-
 
 
permalink
 

 
Newbie

Rank: Omicron


 
Join Date: Dec 2004
Location: Latvia
Posts: 9
11-02-2008, 09:19 PM
 
chumpywumpy , thank you for your guides and server files ! Finally , i`ve managed to configure all required settings and successfully set up a server . Good work dude , keep it in that way !
 
 
permalink
 

 
Expired

Rank: Member


 
Join Date: Aug 2008
Location: RaGEZONE
Posts: 388
11-03-2008, 03:58 AM
 
Is there anyway how to use Cabal PH Client on Cabal Server?
 
 
permalink
 

 
Certified PBKAC

Rank: Moderator


 
Join Date: Jun 2008
Location: 2 clouds to your right
Posts: 1,647
11-03-2008, 01:37 PM
 
Quote: Originally Posted by noobmigit View Post
Inappropriate language and flame removed
Language like that is completely inappropriate and i don't appreciate being flamed either. You should have noticed that plenty of other people could tell it was a 7-zip archive and got it working and i would have explained it to you if you had asked instead of running your mouth and calling me names, not a smart thing to do to a mod. Enjoy your infraction.

Quote: Originally Posted by PostOfTheYear View Post
Is there anyway how to use Cabal PH Client on Cabal Server?
You can use the PH client but you might find you run into some d/c problems as some of the client data won't match the server. I'm not familiar enough with the PH client to know what is different though. The best thing to do is try it and see where problems show up and then post them and we can tell you what to edit.
 
 
permalink
 

 
Member

Rank: Omicron


 
Join Date: Sep 2008
Posts: 27
11-03-2008, 04:22 PM
 
how do i start the serverfiles they are at cng format
 
 
permalink
 

Closed Thread

Tags
databases, guides, server files

Thread Tools

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
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


All times are GMT +1. The time now is 10:34 PM.
Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0 RaGEZONE © 2001 - 2008





 
Evade Blackbelt School