TFS 1.X+ "cannot open config.lua: No such file or directory"

[radzradz]

Hello!
After compiling Theforgottenserver on Ubuntu, im getting this error(see images):
As you can see i don't have "config.lua" file, just "config.lua.dist" on main folder.
I tried to rename and move the files from build folder to the main folder and didn't work.
I followed these instructions; Running your first ubuntu linux OT | OTS Guide (https://docs.otland.net/ots-guide/running-your-first-linux-web-and-otserver)
Help!

 

[Gesior.pl]

As you can see i don't have "config.lua" file, just "config.lua.dist" on main folder.

1. Rename/copy config.lua.dist to config.lua
2. Move build/tfs file into main OTS folder - tfs file, config.lua and data folder must be in same folder

EDIT:
I've noticed on screenshot that you run it using /home/radz/Desktop/forgottenserver-1.6/build/tfs.
You may need to first cd to folder and then run tfs (after moving tfs from build folder to main OTS folder):

cd /home/radz/Desktop/forgottenserver-1.6
./tfs

 

[radzradz]

1. Rename/copy config.lua.dist to config.lua
2. Move build/tfs file into main OTS folder - tfs file, config.lua and data folder must be in same folder

EDIT:
I've noticed on screenshot that you run it using /home/radz/Desktop/forgottenserver-1.6/build/tfs.
You may need to first cd to folder and then run tfs (after moving tfs from build folder to main OTS folder):

cd /home/radz/Desktop/forgottenserver-1.6
./tfs

I tried that, still got the same error. :/

 

[Gesior.pl]

I tried that, still got the same error. :/

Show new screenshot. How it looks now and what command you run?
You can also message me on Discord: gesior.pl , we will find reason faster and then post solution on OTLand.

 

[radzradz]

Nice, it worked now. "tfs" by itself wasn't working but typing the entire patch after cd to folder worked.
I'm getting this now:

I got my nginx and php servers running. Not sure if It is the same server.
I'm able to access the admin page using my local IP (i guess) and 2344 port. I did not configure anything here. I don't know what to do from now.

 

[Gesior.pl]

Im getting this now:

If you are running TFS 1.6 there is no MySQL config in config.lua anymore (I'm working on fix for TFS), but you can add it yourself as end of config.lua file:

mysqlHost = "127.0.0.1"
mysqlUser = "forgottenserver"
mysqlPass = ""
mysqlDatabase = "forgottenserver"
mysqlPort = 3306
mysqlSock = ""

and set it's values to your MySQL login/password/database name.

 

[radzradz]

It's trying to establish database connection but after a while i got this:

Where i can find the database name? I need to configure something inside phpAdmin page?

 

[Xikini]

It's trying to establish database connection but after a while i got this:
View attachment 88344
Where i can find the database name? I need to configure something inside phpAdmin page?
View attachment 88345

► On the left sidebar, click "New".

► Select your database name and click "Create".

► Your database should be created now and selected.

► At the top, click the "Import" button.

► Click "Choose File" next to "Browse your computer" and locate the "schema.sql" file from TFS sources.

► Scroll down and click "Go".

 

[radzradz]

► On the left sidebar, click "New".

► Select your database name and click "Create".

► Your database should be created now and selected.

► At the top, click the "Import" button.

► Click "Choose File" next to "Browse your computer" and locate the "schema.sql" file from TFS sources.

► Scroll down and click "Go".

Done, but still got same issue. :/
I see my otadmin user does not have "ALL PRIVILEGES" like the other users:

Is this right?

Edit: Tried tfs version 1.4.2 but still no success. : /

 

[Xikini]

Done, but still got same issue. :/
I see my otadmin user does not have "ALL PRIVILEGES" like the other users:
View attachment 88346
Is this right?

Edit: Tried tfs version 1.4.2 but still no success. : /

If you are running TFS 1.6 there is no MySQL config in config.lua anymore (I'm working on fix for TFS), but you can add it yourself as end of config.lua file:

mysqlHost = "127.0.0.1"
mysqlUser = "forgottenserver"
mysqlPass = ""
mysqlDatabase = "forgottenserver"
mysqlPort = 3306
mysqlSock = ""

and set it's values to your MySQL login/password/database name.

Did you update this part with your information?

mysqlHost = "127.0.0.1"
mysqlUser = "otadmin"
mysqlPass = "whatever_you_put_as_the_password"
mysqlDatabase = "tfsDB"
mysqlPort = 3306 -- maybe 2344? I saw that in the guide.. just whatever you set it up as I guess
mysqlSock = ""

I don't know what Ubuntu uses to host stuff, but have you also 'turned on' the database?

On windows using Uniform server for example, you need to turn on 'apache' and 'MySQL' through the program for the tfs exe to find them and use them.
------
and yeah, for your user, you probably want all privileges.
Might need to login on the root user to give 'otadmin' full.

 

[radzradz]

Did you update this part with your information?

mysqlHost = "127.0.0.1"
mysqlUser = "otadmin"
mysqlPass = "whatever_you_put_as_the_password"
mysqlDatabase = "tfsDB"
mysqlPort = 3306 -- maybe 2344? I saw that in the guide.. just whatever you set it up as I guess
mysqlSock = ""

I don't know what Ubuntu uses to host stuff, but have you also 'turned on' the database?

On windows using Uniform server for example, you need to turn on 'apache' and 'MySQL' through the program for the tfs exe to find them and use them.
------
and yeah, for your user, you probably want all privileges.
Might need to login on the root user to give 'otadmin' full.

Yeah, i updated the info, when i used the wrong ip or port it's was not even trying to connect but with right ip and port i'ts trying but after 1 min waiting "Establishing database connection..." i got the MySQL message and the error.

The only part inside config.lua i left blank is "mysqlSock". I'm trying to find some info about that.