V83 Maplestory

Hello there, idk if i posted in the right forum but i wish i could get some help

Can one of you guys help me out please

I Ran the ZenthosDev OneW and i get this:

ZenthosDev has started:
World Launched
ERROR: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Cou
ld not create connection to database server. Attempted reconnect 3 times. Giving
up.
Exception in thread "main" java.lang.NullPointerException
at net.world.WorldRegistryImpl.<init>(WorldRegistryImpl.java:56)
at net.world.WorldRegistryImpl.getInstance(WorldRegistryImpl.java:71)
at net.world.WorldServer.main(WorldServer.java:47)
Login Launched
Error initializing loginserverjava.lang.RuntimeException: Could not connect to w
orld server.
Press any key to continue . . . Channel Launched
Exception in thread "main" java.rmi.NotBoundException: WorldRegistry
at sun.rmi.registry.RegistryImpl.lookup(Unknown Source)
at sun.rmi.registry.RegistryImpl_Skel.dispatch(Unknown Source)
at sun.rmi.server.UnicastServerRef.oldDispatch(Unknown Source)
at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source)
at sun.rmi.transport.Transport$1.run(Unknown Source)
at sun.rmi.transport.Transport$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Unknown Source)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Source)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(Unknown Sou
rce)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown Sour
ce)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(Unknow
n Source)
at sun.rmi.transport.StreamRemoteCall.executeCall(Unknown Source)
at sun.rmi.server.UnicastRef.invoke(Unknown Source)
at sun.rmi.registry.RegistryImpl_Stub.lookup(Unknown Source)
at net.channel.ChannelServer.main(ChannelServer.java:204)
Press any key to continue . . .

Don't give out a GameMaster position for something this small.
Your server couldn't make connection to the database. This could mean that either your database credentials put in the source are incorrect, or your sql server isn't running.

@Luxray (THANK U SO MUCH FOR THE REPLY)

I have mysql open and running
it worked but now im getting this:

http://i57.tinypic.com/19pksm.png

World is working.
Login is not working.
Channel is not working.

In DatabaseConnection.java, there will be a line with "jdbc:mysql://HOST:3306/SCHEMA?autoReconnect=true".
After that line (or right behind it on the same line), there will be 2 other parameters to fill in, these are USERNAME and PASSWORD.

HOST = The IP of the host, if hosting locally, use either localhost or 127.0.0.1
SCHEMA = The database schema. The name of the database.
USERNAME = The username to log in to the database.
PASSWORD = The password to log in to the database.

[QUOTE=Luxray;8195335]In DatabaseConnection.java, there will be a line with "jdbc:mysql://HOST:3306/SCHEMA?autoReconnect=true".
After that line (or right behind it on the same line), there will be 2 other parameters to fill in, these are USERNAME and PASSWORD.

HOST = The IP of the host, if hosting locally, use either localhost or 127.0.0.1
SCHEMA = The database schema. The name of the database.
USERNAME = The username to log in to the database.
PASSWORD = The password to log in to the database.

were is the databaseConnecton.java

In your source.
I'll download the source to give a more accurate explaination.

Okay but also if i change sources will i have to redo this all because im just planning to stay with zenthosdev then im going to SupremeMS Source

Okay, so DatabaseConnection.java is located in ZenthosDev/src/database/. On line 36, there's a text similar to what I posted before.
Simply edit 127.0.0.1 to your host and change zenthosdev (behind :3066/) to your schemaname.
The username and password are stored in ServerProperties.java, which is located in ZenthosDev/src/constants/.
On line 57 and 58, it will set the property dbPassword and dbUserName. dbPassword has an empty value (there's nothing between the ""'s), put your password between those ""'s.
dbUserName has the value root, just change that to your database username.

- - - Updated - - -

You will need to do this with every source.

Quote:

---

Originally Posted by Luxray

Okay, so DatabaseConnection.java is located in ZenthosDev/src/database/. On line 36, there's a text similar to what I posted before.
Simply edit 127.0.0.1 to your host and change zenthosdev (behind :3066/) to your schemaname.
The username and password are stored in ServerProperties.java, which is located in ZenthosDev/src/constants/.
On line 57 and 58, it will set the property dbPassword and dbUserName. dbPassword has an empty value (there's nothing between the ""'s), put your password between those ""'s.
dbUserName has the value root, just change that to your database username.

