Main Menu
Menu

Show posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Show posts Menu

Messages - Harry

#1
JTS3ServerMod MySQL & WebInterface / Re: Auto Move
November 30, 2017, 04:25:28 PM
Would you be able to point me in a way in which I could do this, I have no knowledge of coding
#2
JTS3ServerMod MySQL & WebInterface / Auto Move
November 30, 2017, 01:05:56 PM
Hi,

Is it possible to tweak the Auto Move setting so that when a user joins a certain user group they get moved to a certain channel rather than have to disconnect and reconnect?
#3
In my opinion it is easier running a ! command than right clicking on your profile and adding the server group. I have next to no experience with coding so would prefer someone else to do it for me if thats possible
#4
Hi,

Is it possible for commands such as !sterile to be put into a channel and then the server group sterile gets assigned to the user who sent the message?

Thanks,
Harry
#5
I have no Java programming skills  :-\
#6
Ah ok, on another note, is it possible to create custom commands such as !test to assign a user to a certain group?

Thanks,
Harry
#7
I have no experience with php so I would not know how to do this, would you know how to do it?

Thanks
#8
Anyone know if this is possible, I would really like to use it on my teamspeak server rather than having to manually assign server groups.

Thanks
#9
Hello again,

Sorry for all the recent posts. Is there a feature that would allow me to link the server group protection feature to a phpBB database meaning that when someone logs on to the teamspeak server they get server groups assigned to them that are the same as the groups they have on the phpBB forum?

Thanks,
Harry
#10
Quote from: Stefan1200 on January 29, 2017, 10:13:27 PM
Quote from: Harry on January 29, 2017, 10:07:42 PM
I dont speak German but I used Google Translate so here goes, yes I set the address to 127.0.0.1

Sorry, I'm already tired and sometimes I translate English into German so fast in my brain, that I forgot, that I have to answer in English. ;)

Then I don't know. This is an error message from the MySQL server. The MySQL server rejects the connection attempt from the JTS3ServerMod.

But make sure that you don't have spaces around the MySQL password in the JTS3ServerMod_InstanceManager.cfg file, which are not part of the password.

Wow, it was as simple as removing the space after the password haha. Thank you
#11
Quote from: Stefan1200 on January 29, 2017, 10:01:16 PM
Als MySQL Server Adresse ist auch localhost in der JTS3ServerMod_InstanceManager.cfg Datei angegeben worden?
I dont speak German but I used Google Translate so here goes, yes I set the address to 127.0.0.1

Thanks
Harry
#12
Attached is a picture of all the permissions for the 'bot' account which is being used
#13
Quote from: Stefan1200 on January 29, 2017, 05:21:54 PM
Check the user account settings on the MySQL server, this is the error message:
Error while connecting to database: java.sql.SQLException: Access denied for user 'bot'@'localhost' (using password: YES)

For the SSL certificate warning, check this: https://www.stefan1200.de/forum/index.php?topic=416.0

What would be wrong with the user account settings?
#14
Hello,

When I try to launch the bot I get an error about the SSL connection without server identity verification. I have attached the log file

Thanks
Harry

2017-01-29 14:08:05 START_MANAGER JTS3ServerMod 6.3.3 Hosting Edition (31.12.2016) Instance Manager started...
2017-01-29 14:08:05 CONFIG Loading InstanceManager config file from: /root/JTS3ServerMod_HostingEdition/config/JTS3ServerMod_InstanceManager.cfg
2017-01-29 14:08:05 CONFIG Bot chat command !exec is disabled!
2017-01-29 14:08:05 CONFIG Multi IP Mode disabled!
2017-01-29 14:08:05 LOGGER_SQL_ERROR Critical: Cannot connect to MySQL server for logging!
2017-01-29 14:08:05 JTS3ServerMod 6.3.3 Hosting Edition (31.12.2016): EXCEPTION
java.sql.SQLException: Access denied for user 'bot'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:873)
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1710)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1226)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2253)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2284)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2083)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:806)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:410)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:328)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at de.stefan1200.util.MySQLConnect.connect(Unknown Source)
at de.stefan1200.jts3servermod.u.a(Unknown Source)
at de.stefan1200.jts3servermod.u.<init>(Unknown Source)
at de.stefan1200.jts3servermod.f.c(Unknown Source)
at de.stefan1200.jts3servermod.f.<init>(Unknown Source)
at de.stefan1200.jts3servermod.JTS3ServerMod.main(Unknown Source)
2017-01-29 14:08:05 CONFIG MySQL mode enabled!
2017-01-29 14:08:05 MYSQL_ERROR Error while connecting to database: java.sql.SQLException: Access denied for user 'bot'@'localhost' (using password: YES)
2017-01-29 14:08:05 JTS3ServerMod 6.3.3 Hosting Edition (31.12.2016): EXCEPTION
java.sql.SQLException: Access denied for user 'bot'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:873)
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1710)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1226)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2253)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2284)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2083)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:806)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:410)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:328)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at de.stefan1200.util.MySQLConnect.connect(Unknown Source)
at de.stefan1200.jts3servermod.f.e(Unknown Source)
at de.stefan1200.jts3servermod.f.c(Unknown Source)
at de.stefan1200.jts3servermod.f.<init>(Unknown Source)
at de.stefan1200.jts3servermod.JTS3ServerMod.main(Unknown Source)
2017-01-29 14:08:05 QUIT_MANAGER Error while loading the JTS3ServerMod InstanceManager config file, read error messages above to know more. Quitting now...
#15
Also do you know where I can find the  verifyServerCertificate as I get an error when I start the bot.

Thanks