[Maria-discuss] PHP 5.3 and mariadb 5.5.32 pam auth problem.
Hi All. I have: - one devel application server with php53-mysql-5.3.27-1 MariaDB-compat-5.5.32-1.x86_64 MariaDB-common-5.5.32-1.x86_64 MariaDB-shared-5.5.32-1.x86_64 MariaDB-client-5.5.32-1.x86_64 - one devel database server with MariaDB-compat-5.5.30-1.x86_64 MariaDB-server-5.5.30-1.x86_64 MariaDB-common-5.5.30-1.x86_64 MariaDB-shared-5.5.30-1.x86_64 MariaDB-client-5.5.30-1.x86_64 When I try to make a connection from devel to database server with php mysql_connect function then when I am using: - user with local authentication: connection is ok; - user with pam/ldap authentication I get error "Client does not support authentication protocol requested by server; consider upgrading MariaDB client error 1251" When I use mysql command on application server I can connect to the database server with both users, so only php does not work. Have you got similar issues? Any clues anout how to solve the problem? Best regards, Rafal Radecki.
I have a similar setup and use the following code to connect with no problems $Conn = mysqli_init(); mysqli_options($Conn, MYSQLI_INIT_COMMAND, "SET AUTOCOMMIT=1"); mysqli_options($Conn, MYSQLI_OPT_CONNECT_TIMEOUT, 5); mysqli_real_connect( $Conn, 'IP of my DBServer', $PWD, $AccessType, 'NameOfDB', MYSQLI_CLIENT_SSL ); if( mysqli_connect_errno() ) { mysqli_close( $Conn ); header( "Location: MensajeError.php?Errno=3204" ); //No puedo connect exit(); } Richard On 08/16/2013 03:42 AM, Rafał Radecki wrote:
Hi All.
I have: - one devel application server with php53-mysql-5.3.27-1 MariaDB-compat-5.5.32-1.x86_64 MariaDB-common-5.5.32-1.x86_64 MariaDB-shared-5.5.32-1.x86_64 MariaDB-client-5.5.32-1.x86_64 - one devel database server with MariaDB-compat-5.5.30-1.x86_64 MariaDB-server-5.5.30-1.x86_64 MariaDB-common-5.5.30-1.x86_64 MariaDB-shared-5.5.30-1.x86_64 MariaDB-client-5.5.30-1.x86_64 When I try to make a connection from devel to database server with php mysql_connect function then when I am using: - user with local authentication: connection is ok; - user with pam/ldap authentication I get error "Client does not support authentication protocol requested by server; consider upgrading MariaDB client error 1251" When I use mysql command on application server I can connect to the database server with both users, so only php does not work.
Have you got similar issues? Any clues anout how to solve the problem?
Best regards, Rafal Radecki.
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
-- LinuxCabal Asociación Civil Ing. Richard Couture Novell CNE, ECNE, MCNE HP/Compaq ASE Tel.: (+52) (333) 145-2638 Cel.: (+52) (044) 333 377-7505 Cel.: (+52) (044) 333 377-7506 Web: http://www.LinuxCabal.org E-Mail: rrc@linuxcabal.org Hosted en la nube Cloud Sigma - www.CloudSigma.com AVISO DE CONFIDENCIALIDAD: Este correo electrónico, incluyendo en su caso, los archivos adjuntos al mismo, pueden contener información de carácter confidencial y/o privilegiada, y se envían a la atención única y exclusivamente de la persona y/o entidad a quien va dirigido. La copia, revisión, uso, revelación y/o distribución de dicha información confidencial sin la autorización por escrito de LinuxCabal está prohibida. Si usted no es el destinatario a quien se dirige el presente correo, favor de contactar al remitente respondiendo al presente correo y eliminar el correo original incluyendo sus archivos, así como cualesquiera copia del mismo. Mediante la recepción del presente correo usted reconoce y acepta que en caso de incumplimiento de su parte y/o de sus representantes a los términos antes mencionados, LinuxCabal tendrá derecho a los daños y perjuicios que esto le cause.
participants (2)
-
Rafał Radecki
-
Richard Couture