30 Mar
2005
30 Mar
'05
3:16 a.m.
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@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@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@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