• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

[8.60] The Forgotten Server 0.3.6 (Crying Damson) V8

@sztucnooki
change to this and try
Code: 
    -- Database
    -- NOTE: sqlFile is used only by sqlite database, and sqlKeepAlive by mysql database.
    -- To disable sqlKeepAlive such as mysqlReadTimeout use 0 value.
    sqlType = "mysql"
    sqlHost = "127.0.0.1"
    sqlPort = 3306
    sqlUser = "myots"
    sqlPass = "mypassword"
    sqlDatabase = "myots"
    sqlFile = "forgottenserver.s3db"
    sqlKeepAlive = 0
    mysqlReadTimeout = 10
    mysqlWriteTimeout = 10
    encryptionType = "sha1"
 
uhm... veeery strange.
changed to sha1 (crashed 3 times) so changed it back again.
[18/09/2013 17:55:53] > WARNING: You cannot switch from hashed passwords to plain text, change back the passwordType in config.lua to the passwordType you were previously using.
But!
Code: 
[18/09/2013 17:55:53] > Optimizing table: account_viplist... [success]
[18/09/2013 17:55:53] > Optimizing table: accounts... [success]
[18/09/2013 17:55:53] > Optimizing table: environment_killers... [success]
[18/09/2013 17:55:53] > Optimizing table: global_storage... [success]
[18/09/2013 17:55:53] > Optimizing table: guild_invites... [success]
[18/09/2013 17:55:53] > Optimizing table: guild_ranks... [success]
[18/09/2013 17:55:53] > Optimizing table: guilds... [success]
[18/09/2013 17:55:53] > Optimizing table: house_auctions... [success]
[18/09/2013 17:55:53] > Optimizing table: house_data... [success]
[18/09/2013 17:55:53] > Optimizing table: houses... [success]
[18/09/2013 17:55:53] > Optimizing table: killers... [success]
[18/09/2013 17:55:54] > Optimizing table: player_deaths... [success]
[18/09/2013 17:55:54] > Optimizing table: player_items... [success]
[18/09/2013 17:55:54] > Optimizing table: player_killers... [success]
[18/09/2013 17:55:54] > Optimizing table: player_namelocks... [success]
[18/09/2013 17:55:54] > Optimizing table: player_skills... [success]
[18/09/2013 17:55:54] > Optimizing table: player_spells... [success]
[18/09/2013 17:55:54] > Optimizing table: player_storage... [success]
[18/09/2013 17:55:54] > Optimizing table: player_viplist... [success]
[18/09/2013 17:55:54] > Optimizing table: players... [success]
[18/09/2013 17:55:54] > Optimizing table: server_config... [success]
[18/09/2013 17:55:54] > Optimizing table: server_motd... [success]
[18/09/2013 17:55:54] > Optimizing table: server_record... [success]
[18/09/2013 17:55:54] > Optimizing table: server_reports... [success]
[18/09/2013 17:55:54] >> Loading items
[18/09/2013 17:55:54] >> Loading groups
[18/09/2013 17:55:54] >> Loading vocations
[18/09/2013 17:55:54] >> Loading script systems
[18/09/2013 17:55:55] >> Loading chat channels
[18/09/2013 17:55:55] >> Loading outfits
[18/09/2013 17:55:55] >> Loading experience stages
[18/09/2013 17:55:55] >> Loading monsters
[18/09/2013 17:55:55] >> Loading mods...
[18/09/2013 17:55:55] > Loading buypremium_command.xml... done.
[18/09/2013 17:55:55] > Loading changender_command.xml... done.
[18/09/2013 17:55:55] > Loading custommonsters.xml... done.
[18/09/2013 17:55:55] > Loading customspells.xml... done.
[18/09/2013 17:55:55] > Loading firstitems.xml... done.
[18/09/2013 17:55:55] > Loading highscorebook.xml... done.
[18/09/2013 17:55:55] > Loading Military Ranks.xml... done.
[18/09/2013 17:55:55] > 7 mods were loaded.
[18/09/2013 17:55:55] >> Loading map and spawns...
[18/09/2013 17:55:55] > Map size: 2048x2048.
[18/09/2013 17:55:55] > Map descriptions:
[18/09/2013 17:55:55] "Saved with Remere's Map Editor 2.1"
[18/09/2013 17:55:55] "No map description available."
[18/09/2013 17:55:55] > Map loading time: 0.037 seconds.
[18/09/2013 17:55:55] > Data parsing time: 0.001 seconds.
[18/09/2013 17:55:55] > Houses synchronization time: 0.001 seconds.
[18/09/2013 17:55:55] > Content unserialization time: 0.002 seconds.
[18/09/2013 17:55:55] >> Checking world type... PvP
[18/09/2013 17:55:55] >> Initializing game state modules and registering services...
[18/09/2013 17:55:55] mysql_real_query(): UPDATE `bans` SET `active` = 0 WHERE `expires` <= 1379519755 AND `expires` >= 0 AND `active` = 1 LIMIT 1; - MYSQL ERROR: Table 'myots.bans' doesn't exist (1146)
[18/09/2013 17:55:55] > Global address: 127.0.0.1
[18/09/2013 17:55:55] > Local ports: 7171    7172   
[18/09/2013 17:55:55] >> All modules were loaded, server is starting up...
[18/09/2013 17:55:55] >> Forgotten 8.60 server Online!

