About SQL INSTALLING!

[moneymuch]

I accordance with rathena wiki to install sql, Sql Version is 5.161.

but Click "Edit Table Data" under SQL Development, and put ragnarok in the "Default Schema" box. Click next, enter your password, then click finish, enter your password again, and exit out of the editor.

I don't find "Default Schema" in"Edit Table Data" ,look the picture

but i find "Default Schema" in "Edit SQL Script" ,look the picture

which is right?

Edited March 19, 2012 by moneymuch

[Emistry]

on your 1st installation..there is no need to write anything in the default scheme...

when i install my sql...i didnt put anything in the default scheme part..

just left it blank..

it is okay to do so ~

[LCDTheOG]

yeah a default schema is just the database that will be selected when u open the sql viewer gui or whatever ur using, its not mandatory, its just for convenience xD

[moneymuch]

but now it has a error in logserv-sql . how to solve this error.

srclogin_sql

my sql's username and password is "root" and "moneymuchmoney", need i to alter username and password here?

after i alter them, do i release with VS2010 again

or how do i solve thie error

Edited March 17, 2012 by moneymuch

[Emistry]

edit here

https://rathena.svn.sourceforge.net/svnroot/rathena/trunk/conf/inter_athena.conf

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

[moneymuch]

edit here

https://rathena.svn....ter_athena.conf

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

yes ,i edit it ,but it still has a error

sql.db_hostname: 127.0.0.1
sql.db_port: 3306
sql.db_username: root
sql.db_password: moneymuchmoney
sql.db_database: ragnarok
sql.codepage:
// MySQL Character SQL server
char_server_ip: 127.0.0.1
char_server_port: 3306
char_server_id: root
char_server_pw: moneymuchmoney
char_server_db: ragnarok
// MySQL Map SQL Server
map_server_ip: 127.0.0.1
map_server_port: 3306
map_server_id: root
map_server_pw: moneymuchmoney
map_server_db: ragnarok
// MySQL Log SQL Database
log_db_ip: 127.0.0.1
log_db_port: 3306
log_db_id: root
log_db_pw: moneymuchmoney
log_db_db: ragnarok
log_codepage:
log_login_db: loginlog

[Asura]

Hi moneymuch,

Make sure you have a table named 'loginlog' in your 'ragnarok' database.

#Database: ragnarok
#Table: loginlog
CREATE TABLE `loginlog` (
 `time` datetime NOT NULL default '0000-00-00 00:00:00',
 `ip` varchar(15) NOT NULL default '',
 `user` varchar(23) NOT NULL default '',
 `rcode` tinyint(4) NOT NULL default '0',
 `log` varchar(255) NOT NULL default '',
 INDEX (`ip`)
) ENGINE=MyISAM ;

Source: https://rathena.svn....-files/logs.sql

Edited March 18, 2012 by Asura

[moneymuch]

Hi moneymuch,

Make sure you have a table named 'loginlog' in your 'ragnarok' database.

#Database: ragnarok
#Table: loginlog
CREATE TABLE `loginlog` (
 `time` datetime NOT NULL default '0000-00-00 00:00:00',
 `ip` varchar(15) NOT NULL default '',
 `user` varchar(23) NOT NULL default '',
 `rcode` tinyint(4) NOT NULL default '0',
 `log` varchar(255) NOT NULL default '',
 INDEX (`ip`)
) ENGINE=MyISAM ;

Source: https://rathena.svn....-files/logs.sql

HI Asura

yes , i have a "loginlog" in my "ragnarok" database. i try to edit the name of "log" database for "loginlog" and "logs" ,but it has this error

thank you very much for your answer.

i have solved this error.

this is my mistake. i should execute main.sql and logs.sql in "ragnarok", but i execute logs.sql in "log"

Edited March 19, 2012 by moneymuch