DBI errors for Authentication protocol and old

DBI errors for Authentication protocol and old_password segfaults

am 27.03.2008 15:08:16 von peter.musolino

------_=_NextPart_001_01C89014.006BDCCA
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,
I have been working on a problem relating to Request Tracker. I have been =
scouring the web for answers to questions, but instead of answers, I just g=
et new questions.
A bit about the environment, the modules, and the app:

RHEL 4.0 Update 6
Apache 2.0.52-38
MySQL-client-standard 5.0.24a-0
MySQL-devel-standard-5.0.24a-0
MySQL-server-standard-5.0.24a-0
MySQL-shared-compat-5.0.24a-0
mod_perl 2.0.1
DBD::mysql 4.006
DBI 1.604
RT 3.6.6
DBIx::SearchBuilder-1.51

We were first getting the following error in the apache error logs:

DBI connect('dbname=3Drt3;host=3Dlocalhost','rt',...) failed: Client does n=
ot support authentication protocol requested by server; consider upgrading =
MySQL client at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm=
line 106
[Wed Mar 26 09:47:11 2008] [error] [client 10.20.1.102] Connect Failed Clie=
nt does not support authentication protocol requested by server; consider u=
pgrading MySQL client\n at /opt/rt3/lib/RT.pm line 220\n

I checked and there would be no reason that the DBD::mysql would not be usi=
ng anything but the latest mysql client libraries, so I am not sure why it =
is still trying to use the older protocol and choking on the new long passw=
ord scheme. So I took the second of the more suggested routes and changed =
the password of that user with the old_password method. Instead of that er=
ror, I started to get segfaults.

[Tue Mar 25 12:26:40 2008] [notice] child pid 25271 exit signal Segmentatio=
n fault (11)

There were no errors in the mysql err logs nor the system logs.

I decided to do an strace against the running apache process and saw the fo=
llowing:

connect(1, {sa_family=3DAF_FILE, path=3D"/var/lib/mysql/mysql.sock"}, 110) =
=3D 0
setsockopt(1, SOL_IP, IP_TOS, [8], 4) =3D -1 EOPNOTSUPP (Operation not su=
pported)
setsockopt(1, SOL_SOCKET, SO_KEEPALIVE, [1], 4) =3D 0
read(1, ">\0\0\0", 4) =3D 4
read(1, "\n5.0.24a-standard\0\304\224\0\0-gCVdwJK\0,"..., 62) =3D 62
open("/usr/share/mysql/charsets/Index", O_RDONLY|O_LARGEFILE) =3D -1 ENOENT=
(No such file or directory)
write(1, "\24\0\0\1\217 \0\0\0rt\0P[XJIQKK\0rt3", 24) =3D 24
read(1, "\5\0\0\2", 4) =3D 4
read(1, "\0\0\0\2\0", 5) =3D 5
fcntl64(1, F_SETFL, O_RDWR|O_NONBLOCK) =3D 0
read(1, 0xc0977b8, 8192) =3D -1 EAGAIN (Resource temporarily=
unavailable)
fcntl64(1, F_SETFL, O_RDWR) =3D 0
write(1, "\21\0\0\0\3set autocommit=3D1", 21) =3D 21
read(1, "\5\0\0\1", 4) =3D 4
read(1, "\0\0\0\2\0", 5) =3D 5
time(NULL) =3D 1206447319
time(NULL) =3D 1206447319
--- SIGSEGV (Segmentation fault) @ 0 (0) ---
chdir("/etc/httpd") =3D 0
rt_sigaction(SIGSEGV, {SIG_DFL}, {SIG_DFL}, 8) =3D 0
kill(5043, SIGSEGV) =3D 0
sigreturn() =3D ? (mask now [])
--- SIGSEGV (Segmentation fault) @ 0 (0) ---
Process 5043 detached

The Index error is for missing files which can be found in mysql 3.0. I co=
pied the Index files and relevant .conf files into the charsets directory a=
nd the Index error and replaced with=20

open("/usr/share/mysql/charsets/Index", O_RDONLY|O_LARGEFILE) =3D 36
fstat64(36, {st_mode=3DS_IFREG|0755, st_size=3D549, ...}) =3D 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) =
=3D 0xb7e63000
read(36, "# sql/share/charsets/Index\n#\n# T"..., 4096) =3D 549
read(36, "", 4096) =3D 0
close(36) =3D 0
munmap(0xb7e63000, 4096) =3D 0

However the segfault still remains.

I also ran an strace against mysql and got a similar error.

