Zen,
I also installed MySQL-server-4.1.10a-0 on my RH ES. I did not have any problems. So most likely the original problem character set. I suggest dropping ser database and re-running the shell script. 4.1.10a seems to be working fine for me and I had initial user 'admin' entered in subscriber database.
Alex
-----Original Message----- From: serusers-bounces@iptel.org [mailto:serusers-bounces@lists.iptel.org] On Behalf Of Zen Kato Sent: Tuesday, March 29, 2005 7:16 PM To: serusers@lists.iptel.org Subject: [Serusers] ser_mysql.sh on FC3(2.6.10-1.770_FC3),MySQL-server-4.1.10a-0
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
_______________________________________________ Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers