[HELP]Server problem

[PrettyBOYY]

I got a hellbound server up and running a while ago. This one night the power went out at my house and then after that I tried to open the server up but then it keeps saying "Server Terminated Abnormally" I tried reinstalling MySQL and changing the password and username but it still says "Server terminated Abnormally". Do anybody know whats wrong? When I click on Start.bat and the web server pops up and I click it it always says cannot connect to localhost (using password=YES) or something like that. I really need your help. I've searched everywhere but can't find the answer. Thanks for your help.

[MentaL]

[Rin4a]

post the full error and configuration files, if you can, so we could solve your error

[PrettyBOYY]

post the full error and configuration files, if you can, so we could solve your error

ok this is what it says...

http://img143.imageshack.us/img143/3687/13004000zm6.jpg

[Rin4a]

lol... you entered wrong database name in your configuration file!!!
or you didn`t install database at all

[PrettyBOYY]

lol... you entered wrong database name in your configuration file!!!
or you didn`t install database at all

wrong database name? how do you fix that?

i reinstalled the database but then it says

"This system cannot find the path specified.
The system cannot find the file specified
The system cannot find the file specified"


i dont get whats wrong... can you help me? thanks

[WhiteTiger123]

in config/server.properties you must see some lines...

# Database info
Driver=com.mysql.jdbc.Driver
#Driver=org.hsqldb.jdbcDriver
#Driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
URL=jdbc:mysql://localhost/DB_NAME
#URL=jdbc:hsqldb:hsql://localhost/l2jdb
#URL=jdbc:sqlserver://localhost/database=l2jdb/user=sa/password=
Login=DB_USER
Password=DB_PASSWORD

Set DB_NAME to your MySql DB Name ;Default=l2jdb
Set DB_USER to your MySql login name ;Default=root
Set DB_PASSWORD to your MySql login password ;Default=

You might have other DB or other user settings

Sorry for bad English

[Rin4a]

there is one other thing, when installing the database:
right click on tools/database_installer.bat
and edit all the needed values:

set mysqlBinPath= your_full_mysql_path/bin
set lsuser=database_user (defalult: root)
set lspass=database_password (defalult: root)
set lsdb=database_name (defalult: l2jdb)
set lshost=database_host (defalult: localhost)
set gsuser=database_user (defalult: root)
set gspass=database_password (defalult: root)
set gsdb=database_name (defalult: l2jdb)
set gshost=database_host (defalult: localhost)

and then do what WhiteTiger123 told you...
and if you can`t handle that, forget the idea of holding a server, because you can`t complete a simple task...

[PrettyBOYY]

i did all of that stuff... when i try to install the database it says

"mysqldump: Got error: 1049: Unknown database 'l2jdb' when selecting the database"

i've done all the stuff up there but it still says server terminated abnormally...


also when i open up navicat and connect it only doesnt show l2jdb under one of its options...

ok i changed all my config files, i edited the database_installer.bat .... but it still says server terminated abnormally. it seems like the database wont install or something, do anybody know whats wrong?

[DaRkAnGeL]

i did all of that stuff... when i try to install the database it says

"mysqldump: Got error: 1049: Unknown database 'l2jdb' when selecting the database"

i've done all the stuff up there but it still says server terminated abnormally...


also when i open up navicat and connect it only doesnt show l2jdb under one of its options...

ok i changed all my config files, i edited the database_installer.bat .... but it still says server terminated abnormally. it seems like the database wont install or something, do anybody know whats wrong?

give the messages that you received in the console

i can not help you otherwise

[PrettyBOYY]

this is what it says when i try to run the loginserver

http://img409.imageshack.us/img409/7131/89827433vt3.jpg

[Rin4a]