thanks! ;D I still have no idea what has just happened ^^
 
Sztucznooki said:
Hey guys, I have same problem as Yamo has.
my config.lua is:
Code: 
    -- Database
    -- NOTE: sqlFile is used only by sqlite database, and sqlKeepAlive by mysql database.
    -- To disable sqlKeepAlive such as mysqlReadTimeout use 0 value.
    sqlType = "mysql"
    sqlHost = "127.0.0.1"
    sqlPort = 3306
    sqlUser = "root"
    sqlPass = "mypassword"
    sqlDatabase = "myots"
    sqlFile = "forgottenserver.s3db"
    sqlKeepAlive = 0
    mysqlReadTimeout = 10
    mysqlWriteTimeout = 10
    encryptionType = "plain"

Yamo, is it working for u now, or not?
Click to expand...
No, I still got the problem.
I did a little investigation:
I downloaded a port check. Either port 7171, 7172 and 3306 (all TCP/UDP) are open.
I am also pretty sure my settings in config.lua are correct.

So, I neither know what the problem is, nor how to solve the problem.
 
dominique120 said:
My serv boots up perfectly when i use global ip "127.0.0.1" but if I switch to my external ip it crashes. Can someone help me out with this? thanks

@Yamo try using "sha1" for password encryption, and "127.0.0.1" for mysql host. Also make sure that the user's host is set to "localhost" on the left and "127.0.0.1" on the right. Also generate a password with mysql and use that, its safer.
Click to expand...
password encryption = encryptionType (I suppose?)
What do you mean with "Also make sure that the user's host is set to "localhost" on the left and "127.0.0.1" on the right." Little explaination please :)
Thanks for your help as far!
 
Sztucznooki said:
Hey guys, I have same problem as Yamo has.
my config.lua is:
Code: 
    -- Database
    -- NOTE: sqlFile is used only by sqlite database, and sqlKeepAlive by mysql database.
    -- To disable sqlKeepAlive such as mysqlReadTimeout use 0 value.
    sqlType = "mysql"
    sqlHost = "127.0.0.1"
    sqlPort = 3306
    sqlUser = "root"
    sqlPass = "mypassword"
    sqlDatabase = "myots"
    sqlFile = "forgottenserver.s3db"
    sqlKeepAlive = 0
    mysqlReadTimeout = 10
    mysqlWriteTimeout = 10
    encryptionType = "plain"

Yamo, is it working for u now, or not?
Click to expand...

I got my server online now! (on MySQL).
My config.lua now:
Code: 
    -- Database
    -- NOTE: sqlFile is used only by sqlite database, and sqlKeepAlive by mysql database.
    -- To disable sqlKeepAlive such as mysqlReadTimeout use 0 value.
    sqlType = "mysql"
    sqlHost = "127.0.0.1"
    sqlPort = 3306
    sqlUser = "root"
    sqlPass = "" -- my password
    sqlDatabase = "" -- my databasename
    sqlFile = "forgottenserver.s3db"
    sqlKeepAlive = 0
    mysqlReadTimeout = 10
    mysqlWriteTimeout = 10
    encryptionType = "sha1"
 
