[Guide]PokeNet Server Setup

[GeNyaa]

Damn Default you made it way too easy...
I did it in 30mins Thanks gonna look into this
and maybe help the Development ones in a while

 

[-DefaulT]

lol thanks nyaa

 

[avaton]

the first time i followed every step of your guide but i had that error "Server account offline, please try later" when i tried to log in.so i tried to redo everything.now,i have a new problem i removed the previous instance from mysql and when i try to execute the new one i get this error:

any ideas?

 

[-DefaulT]

Check the user table on the mysql database. The user, & host muste be correcty set. Also Rembember firewalls should be open!

Also forward port 3306

mysql> grant all prvileges on *.* to <userName>@<hostName> identified by 'passwrd'

 

[avaton]

The firewall is open.sorry i don't get it.i'm new with that stuff.the only options i have is 'mysql command line' and 'config wizard'.where should i find user table?

 

[-DefaulT]

open the msq command line and type grant all prvileges on *.* to <userName>@<hostName> identified by 'passwrd'

change username and hostname and passwrd

 

[avaton]

firstly asks for my password.i write it down ,then this message appears:

and it closes fast.is it me or there is a real problem? :S

 

[-DefaulT]

You prob just need to edit your conf files since you applied a password to root.

If you can add me to msn and get team viewer

d.faultx@hotmail.com

Ill fix it for u

 

[Omnija]

when im not soo poop feeling from not sleeping ill upload an a pre set webserver/files, so it will be like a click and go. Since apparently ppl are having so much trouble with this.

 

[VodkaMartini]

Found Some Problems:
1. After set the client to full screen, the client crashed when trying to open again.
2. Stuck after chat with other player in 1 map.
3. Thunder Stone bugged, can't evolution level 70 Pikachu.
4. Sometimes after announcing (GM) the client hangs.

questions:
how to edit npc? i found only the coordinates for warp portal & npc location.

 

[Omnija]

when im not soo poop feeling from not sleeping ill upload an a pre set webserver/files, so it will be like a click and go. Since apparently ppl are having so much trouble with this.

I still haven't slept yet but anyways here's the release which is an all in 1 server.

All you have todo is go in the webserver folder and open usbwebserver.exe.

Once you have done this, go into your server folder and open it
Type this in

localhost
pokenet
root
pokepoke
Server Name

and the server should start and all is well.
I also included the Time.php that should fix the problem with time if you have Defaults SVN build.

You must be registered to see links

-> webserver

 

[-DefaulT]

Found Some Problems:
1. After set the client to full screen, the client crashed when trying to open again.
2. Stuck after chat with other player in 1 map.
3. Thunder Stone bugged, can't evolution level 70 Pikachu.
4. Sometimes after announcing (GM) the client hangs.

questions:
how to edit npc? i found only the coordinates for warp portal & npc location.

These are known bugs. Except the full screen, i dont know whats with that. The chat with other player, u click the name of the player in the chat then re select 'local' to get back to all chat. The announcing i dont know whats with that, i think its some sort of spam filter that causes that. Thunderstones, only 4 stones are coded i believe, and i think they have a trainer level restriction on them, not sure. I will look into these though.

 

[sercankd]

it gives me this error
in linux and windows machine error is same

 

[Omnija]

it gives me this error
in linux and windows machine error is same

does the server and client run? because error happen and obviously most of you don't realise that the server and client still run with those error's. Also id like to point out the obvious
"IT IS IN DEVELOPMENT IT IS NOT...NOT COMPLETED, SO ERROR'S DO AND WILL OCCUR"

 

[-DefaulT]

Lol... Those errors are normal.

 

[sercankd]

it says its running but i am unable to register from client. it says
"The account server is currently offline. Please try again later."

 

[Omnija]

it says its running but i am unable to register from client. it says
"The account server is currently offline. Please try again later."

make sure to type in your info in the server properly, make sure to re type the password every time you shut it down. If your still having problems, get a new database and i recommend either downloading my pre set server or defaults svn.

 

[sercankd]

i know i did everything properly in the guide but it shows me this error in the error.log

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
	at com.mysql.jdbc.Util.getInstance(Util.java:381)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2364)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:773)
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
	at java.sql.DriverManager.getConnection(DriverManager.java:620)
	at java.sql.DriverManager.getConnection(DriverManager.java:200)
	at org.pokenet.server.network.MySqlManager.connect(MySqlManager.java:32)
	at org.pokenet.server.network.NetworkService.start(NetworkService.java:92)
	at org.pokenet.server.ServiceManager.start(ServiceManager.java:103)
	at org.pokenet.server.GameServer.start(GameServer.java:320)
	at org.pokenet.server.GameServer.<init>(GameServer.java:159)
	at org.pokenet.server.GameServer.main(GameServer.java:503)
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

 

[dabaotea]

I still haven't slept yet but anyways here's the release which is an all in 1 server.

All you have todo is go in the webserver folder and open usbwebserver.exe.

Once you have done this, go into your server folder and open it
Type this in

localhost
pokenet
root
pokepoke
Server Name

and the server should start and all is well.
I also included the Time.php that should fix the problem with time if you have Defaults SVN build.

You must be registered to see links

-> webserver

It was tested and time.php would "hide" the error on debugging and compiling the server source; however, on the client the time isn't in fact the correct one as the server computer's. Thus it works just to hide the error message.

---------- Post added at 07:55 AM ---------- Previous post was at 07:52 AM ----------

i know i did everything properly in the guide but it shows me this error in the error.log

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
	at com.mysql.jdbc.Util.getInstance(Util.java:381)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2364)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:773)
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
	at java.sql.DriverManager.getConnection(DriverManager.java:620)
	at java.sql.DriverManager.getConnection(DriverManager.java:200)
	at org.pokenet.server.network.MySqlManager.connect(MySqlManager.java:32)
	at org.pokenet.server.network.NetworkService.start(NetworkService.java:92)
	at org.pokenet.server.ServiceManager.start(ServiceManager.java:103)
	at org.pokenet.server.GameServer.start(GameServer.java:320)
	at org.pokenet.server.GameServer.<init>(GameServer.java:159)
	at org.pokenet.server.GameServer.main(GameServer.java:503)
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

MySQL details are in correct as it says: Communications link failure. And do portforward right after.

---------- Post added at 07:57 AM ---------- Previous post was at 07:55 AM ----------

How do you admin ownself? Tried changing value of AdminLevel to 100 in the database but commands don't work.

 

[sercankd]

no mysql details are correct, also i m trying on a dedicated server so i dont need portforwarding.