OMG!!!
IF YOU CAN`T CREATE A SINGLE DATABASE, WHY DO YOU EVEN TRY TO HOLD A SERVER???
http://forum.ragezone.com/forumdisplay.php?f=324
find a guide that you can understand and remake everything!!!

[PrettyBOYY]

i've created the database before... it just messed up on me recently. everything was working fine until my power went out and then it just messed everything up. i've done everything the guide says but this problem still occurs. i'm trying to ask for help on this forum... isnt that what this forum is for?

[Droppo]

i'm trying to ask for help on this forum... isnt that what this forum is for?

Well...no... this is for knowledge sharing, that means not only ask for hel, but help others too...

Droppo.-

[PrettyBOYY]

Well...no... this is for knowledge sharing, that means not only ask for hel, but help others too...

Droppo.-

yea well i help what i know and people who know help others, you dont go around flaming people... thats just wrong

[Droppo]

Lol! I don't flame ppl. And I don't post going offtopic... so you better don't do it either. Stay in topic now.

Droppo.-

[PrettyBOYY]

Lol! I don't flame ppl. And I don't post going offtopic... so you better don't do it either. Stay in topic now.

Droppo.-

yea i made the topic lol... i'm just waiting for somebodys help... been a couple days with nothing

[Droppo]

in that case... read your own error message and the answers you got... all you need to fix that, is already posted. your problem is quite simple just needs some attention and specially, think and don't wait for someone to fix it for you or a step-by-step guide, coz then, you're screwed...

Check Rin4a posts and there you have the solution.

Droppo.-

[PrettyBOYY]

in that case... read your own error message and the answers you got... all you need to fix that, is already posted. your problem is quite simple just needs some attention and specially, think and don't wait for someone to fix it for you or a step-by-step guide, coz then, you're screwed...

Check Rin4a posts and there you have the solution.

Droppo.-

well i've tried everything, it doesnt work. can you tell me specificly which part i'm doing wrong?

[Droppo]

No, Sorry, but I never give anything ready to go to anyone, that makes ppl lazy and leechers. but the answer is pretty much clear you just need to out a lil bit from you now to get it fixed.

Droppo.-

[TrippiN06]

Ok, you said your power went out, so lets go with the obvious help things first.

Does your IP run on Localhost? If not Proceed to Next set of questions.
If so, check the next few things.
1. Make sure your correct username & password are entered. Login to navicat w/ username @ pw or check connection properties if you dont remember what you used. Make sure your hostname/ip=localhost or 127.0.0.1. If your using something different like the local ip ( 192.168.254.1/192.168.1.101..etc.. or your lan is connected dirrectly and you have the external IP....) Then jump to the next set of questions, if its local, then continue.
2. Create a database inside your mysql named "l2jdb"
3. Make sure your mysql path is correct when using the database installer.
4. Install should go flawlessly.

Does your IP run on an Internal IP/External ip (direct conn..)
1. When logging into navicat, go to "mysql" then "users" set "ip" to "%" without the "s.. This will allow you to connect externally no matter what your IP changes to. If you only connect locally, dont worry about this then.
2. Check that your IP is not your external, your internal. ( start > cntrl panel > network connections > local area connection :> right click > properties > Support. See what the ip is ) Be sure that this IP is entered inyour my.ini inside (x:/windows/) or mysql wont allow connections as its not set up on the internal address. Or if its on a direct line without router, then make sure that that address that shows up is in there. If your IP changes ALOT. Then its best to get a router, so atleast your internal IP stays the same, and all ports are always forwarded to it. So that way all you goto do is keep tellin peeps your new external ip..
3. Verify that everything is connecting good through navicat using the IP, Username & pw.
4. Create a database named "l2jdb"
5. Set configs in the database installer. Make sure mysql bin path is correct!!
6. Should be no problems.

Hope i was more help then the others. If you are still having some issues, pm me. :busted_coBut i wont be back around here till friday :) :construct

[lolokopo123]

hi how to fix gsdb fail???

---------- Post added at 11:37 AM ---------- Previous post was at 11:33 AM ----------

hi...how to fix this problem gsdb fail...i dont know why??please how to fix

---------- Post added at 11:37 AM ---------- Previous post was at 11:37 AM ----------

hi...how to fix this problem gsdb fail...i dont know why??please how to fix

[DaRkAnGeL]

hi how to fix gsdb fail???

---------- Post added at 11:37 AM ---------- Previous post was at 11:33 AM ----------

hi...how to fix this problem gsdb fail...i dont know why??please how to fix

---------- Post added at 11:37 AM ---------- Previous post was at 11:37 AM ----------

hi...how to fix this problem gsdb fail...i dont know why??please how to fix

what do you mean with this?