Jump to content

Anong mali dito mga paps?

greenieken

By greenieken
in Tulong para sa Server

 Share

Recommended Posts

Ragnar Lothbrok Poring

Ragnar Lothbrok

Posted
  • Group:  Members
  • Topic Count:  91
  • Topics Per Day:  0.02
  • Content Count:  309
  • Reputation:   6
  • Joined:  04/24/12
  • Last Seen:  
Posted

sql? check yout inter_athena.conf

or maybe you sql database..

Link to comment
Share on other sites
PewN Poring

PewN

Posted
  • Group:  Members
  • Topic Count:  209
  • Topics Per Day:  0.04
  • Content Count:  892
  • Reputation:   27
  • Joined:  12/09/11
  • Last Seen:  
Posted

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

Link to comment
Share on other sites
greenieken Poring

greenieken

Posted
  • Group:  Members
  • Topic Count:  54
  • Topics Per Day:  0.01
  • Content Count:  154
  • Reputation:   1
  • Joined:  05/02/12
  • Last Seen:  
  • Author
Posted

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

Link to comment
Share on other sites
eJay Poring

eJay

Posted
  • Group:  Members
  • Topic Count:  80
  • Topics Per Day:  0.02
  • Content Count:  325
  • Reputation:   76
  • Joined:  03/22/12
  • Last Seen:  
Posted

Print Screen mo nga po yung

char_athena

login_ip:

Char_ip:

Map_athena

char_ip:

map_ip:

subnet_athena

inter_athena

Link to comment
Share on other sites
Prez Poring

Prez

Posted
  • Group:  Members
  • Topic Count:  8
  • Topics Per Day:  0.00
  • Content Count:  78
  • Reputation:   3
  • Joined:  12/06/11
  • Last Seen:  
Posted

execute mo yung sql

Link to comment
Share on other sites
greenieken Poring

greenieken

Posted
  • Group:  Members
  • Topic Count:  54
  • Topics Per Day:  0.01
  • Content Count:  154
  • Reputation:   1
  • Joined:  05/02/12
  • Last Seen:  
  • Author
Posted

@iPrez panong execute paps?

@luffy lahat 127.0.0.1 lang.

Link to comment
Share on other sites
Jupeto Poring

Jupeto

Posted
  • Group:  Members
  • Topic Count:  34
  • Topics Per Day:  0.01
  • Content Count:  225
  • Reputation:   39
  • Joined:  01/20/12
  • Last Seen:  
Posted (edited)

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 (
)

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 by jupeto
Link to comment
Share on other sites
greenieken Poring

greenieken

Posted
  • Group:  Members
  • Topic Count:  54
  • Topics Per Day:  0.01
  • Content Count:  154
  • Reputation:   1
  • Joined:  05/02/12
  • Last Seen:  
  • Author
Posted

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

Link to comment
Share on other sites
Jupeto Poring

Jupeto

Posted
  • Group:  Members
  • Topic Count:  34
  • Topics Per Day:  0.01
  • Content Count:  225
  • Reputation:   39
  • Joined:  01/20/12
  • Last Seen:  
Posted (edited)

@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 by jupeto
Link to comment
Share on other sites
greenieken Poring

greenieken

Posted
  • Group:  Members
  • Topic Count:  54
  • Topics Per Day:  0.01
  • Content Count:  154
  • Reputation:   1
  • Joined:  05/02/12
  • Last Seen:  
  • Author
Posted

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.

Link to comment
Share on other sites
Jupeto Poring

Jupeto

Posted
  • Group:  Members
  • Topic Count:  34
  • Topics Per Day:  0.01
  • Content Count:  225
  • Reputation:   39
  • Joined:  01/20/12
  • Last Seen:  
Posted

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

Link to comment
Share on other sites
greenieken Poring

greenieken

Posted
  • Group:  Members
  • Topic Count:  54
  • Topics Per Day:  0.01
  • Content Count:  154
  • Reputation:   1
  • Joined:  05/02/12
  • Last Seen:  
  • Author
Posted

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

Link to comment
Share on other sites
Jupeto Poring

Jupeto

Posted
  • Group:  Members
  • Topic Count:  34
  • Topics Per Day:  0.01
  • Content Count:  225
  • Reputation:   39
  • Joined:  01/20/12
  • Last Seen:  
Posted (edited)

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 by jupeto
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...