IP problem

[elfrind]

Hello
This time i have problem with connecting to my Data Base.
When i check logs i always get ERROR about 'Port already in use'
For example such one:

[##ERROR##] listen 38121 port fail (Address already in use)

I checked my firewall and everything and dunno why it happens. In DBAgent_24.ini i have correct settings of my ip. I'm sure about it. And My user has permission to connect DB, so my question is what to do?
Thanks,
Elfrind

[MentaL]

[chumpywumpy]

This happens when you stop and start the server a lot whilt playing with the config. It means that there is another DBAgent already running.

Usually you can just reboot centos to cure it but if it doesn't go away then you have some extra symbolic links in /etc/rc.d/init.d/, make sure you only have your *_24 ones and only one of each. Delete any that shouldn't be there and reboot.

I would suggest having a look at my server repack as my gen_config2.sh is modded to prevent problems like this. If you always use gen_config2 to reset the server config it will take care of problems like that for you.

[elfrind]

This happens when you stop and start the server a lot whilt playing with the config. It means that there is another DBAgent already running.

Usually you can just reboot centos to cure it but if it doesn't go away then you have some extra symbolic links in /etc/rc.d/init.d/, make sure you only have your *_24 ones and only one of each. Delete any that shouldn't be there and reboot.

I would suggest having a look at my server repack as my gen_config2.sh is modded to prevent problems like this. If you always use gen_config2 to reset the server config it will take care of problems like that for you.

Hmm I reinstalled whole CentOS and installed everything from your files and i still have same error. What can it be?

[elfrind]

Some more logs from GlobalDBAgent.log

..........
[Sat Aug 23 2008 22:43:05.764613 3086486000]: open log file  '/var/log/cabal/GlobalDBAgent.log'
[Sat Aug 23 2008 22:43:05.764796 3086486000]: LOG LEVEL: 3
[Sat Aug 23 2008 22:43:05.764854 3086486000]: MemPoolUnitSizeClass(0): 14336Bytes
[Sat Aug 23 2008 22:43:05.765978 3086486000]: Start GlobalDBAgent Server
[Sat Aug 23 2008 22:43:05.767011 3086486000]: UseEcryptText (Off)
[Sat Aug 23 2008 22:43:05.799724 3086482320]: CProcessLayer(0)::svc Start [3086482320]
[Sat Aug 23 2008 22:43:05.802039 3075992464]: CProcessLayer(0)::svc Start [3075992464]
[Sat Aug 23 2008 22:43:05.802180 3065502608]: CProcessLayer(0)::svc Start [3065502608]
[Sat Aug 23 2008 22:43:05.802298 3055012752]: CProcessLayer(0)::svc Start [3055012752]
[Sat Aug 23 2008 22:43:05.802467 3044522896]: CProcessLayer(0)::svc Start [3044522896]
[Sat Aug 23 2008 22:43:05.802585 3034033040]: CProcessLayer(0)::svc Start [3034033040]
[Sat Aug 23 2008 22:43:05.802745 3023543184]: CProcessLayer(0)::svc Start [3023543184]
[Sat Aug 23 2008 22:43:05.802863 3013053328]: CProcessLayer(0)::svc Start [3013053328]
[Sat Aug 23 2008 22:43:05.803108 3086486000]: try listening 38180 port
[Sat Aug 23 2008 22:43:05.803220 3086486000]: [##ERROR##] listen 38180 port fail (Address already in use)
[Sat Aug 23 2008 22:43:05.803420 3086486000]: [##ERROR##] active fail
[Sat Aug 23 2008 22:43:05.810207 3002563472]: CProcessLayer(0)::svc Start [3002563472]
[Sat Aug 23 2008 22:43:05.810261 3002563472]: CProcessLayer(0)::svc Terminated [3002563472]
[Sat Aug 23 2008 22:43:05.810426 2992073616]: CProcessLayer(0)::svc Start [2992073616]
[Sat Aug 23 2008 22:43:05.810460 2992073616]: CProcessLayer(0)::svc Terminated [2992073616]
[Sat Aug 23 2008 22:43:05.811421 3086482320]: [##ERROR##] getq fail (108)
[Sat Aug 23 2008 22:43:05.811450 3086482320]: CProcessLayer(0)::svc Terminated [3086482320]
[Sat Aug 23 2008 22:43:05.812319 3075992464]: [##ERROR##] getq fail (108)
[Sat Aug 23 2008 22:43:05.812349 3075992464]: CProcessLayer(0)::svc Terminated [3075992464]
[Sat Aug 23 2008 22:43:05.812422 3065502608]: [##ERROR##] getq fail (108)
[Sat Aug 23 2008 22:43:05.812449 3065502608]: CProcessLayer(0)::svc Terminated [3065502608]
[Sat Aug 23 2008 22:43:05.812517 3055012752]: [##ERROR##] getq fail (108)
[Sat Aug 23 2008 22:43:05.812545 3055012752]: CProcessLayer(0)::svc Terminated [3055012752]
[Sat Aug 23 2008 22:43:05.812612 3044522896]: [##ERROR##] getq fail (108)
[Sat Aug 23 2008 22:43:05.812639 3044522896]: CProcessLayer(0)::svc Terminated [3044522896]
[Sat Aug 23 2008 22:43:05.812707 3034033040]: [##ERROR##] getq fail (108)
[Sat Aug 23 2008 22:43:05.812734 3034033040]: CProcessLayer(0)::svc Terminated [3034033040]
[Sat Aug 23 2008 22:43:05.812801 3023543184]: [##ERROR##] getq fail (108)
[Sat Aug 23 2008 22:43:05.812828 3023543184]: CProcessLayer(0)::svc Terminated [3023543184]
[Sat Aug 23 2008 22:43:05.812895 3013053328]: [##ERROR##] getq fail (108)
[Sat Aug 23 2008 22:43:05.812922 3013053328]: CProcessLayer(0)::svc Terminated [3013053328]
[Sat Aug 23 2008 22:43:06.402558 3085957616]: accept success 10(192.168.1.106:34827)
[Sat Aug 23 2008 22:43:06.402761 3085957616]: 2.open user 10 [855BD98] (192.168.1.106)
[Sat Aug 23 2008 22:43:06.416210 3085957616]: 2.close user 10 [855BD98] (192.168.1.106)
[Sat Aug 23 2008 22:59:39.258952 3085957616]: SIGTERM
3085957616: work_pending_i: Interrupted system call
[Sat Aug 23 2008 22:59:40.040818 3064974224]: CProcessLayer(0)::svc Terminated [3064974224]
[Sat Aug 23 2008 22:59:40.041064 2991545232]: [##ERROR##] getq fail (108)
[Sat Aug 23 2008 22:59:40.041094 2991545232]: CProcessLayer(0)::svc Terminated [2991545232]
[Sat Aug 23 2008 22:59:40.041172 3085953936]: [##ERROR##] getq fail (108)
[Sat Aug 23 2008 22:59:40.041200 3085953936]: CProcessLayer(0)::svc Terminated [3085953936]
[Sat Aug 23 2008 22:59:40.041272 3075464080]: [##ERROR##] getq fail (108)
[Sat Aug 23 2008 22:59:40.041299 3075464080]: CProcessLayer(0)::svc Terminated [3075464080]
[Sat Aug 23 2008 22:59:40.041372 3054484368]: [##ERROR##] getq fail (108)
[Sat Aug 23 2008 22:59:40.041399 3054484368]: CProcessLayer(0)::svc Terminated [3054484368]
[Sat Aug 23 2008 22:59:40.041472 3043994512]: [##ERROR##] getq fail (108)
[Sat Aug 23 2008 22:59:40.041499 3043994512]: CProcessLayer(0)::svc Terminated [3043994512]
[Sat Aug 23 2008 22:59:40.041570 3033504656]: [##ERROR##] getq fail (108)
[Sat Aug 23 2008 22:59:40.041597 3033504656]: CProcessLayer(0)::svc Terminated [3033504656]
[Sat Aug 23 2008 22:59:40.041678 3023014800]: [##ERROR##] getq fail (108)
[Sat Aug 23 2008 22:59:40.041706 3023014800]: CProcessLayer(0)::svc Terminated [3023014800]
[Sat Aug 23 2008 22:59:40.041791 3012524944]: [##ERROR##] getq fail (108)
[Sat Aug 23 2008 22:59:40.041819 3012524944]: CProcessLayer(0)::svc Terminated [3012524944]
[Sat Aug 23 2008 22:59:40.041902 3002035088]: [##ERROR##] getq fail (108)
[Sat Aug 23 2008 22:59:40.041930 3002035088]: CProcessLayer(0)::svc Terminated [3002035088]
....................

[chumpywumpy]

It is still complaining about ports being in use. Are you sure you are using gen_config2 and not gen_config as my script will delete the old services when it is run, though it doesn't actually force the old services to stop first.

Ok, first stop the services and use each of the command below in putty or a terminal...

rm -f /etc/init.d/LoginSvr_*
rm -f /etc/init.d/DBAgent_*
rm -f /etc/init.d/ChatNode_*
rm -f /etc/init.d/WorldSvr_*
rm -f /etc/init.d/GlobalDBAgent
rm -f /etc/init.d/GlobalMgrSvr
rm -f /etc/init.d/CashDBAgent

Now reboot the centos machine and run gen_config2.sh again and that should fix it. Always stop the services before running gen_config2 just to be sure.

[[hidden]]

did you even try to reboot centos? it always clears conflicting ports that are not expected to conflict. and if you didn't touch any of the default port settings, it shouldn't conflict.

[elfrind]

Oh yeah centos crashed =\ but i think You guys say true and it will work now. Anyway i have other problem, rather some nub one, I'm using mrmagoo files after reinstaling (again) centos and i have 2 problems now:
1. I have updated my CentOS and i can't install now some files
a) unixODBC-2.2.11-1.RHEL4.1.i386.rpm - because i have newer one and it doesn't want to run
b) unixODBC-devel-2.2.11-1.RHEL4.1.i386.rpm
unixODBC-kde-2.2.11-1.RHEL4.1.i386.rpm these don't wanna run without this from point a) because i have newer files, and i have no idea if i have downloaded these too or not and my question is if it could work not properly now?
2. OK second problem (also nub one). When i run terminal or putty, doesn't matter witch one it's the same, when i want to run gen_config2.sh, from Your files mrmagoo, I cannot because i don't have permission to use them lol, and i switched user by su - root and su - mymainacc and it doesn't help.
Thats all what i wanted to say hope you can help me this time too coz last time you helped me well. I'm rather looking to get answer to my second question xP [;

Regards,
Elfrind

[[hidden]]

1. follow in order:
a. yum install unixODBC
b. rpm -Uvh freetds*.rpm (supply *)
c.rpm -Uvh cabal.rpm

2.
a.login as root.
b.review /usr/bin/*.bin (make sure permission is set to 755)
c.type /home/cabal/gen_config.sh
d.review inis for changes.
e.reboot and check service cabal status

[elfrind]

EDIT: Sorry i misundertsood You first. Now it works ( i mean gen_config2.sh) Thanks [;

[elfrind]

OK dunno why it hasn't helped at all =\ I still have same erorrs and all. I rebooted CentOS many times and stoped and started service cabal and still no effect.
Any idea why?
P.S. I checked loginsvr_01.log and there i found that it detects when i try to log in to game, so i have no idea what's going on. Oh and when i try to log in my acc bar just ends and nothing happens.
Regards

[[hidden]]

loginsvr doesnt work on its own, it communicates with other files. check other logs for errors.