PI Auth voting system?

**Deception-pkz** · 11-30-2012, 07:01 PM

Edit: When i do ::auth i get this error

Spoiler for Error:

Code:

[11/30/12 10:59 AM]: java.lang.Exception: connection is null
[11/30/12 10:59 AM]:    at server.Database.getConnection(Database.java:49)
[11/30/12 10:59 AM]:    at server.model.mobile.players.Commands.processPacket(Co
mmands.java:50)
[11/30/12 10:59 AM]:    at server.model.mobile.players.PacketHandler.processPack
et(PacketHandler.java:118)
[11/30/12 10:59 AM]:    at server.model.mobile.players.Client.processQueuedPacke
ts(Client.java:1205)
[11/30/12 10:59 AM]:    at server.model.mobile.players.PlayerHandler.process(Pla
yerHandler.java:136)
[11/30/12 10:59 AM]:    at server.Server$1.execute(Server.java:180)
[11/30/12 10:59 AM]:    at server.task.Task2.tick(Task2.java:105)
[11/30/12 10:59 AM]:    at server.event.TaskScheduler.run(TaskScheduler.java:100
)
[11/30/12 10:59 AM]:    at java.util.concurrent.Executors$RunnableAdapter.call(U
nknown Source)
[11/30/12 10:59 AM]:    at java.util.concurrent.FutureTask$Sync.innerRunAndReset
(Unknown Source)
[11/30/12 10:59 AM]:    at java.util.concurrent.FutureTask.runAndReset(Unknown S
ource)
[11/30/12 10:59 AM]:    at java.util.concurrent.ScheduledThreadPoolExecutor$Sche
duledFutureTask.access$301(Unknown Source)
[11/30/12 10:59 AM]:    at java.util.concurrent.ScheduledThreadPoolExecutor$Sche
duledFutureTask.run(Unknown Source)
[11/30/12 10:59 AM]:    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unk
nown Source)
[11/30/12 10:59 AM]:    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Un
known Source)
[11/30/12 10:59 AM]:    at java.lang.Thread.run(Unknown Source)
[11/30/12 11:00 AM]: java.lang.Exception: connection is null
[11/30/12 11:00 AM]:    at server.Database.getConnection(Database.java:49)
[11/30/12 11:00 AM]:    at server.model.mobile.players.Commands.processPacket(Co
mmands.java:50)
[11/30/12 11:00 AM]:    at server.model.mobile.players.PacketHandler.processPack
et(PacketHandler.java:118)
[11/30/12 11:00 AM]:    at server.model.mobile.players.Client.processQueuedPacke
ts(Client.java:1205)
[11/30/12 11:00 AM]:    at server.model.mobile.players.PlayerHandler.process(Pla
yerHandler.java:136)
[11/30/12 11:00 AM]:    at server.Server$1.execute(Server.java:180)
[11/30/12 11:00 AM]:    at server.task.Task2.tick(Task2.java:105)
[11/30/12 11:00 AM]:    at server.event.TaskScheduler.run(TaskScheduler.java:100
)
[11/30/12 11:00 AM]:    at java.util.concurrent.Executors$RunnableAdapter.call(U
nknown Source)
[11/30/12 11:00 AM]:    at java.util.concurrent.FutureTask$Sync.innerRunAndReset
(Unknown Source)
[11/30/12 11:00 AM]:    at java.util.concurrent.FutureTask.runAndReset(Unknown S
ource)
[11/30/12 11:00 AM]:    at java.util.concurrent.ScheduledThreadPoolExecutor$Sche
duledFutureTask.access$301(Unknown Source)
[11/30/12 11:00 AM]:    at java.util.concurrent.ScheduledThreadPoolExecutor$Sche
duledFutureTask.run(Unknown Source)
[11/30/12 11:00 AM]:    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unk
nown Source)
[11/30/12 11:00 AM]:    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Un
known Source)
[11/30/12 11:00 AM]:    at java.lang.Thread.run(Unknown Source)
[11/30/12 11:00 AM]: java.lang.Exception: connection is null
[11/30/12 11:00 AM]:    at server.Database.getConnection(Database.java:49)
[11/30/12 11:00 AM]:    at server.model.mobile.players.Commands.processPacket(Co
mmands.java:50)
[11/30/12 11:00 AM]:    at server.model.mobile.players.PacketHandler.processPack
et(PacketHandler.java:118)
[11/30/12 11:00 AM]:    at server.model.mobile.players.Client.processQueuedPacke
ts(Client.java:1205)
[11/30/12 11:00 AM]:    at server.model.mobile.players.PlayerHandler.process(Pla
yerHandler.java:136)
[11/30/12 11:00 AM]:    at server.Server$1.execute(Server.java:180)
[11/30/12 11:00 AM]:    at server.task.Task2.tick(Task2.java:105)
[11/30/12 11:00 AM]:    at server.event.TaskScheduler.run(TaskScheduler.java:100
)
[11/30/12 11:00 AM]:    at java.util.concurrent.Executors$RunnableAdapter.call(U
nknown Source)
[11/30/12 11:00 AM]:    at java.util.concurrent.FutureTask$Sync.innerRunAndReset
(Unknown Source)
[11/30/12 11:00 AM]:    at java.util.concurrent.FutureTask.runAndReset(Unknown S
ource)
[11/30/12 11:00 AM]:    at java.util.concurrent.ScheduledThreadPoolExecutor$Sche
duledFutureTask.access$301(Unknown Source)
[11/30/12 11:00 AM]:    at java.util.concurrent.ScheduledThreadPoolExecutor$Sche
duledFutureTask.run(Unknown Source)
[11/30/12 11:00 AM]:    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unk
nown Source)
[11/30/12 11:00 AM]:    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Un
known Source)
[11/30/12 11:00 AM]:    at java.lang.Thread.run(Unknown Source)
[11/30/12 11:00 AM]: java.lang.Exception: connection is null
[11/30/12 11:00 AM]:    at server.Database.getConnection(Database.java:49)
[11/30/12 11:00 AM]:    at server.model.mobile.players.Commands.processPacket(Co
mmands.java:50)
[11/30/12 11:00 AM]:    at server.model.mobile.players.PacketHandler.processPack
et(PacketHandler.java:118)
[11/30/12 11:00 AM]:    at server.model.mobile.players.Client.processQueuedPacke
ts(Client.java:1205)
[11/30/12 11:00 AM]:    at server.model.mobile.players.PlayerHandler.process(Pla
yerHandler.java:136)
[11/30/12 11:00 AM]:    at server.Server$1.execute(Server.java:180)
[11/30/12 11:00 AM]:    at server.task.Task2.tick(Task2.java:105)
[11/30/12 11:00 AM]:    at server.event.TaskScheduler.run(TaskScheduler.java:100
)
[11/30/12 11:00 AM]:    at java.util.concurrent.Executors$RunnableAdapter.call(U
nknown Source)
[11/30/12 11:00 AM]:    at java.util.concurrent.FutureTask$Sync.innerRunAndReset
(Unknown Source)
[11/30/12 11:00 AM]:    at java.util.concurrent.FutureTask.runAndReset(Unknown S
ource)
[11/30/12 11:00 AM]:    at java.util.concurrent.ScheduledThreadPoolExecutor$Sche
duledFutureTask.access$301(Unknown Source)
[11/30/12 11:00 AM]:    at java.util.concurrent.ScheduledThreadPoolExecutor$Sche
duledFutureTask.run(Unknown Source)
[11/30/12 11:00 AM]:    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unk
nown Source)
[11/30/12 11:00 AM]:    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Un
known Source)
[11/30/12 11:00 AM]:    at java.lang.Thread.run(Unknown Source)
[11/30/12 11:00 AM]: java.lang.Exception: connection is null
[11/30/12 11:00 AM]:    at server.Database.getConnection(Database.java:49)
[11/30/12 11:00 AM]:    at server.model.mobile.players.Commands.processPacket(Co
mmands.java:50)
[11/30/12 11:00 AM]:    at server.model.mobile.players.PacketHandler.processPack
et(PacketHandler.java:118)
[11/30/12 11:00 AM]:    at server.model.mobile.players.Client.processQueuedPacke
ts(Client.java:1205)
[11/30/12 11:00 AM]:    at server.model.mobile.players.PlayerHandler.process(Pla
yerHandler.java:136)
[11/30/12 11:00 AM]:    at server.Server$1.execute(Server.java:180)
[11/30/12 11:00 AM]:    at server.task.Task2.tick(Task2.java:105)
[11/30/12 11:00 AM]:    at server.event.TaskScheduler.run(TaskScheduler.java:100
)
[11/30/12 11:00 AM]:    at java.util.concurrent.Executors$RunnableAdapter.call(U
nknown Source)
[11/30/12 11:00 AM]:    at java.util.concurrent.FutureTask$Sync.innerRunAndReset
(Unknown Source)
[11/30/12 11:00 AM]:    at java.util.concurrent.FutureTask.runAndReset(Unknown S
ource)
[11/30/12 11:00 AM]:    at java.util.concurrent.ScheduledThreadPoolExecutor$Sche
duledFutureTask.access$301(Unknown Source)
[11/30/12 11:00 AM]:    at java.util.concurrent.ScheduledThreadPoolExecutor$Sche
duledFutureTask.run(Unknown Source)
[11/30/12 11:00 AM]:    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unk
nown Source)
[11/30/12 11:00 AM]:    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Un
known Source)
[11/30/12 11:00 AM]:    at java.lang.Thread.run(Unknown Source)

