I can't get my server to work. Please help!

[Phased]

When i open my server it says:
"The Forgotten Server has stopped working"

but when i change (config.lua)

    sqlType = "mysql"

to:

    sqlType = "sqlite"

my server starts without problem. However my website (Gesior aac 1.0.3) gives me this error:
Error occured!
Error ID:
More info: CANNOT CONNECT TO DATABASE: could not find driver

File: C:\UniServerZ\www\classes/database_sqlite.php Line: 22
File: C:\UniServerZ\www\classes/database.php Line: 199
File: C:\UniServerZ\www\pages/latestnews.php Line: 15
File: C:\UniServerZ\www\system/load.page.php Line: 7
File: C:\UniServerZ\www/index.php Line: 37

I do not understand why this happens. Please help!

 

[dominique120]

Configure gresior to use sqlite.

 

[Phased]

Configure gresior to use sqlite.

I'll try, thanks for answering!

 

[Phased]

Configure gresior to use sqlite.

I can't find where to reconfigure gesior to use sqlite. Would you mind telling me?

 

[dominique120]

I can't find where to reconfigure gesior to use sqlite. Would you mind telling me?

I've never used grensior, let me investigate a bit.

 

[Phased]

bump

 

[Phased]

I've never used grensior, let me investigate a bit.

Found anything yet?

 

[dominique120]

Found anything yet?

Yes that many people have problems when using sqlite. Why not use mysql?

 

[Phased]

Yes that many people have problems when using sqlite. Why not use mysql?

My server won't start if i use mysql in config.lua

 

[dominique120]

Did you set it up properly? Proper password, username, and db, along with 127.0.0.1 as host instead of localhost.

 

[Phased]

Did you set it up properly? Proper password, username, and db, along with 127.0.0.1 as host instead of localhost.

Everything is correctly setup, I have doublechecked multiple times.

 

[dominique120]

Post the connection part of the config.lua. Create a new database and user and set the host of the database as 127.0.0.1

 

[Phased]

Post the connection part of the config.lua. Create a new database and user and set the host of the database as 127.0.0.1

    worldId = 1
    ip = "localhost"
    bindOnlyConfiguredIpAddress = true
    loginPort = 7171
    gamePort = 7172
    adminPort = 7171
    statusPort = 7171
    loginTries = 10
    retryTimeout = 5 * 1000
    loginTimeout = 60 * 1000
    maxPlayers = 1000

    sqlType = "mysql"
    sqlHost = "127.0.0.1"
    sqlPort = 3306
    sqlUser = "stafallot"
    sqlPass = "************************"
    sqlDatabase = "starfallots"
    sqlFile = "forgottenserver.s3db"
    sqlKeepAlive = 1
    mysqlReadTimeout = 10
    mysqlWriteTimeout = 10
    encryptionType = "sha1"

 

[dominique120]

Did you create a user with host 127.0.0.1?
Like this?

 

[Phased]

Did you create a user with host 127.0.0.1?
Like this?

I have tried with both "localhost" and "127.0.0.1"

 

[dominique120]

Do you get any errors in console before the crash?

 

[Phased]

Do you get any errors in console before the crash?

 

[dominique120]

And with sqlite you dont get this? That's weird because if you notice it connect fine to the database, but crashes when loading items.

 

[Phased]

And with sqlite you dont get this? That's weird because if you notice it connect fine to the database, but crashes when loading items.

Indeed, I just can't understand

 

[dominique120]

Try a a different datapack maybe?