Server Help

[Secretperson]

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]

That appears to be properly formed, what is your question/problem?
_________________

[Secretperson]

It freezes at sql initiation.. Wont load pas that. and no errors are spammed

[D1st0rt]

A couple of things you should double check:

• The firewall on your MySQL server allows port 3306 from whatever host your bot is running on.
  
• You're using a valid mysql-connector-whatever-bin.jar (the one in svn is 5.0.7)
  

Both of these can be checked if you download the database client from here and try to connect to your database.

[Secretperson]

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

[Secretperson]

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]

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 ).

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")
_________________

Nickname: Maverick (I changed my name!)
TWCore developer | Subspace statistics

[D1st0rt]

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]

Ah ok, didn't know that. I should remember that, might come in handy some day

[Secretperson]

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]

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.

[SSP]

All of the databases are installed...I double checked.

[Maverick]

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]

Thanks MMaverick and D1st0rt!

No, the previous guest poster wasn't me, btw; it was one of SWE's devs at the time.
_________________
SSCC Star Wars Empire Sysop
MERVBot.com Site Administrator
GetContinuum.com Site Administrator
SSC Forum Operator