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; goto My Network Place -> View Network Connection -> Right Click Local Area Connection -> Status -> click support tab ...




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

Rank: Omicron


 
Join Date: Mar 2007
Location: Republic of the Philippines
Posts: 40
10-22-2008, 05:00 PM
 
goto My Network Place -> View Network Connection -> Right Click Local Area Connection -> Status -> click support tab -> then you will see the net mask -> for Detailed IP's -> click the Details... Button
 
 
permalink
 

 
Newbie

Rank: Omicron


 
Join Date: Sep 2008
Posts: 15
10-22-2008, 05:10 PM
 
just a tip..
for ip... pick an ip that is unused.. example ur lan ip is 192.168.0.160 u can pick an ip like 192.168.0.150 or any ip within range to be ur Cent OS ip

for net mask.. u can find it using using ipconfig

for gateway... the same as net mask

for primary dns... i suggest using opendns ip. 208.67.222.222

dats how i did with the centos part.. (i restart my computer after installing centos---not useful i think)

^_^
 
 
permalink
 

 
RaGEZONER

Rank: Omicron


 
Join Date: May 2007
Posts: 94
10-22-2008, 05:14 PM
 
Quote: Originally Posted by akitoxakabane View Post
just a tip..
for ip... pick an ip that is unused.. example ur lan ip is 192.168.0.160 u can pick an ip like 192.168.0.150 or any ip within range to be ur Cent OS ip

for net mask.. u can find it using using ipconfig

for gateway... the same as net mask

for primary dns... i suggest using opendns ip. 208.67.222.222

dats how i did with the centos part.. (i restart my computer after installing centos---not useful i think)

^_^
Thank you guyz very much but lan, does that count in as cable internet ? (modem)..? cause i got modem.
 
 
permalink
 

 
Newbie

Rank: Omicron


 
Join Date: Sep 2008
Posts: 15
10-22-2008, 05:19 PM
 
modem has different address from lan i think.... wat do u see wen u run cmd>ipconfig???? it should show addresses of the "Ethernet adapter Local Area Connection".. those addresses are the relevant ones....
 
 
permalink
 

 
Member

Rank: Omicron


 
Join Date: Mar 2007
Location: Republic of the Philippines
Posts: 40
10-22-2008, 05:22 PM
 
Akitoxakabane its ur turn^_^