Code:

conn = DriverManager.getConnection(
                                        "jdbc:mysql://" + props.getProperty("localhost") + ":"
                                                        + props.getProperty("3306") + "/"
                                                        + props.getProperty("divinere_some"),
                                        props.getProperty("divinere_some"),
                                        props.getProperty("pass"));
                } catch (Exception e) {
                        throw new Exception("error connecting to database "
                                        + e.getMessage());
                }
        }

Code:

public static Connection getConnection() throws Exception {
                if (conn == null) {
                        throw new Exception("connection is null");
                }
                if (System.currentTimeMillis() - lastUsed > 300000) {
                        try {
                                lastUsed = System.currentTimeMillis();
                                conn.close();
                                connect();
                        } catch (Exception e) {
                                throw new Exception("error refreshing database connection");
                        }
                }

Code:

conn = DriverManager.getConnection(
                                        "jdbc:mysql://" + props.getProperty("localhost") + ":"
                                                        + props.getProperty("3306") + "/"
                                                        + props.getProperty("divinere_vote"),
                                        props.getProperty("divinere_vote"),
                                        props.getProperty("PASS"));
                } catch (Exception e) {
                        throw new Exception("error connecting to database "
                                        + e.getMessage());

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
<properties>
    <comment>Database connection settings</comment>
    <entry key="host">localhost/entry>
    <entry key="port">3306</entry>
    <entry key="name">divinere_vote</entry>
    <entry key="username">divinere_vote</entry>
    <entry key="password">PASS</entry>
</properties>

Anything else im missing that could be causing it?

**Spooky** · 11-30-2012, 07:05 PM

java.io.FileNotFoundException: database.xml (The system cannot find the file spe
cified)

Self explanatory no?

**Deception-pkz** · 11-30-2012, 07:06 PM

Yes ofc. But i have that file in the correct place.

**Spooky** · 11-30-2012, 07:07 PM

Originally Posted by Deception-pkz

Yes ofc. But i have that file in the correct place.

You obviously don't. You need to put it in the root directory of the server, if you are cd'ing(change directory) you need to put it in that folder.

**Deception-pkz** · 11-30-2012, 07:11 PM

Read first page

**Spooky** · 11-30-2012, 07:12 PM

Originally Posted by Deception-pkz

I put it at the start where src and stuff is now

and i get this

Code:

Dec 01, 2012 5:10:37 AM server.Database init
INFO: initiating database connection...
Dec 01, 2012 5:10:37 AM server.Database connect
INFO: connecting to database...
Dec 01, 2012 5:10:37 AM server.Database connect
SEVERE: error connecting to database
java.sql.SQLException: Illegal connection port value 'null'
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
        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:2018)
        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718)
        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
        at java.lang.reflect.Constructor.newInstance(Unknown Source)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
