Solved Problems running my OTS 8.6

[demon088]

Hi,
I recently purchased a service at Spigu Cloud and I can't run my own OTS 8.6 with tfs 0.4 engine. I compiled the tfs 0.4 from this github repository https://github.com/otservme/global860. But when I try to run my OTS:

I can't find out how to solve this problem and I'm hurry for setting online my OTS, so please if you can help me I'd be thankful!

 

[Don Daniello]

In case you don't see the output in the log (as above), you can always run the server in the foreground (as opposed to in the background and via auto-restarter service) to check what the problem is.
I just did that for you and the output was:

otsmanager@158-69-12-209:~/ots$ ./theforgottenserver
[20:45:54.516] [TFS] Revisado por Chaitosoft.com - a sua loja de otserv, version 0.3.7_SVN (Crying Damson)
[20:45:54.516] Compiled with GNU C++ version 5.2.1 20151010 (x86_64: 1) at Apr 27 2016, 18:56:33.
[20:45:54.516] A server developed by Elf, Talaturen, Dalkon, BeniS, Tryller and Kornholijo.
[20:45:54.516] Visit our forum for updates, support and resources: http://otland.net.

[20:45:54.516] >> Loading config (config.lua)
[20:45:54.517] > Opening logs
[20:45:54.517] > Using SHA1 encryption
[20:45:54.517] >> Checking software version...
[20:45:54.517] > Ignoring version check, using SVN
[20:45:54.518] >> Loading RSA key
[20:45:54.518] > Calculating dmp1, dmq1 and iqmp for RSA... done
[20:45:54.519] >> Starting SQL connection

[20:45:54.520] Failed connecting to database - MYSQL ERROR: Access denied for user 'root'@'localhost' (using password: NO) (1045)
theforgottenserver: databasemysql.cpp:39: DatabaseMySQL::DatabaseMySQL(): Assertion `connect(false)' failed.
Aborted

 

[demon088]

So what should I do, I don't understand very well...
Thanks for the reply

 

[Don Daniello]

The error indicates that you have not provided correct username and password to access the database.
The original config.lua that we ship with the server has correct username and password for the forgottenserver database. You can use that one or create one yourself. Just supply a correct password and database name.

 

[demon088]

I'm done with that, but now it seems that its not loading the sql database. I edited the config.lua correctly but I guess the .s3db file is wrong with something because it can't load the databse. What can I do to solve this?
Thanks again!

 

[Don Daniello]

Do you have a version with SQLite support? I hope you don't, you should be using the MySQL database (in which case you can disregard the s3db file settings).

 

[demon088]

Yeah its SQLite support... How can I avoid this problem?

 

[Don Daniello]

From the error message it looks like your server is trying to connect to a MySQL database.

 

[demon088]

Got it, I changed it to sqlite. Does it affect the webpage?

 

[Don Daniello]

Uhm, you'd need an AAC that supports sqlite and it will be slower. I highly suggest you use MySQL just like everybody else is doing these days. There is rarely any material on using sqlite nowadays here on Otland.

 

[demon088]

Okok I understand, so how do I conect to phpmyadmin or something else to upload MySQL schema?

 

[Don Daniello]

The link to phpMyAdmin is displayed to you when you connect via PuTTY. So is username and password. Did you read instructions?

 

[demon088]

True! I'm a dumbass xD
Srry for being so annoying. And thank you so much!