Anong mali dito mga paps?

[greenieken]

http://i46.tinypic.com/6zwm5s.png

[Ragnar Lothbrok]

sql? check yout inter_athena.conf

or maybe you sql database..

[PewN]

inter_athena.conf

// 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: log   [ check your db here ]
log_codepage:
log_login_db: loginlog

[greenieken]

everything is correctly entered. still the same -.-"

[eJay]

Print Screen mo nga po yung

char_athena

login_ip:

Char_ip:

Map_athena

char_ip:

map_ip:

subnet_athena

inter_athena

[Prez]

execute mo yung sql

[greenieken]

@iPrez panong execute paps?

@luffy lahat 127.0.0.1 lang.

[Jupeto]

1. May user ka ba na ragnarok sa sql server mo?

If none:

For PHPMyAdmin Users:

a. Login ka sa database server mo with administrator rights.

b. Check kung merong ragnarok user with all privileges sa databases mo (

http://wiki.phpmyadmin.net/pma/user_management

)

For SQLYog Users:

a. Login ka sa database server mo with administrator rights.

b. Expand mysql database

c. Expand Tables

d. Select or highlight "

user

" table and press F11 in your keybard

e. check on the right if merong ragnarok user with all privileges

2. if no. 1 fails, check in your inter_athena.conf, and change values to

sql.db_hostname: localhost

sql.db_port: 3306

sql.db_username: root

sql.db_password: <your dbpassword when you install mysql server>

sql.db_database: ragnarok

sql.codepage:

// MySQL Character SQL server

char_server_ip: localhost

char_server_port: 3306

char_server_id: ragnarok

char_server_pw: ragnarok

char_server_db: ragnarok

// MySQL Map SQL Server

map_server_ip: localhost

map_server_port: 3306

map_server_id: ragnarok

map_server_pw: ragnarok

map_server_db: ragnarok

// MySQL Log SQL Database

log_db_ip: localhost

log_db_port: 3306

log_db_id: ragnarok

log_db_pw: ragnarok

log_db_db: log

log_codepage:

3. If no. 2 fails, check in your inter_athena.conf, change values to

sql.db_hostname: localhost

char_server_ip: localhost

map_server_ip: localhost

log_db_ip: localhost

leave everything unchanged except above parameters.

Edited August 6, 2012 by jupeto

[greenieken]

@jupeto sir ang gamit ko kasi mySQL work bench.. hmm

[Jupeto]

@jupeto sir ang gamit ko kasi mySQL work bench.. hmm

1. Connect to your database server

2. Copy and paste the code below in your query window.

USE mysql;
SELECT * FROM `user` WHERE `user` = 'ragnarok'

3. Hold CTRL + SHIFT then press Enter keys in your keybpard.

4. Wait for the result

5. If there are any result then you actually have a 'ragnarok' user for your eathena database, but check the host name.

6. So you have the result below, then check for each row's host field values, what do you see in each row?

Please answer my question from #6 above if there are any result before continuing. If none then continue reading below.

7. If you have no ragnarok user at all for etiher hosts (localhost, 127.0.0.1, %) then execute this query in your query window

insert  into `user`(`Host`,`User`,`Password`,`Select_priv`,`Insert_priv`,`Update_priv`,`Delete_priv`,`Create_priv`,`Drop_priv`,`Reload_priv`,`Shutdown_priv`,`Process_priv`,`File_priv`,`Grant_priv`,`References_priv`,`Index_priv`,`Alter_priv`,`Show_db_priv`,`Super_priv`,`Create_tmp_table_priv`,`Lock_tables_priv`,`Execute_priv`,`Repl_slave_priv`,`Repl_client_priv`,`Create_view_priv`,`Show_view_priv`,`Create_routine_priv`,`Alter_routine_priv`,`Create_user_priv`,`Event_priv`,`Trigger_priv`,`Create_tablespace_priv`,`ssl_type`,`ssl_cipher`,`x509_issuer`,`x509_subject`,`max_questions`,`max_updates`,`max_connections`,`max_user_connections`,`plugin`,`authentication_string`) values ('%','ragnarok','*08FF2D2DB3AEFCADCFEF4918974CD7FFE29916ED','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','N','','','','',0,0,0,0,'',''), ('127.0.0.1','ragnarok','*08FF2D2DB3AEFCADCFEF4918974CD7FFE29916ED','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','N','','','','',0,0,0,0,'',''), ('localhost','ragnarok','*08FF2D2DB3AEFCADCFEF4918974CD7FFE29916ED','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','N','','','','',0,0,0,0,'','');

Query above will insert 3 rows ( 3 same username and passwords but 3 different host namely `localhost`, `127.0.0.1`, and `%` )

The password for each ragnarok usernames is ragnarok too

Edited August 7, 2012 by jupeto

[greenieken]

When i entered,

USE mysql;

SELECT * FROM `user` WHERE `user` = 'ragnarok'

nothing comes out so i entered

insert  into `user`(`Host`,`User`,`Password`,`Select_priv`,`Insert_priv`,`Update_priv`,`Delete_priv`,`Create_priv`,`Drop_priv`,`Reload_priv`,`Shutdown_priv`,`Process_priv`,`File_priv`,`Grant_priv`,`References_priv`,`Index_priv`,`Alter_priv`,`Show_db_priv`,`Super_priv`,`Create_tmp_table_priv`,`Lock_tables_priv`,`Execute_priv`,`Repl_slave_priv`,`Repl_client_priv`,`Create_view_priv`,`Show_view_priv`,`Create_routine_priv`,`Alter_routine_priv`,`Create_user_priv`,`Event_priv`,`Trigger_priv`,`Create_tablespace_priv`,`ssl_type`,`ssl_cipher`,`x509_issuer`,`x509_subject`,`max_questions`,`max_updates`,`max_connections`,`max_user_connections`,`plugin`,`authentication_string`) values ('%','ragnarok','*08FF2D2DB3AEFCADCFEF4918974CD7FFE29916ED','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','N','','','','',0,0,0,0,'',''), ('127.0.0.1','ragnarok','*08FF2D2DB3AEFCADCFEF4918974CD7FFE29916ED','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','N','','','','',0,0,0,0,'',''), ('localhost','ragnarok','*08FF2D2DB3AEFCADCFEF4918974CD7FFE29916ED','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','N','','','','',0,0,0,0,'','');

After doing that, it still says that access denied for user ragnarok@localhost. -.-"

Nvm. I figured it out. Thanks.

[Jupeto]

Mind if you tell us how did you solve that for others to see the solution.

[greenieken]

I just missed one thing when I am executing the log schema. I forgot to make it my default schema before executing it. So that's why. But I have another problem, Here it is: http://i50.tinypic.com/ddclfo.png

[Jupeto]

May nasolve na po na ganyan din ang prob, this might help...

http://rathena.org/b...from-ip-127001/

I actually googled it using "rathena parse_char unknown packet received 0x67" keywords XD

Edited August 7, 2012 by jupeto