i give some guide already but not work :(

demonite try akitoxakabane's guide and tips :)
 
 
permalink
 

 
Newbie

Rank: Omicron


 
Join Date: Sep 2008
Posts: 15
10-22-2008, 05:26 PM
 
hehehe. i want to help others too. ^_^

@demonite

if u can give a screenshot of ur ipconfig results under Ethernet adapter Local Area Connection, i think i can suggest an ip u can use for cent.os... and reinstalling it with that new ip is the best way i think... ^_^
 
 
permalink
 

 
Average Member

Rank: Omicron


 
Join Date: Oct 2008
Location: localhost
Posts: 68
10-22-2008, 05:55 PM
 
That is bad my friend. When you ping from CentOS to the windows, you have got to type in the IP instead of the word win.dows.ip. Your CentOS was able to ping your windows just fine according to your picture. The windows to CentOS ip lost 1 packet, but if you ping it one more time, it should work. However, I shouldn't be talking LOL, I still can't get my Cabal server to connect to my database :(
 
 
permalink
 

 
Member

Rank: Omicron


 
Join Date: Mar 2007
Location: Republic of the Philippines
Posts: 40
10-22-2008, 06:02 PM
 
Demonite not Reply ^__^

i think his sleeping to take a rest XD

good monring AKITOXAKABANE +008GMT
 
 
permalink
 

 
Newbie

Rank: Omicron


 
Join Date: Feb 2007
Posts: 23
10-22-2008, 06:10 PM
 
chumpy or cypher can you help me plz
i have an problem with log in.......ive changed the ips in \etc\cabal i put the ip from centos.....and ive tryed to connect with cabal client...sauron patch,GP patch,TFN patch and nothing its says please try later i cant login what to do?(and yes ive put the internal with centos ip and i start the game with start-cabal.bat)
 
 
permalink
 

 
Your fate is sealed!

Rank: Moderator

1 Highscore

 
Join Date: Oct 2005
Location: Italy
Posts: 1,760
10-22-2008, 06:21 PM
 
I would recommend not to share you yahoo id so willingly if you don`t want spams... and i will help you here... use the forum xD
 
 
permalink
 

 
Member

Rank: Omicron


 
Join Date: Mar 2007
Location: Republic of the Philippines
Posts: 40
10-22-2008, 06:22 PM
 
Quote: Originally Posted by cypher View Post
I would recommend not to share you yahoo id so willingly if you don`t want spams... and i will help you here... use the forum xD
[mod]Cypher

i Agree XD
 
 
permalink
 

 
Certified PBKAC

Rank: Moderator


 
Join Date: Jun 2008
Location: 2 clouds to your right
Posts: 1,647
10-22-2008, 07:32 PM
 
Quote: Originally Posted by crystishor View Post
chumpy or cypher can you help me plz
i have an problem with log in.......ive changed the ips in \etc\cabal i put the ip from centos.....and ive tryed to connect with cabal client...sauron patch,GP patch,TFN patch and nothing its says please try later i cant login what to do?(and yes ive put the internal with centos ip and i start the game with start-cabal.bat)
Failing to log inis a misconfiguration problem normally. If you are using my repack then please read the instructions again as at no point do i suggest editing one single ini (or any other) file. I wrote cabal_config.sh specifically because of the sheer number of people who mess up their configs by editing random things without any idea of what the things they are changing do, and if you follow the instructions the ONLY thing you need to know is the centos ip, the windows ip and your sql login infos. I did not spend all that time writing the config script to have to then manually fix half the cabal servers here after trying to guess your configs.
 
 
permalink
 

 
Member

Rank: Omicron


 
Join Date: Jul 2006
Location: Hell
Posts: 38
10-22-2008, 07:36 PM
 
Quote: Originally Posted by felipeluzentti View Post
[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)

anyone know what the problem is?
 
 
permalink
 

 
Newbie

Rank: Omicron


 
Join Date: Feb 2007
Posts: 23
10-22-2008, 07:42 PM
 
so plz tell what i did wrong, i changed the ip in etc at odbc.cfg and i changed the ips and put dbuser id meaning "sa" and password from etc/cabal at CashDBAgent.cfg,ChatNode.cfg,DBAgent.cfg,GlobalDBA gent.cfg,GlobalMgrSvr.cfg,LoginSvr.cfg,WorldSvr.cf g after i installed the server like in your images.....only differs ips and dbpassword, configured the server and started...and still i cant log in what to do next what i forgot to do....i have centos CentOS-4.4-i386-LiveCD.iso the internet connection at centos is NAT its maybe of that?because i tryed the bridget one and its says failed when it tryes to install and i left it NAT....i dont have router i have ip stable
 
 
permalink
 

 
Average Member

Rank: Omicron


 
Join Date: Oct 2008
Location: localhost
Posts: 68
10-22-2008, 08:43 PM
 
Chumpy or anyone :)

When you have a chance, could you please look at these log files?? I've been racking my brain up trying to get the Cabal server to connect to the database and it seems like it's not working. I am able to ping CentOs from Windows and Windows from CentOS. I redo the database 3 times already and it's still not working. Followed your instruction, I created a user (cabal) and make it the DBO of ACCOUNT, cabal_managerdb, CabalCash, Cabal_stat, Event, and Gamedb. When I linked the server, I put my database IP instead of "localhost". The weird thing is, when I use your GM tool and log in as "cabal" I cannot create new user becasue it kept saying, "Duplicate row. Player already exits?" when I know for sure that player has not been created. However, when I log in as "sa" with your GM tool, I am able to create user..it's odd because I did not set anything for the user "sa".

Also, I did put in the file "libtdsodbc.so.0" as DarkCycle suggested in the \root\ep2\usr\lib folder and I still see the error that says it cannot open it in the DBAgent_24 log file. I even double check to make sure FreeTDS is installed by running "Yum install Freetds" under root after I ran the chmod 0777 ./cabal_install.sh --->./cabal_install.sh. When I clicked on the "Database Diagram" of all the database (with the exception of Gamedb), I kept getting this message

"Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects."

Is this the reason why I can't connect to the databse?

At first, I try to rectify it by right click on the Databse, go to properties, and click on the Files, then I choose the owner of the database and put in "sa", and hit Ok. After that, the diagram message disappear and I was able to install the diagram support.

Unfortunately, this didn't really solved anything. When I ran the /hom/cabal/cabal_install.config, I tried both my databse IP (192.168.1.146 and 127.0.0.1) and used both "cabal" login and "sa" login...and it still didn't work.

Other than running the chmod 0777 ./cabal_install.sh ---> then ./cabal_install.sh, and /home/cabal/cabal_config.sh, I did not alter anything else in the Ep2 folder. I've attached some of the log file from the CentOS server, please review them when you have some time. I am about ready to quit, but I REALLY REALLY HATE QUITTING...so please, I really need your help
Attached Files
File Type: txt ChatNode_24.txt (10.1 KB, 10 views)
File Type: txt GlobalMgrSvr.txt (10.6 KB, 6 views)
File Type: txt GlobalDBAgent.txt (4.9 KB, 4 views)
File Type: txt dbagent24.txt (8.0 KB, 3 views)

Last edited by Dinh; 10-23-2008 at 12:45 AM.
 
 
permalink
 

 
Member

Rank: Omicron


 
Join Date: Mar 2007
Location: Republic of the Philippines
Posts: 40
10-23-2008, 01:16 AM
 
For Those People Asking on HOW TO's

There is a FAQ Made by Chumpy

---> [Only Registered and Activated Users Can See Links. Click Here To Register...] <---
 
 
permalink
 

 
Certified PBKAC

Rank: Moderator


 
Join Date: Jun 2008
Location: 2 clouds to your right
Posts: 1,647
10-23-2008, 12:47 PM
 
Quote: Originally Posted by felipeluzentti View Post
anyone know what the problem is?
Quote: Originally Posted by crystishor View Post
so plz tell what i did wrong, i changed the ip in etc at odbc.cfg and i changed the ips and put dbuser id meaning "sa" and password from etc/cabal at CashDBAgent.cfg,ChatNode.cfg,DBAgent.cfg,GlobalDBA gent.cfg,GlobalMgrSvr.cfg,LoginSvr.cfg,WorldSvr.cf g after i installed the server like in your images.....only differs ips and dbpassword, configured the server and started...and still i cant log in what to do next what i forgot to do....i have centos CentOS-4.4-i386-LiveCD.iso the internet connection at centos is NAT its maybe of that?because i tryed the bridget one and its says failed when it tryes to install and i left it NAT....i dont have router i have ip stable
No no no. YOU DO NOT EDIT THE CFG FILES, i seem to say this every day and people are STILL editing things by hand which is completely wrong and you have broken your install. cabal_config.sh RELIES on you not editing the cfg files and if you do so the script cannot find the values it nees to change when you run it which results in a config that doesn't work.

Re-copy the ep 2 files back to the centos machine. DO NOT EDIT ONE SINGLE FILE. Now run cabal_config.sh and answer it's questions. It is that simple.

Quote: Originally Posted by Dinh View Post
Chumpy or anyone :)

