• Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook page for updates, we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.) When you see an Incapsula error, you know we are in the process of migration.

ChatNode_01, EventMgrSvr, AgentShop_01, LoginSvr_01, WorldSvr_01_01

Newbie Spellweaver
Joined
Feb 8, 2011
Messages
28
Reaction score
0
I'm stuck at this, is so lame trust me!
Down i post the log, maybe someone can help me...

ChatNode_01:

EventMgrSvr

AgentShop_01

LoginSvr_01

WorldSvr_01_01

SQL IP: 10.0.0.3 | SERVER IP: 10.0.0.26
:junglejane:
 
Last edited:
Newbie Spellweaver
Joined
Feb 8, 2011
Messages
28
Reaction score
0
I think is my server cannot connect to sql or idk, help me out figure this...:
 

Attachments

You must be registered for see attachments list
Newbie Spellweaver
Joined
Mar 27, 2012
Messages
25
Reaction score
6
You must install ODBC on CentOS.

Error(DBAgent_01):
[unixODBC][Driver Manager]Can't open lib '/usr/lib/libtdsodbc.so.0' : /usr/lib/libtdsodbc.so.0: file too short
 
Newbie Spellweaver
Joined
Feb 8, 2011
Messages
28
Reaction score
0
I update the CentOS via yum update on putty, that will need to fix right?
Give me a tutorial how to instal that stupid thing...
 
Newbie Spellweaver
Joined
Feb 8, 2011
Messages
28
Reaction score
0
New log


[root@localhost ~]# yum install unixODBC openssl097a net-snmp-utils net-snmp-lib s net-snmp lm_sensors gcc freetds dstat compat-libstdc++-33 compat-libstdc++-296
Loaded plugins: fastestmirror, security
Loading mirror speeds from cached hostfile
* base: mirror.yellowfiber.net
* extras: mirror.yellowfiber.net
* updates: mirror.yellowfiber.net
Setting up Install Process
Package unixODBC-2.2.11-10.el5.x86_64 already installed and latest version
Package unixODBC-2.2.11-10.el5.i386 already installed and latest version
Package openssl097a-0.9.7a-12.el5_10.1.x86_64 already installed and latest versi on
Package openssl097a-0.9.7a-12.el5_10.1.i386 already installed and latest version
Package 1:net-snmp-utils-5.3.2.2-25.el5_11.x86_64 already installed and latest v ersion
Package 1:net-snmp-libs-5.3.2.2-25.el5_11.x86_64 already installed and latest ve rsion
Package 1:net-snmp-libs-5.3.2.2-25.el5_11.i386 already installed and latest vers ion
Package 1:net-snmp-5.3.2.2-25.el5_11.x86_64 already installed and latest version
Package lm_sensors-2.10.7-9.el5.x86_64 already installed and latest version
Package lm_sensors-2.10.7-9.el5.i386 already installed and latest version
Package gcc-4.1.2-55.el5.x86_64 already installed and latest version
Package freetds-0.64-11.el5.centos.x86_64 already installed and latest version
Package dstat-0.6.6-5.el5.noarch already installed and latest version
Package compat-libstdc++-33-3.2.3-61.x86_64 already installed and latest version
Package compat-libstdc++-33-3.2.3-61.i386 already installed and latest version
Package compat-libstdc++-296-2.96-138.i386 already installed and latest version
Nothing to do
 

Attachments

You must be registered for see attachments list
Last edited:
Newbie Spellweaver
Joined
Feb 8, 2011
Messages
28
Reaction score
0
[CabalAccount]
Driver = FreeTDS
Address = 10.0.0.3
Port = 1433
Database = ACCOUNT
TDS_Version = 8.0

[CabalCash]
Driver = FreeTDS
Address = 10.0.0.3
Port = 1433
Database = CabalCash
TDS_Version = 8.0

[CabalNetCafe]
Driver = FreeTDS
Address = 10.0.0.3
Port = 1433
Database = NetCafeBilling
TDS_Version = 8.0

[CabalGame01]
Driver = FreeTDS
Address = 10.0.0.3
Port = 1433
Database = SERVER01
TDS_Version = 8.0

[EventData]
Driver = FreeTDS
Address = 10.0.0.3
Port = 1433
Database = EventData
TDS_Version = 8.0

[Authentication]
Driver = FreeTDS
Address = 10.0.0.3
Port = 1433
Database = Authentication
TDS_Version = 8.0



Something won't let cabal server to connect to sql...
 
Newbie Spellweaver
Joined
Feb 8, 2011
Messages
28
Reaction score
0
New log
 

Attachments

You must be registered for see attachments list
Newbie Spellweaver
Joined
Feb 8, 2011
Messages
28
Reaction score
0
I will try now i'm installing centos
I will post a log after !



I will try now i'm installing centos
I will post a log after !
About last centos was 5.idk x64
 
Newbie Spellweaver
Joined
Feb 8, 2011
Messages
28
Reaction score
0
Server work but after i make a character and modify with tools client wont log in game
I log in i select the channel i select the character and after is freeze
 
Trying to be developer ^^
Loyal Member
Joined
Jul 21, 2010
Messages
1,072
Reaction score
360
Im pretty sure u make ur char nation GM. If u want make ur character as Game Master u need to add GM IP into database. Serach keywords in forum
 
Newbie Spellweaver
Joined
Feb 8, 2011
Messages
28
Reaction score
0
I use this and still same problem
USE [Account]
GO
/****** Object: StoredProcedure [dbo].[cabal_sp_gm_ip_check] Script Date: 17.02.2013 23:41:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[cabal_sp_gm_ip_check](@UserIP CHAR(16), @Registered BIT OUTPUT)
AS
BEGIN
--DECLARE @IP bigint
--set @IP = dbo.inet_addr(@UserIP);

--if exists( select fromIP from cabal_GM_ip_table with(nolock) where fromip <= @ip and toip >= @ip)
--BEGIN
SET @Registered = 1;
--END
--ELSE
--BEGIN
-- SET @Registered = 0;
--END
END
I make another account and i can log in game with no problem
Old account is stuck in channel when you select channel will not work