Server Help

Bot Questions - TWCore with mySql databases...

Anonymous - Mon Apr 28, 2008 7:48 pm
Post subject: TWCore with mySql databases...
I am using
phpMyAdmin - 2.11.2.1
MySQL client version: 5.0.16

Code: Show/Hide
# SQL configuration file, for setting up access to MySQL DBs.
# ConnectionCount should equal the number of total connections, with a
# [Connection #] heading for each defined.  Set ConnectionCount to 0
# to disable SQL support.
[General]
RetryCount=3
ConnectionCount=1

[Connection 1]
Name1=local
Driver1=com.mysql.jdbc.Driver
Login1=*******
Password1=********
DataBase1=********
Server1=mysql.*****.sshq.net
Port1=3306
MinPoolSize1=1
MaxPoolSize1=10
WaitIfBusy1=1

[Connection 2]
Name2=website
Driver2=com.mysql.jdbc.Driver
Login2=
Password2=
DataBase2=
Server2=
Port2=3306
MinPoolSize2=1
MaxPoolSize2=5
WaitIfBusy2=1

D1st0rt - Mon Apr 28, 2008 8:03 pm
Post subject:
That appears to be properly formed, what is your question/problem?
Anonymous - Mon Apr 28, 2008 8:08 pm
Post subject: umm
It freezes at sql initiation.. Wont load pas that. and no errors are spammed
D1st0rt - Mon Apr 28, 2008 8:31 pm
Post subject:
A couple of things you should double check:

Both of these can be checked if you download the database client from here and try to connect to your database.
Anonymous - Mon Apr 28, 2008 9:06 pm
Post subject: K
I ran it and put this in...

Unexpected Error
Check your URL

User Name: &&&&&&
URL: mysql.&&&&&.sshq.net
Driver: com.mysql.jdbc.Driver
JDBC Jar File(s): C:\Subspace\twcore\lib\mysql-connector-java-5.0.7-bin.jar
Anonymous - Mon Apr 28, 2008 9:10 pm
Post subject: Might help?
Code: Show/Hide
                at com.jeta.abeille.database.model.TSConnection.a(Unknown Source)
                at com.jeta.abeille.database.model.TSConnection.I(Unknown Source)
                at com.jeta.abeille.database.model.TSConnection.<init>(Unknown Source)
                at com.jeta.abeille.database.model.y.a(Unknown Source)
                at com.jeta.abeille.gui.f.d.a(Unknown Source)
                at com.jeta.abeille.gui.f.d.a(Unknown Source)
                at com.jeta.abeille.gui.f.hb.cmdOk(Unknown Source)
                at com.jeta.open.gui.framework.JETADialog.validateListeners(JETADialog.java:672)
                at com.jeta.open.gui.framework.JETADialog.cmdOk(JETADialog.java:264)
                at com.jeta.open.gui.framework.JETADialog.actionPerformed(JETADialog.java:169)
                at com.jeta.open.gui.framework.JETADialog$CommandListener.actionPerformed(JETADialog.java:734)
                at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
                at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
                at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
                at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
                at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
                at java.awt.Component.processMouseEvent(Unknown Source)
                at javax.swing.JComponent.processMouseEvent(Unknown Source)
                at java.awt.Component.processEvent(Unknown Source)
                at java.awt.Container.processEvent(Unknown Source)
                at java.awt.Component.dispatchEventImpl(Unknown Source)
                at java.awt.Container.dispatchEventImpl(Unknown Source)
                at java.awt.Component.dispatchEvent(Unknown Source)
                at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
                at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
                at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
                at java.awt.Container.dispatchEventImpl(Unknown Source)
                at java.awt.Window.dispatchEventImpl(Unknown Source)
                at java.awt.Component.dispatchEvent(Unknown Source)
                at java.awt.EventQueue.dispatchEvent(Unknown Source)
                at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
                at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
                at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
                at java.awt.Dialog$1.run(Unknown Source)
                at java.awt.Dialog$2.run(Unknown Source)
                at java.security.AccessController.doPrivileged(Native Method)
                at java.awt.Dialog.show(Unknown Source)
                at com.jeta.open.gui.framework.JETADialog.showCenter(JETADialog.java:624)
                at com.jeta.abeille.gui.f.z.actionPerformed(Unknown Source)
                at com.jeta.open.gui.framework.JETAController.actionPerformed(JETAController.java:155)
                at com.jeta.open.gui.framework.JETAController$CommandListener.actionPerformed(JETAController.java:535)
                at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
                at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
                at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
                at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
                at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
                at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
                at java.awt.Component.processMouseEvent(Unknown Source)
                at javax.swing.JComponent.processMouseEvent(Unknown Source)
                at java.awt.Component.processEvent(Unknown Source)
                at java.awt.Container.processEvent(Unknown Source)
                at java.awt.Component.dispatchEventImpl(Unknown Source)
                at java.awt.Container.dispatchEventImpl(Unknown Source)
                at java.awt.Component.dispatchEvent(Unknown Source)
                at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
                at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
                at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
                at java.awt.Container.dispatchEventImpl(Unknown Source)
                at java.awt.Window.dispatchEventImpl(Unknown Source)
                at java.awt.Component.dispatchEvent(Unknown Source)
                at java.awt.EventQueue.dispatchEvent(Unknown Source)
                at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
                at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
                at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
                at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
                at java.awt.EventDispatchThread.run(Unknown Source)

