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.


Messages - Harry

Pages: [1] 2
1
JTS3ServerMod MySQL & WebInterface / Re: Auto Move
« on: 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
« on: 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
General Discussions / Re: ! commands triggering servergroups being added
« on: October 30, 2017, 07:03:03 PM »
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
General Discussions / ! commands triggering servergroups being added
« on: October 29, 2017, 09:41:00 PM »
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
JTS3ServerMod MySQL & WebInterface / Re: MySQL connection problem
« on: January 29, 2017, 11:06:14 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
JTS3ServerMod MySQL & WebInterface / Re: MySQL connection problem
« on: January 29, 2017, 10:07:42 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
JTS3ServerMod MySQL & WebInterface / Re: MySQL connection problem
« on: January 29, 2017, 05:49:59 PM »
Attached is a picture of all the permissions for the 'bot' account which is being used

13
JTS3ServerMod MySQL & WebInterface / Re: MySQL connection problem
« on: January 29, 2017, 05:30:23 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
JTS3ServerMod MySQL & WebInterface / MySQL connection problem
« on: January 29, 2017, 03:36:39 PM »
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

Code: [Select]
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
JTS3ServerMod MySQL & WebInterface / Re: DBConnect_config.php Error
« on: January 29, 2017, 03:10:01 PM »
Also do you know where I can find the  verifyServerCertificate as I get an error when I start the bot.

Thanks

Pages: [1] 2