Re: EP8 Server Files + DB by Justin Bieber
Quote:
Originally Posted by
sunlive
rm -f /var/log/cabal/*.log
rm -f /var/log/cabal/*.trc
rm -f /var/log/cabal/*.txt
rm -f /home/cabal/core.*
service DBAgent_01 restart
sleep 2
service AuthDBAgent restart
sleep 2
service GlobalDBAgent restart
sleep 2
service RockAndRollITS restart
sleep 2
service GlobalMgrSvr restart
sleep 2
service CashDBAgent restart
sleep 2
service PCBangDBAgent restart
sleep 2
service EventDBAgent restart
sleep 2
service PartySvr_01 restart
sleep 5
service EventMgrSvr restart
sleep 2
service ChatNode_01 restart
sleep 2
service AgentShop_01 restart
sleep 2
service WorldSvr_01_01 restart
sleep 2
service LoginSvr_01 restart
sleep 2
save it into startcb.sh set chmod +777 . use your brain
Go in /etc/init.d/, open cabal and add that line... (x30 made that)
Code:
#!/bin/sh
#
# Startup script for the Cabal Server
#
# chkconfig: 345 85 15
# description: Cabal World Server
# processname: WorldSvr
# Source function library.
. /etc/rc.d/init.d/functions
daemons=`cat /etc/cabal/server_list | grep -v ^#`
# See how we were called.
case "$1" in
start)
DAEMON_COREFILE_LIMIT=unlimited
for daemon in $daemons
do
echo -n "Starting $daemon: "
daemon -1 --user root $daemon
echo
sleep 3
done
;;
stop)
for daemon in $daemons
do
echo -n "Shutting down $daemon: "
killproc $daemon
echo
done
;;
status)
for daemon in $daemons
do
status $daemon
done
;;
restart)
$0 stop
$0 start
;;
reload)
for daemon in $daemons
do
echo -n "Reloading $daemon: "
killproc $daemon -HUP
echo
done
;;
*)
echo "Usage: $0 {start|stop|restart|reload|status}"
exit 1
esac
exit 0
(Red line ofc)
Re: EP8 Server Files + DB by Justin Bieber
Quote:
Originally Posted by
xiMpurex
so any "repack updates" or does anyone plan to do it? i mean for real..and sorry for being impatience, just can't wait 8D
Dont Be exited :D: Patience is virtue :thumbup: just wait about the repack,it will be release all in all soon :D:
Re: EP8 Server Files + DB by Justin Bieber
Quote:
Originally Posted by
Lazy
[##ERROR##] Initialize(): InitializeGlobals()
Btw: Any news on TDP when they could have there Repack ready for easy install?
Install Virtual Box, follow a guide on google on how to install CentOS on it. (doesent matter which one, but i still prefer 5.x,i386). Then make what x30unlimited said...
Code:
1. install centos 5.8 32bit minimal
2. do "yum update"
3. you can skip this if you want, install gnome and vnc (google how)
4. copy JUST the cabal rpm in /root (found in home/rpm)
5. install dependencies : "yum install unixODBC openssl097a net-snmp-utils net-snmp-libs net-snmp lm_sensors gcc freetds dstat compat-libstdc++-33 compat-libstdc++-296"
6. "cd /root" and "rpm -Uvh cabal-server-ph-1.0-1.i386.rpm"
7. copy the usr, home and etc folders to ur server in /
8. copy odbc.ini and odbcinst.ini to /etc
9. configure it all, manually, i haven't used any scripts :P
10. use my link and permision script (save it in /root under the name "link.sh" than do "chmod +x link.sh" and then "./link.sh")
11. "service cabal start"
I consider this a repack...
Re: EP8 Server Files + DB by Justin Bieber
Quote:
Originally Posted by
walkernight88
Install Virtual Box, follow a guide on google on how to install CentOS on it. (doesent matter which one, but i still prefer 5.x,i386). Then make what x30unlimited said...
Code:
1. install centos 5.8 32bit minimal
2. do "yum update"
3. you can skip this if you want, install gnome and vnc (google how)
4. copy JUST the cabal rpm in /root (found in home/rpm)
5. install dependencies : "yum install unixODBC openssl097a net-snmp-utils net-snmp-libs net-snmp lm_sensors gcc freetds dstat compat-libstdc++-33 compat-libstdc++-296"
6. "cd /root" and "rpm -Uvh cabal-server-ph-1.0-1.i386.rpm"
7. copy the usr, home and etc folders to ur server in /
8. copy odbc.ini and odbcinst.ini to /etc
9. configure it all, manually, i haven't used any scripts :P
10. use my link and permision script (save it in /root under the name "link.sh" than do "chmod +x link.sh" and then "./link.sh")
11. "service cabal start"
I consider this a repack...
Sir Walkernight8 i want ur help pls with ip configuring i didnt know where and what ip can i set for connection to my sever pls help me if you can thanks :D
Re: EP8 Server Files + DB by Justin Bieber
I like the tutorial and still have x30 error
Re: EP8 Server Files + DB by Justin Bieber
Re: EP8 Server Files + DB by Justin Bieber
Quote:
Originally Posted by
VizesLufi
Sir Walkernight8 i want ur help pls with ip configuring i didnt know where and what ip can i set for connection to my sever pls help me if you can thanks :D
/etc/odbc.ini
Code:
[CabalAccount]
Driver = FreeTDS
Address = MSSQL IP (Windows IP)
Port = 1433
Database = ACCOUNT
TDS_Version = 8.0
[CabalCash]
Driver = FreeTDS
Address = MSSQL IP (Windows IP)
Port = 1433
Database = CabalCash
TDS_Version = 8.0
[CabalNetCafe]
Driver = FreeTDS
Address = MSSQL IP (Windows IP)
Port = 1433
Database = NetCafeBilling
TDS_Version = 8.0
[CabalGame01]
Driver = FreeTDS
Address = MSSQL IP (Windows IP)
Port = 1433
Database = SERVER01
TDS_Version = 8.0
[EventData]
Driver = FreeTDS
Address = MSSQL IP (Windows IP)
Port = 1433
Database = EventData
TDS_Version = 8.0
[Authentication]
Driver = FreeTDS
Address = MSSQL IP (Windows IP)
Port = 1433
Database = Authentication
TDS_Version = 8.0
In /etc/cabal/AuthDBAgen.ini, CashDBAgent.ini, DBAgent_01.ini, EventDBAgent.ini, GlobalDBAgent.ini, PcBangDBAgent.ini find and replace with these:
Code:
DBId=sa
DBPwd=MSSQL PASSWORD
In /etc/cabal/WorldSvr_01_xx.ini add your WAN IP on these lines:
Code:
IPAddress=xxx.xxx.xxx.xxx
AddrForClient=xxx.xxx.xxx.xxx
AddrForClient=xxx.xxx.xxx.xxx
Good luck...
Re: EP8 Server Files + DB by Justin Bieber
Quote:
Originally Posted by
cypher
Thanks cypher now i understand that cuz i have now other problem with when i start "service cabal start" command i use to "service cabal status" command this say ChatNode01 is stopped and all Ch too...
Here is my ChatNode01 log if any1 know the problem help me!
Quote:
[Wed Jan 23 2013 21:56:02.638928 3086756480]: [##ERROR##] connect 127.0.0.1:38170 fail
[Wed Jan 23 2013 21:56:02.639066 3086756480]: [##ERROR##] Link(): link open fail(Automatic), Exit
[Wed Jan 23 2013 21:56:02.639115 3086756480]: [##ERROR##] RunServer(): active fail
[Wed Jan 23 2013 21:56:02.639160 3086756480]: waiting for caching(PR message)
[Wed Jan 23 2013 21:56:02.639452 3023543184]: CProcessLayer(0)::svc Start [3023543184]
[Wed Jan 23 2013 21:56:02.639529 3023543184]: CProcessLayer(0)::svc Terminated [3023543184]
[Wed Jan 23 2013 21:56:02.639875 3013053328]: CProcessLayer(0)::svc Start [3013053328]
[Wed Jan 23 2013 21:56:02.639934 3013053328]: CProcessLayer(0)::svc Terminated [3013053328]
[Wed Jan 23 2013 21:56:02.640096 3086482320]: [##ERROR##] getq fail (108)
[Wed Jan 23 2013 21:56:02.640145 3086482320]: CProcessLayer(0)::svc Terminated [3086482320]
[Wed Jan 23 2013 21:56:02.640288 3075992464]: [##ERROR##] getq fail (108)
[Wed Jan 23 2013 21:56:02.640337 3075992464]: CProcessLayer(0)::svc Terminated [3075992464]
[Wed Jan 23 2013 21:56:02.640412 3065502608]: [##ERROR##] getq fail (108)
[Wed Jan 23 2013 21:56:02.640476 3065502608]: CProcessLayer(0)::svc Terminated [3065502608]
[Wed Jan 23 2013 21:56:02.640549 3055012752]: [##ERROR##] getq fail (108)
[Wed Jan 23 2013 21:56:02.640596 3055012752]: CProcessLayer(0)::svc Terminated [3055012752]
[Wed Jan 23 2013 21:56:02.640676 3044522896]: [##ERROR##] getq fail (108)
[Wed Jan 23 2013 21:56:02.640724 3044522896]: CProcessLayer(0)::svc Terminated [3044522896]
[Wed Jan 23 2013 21:56:02.640790 3034033040]: [##ERROR##] getq fail (108)
[Wed Jan 23 2013 21:56:02.640837 3034033040]: CProcessLayer(0)::svc Terminated [3034033040]
[Wed Jan 23 2013 21:56:02.641073 3086756480]: try listening 38121 port
[Wed Jan 23 2013 21:56:02.641536 3086756480]: FinalEnv BEGIN
[Wed Jan 23 2013 21:56:02.642321 3086756480]: FinalEnv END
Re: EP8 Server Files + DB by Justin Bieber
Quote:
Originally Posted by
VizesLufi
Thanks cypher now i understand that cuz i have now other problem with when i start "service cabal start" command i use to "service cabal status" command this say ChatNode01 is stopped and all Ch too...
Here is my ChatNode01 log if any1 know the problem help me!
Check AuthDBAgent logs... I think you didn't configure ODBC how it must be configured. DB Connection failed on other processes gives your errors...
Re: EP8 Server Files + DB by Justin Bieber
Quote:
Originally Posted by
walkernight88
/etc/odbc.ini
Code:
[CabalAccount]
Driver = FreeTDS
Address = MSSQL IP (Windows IP)
Port = 1433
Database = ACCOUNT
TDS_Version = 8.0
[CabalCash]
Driver = FreeTDS
Address = MSSQL IP (Windows IP)
Port = 1433
Database = CabalCash
TDS_Version = 8.0
[CabalNetCafe]
Driver = FreeTDS
Address = MSSQL IP (Windows IP)
Port = 1433
Database = NetCafeBilling
TDS_Version = 8.0
[CabalGame01]
Driver = FreeTDS
Address = MSSQL IP (Windows IP)
Port = 1433
Database = SERVER01
TDS_Version = 8.0
[EventData]
Driver = FreeTDS
Address = MSSQL IP (Windows IP)
Port = 1433
Database = EventData
TDS_Version = 8.0
[Authentication]
Driver = FreeTDS
Address = MSSQL IP (Windows IP)
Port = 1433
Database = Authentication
TDS_Version = 8.0
In /etc/cabal/AuthDBAgen.ini, CashDBAgent.ini, DBAgent_01.ini, EventDBAgent.ini, GlobalDBAgent.ini, PcBangDBAgent.ini find and replace with these:
Code:
DBId=sa
DBPwd=MSSQL PASSWORD
In /etc/cabal/WorldSvr_01_xx.ini add your WAN IP on these lines:
Code:
IPAddress=xxx.xxx.xxx.xxx
AddrForClient=xxx.xxx.xxx.xxx
AddrForClient=xxx.xxx.xxx.xxx
Good luck...
Very very thanks bro now i will try to connect :D <3
Re: EP8 Server Files + DB by Justin Bieber
Quote:
Originally Posted by
walkernight88
Code:
[CabalAccount]
Driver = FreeTDS
Address = MSSQL IP (Windows IP)
Port = 1433
Database = ACCOUNT
TDS_Version = 8.0
[CabalCash]
Driver = FreeTDS
Address = MSSQL IP (Windows IP)
Port = 1433
Database = CabalCash
TDS_Version = 8.0
[CabalNetCafe]
Driver = FreeTDS
Address = MSSQL IP (Windows IP)
Port = 1433
Database = NetCafeBilling
TDS_Version = 8.0
[CabalGame01]
Driver = FreeTDS
Address = MSSQL IP (Windows IP)
Port = 1433
Database = SERVER01
TDS_Version = 8.0
[EventData]
Driver = FreeTDS
Address = MSSQL IP (Windows IP)
Port = 1433
Database = EventData
TDS_Version = 8.0
[Authentication]
Driver = FreeTDS
Address = MSSQL IP (Windows IP)
Port = 1433
Database = Authentication
TDS_Version = 8.0
TDS_Version = 8.0 you use sql 2005? 0.o
replace with TDS_Version = 10.0
10 were use sql 2008
Re: EP8 Server Files + DB by Justin Bieber
MSSQL 2008 R2 works fine even if it's 8.0 9.0 10.0.... :) Useless comment...
Re: EP8 Server Files + DB by Justin Bieber
Quote:
Originally Posted by
walkernight88
MSSQL 2008 R2 works fine even if it's 8.0 9.0 10.0.... :) Useless comment...
oh sry ><
1 Attachment(s)
Re: EP8 Server Files + DB by Justin Bieber
walkernight88
i can't select channel help
Attachment 121986
EventDBAgent error
[Thu Jan 24 2013 11:18:43.102337 3034155920]: [##ERROR##] OnIPCEMSGetEvents fail
[Thu Jan 24 2013 11:18:43.102384 3034155920]: [##ERROR##] DB ERROR(MSG) : Incompatible data types in stream operation
[Thu Jan 24 2013 11:18:43.102401 3034155920]: [##ERROR##] DB ERROR(CODE) : 32000
[Thu Jan 24 2013 11:18:43.102415 3034155920]: [##ERROR##] DB ERROR(VAR_INFO) : Column: 3<TIMESTAMP>, datatype in operator <</>>: INT
[Thu Jan 24 2013 11:18:43.102429 3034155920]: [##ERROR##] DB ERROR(SQLSTATE) :
[Thu Jan 24 2013 11:18:43.102443 3034155920]: [##ERROR##] DB ERROR(STM_TEXT) : {call dbo.cabal_sp_ems_get_events}
Re: EP8 Server Files + DB by Justin Bieber
Quote:
Originally Posted by
aeyemo
walkernight88
i can't select channel help
Attachment 121986
EventDBAgent error
[Thu Jan 24 2013 11:18:43.102337 3034155920]: [##ERROR##] OnIPCEMSGetEvents fail
[Thu Jan 24 2013 11:18:43.102384 3034155920]: [##ERROR##] DB ERROR(MSG) : Incompatible data types in stream operation
[Thu Jan 24 2013 11:18:43.102401 3034155920]: [##ERROR##] DB ERROR(CODE) : 32000
[Thu Jan 24 2013 11:18:43.102415 3034155920]: [##ERROR##] DB ERROR(VAR_INFO) : Column: 3<TIMESTAMP>, datatype in operator <</>>: INT
[Thu Jan 24 2013 11:18:43.102429 3034155920]: [##ERROR##] DB ERROR(SQLSTATE) :
[Thu Jan 24 2013 11:18:43.102443 3034155920]: [##ERROR##] DB ERROR(STM_TEXT) : {call dbo.cabal_sp_ems_get_events}
MSSQL Errors, did you erased the old data from DB and added a linked server "Gameserver" ?
