From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from lists.gentoo.org ([140.105.134.102] helo=robin.gentoo.org) by nuthatch.gentoo.org with esmtp (Exim 4.50) id 1EUk4E-0004Bo-5g for garchives@archives.gentoo.org; Wed, 26 Oct 2005 12:07:42 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.13.5/8.13.5) with SMTP id j9QC6vw1002954; Wed, 26 Oct 2005 12:06:57 GMT Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.206]) by robin.gentoo.org (8.13.5/8.13.5) with ESMTP id j9QC6tET032438 for ; Wed, 26 Oct 2005 12:06:56 GMT Received: by zproxy.gmail.com with SMTP id l1so112636nzf for ; Wed, 26 Oct 2005 05:06:55 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=djsvjVxIM5+uFrzmCff+qzLd++dZhDhDBKpUGe3mwO/9kA4vWf0NaOO5Shfi/W0gsr6RdmTzBqOy9PHzRDD5iZhzETPf21dRMG+YvsuKTUS84z9CYQNGLFZ4tb61WeOdG5a/HDmYItIZkf5E+/9wt+JOyvRN1S7o7Lb3Kdv42ns= Received: by 10.36.251.77 with SMTP id y77mr637464nzh; Wed, 26 Oct 2005 05:06:55 -0700 (PDT) Received: by 10.36.66.12 with HTTP; Wed, 26 Oct 2005 05:06:54 -0700 (PDT) Message-ID: Date: Wed, 26 Oct 2005 10:06:54 -0200 From: Fernando Boaglio To: gentoo-user-br@lists.gentoo.org Subject: Re: [gentoo-user-br] MySQL 4.0 -> 4.1 - problemas no PHP In-Reply-To: <200510260943.57283.fernandovaz@matrix.com.br> Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-user-br@gentoo.org Reply-to: gentoo-user-br@lists.gentoo.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_13438_7205413.1130328414802" References: <200510260943.57283.fernandovaz@matrix.com.br> X-Archives-Salt: 297c5639-3ac0-4d5f-b9f7-c5a5ca773ce2 X-Archives-Hash: 699aff3d76796b506a2e17352fca822e ------=_Part_13438_7205413.1130328414802 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Pois =E9... ontem eu notei que os meus virtual hosts n=E3o estavam funciona= ndo e ajustei. Mas rodando o info do PHP ele devolve: mysql MySQL Supportenabled Active Persistent Links 0 Active Links 0 Client API version 4.1.14 MYSQL_MODULE_TYPE external MYSQL_SOCKET /var/run/mysqld/mysqld.sock MYSQL_INCLUDE -I/usr/include/mysql MYSQL_LIBS -L/usr/lib -lmysqlclient Ent=E3o o php deveria estar funcionando, n=E3o? 2005/10/26, Fernando Garrido Vaz : > > Se o Tomcat acessa, n=E3o seria alguma coisa com o Apache, e n=E3o com o > mysql? > Lembre q na =FAltima atualiza=E7=E3o mudou bastante coisa, inclusive o lo= cal dos > arquivos de config. Tive que consertar os meus aqui... > > []s > Fernando > > On Wednesday 26 October 2005 10:56, Fernando Boaglio wrote: > > Algu=E9m j=E1 fez essa migra=E7=E3o? > > > > http://www.gentoo.org/doc/en/mysql-upgrading.xml > > http://dev.mysql.com/doc/refman/4.1/en/upgrading-from-4-0.html > > > > Parece q o Mysql 4.1 usa um mecanismo de autentica=E7=E3o diferente ago= ra, > > mas eu o update: SET PASSWORD FOR root@localhost =3D OLD_PASSWORD('senh= a') > > > > Recompilei o mod_php e outras coisas que usam o mysql. > > > > Por algum motivo o phpMyAdmin e qualquer outra coisa em PHP n=E3o > funciona. > > O phpMyAdmin reclama que n=E3o acessa o socket: > > > > #2002 - O servidor n=E3o est=E1 respondendo (ou o soquete do servidor M= ySQL > > local n=E3o est=E1 configurado corretamente) > > > > > > Mas o socket eu acesso sem problemas: > > > > mysqladmin -p --socket=3D/var/run/mysqld/mysqld.sock version > > Enter password: > > mysqladmin Ver 8.41 Distrib 4.1.14, for pc-linux-gnu on i686 > > Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB > > This software comes with ABSOLUTELY NO WARRANTY. This is free software, > > and you are welcome to modify and redistribute it under the GPL license > > > > Server version 4.1.14-log > > Protocol version 10 > > Connection Localhost via UNIX socket > > UNIX socket /var/run/mysqld/mysqld.sock > > Uptime: 21 min 5 sec > > > > Threads: 1 Questions: 1 Slow queries: 0 Opens: 11 Flush tables: 1 Open > > tables: 0 Queries per second avg: 0.001 > > > > > > Uma aplica=E7=E3o em Java com Tomcat acessa a base com sucesso. > > > > O que pode estar errado? > > -- > > []'s > > boaglio@gmail.com > > -- > gentoo-user-br@gentoo.org mailing list > > -- []'s boaglio@gmail.com ------=_Part_13438_7205413.1130328414802 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Pois =E9... ontem eu notei que os meus virtual hosts n=E3o estavam funciona= ndo e ajustei.

