Linux MySQL problem

[sessam]

Hi. Have a problem. Engine tfs 0.4 say more errors.

[16:46:02.622] The Forgotten Server, version 0.4_SVN ()
[16:46:02.622] Compiled with GNU C++ version 3.4.5 (mingw special) at Dec 18 2011, 02:56:58.
[16:46:02.622] A server developed by Elf, Talaturen, Stian, Slawkens, KaczooH  and Kornholijo.
[16:46:02.623] Visit our forum for updates, support and resources: http://otland.net.

[16:46:02.623] >> Loading config (config.lua)
[16:46:02.627] > Opening logs
[16:46:02.627] > Using SHA1 encryption
[16:46:02.845] >> Checking software version... running sub version, please mind it's unstable and only for testing purposes!
[16:46:02.845] > Current version information - version: 0.4_SVN, patch: 0, build: 0, timestamp: 1320861577.
[16:46:02.845] > Latest version information - version: 0.3.6, patch: 0, build: 3293, timestamp: 1260652199.
[16:46:02.845] >> Loading RSA key
Application tried to create a window, but no driver could be loaded.
Make sure that your X server is running and that $DISPLAY is set correctly.
fixme:toolhelp:CreateToolhelp32Snapshot Unimplemented: heap list snapshot
fixme:toolhelp:Heap32ListFirst : stub
[16:46:03.057] >> Starting SQL connection
[16:46:03.062] >> Running Database Manager
[16:46:03.082] > Trigger: ondelete_accounts does not exist, creating it...
[16:46:03.082] mysql_real_query(): CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON `accounts` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `type` NOT IN(1, 2) AND `value` = OLD.`id`; END; - MYSQL ERROR: Access denied; you need the SUPER privilege for this operation (1227)
[16:46:03.089] > Trigger: oncreate_guilds does not exist, creating it...
[16:46:03.090] mysql_real_query(): CREATE TRIGGER `oncreate_guilds` AFTER INSERT ON `guilds` FOR EACH ROW BEGIN INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Leader', 3, NEW.`id`); INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Vice-Leader', 2, NEW.`id`); INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Member', 1, NEW.`id`); END; - MYSQL ERROR: Access denied; you need the SUPER privilege for this operation (1227)
[16:46:03.098] > Trigger: ondelete_guilds does not exist, creating it...
[16:46:03.098] mysql_real_query(): CREATE TRIGGER `ondelete_guilds` BEFORE DELETE ON `guilds` FOR EACH ROW BEGIN UPDATE `players` SET `guildnick` = '', `rank_id` = 0 WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = OLD.`id`); END; - MYSQL ERROR: Access denied; you need the SUPER privilege for this operation (1227)
[16:46:03.105] > Trigger: oncreate_players does not exist, creating it...
[16:46:03.106] mysql_real_query(): CREATE TRIGGER `oncreate_players` AFTER INSERT ON `players` FOR EACH ROW BEGIN INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 0, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 1, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 2, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 3, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 4, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 5, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 6, 10); END; - MYSQL ERROR: Access denied; you need the SUPER privilege for this operation (1227)
[16:46:03.113] > Trigger: ondelete_players does not exist, creating it...
[16:46:03.115] mysql_real_query(): CREATE TRIGGER `ondelete_players` BEFORE DELETE ON `players` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `type` = 2 AND `value` = OLD.`id`; UPDATE `houses` SET `owner` = 0 WHERE `owner` = OLD.`id`; END; - MYSQL ERROR: Access denied; you need the SUPER privilege for this operation (1227)
[16:46:03.125] > No tables were optimized.

 

[Milice]

Create the triggers, or run TFS as SuperUser (sudo or su) if it works, i know old TFS gives you warning that it should not be run as root. But try running it as SU and if that works your problem is solved

 

[sessam]

still is a bug ;/

 

[Milice]

Just execute these querys in your database and it should be fixed:

CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON `accounts` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `type` NOT IN(1, 2) AND `value` = OLD.`id`; END;
CREATE TRIGGER `oncreate_guilds` AFTER INSERT ON `guilds` FOR EACH ROW BEGIN INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Leader', 3, NEW.`id`); INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Vice-Leader', 2, NEW.`id`); INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Member', 1, NEW.`id`); END;
CREATE TRIGGER `ondelete_guilds` BEFORE DELETE ON `guilds` FOR EACH ROW BEGIN UPDATE `players` SET `guildnick` = '', `rank_id` = 0 WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = OLD.`id`); END;CREATE TRIGGER `oncreate_players` AFTER INSERT ON `players` FOR EACH ROW BEGIN INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 0, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 1, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 2, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 3, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 4, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 5, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 6, 10); END;
CREATE TRIGGER `ondelete_players` BEFORE DELETE ON `players` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `type` = 2 AND `value` = OLD.`id`; UPDATE `houses` SET `owner` = 0 WHERE `owner` = OLD.`id`; END;

 

[elsaba]

Hmm mybe help you