Maverick - Tue Apr 29, 2008 2:57 am
Post subject:
Yes, if TWCore can't connect to the MySQL database then it freezes upon initial start.

I don't know Jetaware but I would recommend checking the connection to the database using SQLYog.



Oh, you are a SSHQ.net user (I wonder who you are icon_wink.gif ).

The URL to your database is always mysql.sshq.net .

Keep in mind there is also standard protection to disallow any outside IP to connect to the database aswell.
You can allow your own IP to connect to the database by adding it in the database properties in the Dreamhost Panel.
This is located under Goodies > Manage MySQL > (Click on your username under "Users with Access")
D1st0rt - Tue Apr 29, 2008 8:17 am
Post subject:
Whoops, didn't notice that in the url before, that will probably do it.

Mav, the purpose of using the AbeilleDB client was that it doesn't have its own connector built in so its a good way to test yours.
Maverick - Tue Apr 29, 2008 9:01 am
Post subject:
Ah ok, didn't know that. I should remember that, might come in handy some day icon_wink.gif
Anonymous - Wed Apr 30, 2008 12:38 am
Post subject: Got it connected.
I ran the robohelp..I seem to get it working fine. When i go through the java file everything looks ok. I havent edited it yet but when someone types on it or got it you get this error. Would appreciate support =)

Code: Show/Hide
28 Apr 2008 21:10:21   SWE-Security (robohelp) logged in: 391 ms.
java.lang.NullPointerException
        at twcore.bots.robohelp.robohelp.updateStatRecordsONIT(robohelp.java:116
8)
        at twcore.bots.robohelp.robohelp.handleClaim(robohelp.java:913)
        at twcore.bots.robohelp.robohelp.handleEvent(robohelp.java:1317)
        at twcore.core.net.GamePacketInterpreter.handleChatMessage(Unknown Sourc
e)
        at twcore.core.net.GamePacketInterpreter.translateNormalPacket(Unknown S
ource)
        at twcore.core.net.GamePacketInterpreter.translateGamePacket(Unknown Sou
rce)
        at twcore.core.net.ReliablePacketHandler.handleReliableMessage(Unknown S
ource)
        at twcore.core.net.GamePacketInterpreter.translateSpecialPacket(Unknown
Source)
        at twcore.core.net.GamePacketInterpreter.translateGamePacket(Unknown Sou
rce)
        at twcore.core.Session.run(Unknown Source)
java.lang.NullPointerException
        at twcore.bots.robohelp.robohelp.updateStatRecordsGOTIT(robohelp.java:11
88)
        at twcore.bots.robohelp.robohelp.handleClaim(robohelp.java:915)
        at twcore.bots.robohelp.robohelp.handleEvent(robohelp.java:1317)
        at twcore.core.net.GamePacketInterpreter.handleChatMessage(Unknown Sourc
e)
        at twcore.core.net.GamePacketInterpreter.translateNormalPacket(Unknown S
ource)
        at twcore.core.net.GamePacketInterpreter.translateGamePacket(Unknown Sou
rce)
        at twcore.core.net.ReliablePacketHandler.handleReliableMessage(Unknown S
ource)
        at twcore.core.net.GamePacketInterpreter.translateSpecialPacket(Unknown
Source)
        at twcore.core.net.GamePacketInterpreter.translateGamePacket(Unknown Sou
rce)
        at twcore.core.Session.run(Unknown Source)
java.lang.NullPointerException
        at twcore.bots.robohelp.robohelp.updateStatRecordsONIT(robohelp.java:116
8)
        at twcore.bots.robohelp.robohelp.handleClaim(robohelp.java:913)
        at twcore.bots.robohelp.robohelp.handleEvent(robohelp.java:1317)
        at twcore.core.net.GamePacketInterpreter.handleChatMessage(Unknown Sourc
e)
        at twcore.core.net.GamePacketInterpreter.translateNormalPacket(Unknown S
ource)
        at twcore.core.net.GamePacketInterpreter.translateGamePacket(Unknown Sou
rce)
        at twcore.core.net.ReliablePacketHandler.handleReliableMessage(Unknown S
ource)
        at twcore.core.net.GamePacketInterpreter.translateSpecialPacket(Unknown
Source)
        at twcore.core.net.GamePacketInterpreter.translateGamePacket(Unknown Sou
rce)
        at twcore.core.Session.run(Unknown Source)

Maverick - Wed Apr 30, 2008 10:21 am
Post subject:
Have you imported the required tables into your database for Robohelp? (Download here)

Note you can find other required tables for other bots on this wiki page.
Anonymous - Wed Apr 30, 2008 11:00 am
Post subject: Yes
All of the databases are installed...I double checked.
Maverick - Thu May 01, 2008 8:06 am
Post subject:
I already see what the problem is.
RoboHelp is trying to read out tblCall while the .sql scripts contains the table tblcall.

I've fixed it in the script. Redownload it and re-import it into your database (you might need to remove the old tblcall, tblwarnings and tbladvert).
Aceflyer - Fri May 16, 2008 11:26 pm
Post subject:
Thanks MMaverick and D1st0rt!

No, the previous guest poster wasn't me, btw; it was one of SWE's devs at the time.
All times are -5 GMT
View topic
Powered by phpBB 2.0 .0.11 © 2001 phpBB Group