EP8 Repack, prerelease

[SpawnSiviu]

OK ... This is starting to be a big pain in the B*T!
Done what you told me, everything is on green (port open, connection succeeded, connected) but services are stil stopped.
I can connect to the database with CabalGMTools and BeGa Admin Tool every thing works fine, but the damn services wil not start!
tried manualy start them xxx times ... stil stopped imediatly.
Do you have Yahoo ID so we can talk better pls ...

 

[toast2250]

Which repack are you using now? Try to do manually service ChatNode_01 restart.

 

[SpawnSiviu]

downloaded your repack like 2 days ago and using it right now (still services are stopped)! i did a manually start and restart of the services but it says starting ChatNode_01 [OK], and when i run service ChatNode_01 status it gives me stopped!

 

[toast2250]

Post your logs from /var/log/cabal. It is unusual that the services would not start if isql Connected!.

 

[SpawnSiviu]

Here are my logs!!
View attachment Logs.7z

 

[toast2250]

You said that you have 'manually edited the files in the etc folder and etc/cabal'.

There is absolutely no need to do that at the start in either of repacks.

In GlobalMgrSvr.log there is
[##ERROR##] connect 0.0.0.0:0 fail (not sure why, my ssd has issues so I cant test)

Most important is in AuthDBAgent.log
[##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Cannot open database "Authentication" requested by the login. The login failed
[##ERROR##] Database Connect Fail (uid=xx;pwd=xxxx;dsn=Authentication;APP=AuthDBAgent)

AuthDBAgent is the first service that runs, so there should be no problems. You must have messed up something, run cabal install again and reenter the Info in the cabal config command.

 

[SpawnSiviu]

OK ...
Did it again!

installed cabal server again!


service cabal configure




service cabal start and service cabal status


What did i do wrong??

 

[SpawnSiviu]

OK ... found something interesting in the MySQL Server logs ...

2013-05-14 13:53:18.84 spid1s Server resumed execution after being idle 228 seconds. Reason: timer event.
2013-05-14 15:27:19.16 spid51 Starting up database 'Account'.
2013-05-14 15:27:24.45 spid51 Recovery completed for database Account (database ID 5) in 1 second(s) (analysis 388 ms, redo 0 ms, undo 344 ms.) This is an informational message only. No user action is required.
2013-05-14 15:33:11.61 Logon Error: 18456, Severity: 14, State: 38.
2013-05-14 15:33:11.61 Logon Login failed for user 'sa'. Reason: Failed to open the explicitly specified database. [CLIENT: 192.168.0.253]
2013-05-14 15:34:00.80 Logon Error: 18456, Severity: 14, State: 38.
2013-05-14 15:34:00.80 Logon Login failed for user 'sa'. Reason: Failed to open the explicitly specified database. [CLIENT: 192.168.0.253]
2013-05-14 15:35:37.09 spid53 Starting up database 'Server01'.
2013-05-14 15:56:34.90 Logon Error: 18456, Severity: 14, State: 38.
2013-05-14 15:56:34.90 Logon Login failed for user 'sa'. Reason: Failed to open the explicitly specified database. [CLIENT: 192.168.0.251]
2013-05-14 15:59:52.53 spid51 Starting up database 'EventData'.
2013-05-14 16:02:08.68 Logon Error: 18456, Severity: 14, State: 38.
2013-05-14 16:02:08.68 Logon Login failed for user 'sa'. Reason: Failed to open the explicitly specified database. [CLIENT: 192.168.0.251]
2013-05-14 16:02:54.38 Logon Error: 18456, Severity: 14, State: 38.
2013-05-14 16:02:54.38 Logon Login failed for user 'sa'. Reason: Failed to open the explicitly specified database. [CLIENT: 192.168.0.251]
2013-05-14 16:19:35.98 Logon Error: 18456, Severity: 14, State: 38.
2013-05-14 16:19:35.98 Logon Login failed for user 'sa'. Reason: Failed to open the explicitly specified database. [CLIENT: 192.168.0.251]
2013-05-14 16:26:12.48 Logon Error: 18456, Severity: 14, State: 38.
2013-05-14 16:26:12.48 Logon Login failed for user 'sa'. Reason: Failed to open the explicitly specified database. [CLIENT: 192.168.0.251]
2013-05-14 16:49:31.54 Logon Error: 18456, Severity: 14, State: 38.
2013-05-14 16:49:31.54 Logon Login failed for user 'sa'. Reason: Failed to open the explicitly specified database. [CLIENT: 192.168.0.251]
2013-05-14 16:52:21.08 Logon Error: 18456, Severity: 14, State: 38.
2013-05-14 16:52:21.08 Logon Login failed for user 'sa'. Reason: Failed to open the explicitly specified database. [CLIENT: 192.168.0.251]
2013-05-14 18:29:00.26 Logon Error: 18456, Severity: 14, State: 38.
2013-05-14 18:29:00.26 Logon Login failed for user 'sa'. Reason: Failed to open the explicitly specified database. [CLIENT: 192.168.0.251]
2013-05-14 18:48:19.01 Logon Error: 18456, Severity: 14, State: 38.
2013-05-14 18:48:19.01 Logon Login failed for user 'sa'. Reason: Failed to open the explicitly specified database. [CLIENT: 192.168.0.251]

This seems to be a big problem ...

 

[toast2250]

MySQL? You sure its not MSSQL? Have you installed MSSQL exactly like the guide from Extornia tells you?

You must be registered to see links

 

[SpawnSiviu]

I did it exactly as the guide in extornias post ...

 

[toast2250]

Strange, well,.. I'm no expert but from the logs all I see is that many services cant connect to port 38170 which is GlobalMgrSvr and AuthDBAgent having problems connecting with MSSQL.

Cabal is very annoying to run, one example is when you find in the networking a duplicate of eth0 bak. No matter if you delete all of them and create a new eth0 network settings, the world srv will not show up in the server menu windows when you restart the services.

The world service somehow chooses the old eth0 or something which does not even exist anymore or is stuck somewhere,.. rare occasion.

This issue occurs when you move the VM file around, changing MAC address, network, the only easy fix is to then reinstall CentOS.

 

[SpawnSiviu]

will try again soon and i want to try the SQL Server in CentOS ... No VM ... hope to find a way to restore DB from files or create backup machine in linux ... will post soon with results!
maybe i will get it to work soon!
TY for you help so far ... hope you could help me with other problems if they appear!

 

[Nadiell]

It works 98 % for me,2% left to make the channels to appear but i didn't succesful,i tried even for 3 hours,i changed magic keys/client version and still the same, type server cabal status and everything is ok*running,but channel doesn't appear,any ideea ?
#Thanks !

 

[SpawnSiviu]

Sorry for the late post! Everything works good, i had a typing error in the database ... sorry for that! Thank you for your help ...
I have to find some other things to solve now! Good luck in further developments!

nadiell ... you say that your channels don't appear, if you install the server right you should have only one channel after like 2 min after the server is started!
try using your CentOS IP for players to connect ... if i put my internet IP there i can't connect to the server!

 

[FinalNotice]

... if i put my internet IP there i can't connect to the server!

try look at here
http://forum.ragezone.com/f460/basic-guide-networking-ip-addresses-545188/

 

[SpawnSiviu]

i now it is possible to play from outside the LAN ... but my server if for testing for the moment and is behind 2 routers and a ADSL internet connection (no static IP for this connection, changes from time to time)... so ... till i will get all things done it is just for testing new stuff ... when i will get all things done i will contract other internet provider for a normal connection or a optic fiber one to get my server online for others to play the game as it should be ... not the screwed up game the GMs made from the original one! TY all for your help and very good tutorials! great work ... keep it that way!

 

[nescafeIV]

try upgrade ram 2gb or more in centos..

 

[netsstea]

how do I modify the list of services each time I called command cabal_start
and how to add new services in the Services list and make it work.!

for example : "service WorldSvr_hardcore start " ( i want open test channel ^^ so i need control it)

 

[toast2250]

cabal_start is a symbolic link command to cabal_start.sh, all of the services are listed there with a start delay between each other.
ln -sf /home/cabal/cabal_start.sh /usr/bin/cabal_start

server_list is still being used as usual except for the service cabal start and CentOS boot which without the cabal_start.sh wont work. :blush:

daemons=`cat /etc/cabal/server_list | grep -v ^#`

# See how we were called.
case "$1" in
		
[B]  start)
	/home/cabal/cabal_start.sh
        ;;[/B]
  stop)
	for daemon in $daemons
	do
		echo -n "Shutting down $daemon: "
		killproc $daemon
		echo
	done
        ;;

If you prefer a built in start delay between services in /init.d/cabal then you can check out:
http://forum.ragezone.com/f460/service-cabal-new-commands-925020/ by hefajstos

I will add cabal_logdel and maybe adapt some of the stuff, with full credits off course!
I prefer short links to sh scripts.

If you want to do service WorldSvr_hardcore start then you will have to symbolically link it first.

ln -sf /etc/init.d/cabal_server /etc/init.d/WorldSvr_01_16

 

[xircx]

When i installed it on Centos in VirtBox i also had the same errors/problem. I ended up reinstalling centos to correct this. not sure how but it fixed it.