Database Connect problem

[pepess]

in cabal_rates static i put my config but in Reloading server configuration...


Reloading GlobalDBAgent: [ OK ]
Reloading GlobalMgrSvr: [FAILED]
Reloading CashDBAgent: [ OK ]
Reloading DBAgent_01: [ OK ]
Reloading ChatNode_01: [FAILED]
Reloading WorldSvr_01_01: [ OK ]
Reloading LoginSvr_01: [FAILED]
done.

please Help me :S

i have Windows 7 32b Centos 4.7

sorry my english is bad :S

[MentaL]

[Xc0deRed93]

do this:
Do you want me to find your WAN IP? [Y] : N
then manually enter your wan or lan ip.

run "service cabal start" again.

[pepess]

i need add any port on my Firewall for connecc??

i cant connecc :S

[Yamachi]

i need add any port on my Firewall for connecc??

i cant connecc :S

Read the numerous guides available here on the forums.

[pepess]

i see the guides but no result my problem please help.

now my Chatnode not start is stopped :S

[pepess]

i have got 4gb on RAM and 3.37 GB available but on Putty i select chanel Mercury (1 chanel) need 250 mb on ram but Putty has a problem check This



and other problem on change rates:

check this



Please Help me :S

[matrixfinity]

if you using VMware change ram setting to higher then 248mb :D, then boot up and rerun cabal_config

[pepess]

Problem of Ram is repair (Thanks matrixfinity) but my ChatNode no :S Help please

[matrixfinity]

post chatnodexx.log and your chatnode.ini

[pepess]

Chatnode_09.ini

[NetLib]
Port=38129
SendMaxBufSize=131072
SendMaxBufSizeUserHandler=131072
SendMaxBufSizeLinkHandler=1048576
ProcessDataLimit=10000
MaxUserNum=100
WatchsNoPackLimit=100000
SystemLogTTimeOut=100
ReactorTimeOut=-1
DisableReactorPipe=1
UseEncryptPacket=0
ConnectRetryTime=5000
ConnectRetryNum=50
LogLevel=3
MemPoolUnitSizeClass=2

[ChatNode]
ServerNationIdx=9
ChatNodeIdx=1
Timer=1:1000,2:10000
ProcessLayerTaskNum=8
NoNotifyTimeLimit=120000
NoResponseTimeout=180000
NoActiveLimitTime=120000
BroadCastOverServerNation=0

LogSay=0

; Min char level needed to create a guild
CharLevelForGuildCreate=40
; Allow guild messageboard
AllowGuildBoard=0

; Does it cost Alz to make a guild
; See [Guild] in Const.scp
UseGuildCreateFee=1


[DBAgent]
Addr=192.168.0.10
Port=38189

[GlobalMgrSvr]
Addr=127.0.0.1
Port=38170

chatnode.cfg

[NetLib]
Port=38121
SendMaxBufSize=131072
SendMaxBufSizeUserHandler=131072
SendMaxBufSizeLinkHandler=1048576
ProcessDataLimit=10000
MaxUserNum=100
WatchsNoPackLimit=100000
SystemLogTTimeOut=100
ReactorTimeOut=-1
DisableReactorPipe=1
UseEncryptPacket=0
ConnectRetryTime=5000
ConnectRetryNum=50
LogLevel=3
MemPoolUnitSizeClass=2

[ChatNode]
ServerNationIdx=1
ChatNodeIdx=1
Timer=1:1000,2:10000
ProcessLayerTaskNum=8
NoNotifyTimeLimit=120000
NoResponseTimeout=180000
NoActiveLimitTime=120000
BroadCastOverServerNation=0

LogSay=0

; Min char level needed to create a guild
CharLevelForGuildCreate=40
; Allow guild messageboard
AllowGuildBoard=0

; Does it cost Alz to make a guild
; See [Guild] in Const.scp
UseGuildCreateFee=1


[DBAgent]
Addr=192.168.0.10
Port=38181

[GlobalMgrSvr]
Addr=127.0.0.1
Port=38170



i cant see chatnodexx.log and your chatnode.ini

[matrixfinity]

i think problem is
[DBAgent]
Addr=192.168.0.10 <--- change it to 127.0.0.1 and run cabal service restart see if it works

and chatnodexx.log = chatnode (world).log yours is 09 :D

[pepess]

