:)
- Joined
- Sep 21, 2007
- Messages
- 282
- Reaction score
- 10
Create ODBC -> Administrative Tools -> Data Sources (ODBC) -> System DSN -> ADDMysql 2005
yes I know..that... Im talking about WHAT ARE THE NAMES.. lol raycrash1 and raycrash2?
I think it uses ODBC buy what´s the name of? T_T
Edit:
AquaLung told me that he doesnt used any ODBC.. then..
whan can we do? xD
I take wrong ID xD
Greetings
Ranslsad
I haven't been able to get the server to connect to the db
I haven't been able to get the server to connect to the db
It connects for me using MSSQL 2000 SP4.
AquaLung
.
23:11:27 :: db test start
[B][COLOR="Red"]23:11:27 :: SQL Server Message 5701: Changed database context to 'master'.[/COLOR][/B]
23:11:27 :: -------------- raycrash DB Ok ----------------------
23:11:27 :: db test end
23:11:27 :: SQL Server Message 170: Line 1: Incorrect syntax near 'use'.
[COLOR="Magenta"]23:11:27 :: DB-Library Error 10007: General SQL Server error: Check messages from the SQL Server.[Edit: maybe it uses MD5?][/COLOR]
23:11:27 :: Error:Db.cpp:ExecDB():dbsqlexec():charid:0
23:11:27 :: use
23:11:27 :: Error:raycrashmain.cpp:ms_use_db():ExecDB():charid:0
23:11:27 :: -------------- raycrash Server Start ---------------
But we do all you do and nothings happens..
I will try again starting by 0..
Edit:
Nothings..
I will say what i do..
First Download files ( -.-" ) and Eng Client
Then i create new DB called raycrash1 and 2.. restore DB...
Then i configure Inis with IP 127.0.0.1 and SQL Username and pass...
Then i configure client with my ip 127.0.0.1 and i try connect it says
invalid username...
Edit2:
Watching in Server log... i saw some line that looks rare...
Code:23:11:27 :: db test start [B][COLOR="Red"]23:11:27 :: SQL Server Message 5701: Changed database context to 'master'.[/COLOR][/B] 23:11:27 :: -------------- raycrash DB Ok ---------------------- 23:11:27 :: db test end 23:11:27 :: SQL Server Message 170: Line 1: Incorrect syntax near 'use'. [COLOR="Magenta"]23:11:27 :: DB-Library Error 10007: General SQL Server error: Check messages from the SQL Server.[Edit: maybe it uses MD5?][/COLOR] 23:11:27 :: Error:Db.cpp:ExecDB():dbsqlexec():charid:0 23:11:27 :: use 23:11:27 :: Error:raycrashmain.cpp:ms_use_db():ExecDB():charid:0 23:11:27 :: -------------- raycrash Server Start ---------------
Edit3:
I think you got the SQL Server configured diff of us ones.. i installed yesterday and no changes..
What is you SQL Config -.-"?
Greetings
Ranslsad
That same error show's in my log, so it's not keeping you from logging in. I will post my configs.
AquaLung
.
[Server Info]
AppName=Billing Server
port=15511
RefreshTime=60000
TimeCheck=600000
NewLogCheckTime=3600000
BillingFlag=0
LoginLog=1
CheckValid=0
[DB Info]
ServerNum=1
Server=127.0.0.1
AdminUser=1
UserName=sa
Password=*YOUR SA PASSWORD*
dbName=raycrash
-------------I N F O-------------------------
NewLogCheckTime=3600000
* Server
+ Billing DB Server IP
* dbName
+ Billing DB name
* BillingFlag
-Flag on is Calculate User's Gamming Time
-Prepare Database table Person_BillingInfo for Billing on
+ Billing on : 1
+ Billing off : 0
* LoginLog : File Logging
- Prepare "LoginLog" Directory for LoginLog on
- Prepare Database table FailLogin for LoginLog on (Login Fail Count)
+ LoginLog on : 1
+ LoginLog off : 0
* CheckValid
- 0 is Normal User
- 1 is can't login user because for some reason
+ CheckValid on : 1
+ CheckValid off : 0
-------------------------------------------
[Server]
Number=1
Server1=192.168.0.5
[DB Info]
Server=127.0.0.1
UserName=sa
Password=*YOUR SA PASSWORD*
AppName=rcmainserver
dbname=raycrash
[MSG Server Info]
user_accept_ip = 192.168.0.5
server_accept_ip=127.0.0.1
tcpport=11014
udpport=11013
servertcpport=11015
[Main Server Info]
ID=1
Server=192.168.0.5
udp_port=11017
[Rank Server Info]
Server=192.168.0.5
tcp_port=11016
udp_port=11018
[Game Server Info]
ID=1
Here are my ini's:
192.168.0.5 is my server's IP Address
Billing config.ini
Code:[Server Info] AppName=Billing Server port=15511 RefreshTime=60000 TimeCheck=600000 NewLogCheckTime=3600000 BillingFlag=0 LoginLog=1 CheckValid=0 [DB Info] ServerNum=1 Server=127.0.0.1 AdminUser=1 UserName=sa Password=*YOUR SA PASSWORD* dbName=raycrash -------------I N F O------------------------- NewLogCheckTime=3600000 * Server + Billing DB Server IP * dbName + Billing DB name * BillingFlag -Flag on is Calculate User's Gamming Time -Prepare Database table Person_BillingInfo for Billing on + Billing on : 1 + Billing off : 0 * LoginLog : File Logging - Prepare "LoginLog" Directory for LoginLog on - Prepare Database table FailLogin for LoginLog on (Login Fail Count) + LoginLog on : 1 + LoginLog off : 0 * CheckValid - 0 is Normal User - 1 is can't login user because for some reason + CheckValid on : 1 + CheckValid off : 0 -------------------------------------------
Billing NTService.ini
Code:[Server] Number=1 Server1=192.168.0.5
raycrash.ini in server folder and in system32 folder
Code:[DB Info] Server=127.0.0.1 UserName=sa Password=*YOUR SA PASSWORD* AppName=rcmainserver dbname=raycrash [MSG Server Info] user_accept_ip = 192.168.0.5 server_accept_ip=127.0.0.1 tcpport=11014 udpport=11013 servertcpport=11015 [Main Server Info] ID=1 Server=192.168.0.5 udp_port=11017 [Rank Server Info] Server=192.168.0.5 tcp_port=11016 udp_port=11018 [Game Server Info] ID=1
In the above configs, I combined both raycrash1 and raycrash2 DB's into 1 but I get the same results both ways.
AquaLung
.
Cheers for the release, anyone interested in a sectin yet?