Jump to content
  • 0

L2JFree Install Database Error


Firerain

Question

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:

 

2cgngps.png

Link to comment
Share on other sites

Recommended Posts

  • 0

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

 

You put wrong paths while installation.

Link to comment
Share on other sites

  • 0

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.

Link to comment
Share on other sites

  • 0

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.

 

 

Link to comment
Share on other sites

  • 0

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.

Link to comment
Share on other sites

  • 0

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.

Link to comment
Share on other sites

  • 0

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.

Link to comment
Share on other sites

  • 0

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.

Link to comment
Share on other sites

  • 0

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.

Link to comment
Share on other sites

  • 0

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

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.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

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



  • Posts

    • Welcome to my store :  https://topestore.mysellix.io/fr/ 2015-2022 Aged Discord Account 2015 Discord Account : 50.99 $ 2016 Discord Account : 10$ 2017 Discord Account :3.99 $ 2018 Discord Account : 3.50$ 2019 Discord Account : 2.70 $ 2020 Discord Account :1.50$ 2021 Discord Account :0.99$ 2022 Discord Account :0.70$ Warranty :Lifetime Payment Methods : Crypto/ PayPal Contact Me On Discord Or Telegram Discord : @ultrasstore11 Telegram : https://t.me/ultrastore1 Welcome to my store :  https://topestore.mysellix.io/fr/ 2015-2022 Aged Discord Account 2015 Discord Account : 50.99 $ 2016 Discord Account : 10$ 2017 Discord Account :3.99 $ 2018 Discord Account : 3.50$ 2019 Discord Account : 2.70 $ 2020 Discord Account :1.50$ 2021 Discord Account :0.99$ 2022 Discord Account :0.70$ Warranty :Lifetime Payment Methods : Crypto/ PayPal Contact Me On Discord Or Telegram Discord : @ultrasstore11
    • L2 ArenaWar: Low Rate PvP Server with Free Buffs & Autofarm [PVP]⚔️ [Free]🆓 Classic Interlude with  3x XP rates! Free starter pack(no grade) to kickstart your adventure! Autofarm for convenient grinding! Free buffs to keep you fighting fit! (2 job buffs) No experience loss on death! (Except with Karma) Clear Karma system to keep things fair! ⚖️ Active community of 800-1k players! Join our Discord to learn more! >> Discord <<     Server website: https://l2arenawar.com/en/    
    • This is dedication! 2 years working on a problem. Congratulations!
    • You indeed have to save player position over Enterworld to properly clean it up later (if you don't, even trying to delete packet content would eventually keep it up), that's what we do with debug packet (which is a reusable Map of ExServerPrimitive packets) on aCis.   It doesn't solve the FPS stuttering - more you draw/delete lines, more your client becomes laggy. It's like if client wasn't deleting drawn points/lines properly, but instead simply hide them and redrawn content above.   If you got a solution, I would happy to integrate it.   You should check aCis#Player _debug packet integration, it allows very big amount of lines/points to be drawn, it is also reusable.   https://gitlab.com/Tryskell/acis_public/-/blob/master/aCis_gameserver/java/net/sf/l2j/gameserver/model/actor/Player.java?ref_type=heads https://gitlab.com/Tryskell/acis_public/-/blob/master/aCis_gameserver/java/net/sf/l2j/gameserver/network/clientpackets/EnterWorld.java?ref_type=heads  
    • we sell website templates, make websites to order. Great selection at very good prices. My contacts discord : advert1231 telegram : https://t.me/ggwpins  
  • Topics

×
×
  • Create New...