man look this i check the status of service cabal but, look:

[matrixfinity]

did you change
[DBAgent]
Addr=192.168.0.10 to 127.0.0.1 and run "service cabal restart"? not status :P

[pepess]

yes i change but i have this problem :S i can connect my server for this problem :S

[matrixfinity]

i think it's best you upload your chatnode_09.log and worldsvr_09_10.log

[pepess]

Where is wordsvr_09_10.log and chatnode_09.log??

wordsvr_09_10.ini

[NetLib]
Port=38114
SendMaxBufSize=131072
SendMaxBufSizeUserHandler=131072
SendMaxBufSizeLinkHandler=1048576
ProcessDataLimit=10000
MaxUserNum=100
WatchsNoPackLimit=30000
UseEncryptPacket=1
SystemLogTTimeOut=100
ReactorTimeOut=100
DisableReactorPipe=1
ConnectRetryTime=5000
ConnectRetryNum=10
MemPoolUnitSizeClass=5
LogLevel=3

[WorldSvr]
ServerIdx=9
GroupIdx=10
GlobalTimer=4:10000,5:5000,7:3600000,22:60000,8:2000
WorldTimer=1:100,2:150,3:3000,6:60000,8:2000,9:10000,14:2000,16:200,20:200,21:200
CommonIniPath=Common.ini
IPAddress=192.168.174.128
UpdateInterval=300000


###################################
#### Cash Shop ####
###################################
# AllowCashShop (0|1)
# You must have a cash shop website set up
# Your client must also be hexed to the correct URL for your shop
AllowCashShop=1

#########################################
#### General Gameplay Options ####
#########################################
# Limit the levels of party members
UsePartyMinExpForInvalidPartyMember=1
# Limit the distance you can invite party members from
IgnorePartyInviteDistance=0
# Ignore some buff stacking?
UseIgnoreOtherBlessBuff=0

# Check the player's service type and
# limits inventory/warehouse slot usage
UseCheckInvenItemSlotByServiceType=0
UseBlessingBeadCheck=0

# Limit the number of odd circles a player can use in a dungeon
RestrictOddCircleUseCountInDungeon=1

#
UseArtOfDefensePenalty=1

#
UseMinLevDiffValueForExpCalc=1

#InstantWar
UseInstantWarNationReward=1

#only instant war channel
UseBootUpGmsChannelType=1
WaitUntilChannelTypeSet=1
InstantWarShutDownTimeAttackMilliSec=1800000




###################################
#### Channel options ####
###################################
# UsePvpBetting (0|1)
# Allow PvP honour betting?
# Known to cause crashes
UsePvpBetting=0

# UseMobsChaseModify (0|1)
# Use [MobChase] section in const.scp
# For increasing mob aggro ranges based on the WorldType in common.ini
UseMobsChaseModify=1

# UseDropDiscount (0|1)
# Enable [DropDiscount] section of const.scp
# For overriding specific item drops for events.
UseDropDiscount=1

# UseWorldDrop (0|1)
# Use drops from the terrain files
UseWorldDrop=1

# Limit how many personal shops can be opened?
UseTradeChannelRestriction=0
PShopOpenLimitCount=0
AllowTradeChannel=0

###################################
#### Hack checking options ####
###################################
UseHackcheckByTimeScope=0
UseCheckShopHack=0
UseCheckWarpHack=0
UseCheckWareHouseHack=0
UseCheckSkillCoolTimeHack=0
UseCheckDistanceSkillHack=0
UseCheckDeadStatActive=0
UseCheckDMZArea=0
UseCheckInventoryHack=0
UseCheckUserAttack=0
UseCheckDeadStatActive=0
ActiveDeadStatCount=30
SpeedHackCheckTime=10000
MaxAttackHackTime=300000
CheckSkillTimeHackScope=60000

# I *think* this turns off several of the
# client enc <-> server data checks.
UseCheckBelongItem=0
UseCheckMissionIdx=0
UseCheckDungeon=0

####################################
##### DB Alz hack checking #####
####################################
# UseAlzDbHackCheck (0|1)
# Check alz against reserved and reserved2 in the db.
# If invenory or warehouse alz don't match XORed copy log it
UseAlzDbHackCheck=0

# UseCutIfAlzDbHacked (0|1)
# As well as logging kick the player
# DO NOT edit Alz in the db directly if you enable this
UseCutIfAlzDbHacked=0

