Server Help Forum Index Server Help
Community forums for Subgame, ASSS, and bots
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   StatisticsStatistics   RegisterRegister 
 ProfileProfile   Login to check your private messagesLogin to check your private messages   LoginLogin (SSL) 

Server Help | ASSS Wiki (0) | Shanky.com
TWCore with mySql databases...

 
Post new topic   Reply to topic Printable version
 View previous topic  flagrace Post :: Post Rankbot  View next topic  
Author Message
Secretperson
Guest


Offline

PostPosted: Mon Apr 28, 2008 7:48 pm    Post subject: TWCore with mySql databases... Reply to topic Reply with quote

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
Back to top
D1st0rt
Miss Directed Wannabe


Age:30
Gender:Gender:Male
Joined: Aug 31 2003
Posts: 2247
Location: Blacksburg, VA
Offline

PostPosted: Mon Apr 28, 2008 8:03 pm    Post subject: Reply to topic Reply with quote

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

Back to top
View users profile Send private message Add User to Ignore List Visit posters website
Secretperson
Guest


Offline

PostPosted: Mon Apr 28, 2008 8:08 pm    Post subject: umm Reply to topic Reply with quote

It freezes at sql initiation.. Wont load pas that. and no errors are spammed
Back to top
D1st0rt
Miss Directed Wannabe


Age:30
Gender:Gender:Male
Joined: Aug 31 2003
Posts: 2247
Location: Blacksburg, VA
Offline

PostPosted: Mon Apr 28, 2008 8:31 pm    Post subject: Reply to topic Reply with quote

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.
Back to top
View users profile Send private message Add User to Ignore List Visit posters website
Secretperson
Guest


Offline

PostPosted: Mon Apr 28, 2008 9:06 pm    Post subject: K Reply to topic Reply with quote

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
Back to top
Secretperson
Guest


Offline

PostPosted: Mon Apr 28, 2008 9:10 pm    Post subject: Might help? Reply to topic Reply with quote

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)
Back to top
Maverick
broken record


Age:33
Gender:Gender:Male
Joined: Feb 26 2005
Posts: 1521
Location: The Netherlands
Offline

PostPosted: Tue Apr 29, 2008 2:57 am    Post subject: Reply to topic Reply with quote

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")
_________________
Nickname: Maverick (I changed my name!)
TWCore developer | Subspace statistics
Back to top
View users profile Send private message Add User to Ignore List Visit posters website
D1st0rt
Miss Directed Wannabe


Age:30
Gender:Gender:Male
Joined: Aug 31 2003
Posts: 2247
Location: Blacksburg, VA
Offline

PostPosted: Tue Apr 29, 2008 8:17 am    Post subject: Reply to topic Reply with quote

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.
Back to top
View users profile Send private message Add User to Ignore List Visit posters website
Maverick
broken record


Age:33
Gender:Gender:Male
Joined: Feb 26 2005
Posts: 1521
Location: The Netherlands
Offline

PostPosted: Tue Apr 29, 2008 9:01 am    Post subject: Reply to topic Reply with quote

Ah ok, didn't know that. I should remember that, might come in handy some day icon_wink.gif
Back to top
View users profile Send private message Add User to Ignore List Visit posters website
Secretperson
Guest


Offline

PostPosted: Wed Apr 30, 2008 12:38 am    Post subject: Got it connected. Reply to topic Reply with quote

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)
Back to top
Maverick
broken record


Age:33
Gender:Gender:Male
Joined: Feb 26 2005
Posts: 1521
Location: The Netherlands
Offline

PostPosted: Wed Apr 30, 2008 10:21 am    Post subject: Reply to topic Reply with quote

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.
Back to top
View users profile Send private message Add User to Ignore List Visit posters website
SSP
Guest


Offline

PostPosted: Wed Apr 30, 2008 11:00 am    Post subject: Yes Reply to topic Reply with quote

All of the databases are installed...I double checked.
Back to top
Maverick
broken record


Age:33
Gender:Gender:Male
Joined: Feb 26 2005
Posts: 1521
Location: The Netherlands
Offline

PostPosted: Thu May 01, 2008 8:06 am    Post subject: Reply to topic Reply with quote

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).
Back to top
View users profile Send private message Add User to Ignore List Visit posters website
Aceflyer
Newbie


Gender:Gender:Male
Joined: Feb 13 2008
Posts: 22
Offline

PostPosted: Fri May 16, 2008 11:26 pm    Post subject: Reply to topic Reply with quote

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
Back to top
View users profile Send private message Add User to Ignore List
Display posts from previous:   
Post new topic   Reply to topic    Server Help Forum Index -> Bot Questions All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum
View online users | View Statistics | View Ignored List


Software by php BB © php BB Group
Server Load: 238 page(s) served in previous 5 minutes.

phpBB Created this page in 0.087312 seconds : 39 queries executed (47.7%): GZIP compression disabled