Firerain Posted January 31, 2010 Share Posted January 31, 2010 Yet another issue. Switching from L2J Offical to L2JFree, I already deleted my database, and I've tried making a fresh mysql db to no avail. My issue is, even after editing the config for my database, it gives this error: Quote Link to comment Share on other sites More sharing options...
0 Apithanos Posted January 31, 2010 Share Posted January 31, 2010 you haven't added password on my/sql and server files. Quote Link to comment Share on other sites More sharing options...
0 Firerain Posted January 31, 2010 Author Share Posted January 31, 2010 I added a password on the MySQL. It still gives the error. Explain what you mean. Quote Link to comment Share on other sites More sharing options...
0 Commodus Posted January 31, 2010 Share Posted January 31, 2010 Check your configs for MySQL Again . It cannot connect to your database. { the one you create } You put wrong paths while installation. Quote Link to comment Share on other sites More sharing options...
0 Firerain Posted January 31, 2010 Author Share Posted January 31, 2010 It didn't even ask me for paths, it just jumped right to that screen. Quote Link to comment Share on other sites More sharing options...
0 Apithanos Posted January 31, 2010 Share Posted January 31, 2010 It didn't even ask me for paths, it just jumped right to that screen. edit vars.txt on tools folder. Quote Link to comment Share on other sites More sharing options...
0 Firerain Posted January 31, 2010 Author Share Posted January 31, 2010 There isn't one. It has a file called database_installer.sh. I'm using L2JFree Interlude btw. Here's the original database_installer.sh config: #!/bin/bash ############################################ ## WARNING! WARNING! WARNING! WARNING! ## ## ## ## DON'T USE NOTEPAD TO CHANGE THIS FILE ## ## INSTEAD USE SOME DECENT TEXT EDITOR. ## ## NEWLINE CHARACTERS DIFFER BETWEEN DOS ## ## AND UNIX. ## ## ## ## USING NOTEPAD TO SAVE THIS FILE LEAVE ## ## IT IN A BROKEN STATE!!! ## ############################################ ## Writen by DrLecter ## ## License: GNU GPL ## ## Based on Tiago Tagliaferri's script ## ## E-mail: tiago_tagliaferri@msn.com ## ## From "L2J-DataPack" ## ## Modified for L2JFree ## ############################################ trap finish 2 configure() { echo "#############################################" echo "# You entered script configuration area #" echo "# No change will be performed in your DB #" echo "# I will just ask you some questions about #" echo "# your hosts and DB. #" echo "#############################################" MYSQLDUMPPATH=`which mysqldump 2>/dev/null` MYSQLPATH=`which mysql 2>/dev/null` if [ $? -ne 0 ]; then echo "We were unable to find MySQL binaries on your path" while : do echo -ne "\nPlease enter MySQL binaries directory (no trailing slash): " read MYSQLBINPATH if [ -e "$MYSQLBINPATH" ] && [ -d "$MYSQLBINPATH" ] && [ -e "$MYSQLBINPATH/mysqldump" ] && [ -e "$MYSQLBINPATH/mysql" ]; then MYSQLDUMPPATH="$MYSQLBINPATH/mysqldump" MYSQLPATH="$MYSQLBINPATH/mysql" break else echo "The data you entered is invalid. Please verify and try again." exit 1 fi done fi #LS echo -ne "\nPlease enter MySQL Login Server hostname (default localhost): " read LSDBHOST if [ -z "$LSDBHOST" ]; then LSDBHOST="localhost" fi echo -ne "\nPlease enter MySQL Login Server database name (default l2jdb): " read LSDB if [ -z "$LSDB" ]; then LSDB="l2jdb" fi echo -ne "\nPlease enter MySQL Login Server user (default root): " read LSUSER if [ -z "$LSUSER" ]; then LSUSER="root" fi echo -ne "\nPlease enter MySQL Login Server $LSUSER's password (won't be displayed) :" stty -echo read LSPASS stty echo echo "" if [ -z "$LSPASS" ]; then echo "Hum.. i'll let it be but don't be stupid and avoid empty passwords" elif [ "$LSUSER" == "$LSPASS" ]; then echo "You're not too brilliant choosing passwords huh?" fi #GS echo -ne "\nPlease enter MySQL Game Server hostname (default $LSDBHOST): " read GSDBHOST if [ -z "$GSDBHOST" ]; then GSDBHOST="$LSDBHOST" fi echo -ne "\nPlease enter MySQL Game Server database name (default $LSDB): " read GSDB if [ -z "$GSDB" ]; then GSDB="$LSDB" fi echo -ne "\nPlease enter MySQL Game Server user (default $LSUSER): " read GSUSER if [ -z "$GSUSER" ]; then GSUSER="$LSUSER" fi echo -ne "\nPlease enter MySQL Game Server $GSUSER's password (won't be displayed): " stty -echo read GSPASS stty echo echo "" if [ -z "$GSPASS" ]; then echo "Hum.. i'll let it be but don't be stupid and avoid empty passwords" elif [ "$GSUSER" == "$GSPASS" ]; then echo "You're not too brilliant choosing passwords huh?" fi Can somebody tell me what needs to be edited? I changed the passwords to mysql pass. I'm using MySql 5.1. Quote Link to comment Share on other sites More sharing options...
0 Massari Posted January 31, 2010 Share Posted January 31, 2010 Open the loginserver.properties file and add the proper username and password for your MySQL database...if you have one created lol. Quote Link to comment Share on other sites More sharing options...
0 Firerain Posted January 31, 2010 Author Share Posted January 31, 2010 Did. Same error. You don't understand. The error I get happens as soon as I open up the .bat. I didn't even touch anything =/ I don't even get to change anything, and I think it's supposed to ask me for my password, but it doesn't. It just gives that screen. Like I said, this database installer came with it's own configuration file, which I posted above. Quote Link to comment Share on other sites More sharing options...
0 Massari Posted January 31, 2010 Share Posted January 31, 2010 Did. Same error. You don't understand. The error I get happens as soon as I open up the .bat. I didn't even touch anything =/ Like I said, this database installer came with it's own configuration file, which I posted above. You either don't have a database created or you don't know the proper username or password. I know very well what the first thing that the .bat file does is TRY TO CONNECT to the database using the user and password from the config so it can install the database! If it can't connect to it then it CAN'T install it. It says very clear there, USER DENIED root@localhost (using password: NO) which means you didn't enter any password at all in the config file. Quote Link to comment Share on other sites More sharing options...
0 Firerain Posted January 31, 2010 Author Share Posted January 31, 2010 The config file is confusing. Take a look at it. There's no place for me to put a password. Don't assume I'm a noob. I've had my own server before, with L2JFree Gracia Final. I do have a database created, the user is 'root' and I know what the password. Quote Link to comment Share on other sites More sharing options...
0 Commodus Posted January 31, 2010 Share Posted January 31, 2010 The config file is confusing. Take a look at it. There's no place for me to put a password. Don't assume I'm a noob. I've had my own server before, with L2JFree Gracia Final. I do have a database created, the user is 'root' and I know what the password. So , you know all the infos you need ? What's the problem with your db? Check again your MySQL info's and put the correct paths at the installation. Quote Link to comment Share on other sites More sharing options...
0 Firerain Posted January 31, 2010 Author Share Posted January 31, 2010 Check again your MySQL info's and put the correct paths at the installation. The MySQL info is right. Like I said, when I start the installation BAT it just gives that error right away. I don't have an option to put in the paths, or else I would. Quote Link to comment Share on other sites More sharing options...
0 Commodus Posted January 31, 2010 Share Posted January 31, 2010 The MySQL info is right. Like I said, when I start the installation BAT it just gives that error right away. I don't have an option to put in the paths, or else I would. Well then there is a problem with your database_installer.bat.Seems to be a strange problem. Report it to L2J Free forum. Quote Link to comment Share on other sites More sharing options...
0 Kràtos Posted February 1, 2010 Share Posted February 1, 2010 Right click on the database installer.. edit and look the config ... it needs to put your password.... and the name of your database. Look if the version of your mysql is same as the db installer... Quote Link to comment Share on other sites More sharing options...
0 Massari Posted February 1, 2010 Share Posted February 1, 2010 k nevermind delete this Quote Link to comment Share on other sites More sharing options...
Question
Firerain
Yet another issue. Switching from L2J Offical to L2JFree, I already deleted my database, and I've tried making a fresh mysql db to no avail.
My issue is, even after editing the config for my database, it gives this error:
Link to comment
Share on other sites
17 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.
Note: Your post will require moderator approval before it will be visible.