Mas rodando o info do PHP ele devolve:

mysql

= MySQL Supportenabl= ed
Active = Persistent Links 0
Active = Links = 0
Client = API version 4.1.14
MYSQL_M= ODULE_TYPE external
MYSQL_S= OCKET = /var/run/mysqld/mysqld.sock
MYSQL_I= NCLUDE -I/usr/include/mysql
MYSQL_L= IBS -L= /usr/lib -lmysqlclient

Ent=E3o o php deveria estar funcionando<= /span>, n=E3o?



2005/10/26, Fernando Garrido Vaz &= lt;fernandovaz@matrix.com.br>:
Se o Tomcat acessa, n=E3o seria alguma coisa com o Apache, e n=E3o com o my= sql?
Lembre q na =FAltima atualiza=E7=E3o mudou bastante coisa, inclusiv= e o local dos
arquivos de config.  Tive que consertar os meus = aqui...

[]s
Fernando

On Wednesday 26 October 2005 10:56, Fernando Boaglio wr= ote:
> Algu=E9m j=E1 fez essa migra=E7=E3o?
>
>
http://www.gentoo.org= /doc/en/mysql-upgrading.xml
> http://dev.mysql.com/doc/refman/4.1/en/upgrading-from-4-0.html=
>
> Parece q o Mysql 4.1 usa um mecanismo de autentica=E7= =E3o diferente agora,
> mas eu o update: SET PASSWORD FOR root@localhost =3D OLD_PASSWORD(= 'senha')
>
> Recompilei o mod_php e outras coisas que usam o my= sql.
>
> Por algum motivo o phpMyAdmin e qualquer outra coisa e= m PHP n=E3o funciona.
> O phpMyAdmin reclama que n=E3o acessa o socket:
>
> #2= 002 - O servidor n=E3o est=E1 respondendo (ou o soquete do servidor MySQL> local n=E3o est=E1 configurado corretamente)
>
>
>= Mas o socket eu acesso sem problemas:
>
> mysqladmin -p --socket=3D/var/run/mysqld/mysqld.sock versi= on
> Enter password:
> mysqladmin Ver 8.41 Distrib 4.1.14, for = pc-linux-gnu on i686
> Copyright (C) 2000 MySQL AB & MySQL Finlan= d AB & TCX DataKonsult AB
> This software comes with ABSOLUTELY NO WARRANTY. This is free soft= ware,
> and you are welcome to modify and redistribute it under the G= PL license
>
> Server version 4.1.14-log
> Protocol versi= on 10
> Connection Localhost via UNIX socket
> UNIX socket /var/run/= mysqld/mysqld.sock
> Uptime: 21 min 5 sec
>
> Threads: 1 = Questions: 1 Slow queries: 0 Opens: 11 Flush tables: 1 Open
> tables:= 0 Queries per second avg:=20 0.001
>
>
> Uma aplica=E7=E3o em Java com Tomcat acessa a= base com sucesso.
>
> O que pode estar errado?
> --
&= gt; []'s
> boaglio@gmail.com=

--
gentoo-user-br@gento= o.org mailing list




= --
[]'s
boaglio@gmail.com ------=_Part_13438_7205413.1130328414802-- -- gentoo-user-br@gentoo.org mailing list