fcntl64(12, F_SETFL, O_RDWR|O_NONBLOCK) =3D 0
accept(12, {sa_family=3DAF_FILE, path=3D"ï¿½ï¿½
n"}, [2]) =3D 18
fcntl64(12, F_SETFL, O_RDWR) =3D 0
getsockname(18, {sa_family=3DAF_FILE, path=3D"/var/lib/mysql"}, [28]) =3D 0
fcntl64(18, F_SETFL, O_RDONLY) =3D 0
fcntl64(18, F_GETFL) =3D 0x2 (flags O_RDWR)
fcntl64(18, F_SETFL, O_RDWR|O_NONBLOCK) =3D 0
setsockopt(18, SOL_IP, IP_TOS, [8], 4) =3D -1 EOPNOTSUPP (Operation not su=
pported)
time(NULL) =3D 1206613476
clone(child_stack=3D0xb16b24c4, flags=3DCLONE_VM|CLONE_FS|CLONE_FILES|CLONE=
_SIGHAND|CLONE_THREAD|CLONE_SYSVSEM|CLONE_SETTLS|CLONE_PAREN T_SETTID|CLONE_=
CHILD_CLEARTID|CLONE_DETACHED, parent_tidptr=3D0xb16b2be8, {entry_number:6,=
base_addr:0xb16b2ba0, limit:1048575, seg_32bit:1, contents:0, read_exec_on=
ly:0, limit_in_pages:1, seg_not_present:0, useable:1}, child_tidptr=3D0xb16=
b2be8) =3D 13994
select(13, [10 12], NULL, NULL, NULL

I am fresh out of ideas. Can anyone assist? I have posted to the RT list =
have not yet received any response and given roots in mysql and DBI, I thou=
ght this would be appropriate

Thanks in advance,

Peter Musolino
DB. Zwirn (UK) Ltd.
peter.musolino a t dbzco.com

This e-mail message is intended only for the named recipient(s) above. It =
may contain confidential information. If you are not the intended recipien=
t, you are hereby noti
fied that any use, dissemination, distribution or copying of this e-mail an=
d any attachment(s) is strictly prohibited. D.B. Zwirn & Co., L.P. reserve=
s the right to archive
and monitor all e-mail communications through its networks. If you have r=
eceived this e-mail in error, please immediately notify the sender by reply=
ing to this e-mail and
delete the message and any attachment(s) from your system. Thank you.

------_=_NextPart_001_01C89014.006BDCCA--

Re: DBI errors for Authentication protocol and old_password segfaults

am 27.03.2008 22:27:29 von Patrick Galbraith

Is there any way you could write a simple DBI perl script to connect to
the db, select something out of a table, etc.. That way you could
isolate it a bit more, and if there's anything wrong with the driver, I
can look at it.

Musolino, Peter wrote:

>Hi,
>I have been working on a problem relating to Request Tracker. I have been scouring the web for answers to questions, but instead of answers, I just get new questions.
>A bit about the environment, the modules, and the app:
>
>RHEL 4.0 Update 6
>Apache 2.0.52-38
>MySQL-client-standard 5.0.24a-0
>MySQL-devel-standard-5.0.24a-0
>MySQL-server-standard-5.0.24a-0
>MySQL-shared-compat-5.0.24a-0
>mod_perl 2.0.1
>DBD::mysql 4.006
>DBI 1.604
>RT 3.6.6
>DBIx::SearchBuilder-1.51
>
>We were first getting the following error in the apache error logs:
>
>DBI connect('dbname=rt3;host=localhost','rt',...) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 106
>[Wed Mar 26 09:47:11 2008] [error] [client 10.20.1.102] Connect Failed Client does not support authentication protocol requested by server; consider upgrading MySQL client\n at /opt/rt3/lib/RT.pm line 220\n
>
>I checked and there would be no reason that the DBD::mysql would not be using anything but the latest mysql client libraries, so I am not sure why it is still trying to use the older protocol and choking on the new long password scheme. So I took the second of the more suggested routes and changed the password of that user with the old_password method. Instead of that error, I started to get segfaults.
>
>[Tue Mar 25 12:26:40 2008] [notice] child pid 25271 exit signal Segmentation fault (11)
>
>There were no errors in the mysql err logs nor the system logs.
>
>I decided to do an strace against the running apache process and saw the following:
>
>connect(1, {sa_family=AF_FILE, path="/var/lib/mysql/mysql.sock"}, 110) = 0
>setsockopt(1, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)
>setsockopt(1, SOL_SOCKET, SO_KEEPALIVE, [1], 4) = 0
>read(1, ">\0\0\0", 4) = 4
>read(1, "\n5.0.24a-standard\0\304\224\0\0-gCVdwJK\0,"..., 62) = 62
>open("/usr/share/mysql/charsets/Index", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory)
>write(1, "\24\0\0\1\217 \0\0\0rt\0P[XJIQKK\0rt3", 24) = 24
>read(1, "\5\0\0\2", 4) = 4
>read(1, "\0\0\0\2\0", 5) = 5
>fcntl64(1, F_SETFL, O_RDWR|O_NONBLOCK) = 0
>read(1, 0xc0977b8, 8192) = -1 EAGAIN (Resource temporarily unavailable)
>fcntl64(1, F_SETFL, O_RDWR) = 0
>write(1, "\21\0\0\0\3set autocommit=1", 21) = 21
>read(1, "\5\0\0\1", 4) = 4
>read(1, "\0\0\0\2\0", 5) = 5
>time(NULL) = 1206447319
>time(NULL) = 1206447319
>--- SIGSEGV (Segmentation fault) @ 0 (0) ---
>chdir("/etc/httpd") = 0
>rt_sigaction(SIGSEGV, {SIG_DFL}, {SIG_DFL}, 8) = 0
>kill(5043, SIGSEGV) = 0
>sigreturn() = ? (mask now [])
>--- SIGSEGV (Segmentation fault) @ 0 (0) ---
>Process 5043 detached
>
>The Index error is for missing files which can be found in mysql 3.0. I copied the Index files and relevant .conf files into the charsets directory and the Index error and replaced with
>
>open("/usr/share/mysql/charsets/Index", O_RDONLY|O_LARGEFILE) = 36
>fstat64(36, {st_mode=S_IFREG|0755, st_size=549, ...}) = 0
>mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0xb7e63000
>read(36, "# sql/share/charsets/Index\n#\n# T"..., 4096) = 549
>read(36, "", 4096) = 0
>close(36) = 0
>munmap(0xb7e63000, 4096) = 0
>
>However the segfault still remains.
>
>I also ran an strace against mysql and got a similar error.
>
>fcntl64(12, F_SETFL, O_RDWR|O_NONBLOCK) = 0
>accept(12, {sa_family=AF_FILE, path="ï¿½ï¿½
> n"}, [2]) = 18
>fcntl64(12, F_SETFL, O_RDWR) = 0
>getsockname(18, {sa_family=AF_FILE, path="/var/lib/mysql"}, [28]) = 0
>fcntl64(18, F_SETFL, O_RDONLY) = 0
>fcntl64(18, F_GETFL) = 0x2 (flags O_RDWR)
>fcntl64(18, F_SETFL, O_RDWR|O_NONBLOCK) = 0
>setsockopt(18, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)
>time(NULL) = 1206613476
>clone(child_stack=0xb16b24c4, flags=CLONE_VM|CLONE_FS|CLONE_FILES|CLONE_SIGHAND|CLONE_THRE AD|CLONE_SYSVSEM|CLONE_SETTLS|CLONE_PARENT_SETTID|CLONE_CHIL D_CLEARTID|CLONE_DETACHED, parent_tidptr=0xb16b2be8, {entry_number:6, base_addr:0xb16b2ba0, limit:1048575, seg_32bit:1, contents:0, read_exec_only:0, limit_in_pages:1, seg_not_present:0, useable:1}, child_tidptr=0xb16b2be8) = 13994
>select(13, [10 12], NULL, NULL, NULL
>
>I am fresh out of ideas. Can anyone assist? I have posted to the RT list have not yet received any response and given roots in mysql and DBI, I thought this would be appropriate
>
>Thanks in advance,
>
>Peter Musolino
>D.B. Zwirn (UK) Ltd.
>peter.musolino a t dbzco.com
>
>
>
>
>
>This e-mail message is intended only for the named recipient(s) above. It may contain confidential information. If you are not the intended recipient, you are hereby noti
>fied that any use, dissemination, distribution or copying of this e-mail and any attachment(s) is strictly prohibited. D.B. Zwirn & Co., L.P. reserves the right to archive
> and monitor all e-mail communications through its networks. If you have received this e-mail in error, please immediately notify the sender by replying to this e-mail and
> delete the message and any attachment(s) from your system. Thank you.
>
>
>

--
Patrick Galbraith, Senior Programmer
Grazr - Easy feed grazing and sharing
http://www.grazr.com

Satyam Eva Jayate - Truth Alone Triumphs
Mundaka Upanishad

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: DBI errors for Authentication protocol and old_password segfaults

am 27.03.2008 22:45:03 von peter.musolino

------_=_NextPart_001_01C89053.D0752B92
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: base64

V2l0aCB0aGUgYXV0aGVudGljYXRpb24gcHJvdG9jb2wgZXJyb3IsIHRoZSBy dCBzY3JpcHQgY2Fs
bHMgYSBkYml4OjpzZWFyY2hidWlsZGVyOjpoYW5kbGUgb2JqZWN0IHdoaWNo IGluIHR1cm4gcnVu
cyBhICRkYmgtPmNvbm5lY3Qgd2hpY2ggdGhyb3dzIHRoZSBhdXRoIGVycm9y LiAgSWYgSSBydW4g
cGVybCBhdCB0aGUgY2xpIGFuZCBkbyBhIGRiaCBjb25uZWN0IGRvaW5nIHRo ZSBkaG4gYW5kIHBs
YWluIHRleHQgdXNlcm5hbWUgYW5kIHBhc3N3b3JkLCBpdCBkb2Vzbid0IHRo cm93IGFueSBlcnJv
cnMgb24gdGhlIGNvbm5lY3Rpb24uDQoNCkkgaGF2ZSBub3QgdHJpZWQgc2V0 dGluZyB1cCBhIHF1
ZXJ5IHdpdGggaXQuICBJIHNoYWxsIGdpdmUgaXQgYSBnbyBhbmQgcG9zdCB0 aGUgb3V0Y29tZSB0
b21vcnJvdy4NCg0KQ2hlZXJzLA0KDQpQZXRlcg0KLS0gDQoNClBldGVyIE11 c29saW5vDQpELkIu
IFp3aXJuICYgQ28uLCBMUA0KNTIgQ29uZHVpdCBTdC4gM3JkIEZsb29yDQpM b25kb24sIFcxUyAy
WVoNClVuaXRlZCBLaW5nZG9tDQpQaG9uZTogKzQ0ICgwKSAyMDcgMjIwIDIz MjINCkNlbGw6ICs0
NCAoMCkgNzc5IDUxMCAyMDQ1DQoNCi0tLS0tIE9yaWdpbmFsIE1lc3NhZ2Ug LS0tLS0NCkZyb206
IFBhdHJpY2sgR2FsYnJhaXRoIDxwYXRnQGdyYXpyLmNvbT4NClRvOiBNdXNv bGlubywgUGV0ZXIN
CkNjOiBwZXJsQGxpc3RzLm15c3FsLmNvbSA8cGVybEBsaXN0cy5teXNxbC5j b20+DQpTZW50OiBU
aHUgTWFyIDI3IDIxOjI3OjI5IDIwMDgNClN1YmplY3Q6IFJlOiBEQkkgZXJy b3JzIGZvciBBdXRo
ZW50aWNhdGlvbiBwcm90b2NvbCBhbmQgb2xkX3Bhc3N3b3JkIHNlZ2ZhdWx0 cw0KDQpJcyB0aGVy
ZSBhbnkgd2F5IHlvdSBjb3VsZCB3cml0ZSBhIHNpbXBsZSBEQkkgcGVybCBz Y3JpcHQgdG8gY29u
bmVjdCB0byANCnRoZSBkYiwgc2VsZWN0IHNvbWV0aGluZyBvdXQgb2YgYSB0 YWJsZSwgZXRjLi4g
VGhhdCB3YXkgeW91IGNvdWxkIA0KaXNvbGF0ZSBpdCBhIGJpdCBtb3JlLCBh bmQgaWYgdGhlcmUn
cyBhbnl0aGluZyB3cm9uZyB3aXRoIHRoZSBkcml2ZXIsIEkgDQpjYW4gbG9v ayBhdCBpdC4NCg0K
TXVzb2xpbm8sIFBldGVyIHdyb3RlOg0KDQo+SGksDQo+SSBoYXZlIGJlZW4g d29ya2luZyBvbiBh
IHByb2JsZW0gcmVsYXRpbmcgdG8gUmVxdWVzdCBUcmFja2VyLiAgSSBoYXZl IGJlZW4gc2NvdXJp
bmcgdGhlIHdlYiBmb3IgYW5zd2VycyB0byBxdWVzdGlvbnMsIGJ1dCBpbnN0 ZWFkIG9mIGFuc3dl
cnMsIEkganVzdCBnZXQgbmV3IHF1ZXN0aW9ucy4NCj5BIGJpdCBhYm91dCB0 aGUgZW52aXJvbm1l
bnQsIHRoZSBtb2R1bGVzLCBhbmQgdGhlIGFwcDoNCj4NCj5SSEVMIDQuMCBV cGRhdGUgNg0KPkFw
YWNoZSAyLjAuNTItMzgNCj5NeVNRTC1jbGllbnQtc3RhbmRhcmQgNS4wLjI0 YS0wDQo+TXlTUUwt
ZGV2ZWwtc3RhbmRhcmQtNS4wLjI0YS0wDQo+TXlTUUwtc2VydmVyLXN0YW5k YXJkLTUuMC4yNGEt
MA0KPk15U1FMLXNoYXJlZC1jb21wYXQtNS4wLjI0YS0wDQo+bW9kX3Blcmwg Mi4wLjENCj5EQkQ6
Om15c3FsIDQuMDA2DQo+REJJIDEuNjA0DQo+UlQgMy42LjYNCj5EQkl4OjpT ZWFyY2hCdWlsZGVy
LTEuNTENCj4NCj5XZSB3ZXJlIGZpcnN0IGdldHRpbmcgdGhlIGZvbGxvd2lu ZyBlcnJvciBpbiB0
aGUgYXBhY2hlIGVycm9yIGxvZ3M6DQo+DQo+REJJIGNvbm5lY3QoJ2RibmFt ZT1ydDM7aG9zdD1s
b2NhbGhvc3QnLCdydCcsLi4uKSBmYWlsZWQ6IENsaWVudCBkb2VzIG5vdCBz dXBwb3J0IGF1dGhl
bnRpY2F0aW9uIHByb3RvY29sIHJlcXVlc3RlZCBieSBzZXJ2ZXI7IGNvbnNp ZGVyIHVwZ3JhZGlu
ZyBNeVNRTCBjbGllbnQgYXQgL3Vzci9saWIvcGVybDUvc2l0ZV9wZXJsLzUu OC41L0RCSXgvU2Vh
cmNoQnVpbGRlci9IYW5kbGUucG0gbGluZSAxMDYNCj5bV2VkIE1hciAyNiAw OTo0NzoxMSAyMDA4
XSBbZXJyb3JdIFtjbGllbnQgMTAuMjAuMS4xMDJdIENvbm5lY3QgRmFpbGVk IENsaWVudCBkb2Vz
IG5vdCBzdXBwb3J0IGF1dGhlbnRpY2F0aW9uIHByb3RvY29sIHJlcXVlc3Rl ZCBieSBzZXJ2ZXI7
IGNvbnNpZGVyIHVwZ3JhZGluZyBNeVNRTCBjbGllbnRcbiBhdCAvb3B0L3J0 My9saWIvUlQucG0g
bGluZSAyMjBcbg0KPg0KPkkgY2hlY2tlZCBhbmQgdGhlcmUgd291bGQgYmUg bm8gcmVhc29uIHRo
YXQgdGhlIERCRDo6bXlzcWwgd291bGQgbm90IGJlIHVzaW5nIGFueXRoaW5n IGJ1dCB0aGUgbGF0
ZXN0IG15c3FsIGNsaWVudCBsaWJyYXJpZXMsIHNvIEkgYW0gbm90IHN1cmUg d2h5IGl0IGlzIHN0
aWxsIHRyeWluZyB0byB1c2UgdGhlIG9sZGVyIHByb3RvY29sIGFuZCBjaG9r aW5nIG9uIHRoZSBu
ZXcgbG9uZyBwYXNzd29yZCBzY2hlbWUuICBTbyBJIHRvb2sgdGhlIHNlY29u ZCBvZiB0aGUgbW9y
ZSBzdWdnZXN0ZWQgcm91dGVzIGFuZCBjaGFuZ2VkIHRoZSBwYXNzd29yZCBv ZiB0aGF0IHVzZXIg
d2l0aCB0aGUgb2xkX3Bhc3N3b3JkIG1ldGhvZC4gIEluc3RlYWQgb2YgdGhh dCBlcnJvciwgSSBz
dGFydGVkIHRvIGdldCBzZWdmYXVsdHMuDQo+DQo+W1R1ZSBNYXIgMjUgMTI6 MjY6NDAgMjAwOF0g
W25vdGljZV0gY2hpbGQgcGlkIDI1MjcxIGV4aXQgc2lnbmFsIFNlZ21lbnRh dGlvbiBmYXVsdCAo
MTEpDQo+DQo+VGhlcmUgd2VyZSBubyBlcnJvcnMgaW4gdGhlIG15c3FsIGVy ciBsb2dzIG5vciB0
aGUgc3lzdGVtIGxvZ3MuDQo+DQo+SSBkZWNpZGVkIHRvIGRvIGFuIHN0cmFj ZSBhZ2FpbnN0IHRo
ZSBydW5uaW5nIGFwYWNoZSBwcm9jZXNzIGFuZCBzYXcgdGhlIGZvbGxvd2lu ZzoNCj4NCj5jb25u
ZWN0KDEsIHtzYV9mYW1pbHk9QUZfRklMRSwgcGF0aD0iL3Zhci9saWIvbXlz cWwvbXlzcWwuc29j
ayJ9LCAxMTApID0gMA0KPnNldHNvY2tvcHQoMSwgU09MX0lQLCBJUF9UT1Ms IFs4XSwgNCkgICA9
IC0xIEVPUE5PVFNVUFAgKE9wZXJhdGlvbiBub3Qgc3VwcG9ydGVkKQ0KPnNl dHNvY2tvcHQoMSwg
U09MX1NPQ0tFVCwgU09fS0VFUEFMSVZFLCBbMV0sIDQpID0gMA0KPnJlYWQo MSwgIj5cMFwwXDAi
LCA0KSAgICAgICAgICAgICAgICAgICA9IDQNCj5yZWFkKDEsICJcbjUuMC4y NGEtc3RhbmRhcmRc
MFwzMDRcMjI0XDBcMC1nQ1Zkd0pLXDAsIi4uLiwgNjIpID0gNjINCj5vcGVu KCIvdXNyL3NoYXJl
L215c3FsL2NoYXJzZXRzL0luZGV4IiwgT19SRE9OTFl8T19MQVJHRUZJTEUp ID0gLTEgRU5PRU5U
IChObyBzdWNoIGZpbGUgb3IgZGlyZWN0b3J5KQ0KPndyaXRlKDEsICJcMjRc MFwwXDFcMjE3IFww
XDBcMHJ0XDBQW1hKSVFLS1wwcnQzIiwgMjQpID0gMjQNCj5yZWFkKDEsICJc NVwwXDBcMiIsIDQp
ICAgICAgICAgICAgICAgICAgPSA0DQo+cmVhZCgxLCAiXDBcMFwwXDJcMCIs IDUpICAgICAgICAg
ICAgICAgID0gNQ0KPmZjbnRsNjQoMSwgRl9TRVRGTCwgT19SRFdSfE9fTk9O QkxPQ0spICA9IDAN
Cj5yZWFkKDEsIDB4YzA5NzdiOCwgODE5MikgICAgICAgICAgICAgICAgPSAt MSBFQUdBSU4gKFJl
c291cmNlIHRlbXBvcmFyaWx5IHVuYXZhaWxhYmxlKQ0KPmZjbnRsNjQoMSwg Rl9TRVRGTCwgT19S
RFdSKSAgICAgICAgICAgICA9IDANCj53cml0ZSgxLCAiXDIxXDBcMFwwXDNz ZXQgYXV0b2NvbW1p
dD0xIiwgMjEpID0gMjENCj5yZWFkKDEsICJcNVwwXDBcMSIsIDQpICAgICAg ICAgICAgICAgICAg
PSA0DQo+cmVhZCgxLCAiXDBcMFwwXDJcMCIsIDUpICAgICAgICAgICAgICAg ID0gNQ0KPnRpbWUo
TlVMTCkgICAgICAgICAgICAgICAgICAgICAgICAgICAgICA9IDEyMDY0NDcz MTkNCj50aW1lKE5V
TEwpICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgPSAxMjA2NDQ3MzE5 DQo+LS0tIFNJR1NF
R1YgKFNlZ21lbnRhdGlvbiBmYXVsdCkgQCAwICgwKSAtLS0NCj5jaGRpcigi L2V0Yy9odHRwZCIp
ICAgICAgICAgICAgICAgICAgICAgPSAwDQo+cnRfc2lnYWN0aW9uKFNJR1NF R1YsIHtTSUdfREZM
fSwge1NJR19ERkx9LCA4KSA9IDANCj5raWxsKDUwNDMsIFNJR1NFR1YpICAg ICAgICAgICAgICAg
ICAgICAgPSAwDQo+c2lncmV0dXJuKCkgICAgICAgICAgICAgICAgICAgICAg ICAgICAgID0gPyAo
bWFzayBub3cgW10pDQo+LS0tIFNJR1NFR1YgKFNlZ21lbnRhdGlvbiBmYXVs dCkgQCAwICgwKSAt
LS0NCj5Qcm9jZXNzIDUwNDMgZGV0YWNoZWQNCj4NCj5UaGUgSW5kZXggZXJy b3IgaXMgZm9yIG1p
c3NpbmcgZmlsZXMgd2hpY2ggY2FuIGJlIGZvdW5kIGluIG15c3FsIDMuMC4g IEkgY29waWVkIHRo
ZSBJbmRleCBmaWxlcyBhbmQgcmVsZXZhbnQgLmNvbmYgZmlsZXMgaW50byB0 aGUgY2hhcnNldHMg
ZGlyZWN0b3J5IGFuZCB0aGUgSW5kZXggZXJyb3IgYW5kIHJlcGxhY2VkIHdp dGggDQo+DQo+b3Bl
bigiL3Vzci9zaGFyZS9teXNxbC9jaGFyc2V0cy9JbmRleCIsIE9fUkRPTkxZ fE9fTEFSR0VGSUxF
KSA9IDM2DQo+ZnN0YXQ2NCgzNiwge3N0X21vZGU9U19JRlJFR3wwNzU1LCBz dF9zaXplPTU0OSwg
Li4ufSkgPSAwDQo+bW1hcDIoTlVMTCwgNDA5NiwgUFJPVF9SRUFEfFBST1Rf V1JJVEUsIE1BUF9Q
UklWQVRFfE1BUF9BTk9OWU1PVVMsIC0xLCAwKSA9IDB4YjdlNjMwMDANCj5y ZWFkKDM2LCAiIyBz
cWwvc2hhcmUvY2hhcnNldHMvSW5kZXhcbiNcbiMgVCIuLi4sIDQwOTYpID0g NTQ5DQo+cmVhZCgz
NiwgIiIsIDQwOTYpICAgICAgICAgICAgICAgICAgICAgID0gMA0KPmNsb3Nl KDM2KSAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICA9IDANCj5tdW5tYXAoMHhiN2U2MzAw MCwgNDA5NikgICAg
ICAgICAgICAgICAgPSAwDQo+DQo+SG93ZXZlciB0aGUgc2VnZmF1bHQgc3Rp bGwgcmVtYWlucy4N
Cj4NCj5JIGFsc28gcmFuIGFuIHN0cmFjZSBhZ2FpbnN0IG15c3FsIGFuZCBn b3QgYSBzaW1pbGFy
IGVycm9yLg0KPg0KPmZjbnRsNjQoMTIsIEZfU0VURkwsIE9fUkRXUnxPX05P TkJMT0NLKSA9IDAN
Cj5hY2NlcHQoMTIsIHtzYV9mYW1pbHk9QUZfRklMRSwgcGF0aD0iw6/Cv8K9 w6/Cv8K9DQo+IG4i
fSwgWzJdKSA9IDE4DQo+ZmNudGw2NCgxMiwgRl9TRVRGTCwgT19SRFdSKSAg ICAgICAgICAgID0g
MA0KPmdldHNvY2tuYW1lKDE4LCB7c2FfZmFtaWx5PUFGX0ZJTEUsIHBhdGg9 Ii92YXIvbGliL215
c3FsIn0sIFsyOF0pID0gMA0KPmZjbnRsNjQoMTgsIEZfU0VURkwsIE9fUkRP TkxZKSAgICAgICAg
ICA9IDANCj5mY250bDY0KDE4LCBGX0dFVEZMKSAgICAgICAgICAgICAgICAg ICAgPSAweDIgKGZs
YWdzIE9fUkRXUikNCj5mY250bDY0KDE4LCBGX1NFVEZMLCBPX1JEV1J8T19O T05CTE9DSykgPSAw
DQo+c2V0c29ja29wdCgxOCwgU09MX0lQLCBJUF9UT1MsIFs4XSwgNCkgID0g LTEgRU9QTk9UU1VQ
UCAoT3BlcmF0aW9uIG5vdCBzdXBwb3J0ZWQpDQo+dGltZShOVUxMKSAgICAg ICAgICAgICAgICAg
ICAgICAgICAgICAgID0gMTIwNjYxMzQ3Ng0KPmNsb25lKGNoaWxkX3N0YWNr PTB4YjE2YjI0YzQs
IGZsYWdzPUNMT05FX1ZNfENMT05FX0ZTfENMT05FX0ZJTEVTfENMT05FX1NJ R0hBTkR8Q0xPTkVf
VEhSRUFEfENMT05FX1NZU1ZTRU18Q0xPTkVfU0VUVExTfENMT05FX1BBUkVO VF9TRVRUSUR8Q0xP
TkVfQ0hJTERfQ0xFQVJUSUR8Q0xPTkVfREVUQUNIRUQsIHBhcmVudF90aWRw dHI9MHhiMTZiMmJl
OCwge2VudHJ5X251bWJlcjo2LCBiYXNlX2FkZHI6MHhiMTZiMmJhMCwgbGlt aXQ6MTA0ODU3NSwg
c2VnXzMyYml0OjEsIGNvbnRlbnRzOjAsIHJlYWRfZXhlY19vbmx5OjAsIGxp bWl0X2luX3BhZ2Vz
OjEsIHNlZ19ub3RfcHJlc2VudDowLCB1c2VhYmxlOjF9LCBjaGlsZF90aWRw dHI9MHhiMTZiMmJl
OCkgPSAxMzk5NA0KPnNlbGVjdCgxMywgWzEwIDEyXSwgTlVMTCwgTlVMTCwg TlVMTCA8dW5maW5p
c2hlZCAuLi4+DQo+DQo+SSBhbSBmcmVzaCBvdXQgb2YgaWRlYXMuICBDYW4g YW55b25lIGFzc2lz
dD8gIEkgaGF2ZSBwb3N0ZWQgdG8gdGhlIFJUIGxpc3QgaGF2ZSBub3QgeWV0 IHJlY2VpdmVkIGFu
eSByZXNwb25zZSBhbmQgZ2l2ZW4gcm9vdHMgaW4gbXlzcWwgYW5kIERCSSwg SSB0aG91Z2h0IHRo
aXMgd291bGQgYmUgYXBwcm9wcmlhdGUNCj4NCj5UaGFua3MgaW4gYWR2YW5j ZSwNCj4NCj5QZXRl
ciBNdXNvbGlubw0KPkQuQi4gWndpcm4gKFVLKSBMdGQuDQo+cGV0ZXIubXVz b2xpbm8gYSB0IGRi
emNvLmNvbQ0KPg0KPg0KPg0KPg0KPg0KPlRoaXMgZS1tYWlsIG1lc3NhZ2Ug aXMgaW50ZW5kZWQg
b25seSBmb3IgdGhlIG5hbWVkIHJlY2lwaWVudChzKSBhYm92ZS4gIEl0IG1h eSBjb250YWluIGNv
bmZpZGVudGlhbCBpbmZvcm1hdGlvbi4gIElmIHlvdSBhcmUgbm90IHRoZSBp bnRlbmRlZCByZWNp
cGllbnQsIHlvdSBhcmUgaGVyZWJ5IG5vdGkNCj5maWVkIHRoYXQgYW55IHVz ZSwgZGlzc2VtaW5h
dGlvbiwgZGlzdHJpYnV0aW9uIG9yIGNvcHlpbmcgb2YgdGhpcyBlLW1haWwg YW5kIGFueSBhdHRh
Y2htZW50KHMpIGlzIHN0cmljdGx5IHByb2hpYml0ZWQuICBELkIuIFp3aXJu ICYgQ28uLCBMLlAu
IHJlc2VydmVzIHRoZSByaWdodCB0byBhcmNoaXZlDQo+IGFuZCBtb25pdG9y IGFsbCBlLW1haWwg
Y29tbXVuaWNhdGlvbnMgdGhyb3VnaCBpdHMgbmV0d29ya3MuICBJZiB5b3Ug aGF2ZSByZWNlaXZl
ZCB0aGlzIGUtbWFpbCBpbiBlcnJvciwgcGxlYXNlIGltbWVkaWF0ZWx5IG5v dGlmeSB0aGUgc2Vu
ZGVyIGJ5IHJlcGx5aW5nIHRvIHRoaXMgZS1tYWlsIGFuZA0KPiBkZWxldGUg dGhlIG1lc3NhZ2Ug
YW5kIGFueSBhdHRhY2htZW50KHMpIGZyb20geW91ciBzeXN0ZW0uICBUaGFu ayB5b3UuDQo+DQo+
ICANCj4NCg0KDQotLSANClBhdHJpY2sgR2FsYnJhaXRoLCBTZW5pb3IgUHJv Z3JhbW1lciANCkdy
YXpyIC0gRWFzeSBmZWVkIGdyYXppbmcgYW5kIHNoYXJpbmcNCmh0dHA6Ly93 d3cuZ3JhenIuY29t
IA0KDQpTYXR5YW0gRXZhIEpheWF0ZSAtIFRydXRoIEFsb25lIFRyaXVtcGhz DQpNdW5kYWthIFVw
YW5pc2hhZA0KDQoNCgoKClRoaXMgZS1tYWlsIG1lc3NhZ2UgaXMgaW50ZW5k ZWQgb25seSBmb3Ig
dGhlIG5hbWVkIHJlY2lwaWVudChzKSBhYm92ZS4gIEl0IG1heSBjb250YWlu IGNvbmZpZGVudGlh
bCBpbmZvcm1hdGlvbi4gIElmIHlvdSBhcmUgbm90IHRoZSBpbnRlbmRlZCBy ZWNpcGllbnQsIHlv
dSBhcmUgaGVyZWJ5IG5vdGkKZmllZCB0aGF0IGFueSB1c2UsIGRpc3NlbWlu YXRpb24sIGRpc3Ry
aWJ1dGlvbiBvciBjb3B5aW5nIG9mIHRoaXMgZS1tYWlsIGFuZCBhbnkgYXR0 YWNobWVudChzKSBp
cyBzdHJpY3RseSBwcm9oaWJpdGVkLiAgRC5CLiBad2lybiAmIENvLiwgTC5Q LiByZXNlcnZlcyB0
aGUgcmlnaHQgdG8gYXJjaGl2ZQogYW5kIG1vbml0b3IgYWxsIGUtbWFpbCBj b21tdW5pY2F0aW9u
cyB0aHJvdWdoIGl0cyBuZXR3b3Jrcy4gIElmIHlvdSBoYXZlIHJlY2VpdmVk IHRoaXMgZS1tYWls
IGluIGVycm9yLCBwbGVhc2UgaW1tZWRpYXRlbHkgbm90aWZ5IHRoZSBzZW5k ZXIgYnkgcmVwbHlp
bmcgdG8gdGhpcyBlLW1haWwgYW5kCiBkZWxldGUgdGhlIG1lc3NhZ2UgYW5k IGFueSBhdHRhY2ht
ZW50KHMpIGZyb20geW91ciBzeXN0ZW0uICBUaGFuayB5b3UuCg==

------_=_NextPart_001_01C89053.D0752B92--

RE: DBI errors for Authentication protocol and old_password segfaults

am 28.03.2008 15:02:36 von peter.musolino

I did some normal queries and selecting out of the table is fine. =20
One of the last things it does before the segfault is: =20
write(1, "\21\0\0\0\3set autocommit=3D1", 21) =3D 21

I have been looking around a bit more and I am wondering if it is related t=
o this old bug here:
http://bugs.mysql.com/bug.php?id=3D24244

I never actually see that message about autocommit not being supported in a=
ny of my stack traces or log files though.

-----Original Message-----
From: Patrick Galbraith [mailto:patg@grazr.com]=20
Sent: 27 March 2008 21:27
To: Musolino, Peter
Cc: perl@lists.mysql.com
Subject: Re: DBI errors for Authentication protocol and old_password segfau=
lts

Is there any way you could write a simple DBI perl script to connect to=20
the db, select something out of a table, etc.. That way you could=20
isolate it a bit more, and if there's anything wrong with the driver, I=20
can look at it.

Musolino, Peter wrote:

>Hi,
>I have been working on a problem relating to Request Tracker. I have been=
scouring the web for answers to questions, but instead of answers, I just =
get new questions.
>A bit about the environment, the modules, and the app:
>
>RHEL 4.0 Update 6
>Apache 2.0.52-38
>MySQL-client-standard 5.0.24a-0
>MySQL-devel-standard-5.0.24a-0
>MySQL-server-standard-5.0.24a-0
>MySQL-shared-compat-5.0.24a-0
>mod_perl 2.0.1
>DBD::mysql 4.006
>DBI 1.604
>RT 3.6.6
>DBIx::SearchBuilder-1.51
>
>We were first getting the following error in the apache error logs:
>
>DBI connect('dbname=3Drt3;host=3Dlocalhost','rt',...) failed: Client does =
not support authentication protocol requested by server; consider upgrading=
MySQL client at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.p=
m line 106
>[Wed Mar 26 09:47:11 2008] [error] [client 10.20.1.102] Connect Failed Cli=
ent does not support authentication protocol requested by server; consider =
upgrading MySQL client\n at /opt/rt3/lib/RT.pm line 220\n
>
>I checked and there would be no reason that the DBD::mysql would not be us=
ing anything but the latest mysql client libraries, so I am not sure why it=
is still trying to use the older protocol and choking on the new long pass=
word scheme. So I took the second of the more suggested routes and changed=
the password of that user with the old_password method. Instead of that e=
rror, I started to get segfaults.
>
>[Tue Mar 25 12:26:40 2008] [notice] child pid 25271 exit signal Segmentati=
on fault (11)
>
>There were no errors in the mysql err logs nor the system logs.
>
>I decided to do an strace against the running apache process and saw the f=
ollowing:
>
>connect(1, {sa_family=3DAF_FILE, path=3D"/var/lib/mysql/mysql.sock"}, 110)=
=3D 0
>setsockopt(1, SOL_IP, IP_TOS, [8], 4) =3D -1 EOPNOTSUPP (Operation not s=
upported)
>setsockopt(1, SOL_SOCKET, SO_KEEPALIVE, [1], 4) =3D 0
>read(1, ">\0\0\0", 4) =3D 4
>read(1, "\n5.0.24a-standard\0\304\224\0\0-gCVdwJK\0,"..., 62) =3D 62
>open("/usr/share/mysql/charsets/Index", O_RDONLY|O_LARGEFILE) =3D -1 ENOEN=
T (No such file or directory)
>write(1, "\24\0\0\1\217 \0\0\0rt\0P[XJIQKK\0rt3", 24) =3D 24
>read(1, "\5\0\0\2", 4) =3D 4
>read(1, "\0\0\0\2\0", 5) =3D 5
>fcntl64(1, F_SETFL, O_RDWR|O_NONBLOCK) =3D 0
>read(1, 0xc0977b8, 8192) =3D -1 EAGAIN (Resource temporaril=
y unavailable)
>fcntl64(1, F_SETFL, O_RDWR) =3D 0
>write(1, "\21\0\0\0\3set autocommit=3D1", 21) =3D 21
>read(1, "\5\0\0\1", 4) =3D 4
>read(1, "\0\0\0\2\0", 5) =3D 5
>time(NULL) =3D 1206447319
>time(NULL) =3D 1206447319
>--- SIGSEGV (Segmentation fault) @ 0 (0) ---
>chdir("/etc/httpd") =3D 0
>rt_sigaction(SIGSEGV, {SIG_DFL}, {SIG_DFL}, 8) =3D 0
>kill(5043, SIGSEGV) =3D 0
>sigreturn() =3D ? (mask now [])
>--- SIGSEGV (Segmentation fault) @ 0 (0) ---
>Process 5043 detached
>
>The Index error is for missing files which can be found in mysql 3.0. I c=
opied the Index files and relevant .conf files into the charsets directory =
and the Index error and replaced with=20
>
>open("/usr/share/mysql/charsets/Index", O_RDONLY|O_LARGEFILE) =3D 36
>fstat64(36, {st_mode=3DS_IFREG|0755, st_size=3D549, ...}) =3D 0
>mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) =
=3D 0xb7e63000
>read(36, "# sql/share/charsets/Index\n#\n# T"..., 4096) =3D 549
>read(36, "", 4096) =3D 0
>close(36) =3D 0
>munmap(0xb7e63000, 4096) =3D 0
>
>However the segfault still remains.
>
>I also ran an strace against mysql and got a similar error.
>
>fcntl64(12, F_SETFL, O_RDWR|O_NONBLOCK) =3D 0
>accept(12, {sa_family=3DAF_FILE, path=3D"ï¿½ï¿½
> n"}, [2]) =3D 18
>fcntl64(12, F_SETFL, O_RDWR) =3D 0
>getsockname(18, {sa_family=3DAF_FILE, path=3D"/var/lib/mysql"}, [28]) =3D 0
>fcntl64(18, F_SETFL, O_RDONLY) =3D 0
>fcntl64(18, F_GETFL) =3D 0x2 (flags O_RDWR)
>fcntl64(18, F_SETFL, O_RDWR|O_NONBLOCK) =3D 0
>setsockopt(18, SOL_IP, IP_TOS, [8], 4) =3D -1 EOPNOTSUPP (Operation not s=
upported)
>time(NULL) =3D 1206613476
>clone(child_stack=3D0xb16b24c4, flags=3DCLONE_VM|CLONE_FS|CLONE_FILES|CLON=
E_SIGHAND|CLONE_THREAD|CLONE_SYSVSEM|CLONE_SETTLS|CLONE_PARE NT_SETTID|CLONE=
_CHILD_CLEARTID|CLONE_DETACHED, parent_tidptr=3D0xb16b2be8, {entry_number:6=
, base_addr:0xb16b2ba0, limit:1048575, seg_32bit:1, contents:0, read_exec_o=
nly:0, limit_in_pages:1, seg_not_present:0, useable:1}, child_tidptr=3D0xb1=
6b2be8) =3D 13994
>select(13, [10 12], NULL, NULL, NULL
>
>I am fresh out of ideas. Can anyone assist? I have posted to the RT list=
have not yet received any response and given roots in mysql and DBI, I tho=
ught this would be appropriate
>
>Thanks in advance,
>
>Peter Musolino
>D.B. Zwirn (UK) Ltd.
>peter.musolino a t dbzco.com
>
>
>
>
>
>This e-mail message is intended only for the named recipient(s) above. It=
may contain confidential information. If you are not the intended recipie=
nt, you are hereby noti
>fied that any use, dissemination, distribution or copying of this e-mail a=
nd any attachment(s) is strictly prohibited. D.B. Zwirn & Co., L.P. reserv=
es the right to archive
> and monitor all e-mail communications through its networks. If you have =
received this e-mail in error, please immediately notify the sender by repl=
ying to this e-mail and
> delete the message and any attachment(s) from your system. Thank you.
>
> =20
>

--=20
Patrick Galbraith, Senior Programmer=20
Grazr - Easy feed grazing and sharing
http://www.grazr.com=20

Satyam Eva Jayate - Truth Alone Triumphs
Mundaka Upanishad

This e-mail message is intended only for the named recipient(s) above. It =
may contain confidential information. If you are not the intended recipien=
t, you are hereby noti
fied that any use, dissemination, distribution or copying of this e-mail an=
d any attachment(s) is strictly prohibited. D.B. Zwirn & Co., L.P. reserve=
s the right to archive
and monitor all e-mail communications through its networks. If you have r=
eceived this e-mail in error, please immediately notify the sender by reply=
ing to this e-mail and
delete the message and any attachment(s) from your system. Thank you.

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=3Dgcdmp-msql-mysql-modules @m.gmane.org

Re: DBI errors for Authentication protocol and old_password segfaults

am 28.03.2008 15:39:01 von Patrick Galbraith

even if it's not supported, it shouldn't crash it - it's just a database
call from client to server that either passes or fails. What if you run
that command in the mysql client?

Musolino, Peter wrote:

>I did some normal queries and selecting out of the table is fine.
>One of the last things it does before the segfault is:
>write(1, "\21\0\0\0\3set autocommit=1", 21) = 21
>
>I have been looking around a bit more and I am wondering if it is related to this old bug here:
>http://bugs.mysql.com/bug.php?id=24244
>
>I never actually see that message about autocommit not being supported in any of my stack traces or log files though.
>
>-----Original Message-----
>From: Patrick Galbraith [mailto:patg@grazr.com]
>Sent: 27 March 2008 21:27
>To: Musolino, Peter
>Cc: perl@lists.mysql.com
>Subject: Re: DBI errors for Authentication protocol and old_password segfaults
>
>Is there any way you could write a simple DBI perl script to connect to
>the db, select something out of a table, etc.. That way you could
>isolate it a bit more, and if there's anything wrong with the driver, I
>can look at it.
>
>Musolino, Peter wrote:
>
>
>
>>Hi,
>>I have been working on a problem relating to Request Tracker. I have been scouring the web for answers to questions, but instead of answers, I just get new questions.
>>A bit about the environment, the modules, and the app:
>>
>>RHEL 4.0 Update 6
>>Apache 2.0.52-38
>>MySQL-client-standard 5.0.24a-0
>>MySQL-devel-standard-5.0.24a-0
>>MySQL-server-standard-5.0.24a-0
>>MySQL-shared-compat-5.0.24a-0
>>mod_perl 2.0.1
>>DBD::mysql 4.006
>>DBI 1.604
>>RT 3.6.6
>>DBIx::SearchBuilder-1.51
>>
>>We were first getting the following error in the apache error logs:
>>
>>DBI connect('dbname=rt3;host=localhost','rt',...) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 106
>>[Wed Mar 26 09:47:11 2008] [error] [client 10.20.1.102] Connect Failed Client does not support authentication protocol requested by server; consider upgrading MySQL client\n at /opt/rt3/lib/RT.pm line 220\n
>>
>>I checked and there would be no reason that the DBD::mysql would not be using anything but the latest mysql client libraries, so I am not sure why it is still trying to use the older protocol and choking on the new long password scheme. So I took the second of the more suggested routes and changed the password of that user with the old_password method. Instead of that error, I started to get segfaults.
>>
>>[Tue Mar 25 12:26:40 2008] [notice] child pid 25271 exit signal Segmentation fault (11)
>>
>>There were no errors in the mysql err logs nor the system logs.
>>
>>I decided to do an strace against the running apache process and saw the following:
>>
>>connect(1, {sa_family=AF_FILE, path="/var/lib/mysql/mysql.sock"}, 110) = 0
>>setsockopt(1, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)
>>setsockopt(1, SOL_SOCKET, SO_KEEPALIVE, [1], 4) = 0
>>read(1, ">\0\0\0", 4) = 4
>>read(1, "\n5.0.24a-standard\0\304\224\0\0-gCVdwJK\0,"..., 62) = 62
>>open("/usr/share/mysql/charsets/Index", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory)
>>write(1, "\24\0\0\1\217 \0\0\0rt\0P[XJIQKK\0rt3", 24) = 24
>>read(1, "\5\0\0\2", 4) = 4
>>read(1, "\0\0\0\2\0", 5) = 5
>>fcntl64(1, F_SETFL, O_RDWR|O_NONBLOCK) = 0
>>read(1, 0xc0977b8, 8192) = -1 EAGAIN (Resource temporarily unavailable)
>>fcntl64(1, F_SETFL, O_RDWR) = 0
>>write(1, "\21\0\0\0\3set autocommit=1", 21) = 21
>>read(1, "\5\0\0\1", 4) = 4
>>read(1, "\0\0\0\2\0", 5) = 5
>>time(NULL) = 1206447319
>>time(NULL) = 1206447319
>>--- SIGSEGV (Segmentation fault) @ 0 (0) ---
>>chdir("/etc/httpd") = 0
>>rt_sigaction(SIGSEGV, {SIG_DFL}, {SIG_DFL}, 8) = 0
>>kill(5043, SIGSEGV) = 0
>>sigreturn() = ? (mask now [])
>>--- SIGSEGV (Segmentation fault) @ 0 (0) ---
>>Process 5043 detached
>>
>>The Index error is for missing files which can be found in mysql 3.0. I copied the Index files and relevant .conf files into the charsets directory and the Index error and replaced with
>>
>>open("/usr/share/mysql/charsets/Index", O_RDONLY|O_LARGEFILE) = 36
>>fstat64(36, {st_mode=S_IFREG|0755, st_size=549, ...}) = 0
>>mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0xb7e63000
>>read(36, "# sql/share/charsets/Index\n#\n# T"..., 4096) = 549
>>read(36, "", 4096) = 0
>>close(36) = 0
>>munmap(0xb7e63000, 4096) = 0
>>
>>However the segfault still remains.
>>
>>I also ran an strace against mysql and got a similar error.
>>
>>fcntl64(12, F_SETFL, O_RDWR|O_NONBLOCK) = 0
>>accept(12, {sa_family=AF_FILE, path="ï¿½ï¿½
>>n"}, [2]) = 18
>>fcntl64(12, F_SETFL, O_RDWR) = 0
>>getsockname(18, {sa_family=AF_FILE, path="/var/lib/mysql"}, [28]) = 0
>>fcntl64(18, F_SETFL, O_RDONLY) = 0
>>fcntl64(18, F_GETFL) = 0x2 (flags O_RDWR)
>>fcntl64(18, F_SETFL, O_RDWR|O_NONBLOCK) = 0
>>setsockopt(18, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)
>>time(NULL) = 1206613476
>>clone(child_stack=0xb16b24c4, flags=CLONE_VM|CLONE_FS|CLONE_FILES|CLONE_SIGHAND|CLONE_THRE AD|CLONE_SYSVSEM|CLONE_SETTLS|CLONE_PARENT_SETTID|CLONE_CHIL D_CLEARTID|CLONE_DETACHED, parent_tidptr=0xb16b2be8, {entry_number:6, base_addr:0xb16b2ba0, limit:1048575, seg_32bit:1, contents:0, read_exec_only:0, limit_in_pages:1, seg_not_present:0, useable:1}, child_tidptr=0xb16b2be8) = 13994
>>select(13, [10 12], NULL, NULL, NULL
>>
>>I am fresh out of ideas. Can anyone assist? I have posted to the RT list have not yet received any response and given roots in mysql and DBI, I thought this would be appropriate
>>
>>Thanks in advance,
>>
>>Peter Musolino
>>D.B. Zwirn (UK) Ltd.
>>peter.musolino a t dbzco.com
>>
>>
>>
>>
>>
>>This e-mail message is intended only for the named recipient(s) above. It may contain confidential information. If you are not the intended recipient, you are hereby noti
>>fied that any use, dissemination, distribution or copying of this e-mail and any attachment(s) is strictly prohibited. D.B. Zwirn & Co., L.P. reserves the right to archive
>>and monitor all e-mail communications through its networks. If you have received this e-mail in error, please immediately notify the sender by replying to this e-mail and
>>delete the message and any attachment(s) from your system. Thank you.
>>
>>
>>
>>
>>
>
>
>
>

--
Patrick Galbraith, Senior Programmer
Grazr - Easy feed grazing and sharing
http://www.grazr.com

Satyam Eva Jayate - Truth Alone Triumphs
Mundaka Upanishad

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

RE: DBI errors for Authentication protocol and old_password segfaults

am 28.03.2008 17:37:55 von peter.musolino

Running set autocommit=3D1 from the client runs fine.
mysql> set autocommit=3D1;
Query OK, 0 rows affected (0.00 sec)=20

I cannot tell from regular strace of httpd where the call to the script is =
going wrong. I am attempting to attach some debugging to the fastcgi scrip=
t to see if I can get look at a more granular level as to where the break i=
s happening.

-----Original Message-----
From: Patrick Galbraith [mailto:patg@grazr.com]=20
Sent: 28 March 2008 14:39
To: Musolino, Peter
Cc: perl@lists.mysql.com
Subject: Re: DBI errors for Authentication protocol and old_password segfau=
lts

even if it's not supported, it shouldn't crash it - it's just a database=20
call from client to server that either passes or fails. What if you run=20
that command in the mysql client?

Musolino, Peter wrote:

>I did some normal queries and selecting out of the table is fine. =20
>One of the last things it does before the segfault is: =20
>write(1, "\21\0\0\0\3set autocommit=3D1", 21) =3D 21
>
>I have been looking around a bit more and I am wondering if it is related =
to this old bug here:
>http://bugs.mysql.com/bug.php?id=3D24244
>
>I never actually see that message about autocommit not being supported in =
any of my stack traces or log files though.
>
>-----Original Message-----
>From: Patrick Galbraith [mailto:patg@grazr.com]=20
>Sent: 27 March 2008 21:27
>To: Musolino, Peter
>Cc: perl@lists.mysql.com
>Subject: Re: DBI errors for Authentication protocol and old_password segfa=
ults
>
>Is there any way you could write a simple DBI perl script to connect to=20
>the db, select something out of a table, etc.. That way you could=20
>isolate it a bit more, and if there's anything wrong with the driver, I=20
>can look at it.
>
>Musolino, Peter wrote:
>
> =20
>
>>Hi,
>>I have been working on a problem relating to Request Tracker. I have bee=
n scouring the web for answers to questions, but instead of answers, I just=
get new questions.
>>A bit about the environment, the modules, and the app:
>>
>>RHEL 4.0 Update 6
>>Apache 2.0.52-38
>>MySQL-client-standard 5.0.24a-0
>>MySQL-devel-standard-5.0.24a-0
>>MySQL-server-standard-5.0.24a-0
>>MySQL-shared-compat-5.0.24a-0
>>mod_perl 2.0.1
>>DBD::mysql 4.006
>>DBI 1.604
>>RT 3.6.6
>>DBIx::SearchBuilder-1.51
>>
>>We were first getting the following error in the apache error logs:
>>
>>DBI connect('dbname=3Drt3;host=3Dlocalhost','rt',...) failed: Client does=
not support authentication protocol requested by server; consider upgradin=
g MySQL client at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.=
pm line 106
>>[Wed Mar 26 09:47:11 2008] [error] [client 10.20.1.102] Connect Failed Cl=
ient does not support authentication protocol requested by server; consider=
upgrading MySQL client\n at /opt/rt3/lib/RT.pm line 220\n
>>
>>I checked and there would be no reason that the DBD::mysql would not be u=
sing anything but the latest mysql client libraries, so I am not sure why i=
t is still trying to use the older protocol and choking on the new long pas=
sword scheme. So I took the second of the more suggested routes and change=
d the password of that user with the old_password method. Instead of that =
error, I started to get segfaults.
>>
>>[Tue Mar 25 12:26:40 2008] [notice] child pid 25271 exit signal Segmentat=
ion fault (11)
>>
>>There were no errors in the mysql err logs nor the system logs.
>>
>>I decided to do an strace against the running apache process and saw the =
following:
>>
>>connect(1, {sa_family=3DAF_FILE, path=3D"/var/lib/mysql/mysql.sock"}, 110=
) =3D 0
>>setsockopt(1, SOL_IP, IP_TOS, [8], 4) =3D -1 EOPNOTSUPP (Operation not =
supported)
>>setsockopt(1, SOL_SOCKET, SO_KEEPALIVE, [1], 4) =3D 0
>>read(1, ">\0\0\0", 4) =3D 4
>>read(1, "\n5.0.24a-standard\0\304\224\0\0-gCVdwJK\0,"..., 62) =3D 62
>>open("/usr/share/mysql/charsets/Index", O_RDONLY|O_LARGEFILE) =3D -1 ENOE=
NT (No such file or directory)
>>write(1, "\24\0\0\1\217 \0\0\0rt\0P[XJIQKK\0rt3", 24) =3D 24
>>read(1, "\5\0\0\2", 4) =3D 4
>>read(1, "\0\0\0\2\0", 5) =3D 5
>>fcntl64(1, F_SETFL, O_RDWR|O_NONBLOCK) =3D 0
>>read(1, 0xc0977b8, 8192) =3D -1 EAGAIN (Resource temporari=
ly unavailable)
>>fcntl64(1, F_SETFL, O_RDWR) =3D 0
>>write(1, "\21\0\0\0\3set autocommit=3D1", 21) =3D 21
>>read(1, "\5\0\0\1", 4) =3D 4
>>read(1, "\0\0\0\2\0", 5) =3D 5
>>time(NULL) =3D 1206447319
>>time(NULL) =3D 1206447319
>>--- SIGSEGV (Segmentation fault) @ 0 (0) ---
>>chdir("/etc/httpd") =3D 0
>>rt_sigaction(SIGSEGV, {SIG_DFL}, {SIG_DFL}, 8) =3D 0
>>kill(5043, SIGSEGV) =3D 0
>>sigreturn() =3D ? (mask now [])
>>--- SIGSEGV (Segmentation fault) @ 0 (0) ---
>>Process 5043 detached
>>
>>The Index error is for missing files which can be found in mysql 3.0. I =
copied the Index files and relevant .conf files into the charsets directory=
and the Index error and replaced with=20
>>
>>open("/usr/share/mysql/charsets/Index", O_RDONLY|O_LARGEFILE) =3D 36
>>fstat64(36, {st_mode=3DS_IFREG|0755, st_size=3D549, ...}) =3D 0
>>mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0)=
=3D 0xb7e63000
>>read(36, "# sql/share/charsets/Index\n#\n# T"..., 4096) =3D 549
>>read(36, "", 4096) =3D 0
>>close(36) =3D 0
>>munmap(0xb7e63000, 4096) =3D 0
>>
>>However the segfault still remains.
>>
>>I also ran an strace against mysql and got a similar error.
>>
>>fcntl64(12, F_SETFL, O_RDWR|O_NONBLOCK) =3D 0
>>accept(12, {sa_family=3DAF_FILE, path=3D"ï¿½ï¿½
>>n"}, [2]) =3D 18
>>fcntl64(12, F_SETFL, O_RDWR) =3D 0
>>getsockname(18, {sa_family=3DAF_FILE, path=3D"/var/lib/mysql"}, [28]) =3D=
0
>>fcntl64(18, F_SETFL, O_RDONLY) =3D 0
>>fcntl64(18, F_GETFL) =3D 0x2 (flags O_RDWR)
>>fcntl64(18, F_SETFL, O_RDWR|O_NONBLOCK) =3D 0
>>setsockopt(18, SOL_IP, IP_TOS, [8], 4) =3D -1 EOPNOTSUPP (Operation not =
supported)
>>time(NULL) =3D 1206613476
>>clone(child_stack=3D0xb16b24c4, flags=3DCLONE_VM|CLONE_FS|CLONE_FILES|CLO=
NE_SIGHAND|CLONE_THREAD|CLONE_SYSVSEM|CLONE_SETTLS|CLONE_PAR ENT_SETTID|CLON=
E_CHILD_CLEARTID|CLONE_DETACHED, parent_tidptr=3D0xb16b2be8, {entry_number:=
6, base_addr:0xb16b2ba0, limit:1048575, seg_32bit:1, contents:0, read_exec_=
only:0, limit_in_pages:1, seg_not_present:0, useable:1}, child_tidptr=3D0xb=
16b2be8) =3D 13994
>>select(13, [10 12], NULL, NULL, NULL
>>
>>I am fresh out of ideas. Can anyone assist? I have posted to the RT lis=
t have not yet received any response and given roots in mysql and DBI, I th=
ought this would be appropriate
>>
>>Thanks in advance,
>>
>>Peter Musolino
>>D.B. Zwirn (UK) Ltd.
>>peter.musolino a t dbzco.com
>>
>>
>>
>>
>>
>>This e-mail message is intended only for the named recipient(s) above. I=
t may contain confidential information. If you are not the intended recipi=
ent, you are hereby noti
>>fied that any use, dissemination, distribution or copying of this e-mail =
and any attachment(s) is strictly prohibited. D.B. Zwirn & Co., L.P. reser=
ves the right to archive
>>and monitor all e-mail communications through its networks. If you have =
received this e-mail in error, please immediately notify the sender by repl=
ying to this e-mail and
>>delete the message and any attachment(s) from your system. Thank you.
>>
>>=20
>>
>> =20
>>
>
>
> =20
>

--=20
Patrick Galbraith, Senior Programmer=20
Grazr - Easy feed grazing and sharing
http://www.grazr.com=20

Satyam Eva Jayate - Truth Alone Triumphs
Mundaka Upanishad

This e-mail message is intended only for the named recipient(s) above. It =
may contain confidential information. If you are not the intended recipien=
t, you are hereby noti
fied that any use, dissemination, distribution or copying of this e-mail an=
d any attachment(s) is strictly prohibited. D.B. Zwirn & Co., L.P. reserve=
s the right to archive
and monitor all e-mail communications through its networks. If you have r=
eceived this e-mail in error, please immediately notify the sender by reply=
ing to this e-mail and
delete the message and any attachment(s) from your system. Thank you.

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=3Dgcdmp-msql-mysql-modules @m.gmane.org

RE: DBI errors for Authentication protocol and old_password segfaults

am 28.03.2008 19:24:09 von peter.musolino

I have turned DBI debugging to 2. Here is the output into httpd/error_log

-> DBI->connect(dbi:mysql:dbname=3Drt3;host=3Dlocalhost, rt, ****)
-> DBI->install_driver(mysql) for linux perl=3D5.008005 pid=3D21022 rui=
d=3D48 euid=3D48
install_driver: DBD::mysql version 4.006 loaded from /usr/lib/perl5/=
site_perl/5.8.5/i386-linux-thread-multi/DBD/mysql.pm
<- install_driver=3D DBI::dr=3DHASH(0xc4c97a0)
!! warn: 0 CLEARED by call to connect method
-> connect for DBD::mysql::dr (DBI::dr=3DHASH(0xc4c97a0)~0xc4c97e8 'dbn=
ame=3Drt3;host=3Dlocalhost' 'rt' ****) thr#b47cee0
imp_dbh->connect: dsn =3D dbname=3Drt3;host=3Dlocalhost, uid =3D rt, pwd =
=3D xxxxxxxxxxx
imp_dbh->my_login : dbname =3D rt3, uid =3D rt, pwd =3D xxxxxxxxxxxx,host =
=3D localhost, port =3D NULL
imp_dbh->mysql_dr_connect: host =3D |localhost|, port =3D 0, uid =3D rt, pw=
d =3D xxxxxxxxxxxx
imp_dbh->use_server_side_prepare: 0
imp_dbh->mysql_dr_connect: client_flags =3D 2
imp_dbh->mysql_dr_connect: <- -> STORE for DBD::mysql::db (DBI::db=3DHAS=
H(0xc4cb7f4)~INNER 'mysql_auto_reconnect' 1) thr#b47cee0
<- STORE=3D 1 at mysql.pm line 145
<- connect=3D DBI::db=3DHASH(0xc4cb8c0) at DBI.pm line 637
-> STORE for DBD::mysql::db (DBI::db=3DHASH(0xc4cb7f4)~INNER 'PrintErro=
r' 1) thr#b47cee0
<- STORE=3D 1 at DBI.pm line 689
-> STORE for DBD::mysql::db (DBI::db=3DHASH(0xc4cb7f4)~INNER 'AutoCommi=
t' 1) thr#b47cee0
<- STORE=3D 1 at DBI.pm line 689
-> STORE for DBD::mysql::db (DBI::db=3DHASH(0xc4cb7f4)~INNER 'Username'=
'rt') thr#b47cee0
<- STORE=3D 1 at DBI.pm line 692
<> FETCH=3D 'rt' ('Username' from cache) at DBI.pm line 692
-> connected in DBD::_::db for DBD::mysql::db (DBI::db=3DHASH(0xc4cb8c0=
)~0xc4cb7f4 'dbi:mysql:dbname=3Drt3;host=3Dlocalhost' 'rt' 'xxxxxxxxxxxx') =
thr#b47cee0
<- connected=3D undef at DBI.pm line 698
<- connect=3D DBI::db=3DHASH(0xc4cb8c0)
-> STORE for DBD::mysql::db (DBI::db=3DHASH(0xc4cb7f4)~INNER 'dbi_conne=
ct_closure' CODE(0xc4c7318)) thr#b47cee0
<- STORE=3D 1 at DBI.pm line 707
-> STORE for DBD::mysql::db (DBI::db=3DHASH(0xc4cb7f4)~INNER 'FetchHash=
KeyName' 'NAME_lc') thr#b47cee0
<- STORE=3D 1 at Handle.pm line 110
-> STORE for DBD::mysql::db (DBI::db=3DHASH(0xc4cb7f4)~INNER 'LongReadL=
en' 10000000) thr#b47cee0
<- STORE=3D 1 at Handle.pm line 104
-> prepare for DBD::mysql::db (DBI::db=3DHASH(0xc4cb8c0)~0xc4cb7f4 'SEL=
ECT * FROM Users WHERE Name =3D ?') thr#b47cee0
-> dbd_st_prepare MYSQL_VERSION_ID 50024, SQL statement: SELECT * =
FROM Users WHERE Name =3D ?
>- dbd_st_free_result_sets
<- dbd_st_free_result_sets RC -1
[Fri Mar 28 13:55:43 2008] [notice] child pid 21022 exit signal Segmentatio=
n fault (11)

-----Original Message-----
From: Musolino, Peter [mailto:peter.musolino@dbzco.com]=20
Sent: 28 March 2008 16:38
To: Patrick Galbraith
Cc: perl@lists.mysql.com
Subject: RE: DBI errors for Authentication protocol and old_password segfau=
lts

Running set autocommit=3D1 from the client runs fine.
mysql> set autocommit=3D1;
Query OK, 0 rows affected (0.00 sec)=20

I cannot tell from regular strace of httpd where the call to the script is =
going wrong. I am attempting to attach some debugging to the fastcgi scrip=
t to see if I can get look at a more granular level as to where the break i=
s happening.

-----Original Message-----
From: Patrick Galbraith [mailto:patg@grazr.com]=20
Sent: 28 March 2008 14:39
To: Musolino, Peter
Cc: perl@lists.mysql.com
Subject: Re: DBI errors for Authentication protocol and old_password segfau=
lts

even if it's not supported, it shouldn't crash it - it's just a database=20
call from client to server that either passes or fails. What if you run=20
that command in the mysql client?

Musolino, Peter wrote:

>I did some normal queries and selecting out of the table is fine. =20
>One of the last things it does before the segfault is: =20
>write(1, "\21\0\0\0\3set autocommit=3D1", 21) =3D 21
>
>I have been looking around a bit more and I am wondering if it is related =
to this old bug here:
>http://bugs.mysql.com/bug.php?id=3D24244
>
>I never actually see that message about autocommit not being supported in =
any of my stack traces or log files though.
>
>-----Original Message-----
>From: Patrick Galbraith [mailto:patg@grazr.com]=20
>Sent: 27 March 2008 21:27
>To: Musolino, Peter
>Cc: perl@lists.mysql.com
>Subject: Re: DBI errors for Authentication protocol and old_password segfa=
ults
>
>Is there any way you could write a simple DBI perl script to connect to=20
>the db, select something out of a table, etc.. That way you could=20
>isolate it a bit more, and if there's anything wrong with the driver, I=20
>can look at it.
>
>Musolino, Peter wrote:
>
> =20
>
>>Hi,
>>I have been working on a problem relating to Request Tracker. I have bee=
n scouring the web for answers to questions, but instead of answers, I just=
get new questions.
>>A bit about the environment, the modules, and the app:
>>
>>RHEL 4.0 Update 6
>>Apache 2.0.52-38
>>MySQL-client-standard 5.0.24a-0
>>MySQL-devel-standard-5.0.24a-0
>>MySQL-server-standard-5.0.24a-0
>>MySQL-shared-compat-5.0.24a-0
>>mod_perl 2.0.1
>>DBD::mysql 4.006
>>DBI 1.604
>>RT 3.6.6
>>DBIx::SearchBuilder-1.51
>>
>>We were first getting the following error in the apache error logs:
>>
>>DBI connect('dbname=3Drt3;host=3Dlocalhost','rt',...) failed: Client does=
not support authentication protocol requested by server; consider upgradin=
g MySQL client at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.=
pm line 106
>>[Wed Mar 26 09:47:11 2008] [error] [client 10.20.1.102] Connect Failed Cl=
ient does not support authentication protocol requested by server; consider=
upgrading MySQL client\n at /opt/rt3/lib/RT.pm line 220\n
>>
>>I checked and there would be no reason that the DBD::mysql would not be u=
sing anything but the latest mysql client libraries, so I am not sure why i=
t is still trying to use the older protocol and choking on the new long pas=
sword scheme. So I took the second of the more suggested routes and change=
d the password of that user with the old_password method. Instead of that =
error, I started to get segfaults.
>>
>>[Tue Mar 25 12:26:40 2008] [notice] child pid 25271 exit signal Segmentat=
ion fault (11)
>>
>>There were no errors in the mysql err logs nor the system logs.
>>
>>I decided to do an strace against the running apache process and saw the =
following:
>>
>>connect(1, {sa_family=3DAF_FILE, path=3D"/var/lib/mysql/mysql.sock"}, 110=
) =3D 0
>>setsockopt(1, SOL_IP, IP_TOS, [8], 4) =3D -1 EOPNOTSUPP (Operation not =
supported)
>>setsockopt(1, SOL_SOCKET, SO_KEEPALIVE, [1], 4) =3D 0
>>read(1, ">\0\0\0", 4) =3D 4
>>read(1, "\n5.0.24a-standard\0\304\224\0\0-gCVdwJK\0,"..., 62) =3D 62
>>open("/usr/share/mysql/charsets/Index", O_RDONLY|O_LARGEFILE) =3D -1 ENOE=
NT (No such file or directory)
>>write(1, "\24\0\0\1\217 \0\0\0rt\0P[XJIQKK\0rt3", 24) =3D 24
>>read(1, "\5\0\0\2", 4) =3D 4
>>read(1, "\0\0\0\2\0", 5) =3D 5
>>fcntl64(1, F_SETFL, O_RDWR|O_NONBLOCK) =3D 0
>>read(1, 0xc0977b8, 8192) =3D -1 EAGAIN (Resource temporari=
ly unavailable)
>>fcntl64(1, F_SETFL, O_RDWR) =3D 0
>>write(1, "\21\0\0\0\3set autocommit=3D1", 21) =3D 21
>>read(1, "\5\0\0\1", 4) =3D 4
>>read(1, "\0\0\0\2\0", 5) =3D 5
>>time(NULL) =3D 1206447319
>>time(NULL) =3D 1206447319
>>--- SIGSEGV (Segmentation fault) @ 0 (0) ---
>>chdir("/etc/httpd") =3D 0
>>rt_sigaction(SIGSEGV, {SIG_DFL}, {SIG_DFL}, 8) =3D 0
>>kill(5043, SIGSEGV) =3D 0
>>sigreturn() =3D ? (mask now [])
>>--- SIGSEGV (Segmentation fault) @ 0 (0) ---
>>Process 5043 detached
>>
>>The Index error is for missing files which can be found in mysql 3.0. I =
copied the Index files and relevant .conf files into the charsets directory=
and the Index error and replaced with=20
>>
>>open("/usr/share/mysql/charsets/Index", O_RDONLY|O_LARGEFILE) =3D 36
>>fstat64(36, {st_mode=3DS_IFREG|0755, st_size=3D549, ...}) =3D 0
>>mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0)=
=3D 0xb7e63000
>>read(36, "# sql/share/charsets/Index\n#\n# T"..., 4096) =3D 549
>>read(36, "", 4096) =3D 0
>>close(36) =3D 0
>>munmap(0xb7e63000, 4096) =3D 0
>>
>>However the segfault still remains.
>>
>>I also ran an strace against mysql and got a similar error.
>>
>>fcntl64(12, F_SETFL, O_RDWR|O_NONBLOCK) =3D 0
>>accept(12, {sa_family=3DAF_FILE, path=3D"ï¿½ï¿½
>>n"}, [2]) =3D 18
>>fcntl64(12, F_SETFL, O_RDWR) =3D 0
>>getsockname(18, {sa_family=3DAF_FILE, path=3D"/var/lib/mysql"}, [28]) =3D=
0
>>fcntl64(18, F_SETFL, O_RDONLY) =3D 0
>>fcntl64(18, F_GETFL) =3D 0x2 (flags O_RDWR)
>>fcntl64(18, F_SETFL, O_RDWR|O_NONBLOCK) =3D 0
>>setsockopt(18, SOL_IP, IP_TOS, [8], 4) =3D -1 EOPNOTSUPP (Operation not =
supported)
>>time(NULL) =3D 1206613476
>>clone(child_stack=3D0xb16b24c4, flags=3DCLONE_VM|CLONE_FS|CLONE_FILES|CLO=
NE_SIGHAND|CLONE_THREAD|CLONE_SYSVSEM|CLONE_SETTLS|CLONE_PAR ENT_SETTID|CLON=
E_CHILD_CLEARTID|CLONE_DETACHED, parent_tidptr=3D0xb16b2be8, {entry_number:=
6, base_addr:0xb16b2ba0, limit:1048575, seg_32bit:1, contents:0, read_exec_=
only:0, limit_in_pages:1, seg_not_present:0, useable:1}, child_tidptr=3D0xb=
16b2be8) =3D 13994
>>select(13, [10 12], NULL, NULL, NULL
>>
>>I am fresh out of ideas. Can anyone assist? I have posted to the RT lis=
t have not yet received any response and given roots in mysql and DBI, I th=
ought this would be appropriate
>>
>>Thanks in advance,
>>
>>Peter Musolino
>>D.B. Zwirn (UK) Ltd.
>>peter.musolino a t dbzco.com
>>
>>
>>
>>
>>
>>This e-mail message is intended only for the named recipient(s) above. I=
t may contain confidential information. If you are not the intended recipi=
ent, you are hereby noti
>>fied that any use, dissemination, distribution or copying of this e-mail =
and any attachment(s) is strictly prohibited. D.B. Zwirn & Co., L.P. reser=
ves the right to archive
>>and monitor all e-mail communications through its networks. If you have =
received this e-mail in error, please immediately notify the sender by repl=
ying to this e-mail and
>>delete the message and any attachment(s) from your system. Thank you.
>>
>>=20
>>
>> =20
>>
>
>
> =20
>

--=20
Patrick Galbraith, Senior Programmer=20
Grazr - Easy feed grazing and sharing
http://www.grazr.com=20

Satyam Eva Jayate - Truth Alone Triumphs
Mundaka Upanishad

This e-mail message is intended only for the named recipient(s) above. It =
may contain confidential information. If you are not the intended recipien=
t, you are hereby noti
fied that any use, dissemination, distribution or copying of this e-mail an=
d any attachment(s) is strictly prohibited. D.B. Zwirn & Co., L.P. reserve=
s the right to archive
and monitor all e-mail communications through its networks. If you have r=
eceived this e-mail in error, please immediately notify the sender by reply=
ing to this e-mail and
delete the message and any attachment(s) from your system. Thank you.

--=20
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=3Dpeter.musolino@dbzco=
..com

This e-mail message is intended only for the named recipient(s) above. It =
may contain confidential information. If you are not the intended recipien=
t, you are hereby noti
fied that any use, dissemination, distribution or copying of this e-mail an=
d any attachment(s) is strictly prohibited. D.B. Zwirn & Co., L.P. reserve=
s the right to archive
and monitor all e-mail communications through its networks. If you have r=
eceived this e-mail in error, please immediately notify the sender by reply=
ing to this e-mail and
delete the message and any attachment(s) from your system. Thank you.

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=3Dgcdmp-msql-mysql-modules @m.gmane.org