omimo Posted August 12, 2012 Group: Members Topic Count: 32 Topics Per Day: 0.01 Content Count: 97 Reputation: 0 Joined: 03/03/12 Last Seen: May 18, 2023 Share Posted August 12, 2012 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 Quote Link to comment Share on other sites More sharing options...
Ryuuzaki Posted August 12, 2012 Group: Members Topic Count: 1 Topics Per Day: 0.00 Content Count: 87 Reputation: 13 Joined: 02/15/12 Last Seen: April 11 Share Posted August 12, 2012 Double check your inter.conf, is your MYSQL user really ragnarok? Quote Link to comment Share on other sites More sharing options...
omimo Posted August 12, 2012 Group: Members Topic Count: 32 Topics Per Day: 0.01 Content Count: 97 Reputation: 0 Joined: 03/03/12 Last Seen: May 18, 2023 Author Share Posted August 12, 2012 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 Quote Link to comment Share on other sites More sharing options...
Ryuuzaki Posted August 12, 2012 Group: Members Topic Count: 1 Topics Per Day: 0.00 Content Count: 87 Reputation: 13 Joined: 02/15/12 Last Seen: April 11 Share Posted August 12, 2012 Browse this one first~ http://rathena.org/wiki/Installation_on_Windows Quote Link to comment Share on other sites More sharing options...
omimo Posted August 12, 2012 Group: Members Topic Count: 32 Topics Per Day: 0.01 Content Count: 97 Reputation: 0 Joined: 03/03/12 Last Seen: May 18, 2023 Author Share Posted August 12, 2012 yes i've followed that one also Quote Link to comment Share on other sites More sharing options...
Volusion Posted August 12, 2012 Group: Members Topic Count: 1 Topics Per Day: 0.00 Content Count: 13 Reputation: 0 Joined: 08/02/12 Last Seen: December 14, 2012 Share Posted August 12, 2012 (edited) 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.1sql.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 Quote Link to comment Share on other sites More sharing options...
omimo Posted August 12, 2012 Group: Members Topic Count: 32 Topics Per Day: 0.01 Content Count: 97 Reputation: 0 Joined: 03/03/12 Last Seen: May 18, 2023 Author Share Posted August 12, 2012 (edited) 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 Quote Link to comment Share on other sites More sharing options...
Volusion Posted August 12, 2012 Group: Members Topic Count: 1 Topics Per Day: 0.00 Content Count: 13 Reputation: 0 Joined: 08/02/12 Last Seen: December 14, 2012 Share Posted August 12, 2012 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? Quote Link to comment Share on other sites More sharing options...
Ryuuzaki Posted August 12, 2012 Group: Members Topic Count: 1 Topics Per Day: 0.00 Content Count: 87 Reputation: 13 Joined: 02/15/12 Last Seen: April 11 Share Posted August 12, 2012 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? Quote Link to comment Share on other sites More sharing options...
omimo Posted August 12, 2012 Group: Members Topic Count: 32 Topics Per Day: 0.01 Content Count: 97 Reputation: 0 Joined: 03/03/12 Last Seen: May 18, 2023 Author Share Posted August 12, 2012 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" Quote Link to comment Share on other sites More sharing options...
Ryuuzaki Posted August 12, 2012 Group: Members Topic Count: 1 Topics Per Day: 0.00 Content Count: 87 Reputation: 13 Joined: 02/15/12 Last Seen: April 11 Share Posted August 12, 2012 Let me rephrase it, did you install a SQL database server? If not, you would have to do that first. Quote Link to comment Share on other sites More sharing options...
Volusion Posted August 12, 2012 Group: Members Topic Count: 1 Topics Per Day: 0.00 Content Count: 13 Reputation: 0 Joined: 08/02/12 Last Seen: December 14, 2012 Share Posted August 12, 2012 lol You Didn't even have a MySQL Database setup lol Quote Link to comment Share on other sites More sharing options...
omimo Posted August 12, 2012 Group: Members Topic Count: 32 Topics Per Day: 0.01 Content Count: 97 Reputation: 0 Joined: 03/03/12 Last Seen: May 18, 2023 Author Share Posted August 12, 2012 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) Quote Link to comment Share on other sites More sharing options...
Lelouch vi Britannia Posted August 12, 2012 Group: Members Topic Count: 45 Topics Per Day: 0.01 Content Count: 715 Reputation: 83 Joined: 01/05/12 Last Seen: April 10, 2023 Share Posted August 12, 2012 (edited) 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 Quote Link to comment Share on other sites More sharing options...
Volusion Posted August 12, 2012 Group: Members Topic Count: 1 Topics Per Day: 0.00 Content Count: 13 Reputation: 0 Joined: 08/02/12 Last Seen: December 14, 2012 Share Posted August 12, 2012 Do what he said in MySQL Admin what i stated like 1hour ago~ Quote Link to comment Share on other sites More sharing options...
omimo Posted August 13, 2012 Group: Members Topic Count: 32 Topics Per Day: 0.01 Content Count: 97 Reputation: 0 Joined: 03/03/12 Last Seen: May 18, 2023 Author Share Posted August 13, 2012 (edited) 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 Quote Link to comment Share on other sites More sharing options...
Mystery Posted August 13, 2012 Group: Members Topic Count: 94 Topics Per Day: 0.02 Content Count: 2192 Reputation: 252 Joined: 11/11/11 Last Seen: June 24, 2020 Share Posted August 13, 2012 http://rathena.org/wiki/SQL_Installation http://rathena.org/wiki/Connecting Quote Link to comment Share on other sites More sharing options...
omimo Posted August 13, 2012 Group: Members Topic Count: 32 Topics Per Day: 0.01 Content Count: 97 Reputation: 0 Joined: 03/03/12 Last Seen: May 18, 2023 Author Share Posted August 13, 2012 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. Quote Link to comment Share on other sites More sharing options...
Mystery Posted August 13, 2012 Group: Members Topic Count: 94 Topics Per Day: 0.02 Content Count: 2192 Reputation: 252 Joined: 11/11/11 Last Seen: June 24, 2020 Share Posted August 13, 2012 Your logs tables aren't loaded: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk/sql-files/logs.sql Quote Link to comment Share on other sites More sharing options...
omimo Posted August 13, 2012 Group: Members Topic Count: 32 Topics Per Day: 0.01 Content Count: 97 Reputation: 0 Joined: 03/03/12 Last Seen: May 18, 2023 Author Share Posted August 13, 2012 ahm i tried to replace it in the logs.sql and debug it. i got the same error on the logserv_sql console Quote Link to comment Share on other sites More sharing options...
Lelouch vi Britannia Posted August 13, 2012 Group: Members Topic Count: 45 Topics Per Day: 0.01 Content Count: 715 Reputation: 83 Joined: 01/05/12 Last Seen: April 10, 2023 Share Posted August 13, 2012 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 Quote Link to comment Share on other sites More sharing options...
omimo Posted August 14, 2012 Group: Members Topic Count: 32 Topics Per Day: 0.01 Content Count: 97 Reputation: 0 Joined: 03/03/12 Last Seen: May 18, 2023 Author Share Posted August 14, 2012 (edited) 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 Quote Link to comment Share on other sites More sharing options...
Question
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
Link to comment
Share on other sites
21 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.