:282)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at server.Database.connect(Database.java:59)
        at server.Database.init(Database.java:47)
        at server.Server.main(Server.java:113)

Port must be an int set in the database.xml

Code:

<entry key="port">3306</entry>

**Dondxon** · 11-30-2012, 07:14 PM

i fkn bought a auth code system and the guy ([Only registered and activated users can see links. ]) doesnt want to give me the index.php of the auth system.

there goes my money...

-other index's doesnt work. cus it has real weird methods and shit.

**Spooky** · 11-30-2012, 07:16 PM

Originally Posted by Dondxon

i fkn bought a auth code system and the guy doesnt want to give me the index.php of the auth system.

there goes my money...

-other index's doesnt work. cus it has real weird methods and shit.

I don't think this is the place to put your rant. It is no help to OP that you was ripped off. Create a scam report.

**Deception-pkz** · 11-30-2012, 07:16 PM

It already is 3306?

**Deception-pkz** · 11-30-2012, 08:26 PM

New problem

help me through skype ? or teamviewer?

Thread: PI Auth voting system?

Thread Tools

Thankful user:

Users Browsing this Thread

User Tag List

Similar Threads

Bug Free - Auth Voting System [PI, IX]

Auth Voting System

Buying Voting Auth Code System

[PI]Buying Voting System with auth

Buying auth voting system