# Stores detected hack users in the DB
UseHackUserDBSave=1

# I *think* these are the number of hacks
# to detect before kicking the player
MaxTimeHackingCount=2
MaxDistanceHackingCount=2

######################################
#### Enable GM commands? ####
######################################
# UseAdminUser (0|1)
# Enable GM commands for GMs
# Must also be set up in LoginSvr config
UseAdminUser=1

############################################
#### Dungeon Instance options ####
############################################
# Instances are the temporary copies of dungeon maps you enter
# when going into a dungeon. These instances are why you don't
# all end up in the same dungeon. The maximum number of instances
# can be found in QuestDungeon.scp

# Allow additional mission dungeon instances in premium channels
UseAdditionalMissionDungeonInstanceInPremiumCH=0

# Allow additional mission dungeon instances for premium players
UseAdditionalMissionDungeonInstanceInPremiumUser=0

# Number of additional instances for the above
AdditionalMissionDungeonInstanceCount=0

###################################
#### Anti-addiction system ####
###################################
UseAntiOnlineGameAddictionSystem=0 ### LS = 0 , ITS = 1
InstantPlayTimeClearIntervalMin=300
InstantPlayTimeNotifyIntervalMin=0
advantageBoundaryTime0=10800
advantageBoundaryTime1=18000
InstantPlayTimeDebugMultiple=1

###################################
#### GameGuard ####
###################################
# UseGameGuardAuth (0|1)
UseGameGuardAuth=0
# The GameGuard library name
AddGameGuardName=libggauth2.so.0
# GameGuard check interval and timeout
GameGuardInterval=180000
NoResponseTimeout=180000

# UseApex (0|1)
# Usage not known
UseApex=0
# ApexModulePath
#ApexModulePath=./ApexProxy.dll
ApexModulePath=./ApexProxy.so

# UseNonClientCheck (0|1)
#Check if the client is the right version
UseNonClientCheck=0
NonClientDisAdvantageRate=90

# UseRandomValueWriteLog (0|1)
# Write random errors to logs
# Used to test log writing performance only
# Do not enable
UseRandomValueWriteLog=0

ExtraCount=5

[DBAgent]
Addr=127.0.0.1
Port=38189

[GlobalMgrSvr]
Addr=192.168.174.128
Port=38170

[CashDBAgent]
Addr=127.0.0.1
Port=38190

[ChatNode]
AddrForServer=192.168.174.128
AddrForClient=192.168.174.128
Port=38129


chatnode_09.ini


[NetLib]
Port=38129
SendMaxBufSize=131072
SendMaxBufSizeUserHandler=131072
SendMaxBufSizeLinkHandler=1048576
ProcessDataLimit=10000
MaxUserNum=100
WatchsNoPackLimit=100000
SystemLogTTimeOut=100
ReactorTimeOut=-1
DisableReactorPipe=1
UseEncryptPacket=0
ConnectRetryTime=5000
ConnectRetryNum=50
LogLevel=3
MemPoolUnitSizeClass=2

[ChatNode]
ServerNationIdx=9
ChatNodeIdx=1
Timer=1:1000,2:10000
ProcessLayerTaskNum=8
NoNotifyTimeLimit=120000
NoResponseTimeout=180000
NoActiveLimitTime=120000
BroadCastOverServerNation=0

LogSay=0

; Min char level needed to create a guild
CharLevelForGuildCreate=40
; Allow guild messageboard
AllowGuildBoard=0

; Does it cost Alz to make a guild
; See [Guild] in Const.scp
UseGuildCreateFee=1


[DBAgent]
Addr=127.0.0.1
Port=38189

[GlobalMgrSvr]
Addr=192.168.174.128

[matrixfinity]

root/var/log/cabal

[pepess]

i haven't got this folder Cabal look:



i change this but nothing the World is stopped and chatnode is stoped :S

[matrixfinity]

rerun cabal_install if problems use chumpywumpy guides
http://forum.ragezone.com/f459/collection-545201/

[Alphakilo23]

That's odd, out of curiosity, what CentOS version did you install?

[pepess]

4.7 and Windows 7 32b

[Drav3n]

root/var/log/cabal

that's not the directory of logs. removed the root

/var/log/cabal

[pepess]

