Connecting

[omimo]

I've already change username and password to s1 and p1 and change the char map login server port tru c++ and debug it still i got this message

http://img853.imageshack.us/img853/9382/86752821.png

Thank you for the help

[Ryuuzaki]

Double check your inter.conf, is your MYSQL user really ragnarok?

[omimo]

ahm, at first it is set as ragnarok, actually i've just downloaded everything from here : https://rathena.svn.sourceforge.net/svnroot/rathena/trunk/ and i'm just changing everything.

hope you can help me

[Ryuuzaki]

Browse this one first~

http://rathena.org/wiki/Installation_on_Windows

[omimo]

yes i've followed that one also

[Volusion]

It's showing i guess you didn't configure ur MySQL in Inter.Conf Correctly did you make MySQL Etc(Of Course i hope) Well Its not showing you configured it correctly Just look at ur mysql log (loginlog) Or whatever its called if its called ragnarok put ragnarok etc

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

Do not Copy it cause its no configured but that what you have to configure From MySQL To that hope this helped lol

Edited August 12, 2012 by Volusion

[omimo]

ahm i changed everything here's the one i did

// 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: s1

sql.db_password: p1

sql.db_database: ragnarok

sql.codepage:

// MySQL Character SQL server

char_server_ip: 127.0.0.1

char_server_port: 6121

char_server_id: s1

char_server_pw: p1

char_server_db: ragnarok

// MySQL Map SQL Server

map_server_ip: 127.0.0.1

map_server_port: 5121

map_server_id: s1

map_server_pw: p1

map_server_db: ragnarok

// MySQL Log SQL Database

log_db_ip: 127.0.0.1

log_db_port: 6900

log_db_id: s1

log_db_pw: p1

log_db_db: ragnarok

log_codepage:

log_login_db: loginlog

is this right?

Edited August 12, 2012 by omimo

[Volusion]

well i'll have to check ur MySQL ro know if its right and btw why are you're passwords s1 an p1 lol Did you Configure MySQL Admin?

are you sure its the pass and user to MySQL That you added in inter.conf?

[Ryuuzaki]

You are misunderstanding the s1 / p1 part. This one is defined in the map_athena.conf & char_athena.conf. And this one is also defined in the login sql database.

Do you even have a SQL database setup?

[omimo]

You are misunderstanding the s1 / p1 part. This one is defined in the map_athena.conf & char_athena.conf. And this one is also defined in the login sql database.

Do you even have a SQL database setup?

no, i will change it to the default setting which is "ragnarok"

[Ryuuzaki]

Let me rephrase it, did you install a SQL database server? If not, you would have to do that first.

[Volusion]

lol You Didn't even have a MySQL Database setup lol

[omimo]

well i'll have to check ur MySQL ro know if its right and btw why are you're passwords s1 an p1 lol Did you Configure MySQL Admin?

are you sure its the pass and user to MySQL That you added in inter.conf?

no, ok i will change it to the default settings for userid and pwid (ragnarok)

[Lelouch vi Britannia]

Have you added Schema Privilages in your Ragnarok Schema ? if not do this

1. Run your MySQL Administrator.

2. Click the "User Administrator".

3. Click your Ragnarok Schema.

4. Find and Click the "Schema Privilages"

5. Again click your Ragnarok Schema.

6. Find this "<<" and click it.

7. And last click the "Apply changes" then your done.

Edited August 12, 2012 by Lelouch vi Britannia

[Volusion]

Do what he said in MySQL Admin what i stated like 1hour ago~

[omimo]

i've tried the schema priviledge but i dont see ragnarok schema.

i'm crap, i'm sorry coz i don't know anything at all when using my sql coz whenever i download pre-compiled svn's i always go for text.

Edited August 13, 2012 by omimo

[Mystery]

http://rathena.org/wiki/SQL_Installation

http://rathena.org/wiki/Connecting

[omimo]

ahm i've manage to run it but one the on the logserv_sql console it says:

http://img850.imageshack.us/img850/2067/99668295.png

how can i resolve this?

i followed everything on setting up sql server/installation and everything is working.

[Mystery]

Your logs tables aren't loaded: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk/sql-files/logs.sql

[omimo]

ahm i tried to replace it in the logs.sql and debug it. i got the same error on the logserv_sql console

[Lelouch vi Britannia]

Just add the logs.sql as same as you did to your main.sql. But you can make a Log Schema add your logs.sql just change this

conf/inter_athena.conf at line 55

log_db_db: ragnarok

changed to

log_db_db: log

[omimo]

sir i did add the logs.sql to log schema, after i change the log_db_db: ragnarok to log_db_db: log it says this:

http://img829.images...65/68612118.png

sir these are the step i did for setting up mysql server:

1.new instance

>localhost

>username:ragnarok

>password:ragnarok

2.Query Database

>New schema>ragnarok

>New schema>log

>ragnarok schema>open script>main.sql

>log schema>open script>logs.sql

3.management security

>new account>login name: ragnarok>connectivity: 127.0.0.1>password: ragnarok

>new account>login name: logs>connectivity: 127.0.0.1>password: ragnarok

4.Schema Privilege

>ragnarok>selected port>selected schema: ragnarok>select all

>logs>selected port>selected schema: log>select all

my inter_athena.conf(didn't do anything here)

// 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

did i do anything wrong to have an error in my logserv_sql console?

Edited August 15, 2012 by omimo