L2JFree Install Database Error

[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:

 

[Apithanos]

you haven't added password on my/sql and server files.

[Firerain]

I added a password on the MySQL. It still gives the error. Explain what you mean.

[Commodus]

Check your configs for MySQL Again . It cannot connect to your database. { the one you create }

 

You put wrong paths while installation.

[Firerain]

It didn't even ask me for paths, it just jumped right to that screen.

[Apithanos]

It didn't even ask me for paths, it just jumped right to that screen.

edit vars.txt on tools folder.

[Firerain]

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.

[Massari]

Open the loginserver.properties file and add the proper username and password for your MySQL database...if you have one created lol.

 

[Firerain]

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.

 

 

[Massari]

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.

[Firerain]

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.

[Commodus]

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.

[Firerain]

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.

[Commodus]

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.

[Kràtos]

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

[Massari]

k nevermind delete this