I have been trying to set up my own ot server 8.6 and i have succeded this far: I could log in via my own global ip, my Znote AAC was functional, and the server connected with mysql database without any problems.
But my brother couldn't get past the character selection screen.
But this is not the issue anymore. Ever since i have restarted my computer, my server won't even start. When i click on the "TheForgottenServerV8.2 32bit" file it sometimes says, cannot connect to sql database, sometimes it comes to Running database manager, and sometimes to loading items, then it just stops working. i have created countless users and databases over and over in phpadmin, varying beetwen usernames, hosts (localhost and 127.0.0.1) and passwords. also have i checked config.lua, to see that everything was the same as in mysql database. but i just cant get it to work again. i have also watched the video tutorial, and have done everything the same (or at least similar, since it is made for the 9.6 client), but it wont work.
sqlType = "mysql"
sqlHost = "127.0.0.1"
sqlPort = 3306
sqlUser = "otserv86"
sqlPass = "mypassword"
sqlDatabase = "mydatabase"
sqlFile = "theforgottenserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "sha1"
this is my config.lua section on databases (i don't know hot to embed txt files, sorry
any reply would be greatly appreciated
But my brother couldn't get past the character selection screen.
But this is not the issue anymore. Ever since i have restarted my computer, my server won't even start. When i click on the "TheForgottenServerV8.2 32bit" file it sometimes says, cannot connect to sql database, sometimes it comes to Running database manager, and sometimes to loading items, then it just stops working. i have created countless users and databases over and over in phpadmin, varying beetwen usernames, hosts (localhost and 127.0.0.1) and passwords. also have i checked config.lua, to see that everything was the same as in mysql database. but i just cant get it to work again. i have also watched the video tutorial, and have done everything the same (or at least similar, since it is made for the 9.6 client), but it wont work.
sqlType = "mysql"
sqlHost = "127.0.0.1"
sqlPort = 3306
sqlUser = "otserv86"
sqlPass = "mypassword"
sqlDatabase = "mydatabase"
sqlFile = "theforgottenserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "sha1"
this is my config.lua section on databases (i don't know hot to embed txt files, sorry
any reply would be greatly appreciated