Yamo said:
I got my server online now! (on MySQL).
My config.lua now:
Code: 
    -- Database
    -- NOTE: sqlFile is used only by sqlite database, and sqlKeepAlive by mysql database.
    -- To disable sqlKeepAlive such as mysqlReadTimeout use 0 value.
    sqlType = "mysql"
    sqlHost = "127.0.0.1"
    sqlPort = 3306
    sqlUser = "root"
    sqlPass = "" -- my password
    sqlDatabase = "" -- my databasename
    sqlFile = "forgottenserver.s3db"
    sqlKeepAlive = 0
    mysqlReadTimeout = 10
    mysqlWriteTimeout = 10
    encryptionType = "sha1"
Click to expand...
aaand it stopped working xD
 
@Yamo send me your server and il fix every bugg on it... else i can send you a way better just tell me what kind of serv it is
 
@Yamo download teamviewer 8 and pm you comp name and pw and il fix it for you so you can watch when im doing it
 
Sztucznooki said:
uhm... veeery strange.
changed to sha1 (crashed 3 times) so changed it back again.
[18/09/2013 17:55:53] > WARNING: You cannot switch from hashed passwords to plain text, change back the passwordType in config.lua to the passwordType you were previously using.
But!
Code: 
[18/09/2013 17:55:53] > Optimizing table: account_viplist... [success]
[18/09/2013 17:55:53] > Optimizing table: accounts... [success]
[18/09/2013 17:55:53] > Optimizing table: environment_killers... [success]
[18/09/2013 17:55:53] > Optimizing table: global_storage... [success]
[18/09/2013 17:55:53] > Optimizing table: guild_invites... [success]
[18/09/2013 17:55:53] > Optimizing table: guild_ranks... [success]
[18/09/2013 17:55:53] > Optimizing table: guilds... [success]
[18/09/2013 17:55:53] > Optimizing table: house_auctions... [success]
[18/09/2013 17:55:53] > Optimizing table: house_data... [success]
[18/09/2013 17:55:53] > Optimizing table: houses... [success]
[18/09/2013 17:55:53] > Optimizing table: killers... [success]
[18/09/2013 17:55:54] > Optimizing table: player_deaths... [success]
[18/09/2013 17:55:54] > Optimizing table: player_items... [success]
[18/09/2013 17:55:54] > Optimizing table: player_killers... [success]
[18/09/2013 17:55:54] > Optimizing table: player_namelocks... [success]
[18/09/2013 17:55:54] > Optimizing table: player_skills... [success]
[18/09/2013 17:55:54] > Optimizing table: player_spells... [success]
[18/09/2013 17:55:54] > Optimizing table: player_storage... [success]
[18/09/2013 17:55:54] > Optimizing table: player_viplist... [success]
[18/09/2013 17:55:54] > Optimizing table: players... [success]
[18/09/2013 17:55:54] > Optimizing table: server_config... [success]
[18/09/2013 17:55:54] > Optimizing table: server_motd... [success]
[18/09/2013 17:55:54] > Optimizing table: server_record... [success]
[18/09/2013 17:55:54] > Optimizing table: server_reports... [success]
[18/09/2013 17:55:54] >> Loading items
[18/09/2013 17:55:54] >> Loading groups
[18/09/2013 17:55:54] >> Loading vocations
[18/09/2013 17:55:54] >> Loading script systems
[18/09/2013 17:55:55] >> Loading chat channels
[18/09/2013 17:55:55] >> Loading outfits
[18/09/2013 17:55:55] >> Loading experience stages
[18/09/2013 17:55:55] >> Loading monsters
[18/09/2013 17:55:55] >> Loading mods...
[18/09/2013 17:55:55] > Loading buypremium_command.xml... done.
[18/09/2013 17:55:55] > Loading changender_command.xml... done.
[18/09/2013 17:55:55] > Loading custommonsters.xml... done.
[18/09/2013 17:55:55] > Loading customspells.xml... done.
[18/09/2013 17:55:55] > Loading firstitems.xml... done.
[18/09/2013 17:55:55] > Loading highscorebook.xml... done.
[18/09/2013 17:55:55] > Loading Military Ranks.xml... done.
[18/09/2013 17:55:55] > 7 mods were loaded.
[18/09/2013 17:55:55] >> Loading map and spawns...
[18/09/2013 17:55:55] > Map size: 2048x2048.
[18/09/2013 17:55:55] > Map descriptions:
[18/09/2013 17:55:55] "Saved with Remere's Map Editor 2.1"
[18/09/2013 17:55:55] "No map description available."
[18/09/2013 17:55:55] > Map loading time: 0.037 seconds.
[18/09/2013 17:55:55] > Data parsing time: 0.001 seconds.
[18/09/2013 17:55:55] > Houses synchronization time: 0.001 seconds.
[18/09/2013 17:55:55] > Content unserialization time: 0.002 seconds.
[18/09/2013 17:55:55] >> Checking world type... PvP
[18/09/2013 17:55:55] >> Initializing game state modules and registering services...
[18/09/2013 17:55:55] mysql_real_query(): UPDATE `bans` SET `active` = 0 WHERE `expires` <= 1379519755 AND `expires` >= 0 AND `active` = 1 LIMIT 1; - MYSQL ERROR: Table 'myots.bans' doesn't exist (1146)
[18/09/2013 17:55:55] > Global address: 127.0.0.1
[18/09/2013 17:55:55] > Local ports: 7171    7172  
[18/09/2013 17:55:55] >> All modules were loaded, server is starting up...
[18/09/2013 17:55:55] >> Forgotten 8.60 server Online!