When you have a chance, could you please look at these log files?? I've been racking my brain up trying to get the Cabal server to connect to the database and it seems like it's not working. I am able to ping CentOs from Windows and Windows from CentOS. I redo the database 3 times already and it's still not working. Followed your instruction, I created a user (cabal) and make it the DBO of ACCOUNT, cabal_managerdb, CabalCash, Cabal_stat, Event, and Gamedb. When I linked the server, I put my database IP instead of "localhost". The weird thing is, when I use your GM tool and log in as "cabal" I cannot create new user becasue it kept saying, "Duplicate row. Player already exits?" when I know for sure that player has not been created. However, when I log in as "sa" with your GM tool, I am able to create user..it's odd because I did not set anything for the user "sa".

Also, I did put in the file "libtdsodbc.so.0" as DarkCycle suggested in the \root\ep2\usr\lib folder and I still see the error that says it cannot open it in the DBAgent_24 log file. I even double check to make sure FreeTDS is installed by running "Yum install Freetds" under root after I ran the chmod 0777 ./cabal_install.sh --->./cabal_install.sh. When I clicked on the "Database Diagram" of all the database (with the exception of Gamedb), I kept getting this message

"Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects."

Is this the reason why I can't connect to the databse?

At first, I try to rectify it by right click on the Databse, go to properties, and click on the Files, then I choose the owner of the database and put in "sa", and hit Ok. After that, the diagram message disappear and I was able to install the diagram support.

Unfortunately, this didn't really solved anything. When I ran the /hom/cabal/cabal_install.config, I tried both my databse IP (192.168.1.146 and 127.0.0.1) and used both "cabal" login and "sa" login...and it still didn't work.

Other than running the chmod 0777 ./cabal_install.sh ---> then ./cabal_install.sh, and /home/cabal/cabal_config.sh, I did not alter anything else in the Ep2 folder. I've attached some of the log file from the CentOS server, please review them when you have some time. I am about ready to quit, but I REALLY REALLY HATE QUITTING...so please, I really need your help
The database diagrams are not necessary and are always missing unless you create them.

