Linux Help starting my OTS 8.6 on VPS!

[demon088]

Hello Otland community, I'm looking for some help for the last steps to setting online my tibia server in 8.6 version.

1. I compilated TFS 1.2 on Debian 8 (jessie) VPS trough Putty and it's all configurated, but when I try to run my server here it goes:

- Config.lua located in the folder '/root/tfs' (route of my serv data).
- Tfs 1.2 is compilated in '/root/theforgottenserver' and it has another config.lua file.

My config.lua contents in SQL DB section:
-- Database
sqlHost = "127.0.0.1"
sqlUser = "root"
sqlPass = ""

I'm really new at these Linux things, so I don't understand how to solve my problem or where to find. I searched other threads but didn't get my problem solved.

2. I also have a problem with Phpmyadmin, when I enter to mydomain/phpmyadmin:

I just don't figure out how to solve any of those problems, so if you have any idea to share I would be thankful.
Thanks for your time and all the help. See you!

 

[oualid6496]

it's not connecting with your database do you have a mysql database?

 

[demon088]

I have MySQL installed in Debian, but I didn't uploaded my schema.sql to phpmyadmin service because I can't log into my account in my web. But the vps local tfs folder has my databse.s3db and the schemas in the server's folder, take a look:

I've tried every configuration in config.lua, I also moved the .s3db trough the folders, but it have not changed, it even ignores the changes I make in config.lua (users, passwords, etc...) I just don't understand the issues.

 

[tokenzz]

I have MySQL installed in Debian, but I didn't uploaded my schema.sql to phpmyadmin service because I can't log into my account in my web. But the vps local tfs folder has my databse.s3db and the schemas in the server's folder, take a look:

I've tried every configuration in config.lua, I also moved the .s3db trough the folders, but it have not changed, it even ignores the changes I make in config.lua (users, passwords, etc...) I just don't understand the issues.

The error occurs because you haven't uploaded the schema to your database = you have no database

 

[SamX]

You just said you don't have access to php my admin. Well neither does your config file. Figure out your password and update the config.lua file then import scheme.sql in your database.

If you installed MySQL in putty it should have prompted you to make a password.

 

[Techrlz]

In config.lua change all "mysql things" with this:

sqlType = "mysql"
mysqlHost = "127.0.0.1"
mysqlUser = "root"
mysqlPass = ""
mysqlDatabase = "otserver"
mysqlPort = 3306
mysqlSock = ""
passwordType = "sha1"

 

[demon088]

Yes it did, I installed it normally but it looks like I did something wrong and can't link nginx to phpmyadmin.
So... if I upload my schema.sql to my php and configure config.lua with the same password and user as phpmyadmin, I should be able to run online my serv?

 

[SamX]

Yes

First go to php my admin and create new user (grant all privileges) then import scheme.sql
Enter new users information into config
Start server

It should work

 

[demon088]

Yes

First go to php my admin and create new user (grant all privileges) then import scheme.sql
Enter new users information into config
Start server

It should work

Ok I'm actually having the trouble with nginx, it doesn't let me access to phpmyadmin.
So I think that solving it that's all.

In config.lua change all "mysql things" with this:

sqlType = "mysql"
mysqlHost = "127.0.0.1"
mysqlUser = "root"
mysqlPass = ""
mysqlDatabase = "otserver"
mysqlPort = 3306
mysqlSock = ""
passwordType = "sha1"

config.lua is out of access because I haven't phpmyadmin service, so I can't upload my schema. If I can't "open" this path I can't go any further.

Thanks to all for the help.

 

[demon088]

Okay, I found my problem...
I don't know how exactly the way to configure the nginx's '/etc/nginx/sites-available/default'
Here is mine:

I can't find 'http://mydomain/phpmyadmin' because this document isn't configurated at all, but when I look posts explaining it, the document is very different and I justa can't find the way it must be configurated to show phpmyadmin on my web browser.
Somebody can explain the way it must be done? It's Nginx 1.6.2.
Thanks for your time and help!

 

[demon088]

Now I can't compile TFS, I tried to start all over again to make no mistakes and now...

I can't find the reason, I did the same things as before and now I'm stuck steps back... Why is this happening?
Please help! -_-'