thanks! ;D I still have no idea what has just happened ^^
Click to expand...
np bro! nice to see it works :) try add this table to the database

Code: 
CREATE TABLE `bans`
(
`id` INT UNSIGNED NOT NULL auto_increment,
`type` TINYINT(1) NOT NULL COMMENT '1 - ip banishment, 2 - namelock, 3 - account banishment, 4 - notation, 5 - deletion',
`value` INT UNSIGNED NOT NULL COMMENT 'ip address (integer), player guid or account number',
`param` INT UNSIGNED NOT NULL DEFAULT 4294967295 COMMENT 'used only for ip banishment mask (integer)',
`active` TINYINT(1) NOT NULL DEFAULT TRUE,
`expires` INT NOT NULL,
`added` INT UNSIGNED NOT NULL,
`admin_id` INT UNSIGNED NOT NULL DEFAULT 0,
`comment` TEXT NOT NULL,
`reason` INT UNSIGNED NOT NULL DEFAULT 0,
`action` INT UNSIGNED NOT NULL DEFAULT 0,
`statement` VARCHAR(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `type` (`type`, `value`),
KEY `active` (`active`)
) ENGINE = InnoDB;
 
@Yamo yeah sorry I got confused there, sql host should be set to 127.0.0.1 instead of localhost. In me experience toy have to either use localhost for everything(but it causes an error in znote acc sometimes) or 127.0.0.1.

@simson361 could you do that with me to please? :) I only have a few bugs dont worry lol
 
When I use an external ip the server crashes, when I use 127.0.0.1 it works fine.

-- Connection config
ip = "127.0.0.1" <my problem is here, if I use my external ip (190.234...) the serv crashes. its works perfect with the one thats there now

Atached is the config lua saved in .txt format

I also get a mysql error but now this one is more important
 

Attachments

look you ip here and pit in in --Connection config ip = 'your ip' and you have to portforward !
 
I would give you the error message, thing is, it just crashes. And I have another server that runs on OTX for 9.60 and that does not crash when I load it with closed ports and an external ip. I'm going to try otx again, the problem is that when I use otx I get a bunch or errors with this datapack.
 
And for some odd reason, I cant see to forward my ports anymore. Dealing with TFS is the most frustrating thing I have ever done.
 
You better see this yourself, I run out of things to try. You want to try remote desktop connection?
 

Similar threads

Codinablack
Black Tek Server Pre-Release
2
Replies
33
Views
2K
Codinablack
Codinablack
chucky91
TibiaCore 7.4 TFS 1.2 same Nostalrius project.
2 3 4
Replies
75
Views
5K
johnsamir
johnsamir
Shiris undrin
[8.60] [TFS 1.2] -[Real Map full] with mount & market system
3 4 5
Replies
94
Views
12K
Zatjin
Zatjin
chucky91
TFS 8.60 with Cast System
2
Replies
32
Views
3K
Xentiss
X
E
  • Solved
TFS 0.X 8.60 0.4 MOD MYSQL THERE IS HOW TO DO IT SQLITE
Replies
13
Views
524
Enderlop
E
johnsamir
  • Question
Market system tfs 1.5 - 8.6 help debbuging
Replies
5
Views
558
johnsamir
johnsamir
Q
  • Question
TFS 1.3 Canary Tibia 13.1 No connection could be made because target.
Replies
4
Views
502
Qumora
Q
Back
Top