Hi all. MySql password for root: Domain (realm) for the default user 'admin': 10.200.19.34 http://10.200.19.34%3E creating database openser ... ERROR 1071 (42000) at line 131: Specified key was too long; max key length is 1000 bytes Install SERWEB tables ?(y/n):
Is there anyway to solve this issue...?Have tried Latin character set too but still the same probelm. Best Regards, Arshad Mehrab Memon
What version of OpenSER are you running ? Can you see if the problem happens with the most current SVN version ?
The database table creation process has been greatly enhanced thanks to Henning and others. You should get the most current version of OpenSER and see of the error goes away.
The following MySQL command will show you the default character set for the openser database:
SHOW CREATE DATABASE openser;
The problem is that an INDEX is being created that is more than 1000 bytes in length. Many of the indexes used are a combination of columns. If the total length of ALL the columns included in the index exceeds 1000 bytes this error will be produced. You can take a look at the script you are executing to see if you can track this problem down yourself. The script is probably located in /usr/local/sbin on your system.
Regards, Norm
Memon,Arshad Mehrab wrote:
Hi all. MySql password for root: Domain (realm) for the default user 'admin': 10.200.19.34 http://10.200.19.34/ http://10.200.19.34 http://10.200.19.34/> creating database openser ... ERROR 1071 (42000) at line 131: Specified key was too long; max key length is 1000 bytes Install SERWEB tables ?(y/n):
Is there anyway to solve this issue...?Have tried Latin character set too but still the same probelm. Best Regards, Arshad Mehrab Memon
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
-
Memon,Arshad Mehrab -
Norman Brandinger