[Serusers] ser_mysql.sh on FC3(2.6.10-1.770_FC3), MySQL-server-4.1.10a-0

[Zen Kato]

Hi,

I installed MySQL-4.1.10a-0 rpms from 
http://dev.mysql.com/downloads/mysql/4.1.html
on FC3(2.6.10-1.770_FC3), ser-0.8.14 source from CVS(3/29/05).

When I created 'ser_mysql.sh' the following error came out;

[root at m5n zenkato]# ser_mysql.sh create
MySql password for root:
creating database ser ...
ERROR 1071 (42000) at line 91: Specified key was too long; max key length is 1000 bytes

[root at m5n sbin]# mysql -u ser -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 4.1.10a-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use ser
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+-----------------+
| Tables_in_ser   |
+-----------------+
| acc             |
| active_sessions |
| version         |
+-----------------+
3 rows in set (0.00 sec)

I found same errors on;
http://bugs.mysql.com/bug.php?id=4541
MySQL Bugs: #4541: "Specified key was too long; max key length is 1000 bytes" with utf8

http://forum.mamboserver.com/showthread.php?t=24624

so, I added 'DEFAULT CHARACTER SET latin1' on /usr/local/sbin/ser_mysql.sh
as follows;

#
# Table structure versions
#

CREATE TABLE version (
   table_name varchar(64) NOT NULL,
   version smallint(5) DEFAULT '0' NOT NULL
) $TABLE_TYPE, DEFAULT CHARACTER SET latin1;

.....snip.......

#
# Table structure for table 'subscriber' -- user database
#


CREATE TABLE subscriber (

...... snip ...

) $TABLE_TYPE, DEFAULT CHARACTER SET latin1;

# hook-table for all posssible future config values
# (currently unused)

..... snip .......

And then did;
ser_mysql.sh reinstall

[root at m5n CVS]# mysql -u ser -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 4.1.10a-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use ser
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+-----------------------+
| Tables_in_ser         |
+-----------------------+
| acc                   |
| active_sessions       |
| aliases               |
| config                |
| domain                |
| event                 |
| grp                   |
| location              |
| missed_calls          |
| pending               |
| phonebook             |
| preferences           |
| reserved              |
| server_monitoring     |
| server_monitoring_agg |
| silo                  |
| subscriber            |
| uri                   |
| version               |
+-----------------------+
19 rows in set (0.00 sec)

mysql> select * from subscriber;
Empty set (0.03 sec)

mysql>

Initial records were Empty, 'admin' was not created.
Should I down grade to MySQL-4.0?

Regards,

Zen