Client not communicating with mysql

[BruceW]

I need help...

It's my very first installation, i got the server running with no error (red) or warning (yellow). All logserv, charserv and mapserv batch files are running smoothly.

the ver before compilation was 20110315... its the same ragexe client+diff i'm using...

i got my permissions ok on sercurity settings and have 3 logins under ragnarok database table login...

my Clientinfo.xml address is at 127.0.0.1 currently im running the client together in one machine together with the server at Windows XP...

my data.ini is plain 0=rdata.grf and 1=data.grf ... i will be making my editions later...

My Problem is: when i try to connect from client to server i am able to type my username and password but the logserv-sql.bat does not seem to read my request. It's just stale with no changes at all. Therefore i get an Unregistered account error on my client.

i tried changing my xml address to my current IP address but it still dies not work.

i tried going to command like to see if my mysql is ok... i can use database and select fields from tables no problem.

Can somebody put me in the right direction where to look?

Much Appreciated,

Bruce

[Emistry]

my data.ini is plain 0=rdata.grf and 1=data.grf ... i will be making my editions later...

you need your own grf in order to make it connect with your server based on the setting you set in clientinfo

i was wondering where you guide get the guide of this installation ? wiki ?

because you guys seem to alway missed out the part for custom grf ....

[BruceW]

i see thanks... i though GRF would be just for pics and sound file and nothing to do with sql injection or client logging...

beside my error has nothing to do with missing file from data... it's something to do with connection.

also is there a plain grf file we can use and edit later?

Thanks

Edited November 23, 2012 by BruceW

[Emistry]

GRF has nothing to do with SQL Injection... only for Client to connect with Server ... as well as other misc data ( textures / translated data / sound clips / customs )

what you need is clientinfo to establish the connection between server and clients.

[BruceW]

yes as i said i got clientinfo address set to local...

"my Clientinfo.xml address is at 127.0.0.1 currently im running the client together in one machine together with the server at Windows XP..."

since it is just one machine i used the 127.0.0.1 also i did mention...

"i tried changing my xml address to my current IP address but it still dies not work."

anything else i should look for?

[Emistry]

my data.ini is plain 0=rdata.grf and 1=data.grf ..

i forget to add the part that required you to addin your custom grf ...

[Data]
0=YOURCUSTOM.grf
1=rdata.grf
2=data.grf

[BruceW]

mycustom GRF can wait... i just want to be able to log to my server first... are you telling me there is something in grf that bypasses server logins?

[hendra814]

are you already add privilage at mysql for your RO database?

or maybe your mysql password not same at inter_athena.conf

on this section

// Global SQL settings

// overriden by local settings when the hostname is defined there

// (currently only the login-server reads/obeys these settings)

sql.db_hostname: 127.0.0.1

sql.db_port: 3306

sql.db_username: ragnarok

sql.db_password: ragnarok

sql.db_database: ragnarok

sql.codepage:

// MySQL Character SQL server

char_server_ip: 127.0.0.1

char_server_port: 3306

char_server_id: ragnarok

char_server_pw: ragnarok

char_server_db: ragnarok

// MySQL Map SQL Server

map_server_ip: 127.0.0.1

map_server_port: 3306

map_server_id: ragnarok

map_server_pw: ragnarok

map_server_db: ragnarok

// MySQL Log SQL Database

log_db_ip: 127.0.0.1

log_db_port: 3306

log_db_id: ragnarok

log_db_pw: ragnarok

log_db_db: ragnarok

log_codepage:

log_login_db: loginlog

Edited November 23, 2012 by hendra814

[BruceW]

i followed the install guide and this is what i have...

on SQL Dev i got my localhost connection

on Serv admin i got mysql@localhost instance

under manage security @ mysql@localhost instance i got ragnarok as user with admin roles Mon Admin, DBM, DBD, BackupAdm

on schem Priv under ragnarok i got log and ragnarok as schema all priviledges...

additional info on my xml

port is 6900

ver 28

langtype 1

anything i did wrong?

thanks,

Edited November 23, 2012 by BruceW

[Emistry]

mycustom GRF can wait... i just want to be able to log to my server first... are you telling me there is something in grf that bypasses server logins?

=='' there is no way for you connect if you cant make sure your client read your custom clientinfo ....

either you put it in data folder ( ensure your client read Data Folder First ) or put it in GRF and do what i mentioned in previous post..

otherwise....there is no way you can connect ....

[BruceW]

how exactly does Data.ini and Clientinfo.xlm work....

i thought it would be like data.ini will declare the GRF files for picture and sound while Clientinfo.xml will declare the connection for my client's EXE

sure the exe get the picture from the GRF to display the look you like for character menu... but that is not my problem right now... my problem is connection of my client exe+clientinfo.xml to my mysql... as i've said my sql is stale or not moving.

sorry im confused now.

Thank you for your patience.

are you already add privilage at mysql for your RO database?

or maybe your mysql password not same at inter_athena.conf

on this section

// Global SQL settings

// overriden by local settings when the hostname is defined there

// (currently only the login-server reads/obeys these settings)

sql.db_hostname: 127.0.0.1

sql.db_port: 3306

sql.db_username: ragnarok

sql.db_password: ragnarok

sql.db_database: ragnarok

sql.codepage:

// MySQL Character SQL server

char_server_ip: 127.0.0.1

char_server_port: 3306

char_server_id: ragnarok

char_server_pw: ragnarok

char_server_db: ragnarok

// MySQL Map SQL Server

map_server_ip: 127.0.0.1

map_server_port: 3306

map_server_id: ragnarok

map_server_pw: ragnarok

map_server_db: ragnarok

// MySQL Log SQL Database

log_db_ip: 127.0.0.1

log_db_port: 3306

log_db_id: ragnarok

log_db_pw: ragnarok

log_db_db: ragnarok

log_codepage:

log_login_db: loginlog

my log_db_db is "log"

while my passwords are all the same but not ragnarok

logserver connects to the char server same with map... all green or white color no warnings or errors...

Do i need to add another account/priviledge for "ALL USERS of the server" on my RO Db or will the current (as per guide) will suffice?

Is the exe nailed to password ragnarok? do i need to hex for this purpose?

I;ve tried 2 clients ragexe 2010-08-17 and 2011-03-15 no connection on mysql

Edited November 23, 2012 by BruceW

[BruceW]

problem fix my Clientinfo.xml is in my root it should be located at the data folder