[OpenSER-Users] OPENSER with MYSQL

[Norman Brandinger]

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 at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
>