Hello,

I tried to run a freeciv server with authentication and a MySQL database under Arch Linux which uses MariaDB instead. The script setup_auth_server.sh didn't work for that. It uses two commands to create the appropriate tables (line 424 and 438):


CREATE TABLE $TABLE_USER (id int(11) NOT NULL auto_increment, name varchar(48) default NULL, password varchar(32) default NULL, email varchar(128) default NULL, createtime int(11) default NULL, accesstime int(11) default NULL, address varchar(255) default NULL, createaddress varchar(255) default NULL, logincount int(11) default '0', PRIMARY KEY (id), UNIQUE KEY name (name) ) TYPE=MyISAM;

CREATE TABLE $TABLE_LOG ( id int(11) NOT NULL auto_increment, name varchar(48) default NULL, logintime int(11) default NULL, address varchar(255) default NULL, succeed enum('S','F') default 'S', PRIMARY KEY (id) ) TYPE=MyISAM;

This doesn't work with MariaDB 5.5.33 because of 'TYPE=MyISAM' which is deprecated/removed. It also seems to be deprecated in MySQL. So even if there is no problem yet, there will probably be one in the future I guess. The correct syntax to specify the storage engine would be: 'ENGINE=MyISAM' ( http://bugs.mysql.com/bug.php?id=47974 ) I changed both lines in my setup_auth_server.sh and it works fine on my system.

I hope it's okay to send this to the mailing list since I am not sure if this is considered a bug.

Cheers, Manuel



_______________________________________________
Freeciv-dev mailing list
Freeciv-dev@gna.org
https://mail.gna.org/listinfo/freeciv-dev

Reply via email to