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

Alex Vishnev avishnev at optonline.net
Wed Mar 30 14:27:12 CEST 2005


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 at iptel.org [mailto:serusers-bounces at lists.iptel.org] On
Behalf Of Zen Kato
Sent: Tuesday, March 29, 2005 7:16 PM
To: serusers at 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 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 

_______________________________________________
Serusers mailing list
serusers at lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers





More information about the sr-users mailing list