please tell me what port need open in my firewall of Windows 7 ??

Chatnode and World problem is ready

[pepess]

i use this comand cat DBAgent_01.log and one error more :S check this:



i use this query in my Sql but the problem is more big

Declare @insname varchar(25)
if convert(varchar(25),serverproperty('instancename')) is null
set @insname='MSSQLSERVER'
else
set @insname=convert(varchar(25),serverproperty('instancename'))
select @insname as 'Instance',
serverproperty('productversion') as 'Ver', serverproperty('productlevel') as 'SP',
serverproperty('edition') as 'Edition'
if @insname<>'MSSQLSERVER'
begin
select 'THIS IS BAD! You must reinstall MSSQL. Please follow the guides next time.' as 'MSSQL is a named instance!'
end

begin
Declare @inspath varchar(10),@reg varchar(100),@tcpremote as int
EXEC master.dbo.xp_regread @rootkey='HKEY_LOCAL_MACHINE',
@key='Software\Microsoft\Microsoft SQL Server\Instance Names\SQL\',
@value_name=@insname,
@value=@inspath OUTPUT
set @reg='Software\Microsoft\Microsoft SQL Server\' + @inspath + '\MSSQLSERVER\SuperSocketNetLib\tcp\'
EXEC master.dbo.xp_regread @rootkey='HKEY_LOCAL_MACHINE',
@key=@reg,
@value_name='Enabled',
@value=@tcpremote OUTPUT
select @inspath as 'Instance path',@tcpremote as 'Remote connections enabled?'
if @tcpremote='0'
begin
EXEC master.dbo.xp_regwrite @rootkey='HKEY_LOCAL_MACHINE',
@key=@reg, @value_name='Enabled', @type='REG_DWORD',@value=1
select 'I enabled remote connections ! Please reboot !' as 'Remote connections checker'
end
else
begin
select 'This is good! I have nothing to do :(' as 'Remote connections checker'
end
select account.dbo.fn_md5('test') as 'xp_md5.dll check'
end


but the problem is more big check this


[root@localhost cabal]# cat DBAgent_01.log
[Tue Feb 7 2012 09:16:15.510716 3086358208]: open log file '/var/log/cabal/DBAgent_01.log'
[Tue Feb 7 2012 09:16:15.510886 3086358208]: LOG LEVEL: 3
[Tue Feb 7 2012 09:16:15.510953 3086358208]: MemPoolUnitSizeClass(2): 24576Bytes
[Tue Feb 7 2012 09:16:15.512076 3086358208]: Start DBAgent_01 Server
[Tue Feb 7 2012 09:16:15.512963 3086358208]: UseEcryptText (Off)
[Tue Feb 7 2012 09:16:15.522926 3086355360]: CProcessLayer(0)::svc Start [3086355360]
[Tue Feb 7 2012 09:16:15.523152 3075865504]: CProcessLayer(0)::svc Start [3075865504]
[Tue Feb 7 2012 09:16:15.523294 3065375648]: CProcessLayer(0)::svc Start [3065375648]
[Tue Feb 7 2012 09:16:15.523443 3054885792]: CProcessLayer(0)::svc Start [3054885792]
[Tue Feb 7 2012 09:16:15.523675 3086358208]: try listening 38181 port
[Tue Feb 7 2012 09:16:15.523908 3044395936]: CProcessLayer(0)::svc Start [3044395936]
[Tue Feb 7 2012 09:16:16.083861 3086358208]: accept success 8(127.0.0.1:32810)
[Tue Feb 7 2012 09:16:16.085021 3086358208]: 1.open user 8 [86F23F8] (127.0.0.1)
[Tue Feb 7 2012 09:16:16.667517 3086358208]: accept success 10(127.0.0.1:32812)
[Tue Feb 7 2012 09:16:16.667705 3086358208]: 2.open user 10 [8700B38] (127.0.0.1)

My FIles Log http://www.mediafire.com/?h78705f3866bqr3

My firewall in windowis off and the port in centos is open on Nat
i have got Window 7 32b and centos 4.7

[Yamachi]

1. Stop making new threads every time you have something to add to your problem.
2. Read http://forum.ragezone.com/f451/cabal...-rules-724310/ and http://forum.ragezone.com/f451/posti...ed-faq-598777/.
3. Reinstall your server completely, and follow the guides.