- - - Updated - - -

You will need to do this with every source.

---

Uhm can you help me with this on teamviewer
and i have no password on my mysql

Just edit the parts I told you, compile and replace the JAR file.
If you have no database password, just leave the part as it is right now.

Quote:

---

Originally Posted by Luxray

Just edit the parts I told you, compile and replace the JAR file.
If you have no database password, just leave the part as it is right now.

---

K, I'll try to do this on zenthosdev if it works i will do it on supremeMS

Okay, so DatabaseConnection.java is located in ZenthosDev/src/database/. On line 36, there's a text similar to what I posted before.
Simply edit 127.0.0.1 to your host

my host is 127.0.0.1 so i leave it like that right? (this is my first time making one)

Quote:

---

Originally Posted by Saifiki

K, I'll try to do this on zenthosdev if it works i will do it on supremeMS

Okay, so DatabaseConnection.java is located in ZenthosDev/src/database/. On line 36, there's a text similar to what I posted before.
Simply edit 127.0.0.1 to your host

my host is 127.0.0.1 so i leave it like that right?

---

Yes, leaving it as 127.0.0.1 is fine then.

heres my databasconnection.java

package database;


import constants.ServerProperties;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Collection;
import java.util.LinkedList;


public class DatabaseConnection {
private static ThreadLocal<Connection> con = new ThreadLocalConnection();
private final static String dbUserName = ServerProperties.getDBusername;
private final static String dbPassword = ServerProperties.getDBpassword;


public static Connection getConnection() {
return con.get();
}


public static void closeAll() throws SQLException {
for (Connection conn : ThreadLocalConnection.allConnections) {
conn.close();
}
}


private static class ThreadLocalConnection extends ThreadLocal<Connection> {
public static Collection<Connection> allConnections = new LinkedList<Connection>();


@Override
protected Connection initialValue() {
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
System.out.println("ERROR: " + e);
}
try {
Connection con = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/zenthosdev?autoReconnect=true", dbUserName, dbPassword);
allConnections.add(con);
return con;
} catch (SQLException e) {
System.out.println("ERROR: " + e);
return null;
}
}
}
}


----------------------------------------------------------------------------------------------------
nothing to change here ^^ also this i dont really get:

Okay, so DatabaseConnection.java is located in ZenthosDev/src/database/. On line 36, there's a text similar to what I posted before.
Simply edit 127.0.0.1 to your host and change zenthosdev (behind :3066/) to your schemaname.
The username and password are stored in ServerProperties.java, which is located in ZenthosDev/src/constants/.
On line 57 and 58, it will set the property dbPassword and dbUserName. dbPassword has an empty value (there's nothing between the ""'s), put your password between those ""'s.
dbUserName has the value root, just change that to your database username.

this is my mysql set up starting: http://i60.tinypic.com/akx17d.png
please can you help me by using teamviewer im really new at this
(ID:738 479 331 Pass:5868)



- - - Updated - - -

(this is really hard)

This is my mysql setup at the starting

http://i60.tinypic.com/akx17d.png




- - - Updated - - -

Just tried again does not work i still get this error http://tinypic.com/view.php?pic=19pksm&s=8

Quote:

---

Originally Posted by Saifiki

snip

---

Your database connection should ALWAYS be 127.0.0.1 or localhost. Your database (for most servers) is stored on the same computer that the server is being hosted from. If you're having connection issues, make sure your MySQL Schema is called "zenthosdev". If it's not named ZenthosDev (it's always toLowerCase in mysql anyways), then THAT is what you change in your DatabaseProperties. (:3306/yourDbNameHere)

If you still get connection issues, make sure you turned WampServer online. If it's off, you won't be able to connect.

Oh, and jus sayin', you probably shouldn't just throw out your teamviewer id and password out for everyone to see.. lol

kk ty all you guys fixed it but im just getting one problem like the other people

http://oi42.tinypic.com/e5soc0.jpg

Please Help me i want this server public really soon in like a day or two :(