[Serusers] PROBLEM WHIT MYSQL MODULE.HELP ME!!

[Carsten Bock]

Hi Vincenzo,

Did you compile SER yourself? If Yes, you should check, if your
mySQL-client has the same version as the mySQL-Server.
If this does not help, you should set the mySQL-Password with the
"old_password" function in mySQL. Like this:

update user set password=old_password('blabla') where user='ser';
flush priviledges;

This should help. I have never had this problem with SER, but with PHP
using compiled PHP-mySQL Packages.

Carsten

You can read more about this issue in the mySQL manual
(http://dev.mysql.com/doc/refman/5.0/en/old-client.html)

Vincenzo Golia D'Augè schrieb:
> Hi all,
> i'm trying to install SER for the first time for a job at university.
> I'm using the distribution Fedora Core 2 and I have found some problems.
> This problems come out when I load the modules for MySQL 
> support:mysql.so,auth.so,auth_db.so
> Asper having loaded this modules when i try to start SER whith the 
> command serctl start
> it appears the following error:
>
> Starting SER : PID file /var/run/ser.pid does not exist -- SER start 
> failed
>
> Checking the file log /va/log/messages I have found out that the 
> errors that I had found trying
> to start the program were the following:
>
> Mar  7 15:51:29 localhost /usr/local/sbin/ser[4288]: Maxfwd module- 
> initializing
> Mar  7 15:51:29 localhost /usr/local/sbin/ser[4288]: new_connection(): 
> Client does not support authentication protocol requested by server; 
> consider upgrading MySQL client
> Mar  7 15:51:29 localhost /usr/local/sbin/ser[4288]: db_init(): Could 
> not create a connection
> Mar  7 15:51:29 localhost /usr/local/sbin/ser[4288]: ERROR: 
> auth_db_ver: unable to open database connection
> Mar  7 15:51:29 localhost /usr/local/sbin/ser[4288]: 
> auth_db:str_fixup(): Error while querying table version
> Mar  7 15:51:29 localhost /usr/local/sbin/ser[4288]: ERROR: fix_expr : 
> fix_actions error
>
> May any of you help me,please?It is quite urgent.
> Thank you.
> Hear from you soon.
> Vincenzo
>
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
>