Page 2 of 3

Re: database problem.. i think im slow oO

Posted: Sat May 15, 2010 10:39 am
by tehmeat
janiii wrote:run the .bat file from a command line window, so that when it closes the command line window will stay open.
how would i do that..
sorry i been up for 23hours the last 3 lookin around on the net for this fix :(

Re: database problem.. i think im slow oO

Posted: Sat May 15, 2010 10:41 am
by LasTravel
tehmeat wrote:
janiii wrote:run the .bat file from a command line window, so that when it closes the command line window will stay open.
how would i do that..
sorry i been up for 23hours the last 3 lookin around on the net for this fix :(
Start>execute>cmd and drag the database_installer.bat to cmd window and press enter

Re: database problem.. i think im slow oO

Posted: Sat May 15, 2010 10:44 am
by tehmeat
LasTravel wrote:You are using windows server?

vars.txt are created on serverfolder/tools/ when you execute database_installer.bat, try execute it with right click > ejecute as admin
i dont see that txt file.. lol i dont kno what to say its not there

i did run as admin.. still closes :(

Re: database problem.. i think im slow oO

Posted: Sat May 15, 2010 10:50 am
by LasTravel
Then create it, vars.txt with:

Code: Select all

@echo off set config_version=2 set cmode=cset safe_mode=1 set mysqlPath=C:\Program Files (x86)\EasyPHP-5.3.2i\mysql\bin\mysql.exeset mysqlBinPath=C:\Program Files (x86)\EasyPHP-5.3.2i\mysql\binset mysqldumpPath=C:\Program Files (x86)\EasyPHP-5.3.2i\mysql\bin\mysqldump.exeset lsuser=rootset lspass=set lsdb=l2jdbset lshost=localhost set cbuser=rootset cbpass=set cbdb=l2jcbset cbhost=localhost set gsuser=rootset gspass=set gsdb=l2jdbset gshost=localhostset logdir=.set backup=.
If it don't work try put the patchs into a ""

And execute the installer...

Re: database problem.. i think im slow oO

Posted: Sat May 15, 2010 10:52 am
by tehmeat
LasTravel wrote:Then create it, vars.txt with:

Code: Select all

@echo off set config_version=2 set cmode=cset safe_mode=1 set mysqlPath=C:\Program Files (x86)\EasyPHP-5.3.2i\mysql\bin\mysql.exeset mysqlBinPath=C:\Program Files (x86)\EasyPHP-5.3.2i\mysql\binset mysqldumpPath=C:\Program Files (x86)\EasyPHP-5.3.2i\mysql\bin\mysqldump.exeset lsuser=rootset lspass=set lsdb=l2jdbset lshost=localhost set cbuser=rootset cbpass=set cbdb=l2jcbset cbhost=localhost set gsuser=rootset gspass=set gsdb=l2jdbset gshost=localhostset logdir=.set backup=.
If it don't work try put the patchs into a ""

And execute the installer...
lol i just edited that myself i have now when i can start to load it.. but i get an error " there was some problem while executing ***mysql" -h localhost -u root --password= -e "CREATE DATABASE l2jcb" 2> NUL"

Re: database problem.. i think im slow oO

Posted: Sat May 15, 2010 10:54 am
by LasTravel
You have created the database l2jcb?

If not, create it and ejecute again :D

Re: database problem.. i think im slow oO

Posted: Sat May 15, 2010 10:56 am
by tehmeat
it started then that came up.. i continue running the script and the error came up again then it said error occured while trying to create a database for ur login server.. i clicked c for continue and it just keeps going in circles

Re: database problem.. i think im slow oO

Posted: Sat May 15, 2010 10:59 am
by tehmeat
also the vars file is finally there.. :D

Re: database problem.. i think im slow oO

Posted: Sat May 15, 2010 11:01 am
by tehmeat
im not sure if its going to work or if im missing anything still
but i do see cbserver_back.sql and loginserver_backup.sql

Re: database problem.. i think im slow oO

Posted: Sat May 15, 2010 11:01 am
by LasTravel
Maybe you don't have the databases, you need create 2 databases, l2jdb and l2jcb

PS: Don't make triple post or TPH will shoot your head, use the edit button ^^...

Re: database problem.. i think im slow oO

Posted: Sat May 15, 2010 11:07 am
by tehmeat
ok i have both databases set with navicat if thats what i needed to do.. but im still getting the same errors :(




P.S. woot its working.. after the vars file showed up i never cleared it out.. i just did so and it just ran the full install :D

P.S. thank u so much! u've been a huge help :D

Re: database problem.. i think im slow oO

Posted: Sat May 15, 2010 11:11 am
by LasTravel
Okay, welcome to l2j!

Re: database problem.. i think im slow oO

Posted: Sun May 16, 2010 9:29 pm
by Onepamopa
Note to windows users: try to avoid installing mysql, & l2j server in directories with spaces, sometimes they can cause issues :)

Re: database problem.. i think im slow oO

Posted: Sun May 16, 2010 10:52 pm
by MELERIX
Onepamopa wrote:Note to windows users: try to avoid installing mysql, & l2j server in directories with spaces, sometimes they can cause issues :)
My L2J server, Java & MySQL are in directories with spaces, and nothings happens, all is working fine.

Re: database problem.. i think im slow oO

Posted: Mon Jun 21, 2010 4:26 pm
by iltrida
I have had the same problem with database_installer. I put the full path in mysql "set" (all 3 of them) into var.txt, and surprise! the program go on :)