This is showing up in your logs:
Quote:
/usr/lib/libtdsodbc.so.0: requires glibc 2.5 or later dynamic linker
This should have been solved by installing freetds. What centos version do you use? I have had 3 or 4 reports of freetds being missing now which didn't happen in v1 of my repack and i am guessing that something is failing during cabal_install.sh but nobody has reported any errors so i'm a bit ballfed how just this one rpm is getting missed out.

During cabal_install.sh when asked if you were installing on centos 4 did you enter anything or did you just press Enter?
 
 
permalink
 

 
Member

Rank: Omicron


 
Join Date: Jun 2008
Posts: 46
10-23-2008, 04:10 PM
 
Oya almost forgt abt my error u say u needme to test out something?
Sry I was working on other server......

Thx
 
 
permalink
 

 
Average Member

Rank: Omicron


 
Join Date: Oct 2008
Location: localhost
Posts: 68
10-23-2008, 05:11 PM
 
Thanks for the reply Chumpy. It's always great to hear from ya. I am running CentOS 4.7 final version and when I ran the cabal_config.sh, I usually just press Enter when it asked me am I running CentOS 4. But I tried pressing Y too and it doesn't really do anything. And I did open port 1433 in windows firewall and was able to telnet to the database through windows and CentOS. I am willing to try another version if you can suggest me one that will work. Please let me know :)
 
 
permalink
 

 
Newbie

Rank: Omicron


 
Join Date: Feb 2007
Posts: 23
10-23-2008, 09:44 PM
 
k chumpy i installed centos again......installed the server configured ...not manually and still i cant log in
 
 
permalink
 

 
Newbie

Rank: Omicron


 
Join Date: May 2008
Posts: 1
10-24-2008, 01:30 AM
 
@chumpywumpy
Need Help plsss....... when i run my server my worldsvr_01_01 is ok, but when i try to connect from client i get disconnected. and then when i check it in the service cabal status its say its stopped. help me please thx before
Attached Images
File Type: jpg worldsvr.JPG (201.2 KB, 18 views)
 
 
permalink
 

 
Member

Rank: Omicron


 
Join Date: Mar 2007
Location: Republic of the Philippines
Posts: 40
10-24-2008, 07:38 AM
 
[Question]

What Are The Ports do i need to Forward
  • 38101
  • 38121
What Else ???

Anyone can answer ?
Thanks


EDIT :

IM USING SQL2000 + SP4

ADD:

Chumpy im stack AT Connecting Server When i log in and i choose server when i click its always connecting

how can i fixed that ? i used ur REPACK v2 and DATAbase...

i used GP + Sauron

and how can i make GM account ??

Thanks

if ever chumpywill not reply anyone can help me ?


EDIT :

STACK @ SERVER SELECTION
When i choose Channel its Loading but Failed after a while

" Please Try Again Later "

Last edited by tzinpo; 10-24-2008 at 10:44 AM.
 
 
permalink
 

 
Certified PBKAC

Rank: Moderator


 
Join Date: Jun 2008
Location: 2 clouds to your right
Posts: 1,647
10-24-2008, 12:44 PM
 
Sorry i wasn't here answering posts last night. I have managed to destroy windows on my home pc last night (again) and i am going to have to back up all my data and rebuild when i get home from work. I won't be able to go through the recent posts until either late tonight or tomorrow morning, but i will be going through them asap so don't think i am ignoring you ;)
 
 
permalink
 

 
Member

Rank: Omicron


 
Join Date: Mar 2007
Location: Republic of the Philippines
Posts: 40
10-24-2008, 01:04 PM
 
Quote: Originally Posted by chumpywumpy View Post
Sorry i wasn't here answering posts last night. I have managed to destroy windows on my home pc last night (again) and i am going to have to back up all my data and rebuild when i get home from work. I won't be able to go through the recent posts until either late tonight or tomorrow morning, but i will be going through them asap so don't think i am ignoring you ;)

Chumpy Goodluck and godbless....

im going to wait for your reply about my simple problem :)

hope you can answer it soon

See yah !
 
 
permalink
 

 
MMORPG-DEVELOPMENT.CO.NR

Rank: Member


 
Join Date: Aug 2007
Location: PrOuD To Be Ka - FuSo
Posts: 1,360
10-24-2008, 06:24 PM
 
make on help section... not here?
 
 
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:25 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