[2.3] login help

[D4N0]

okay i decided to have a look at some 2.3 files. so i followed the guide to set a server up. and as i predicted nothing would work right 4 me lol.

iv managed to get in game now after messing about with things. and its looking great. but i have a few errors that are worrying me. any help please


also this is titled wrong now because i have edited this whole thread coz i have stored the problems i did have.

here is the info from m2gate server thing

Loaded client version information and server table...
Loading StdItem.DB...
StdItem.DB loaded(758).
Loading MapFiles...
Mapfile loaded(429).
DecoItem loaded..
Loading Guild Territorys...
Loading Monster.DB...
Monster.DB loaded(502).
Loading Magic.DB...
Magic.DB loaded(55).
Loading MonGen.txt...
MonGen.txt loaded(255).
Loading GenMsg.txt...
GenMsg.txt loaded(6).
Loading UnbindList.txt...
UnbindList information loaded.
Loading BindList.txt...
BindList information loaded.
Loading MapQuest.txt...
MapQuest information loaded.
Loading QuestDiary\*.txt...
QuestDiary information loaded.
!Abuse.txt loaded..
Loading LineNotice...
Line Notice loaded...
Admin List loaded..
Guild List loaded..
PumpkinLists loaded..
Castle List loaded..
Castle initialized..
IDSoc Initialized..
GrobalEnvir loaded..
MakeStoneMines...
Merchant loaded...
GuardList loaded..
Npc loaded..
MakeItem loaded..
StartPoints loaded...
F-Engine resumed..
U-Engine initialized..
[3/29/2008 1:59:19 AM] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login 'lom2'. Login fails
[3/29/2008 1:59:19 AM] [LoadGuildInfo] Failed
[3/29/2008 1:59:19 AM] Guilds: 0
[3/29/2008 1:59:19 AM] Total Castles: 1
[3/29/2008 1:59:22 AM] LoginServer Connected(127.0.0.1:5600)
[3/29/2008 1:59:25 AM] DBServer Connected(127.0.0.1:6000)
[3/29/2008 1:59:26 AM] Gate[0](127.0.0.1:4887) Opened...
[3/29/2008 2:00:15 AM] -- --> Error Keeping charQuery Alive!
[3/29/2008 2:00:15 AM] -- --> Error Keeping charQueryCommand Alive!

and hear is a screenie of the gates::

.


also when i try to 'tab out' the screen goes black with just the mouse. the only thing i can then do to be able to see the desktop is open ask manager

 

[koni]

1st problem is that you have not followed the guide, in the guide it tells you how to setup the sql login properly.

Go to the folder /DBServer/dbsrc.ini and edit the following.

SQLType = mssql
SQLHost = localhost
SQLPort = 3306
SQLDatabase = mir2
SQLUsername = sa
SQLPassword = (Enter the password you entered while setting up SQL Server 2000).

Then Go to the folder /M2Server/Setup.txt and edit the following.

UseSQL = True
SQLHost = 127.0.0.1 (which is nothing but your localhost)
SQLUsername = sa
SQLPassword = (Enter the password you entered while setting up SQL Server 2000)
SQLDatabase = mir2
SQLType = mssql

you will need to change the details above to your details

2nd problem, yes you will just get a black screen, there is no sql database for the m2server and dbserver to connect to to save your data or load your data, no database = no game = black screen.

 

[D4N0]

edit: right i looked @ the sql thing

but i still get the:

F-Engine resumed..
U-Engine initialized..
[3/29/2008 2:55:16 PM] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login 'lom2'. Login fails
[3/29/2008 2:55:16 PM] [LoadGuildInfo] Failed
[3/29/2008 2:55:16 PM] Guilds: 0
[3/29/2008 2:55:16 PM] Total Castles: 1
[3/29/2008 2:55:20 PM] LoginServer Connected(127.0.0.1:5600)
[3/29/2008 2:55:21 PM] Gate[0](127.0.0.1:3454) Opened...
[3/29/2008 2:55:23 PM] DBServer Connected(127.0.0.1:6000)
[3/29/2008 2:56:14 PM] -- --> Error Keeping charQuery Alive!
[3/29/2008 2:56:14 PM] -- --> Error Keeping charQueryCommand Alive!
[3/29/2008 3:05:14 PM] Users: 0

at the end...

hear is what i got:

[SQL]
SQLType=mssql
SQLHost=localhost
SQLPort=3306
SQLDatabase=mir2
SQLUsername=sa
SQLPassword=******

[SQL]
UseSQL=TRUE
SQLHost=127.0.0.1
SQLUsername=sa
SQLPassword=******
SQLDatabase=mir2
SQLType=mssql
SQLPort=3306
SQLCharDatabase=lom2

as for the second part. i don't think u understand what i mean...

i can get in game and run around etc etc all ok. i can visually see the graphics. but when i want to 'tab out' to go to a diff app. running the screen will go black.

 

[D4N0]

hahha fixed it.. ty ne way

 

[NeOn]

hahha fixed it.. ty ne way

lol spend more time in reading instructions rather than posting, dont rush because it will always slow u down!