>Description:
I've coded a end-user login routine which connects, prepares a select query,
tests the column,
finishes, then, prepares an update query, sets a timeout variable, finishes,
and disconnects.
After the Db sequence, the routine prints(Perl5) HTML for the menu
(authority granted) or
re-prints the HTML for login with a message. There's two major functions Db
and HTML output.
The Db sequence runs fine until the disconnect when it seems to fail and
loop back into the
connect, prepare, test, etc. sequence. This disconnect failure, re-connect
repeats 3-6 times
and stops when it tries to roll-back (although AutoCommit is 1). Sometimes
the bind variables
are changed and the queries fail to, although not always.
Cut and Paste of
DBI->trace -----------------------------------------------------------------
----
<- err= undef
-> finish for DBD::mysql::st (DBI::st=HASH(0x820e95c)~0x820e98c)
<- finish= 1 at pkgadminlogin.pl line 138
**** Done with the Update, now on to disconnect and exit *****
-> disconnect for DBD::mysql::db (DBI::db=HASH(0x8205d44)~0x8205d8c)
imp_dbh->svsock: 81fd67c
<- disconnect= 1 at pkgadminlogin.pl line 141
***** Ending Db select, update loop... going to gtpmaint.pl *****
-> DESTROY for DBD::mysql::st (DBI::st=HASH(0x820e98c)~INNER)
<- DESTROY= undef at gtpmaint.pl line 37
-> DESTROY for DBD::mysql::db (DBI::db=HASH(0x8205d8c)~INNER)
<- DESTROY= undef at gtpmaint.pl line 37
-- DBI::END
-> disconnect_all for DBD::mysql::dr (DBI::dr=HASH(0x81b35e4)~0x8205d08)
<- disconnect_all= '' at DBI.pm line 533
-> DESTROY in DBD::_::common for DBD::mysql::dr
(DBI::dr=HASH(0x8205d08)~INNER)
<- DESTROY= undef during global destruction
DBI 1.21-nothread dispatch trace level set to 2
Note: perl is running without the recommended perl -w option
***** Starting Db select, update loop *****
-> DBI->connect(DBI:mysql:james:localhost, lolson, ****,
HASH(0x818b9e0))
-> DBI->install_driver(mysql) for linux perl=5.006001 pid=1370 ruid=500
euid=500
DBI 1.21-nothread dispatch trace level set to 2
>How-To-Repeat:
I've coded the authorization routine to call the HTML print routine.
I've coded the HTML print routine to call the authorization routine.
I've coded the authorization routine to system() the HTML print routine in
the forground and
background.
I've put all the code in-stream and the same looping issue remains.
>Fix:
I haven't been able to determine how to cleanly disconnect after the Db
sequence runs once.
>Submitter-Id: <submitter ID>
>Originator: Lance Olson
>Organization: Olson Systems
<organization of PR author (multiple lines)>
>MySQL support: [none ]
>Synopsis: <Disconnect causes looping of prior connect, query, finish>
>Severity: <non-critical>
>Priority: <low>
>Category: mysql
>Class: <sw-bug>
>Release: mysql-3.23.49 (Source distribution)
>Environment:
<machine, os, target, libraries (multiple lines)>
System: Linux localhost.localdomain 2.4.18-3 #1 Thu Apr 18 07:31:07 EDT 2002
i586 unknown
Architecture: i586
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 20000731 (Red Hat Linux 7.3 2.96-110)
Compilation info: CC='gcc'
CFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_L
ARGEFILE_SOURCE' CXX='gcc'
CXXFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D
_LARGEFILE_SOURCE -fno-rtti -fno-exceptions' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Jun 7 12:01 /lib/libc.so.6 ->
libc-2.2.5.so
-rwxr-xr-x 1 root root 1343176 Apr 15 08:02 /lib/libc-2.2.5.so
-rw-r--r-- 1 root root 2310808 Apr 15 08:02 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Apr 15 07:55 /usr/lib/libc.so
Configure command: ./configure
i386-redhat-linux --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --sbind
ir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --includedir=/usr/includ
e --libdir=/usr/lib --libexecdir=/usr/libexec --localstatedir=/var --shareds
tatedir=/usr/com --mandir=/usr/share/man --infodir=/usr/share/info --without
-debug --without-readline --enable-shared --with-extra-charsets=complex --wi
th-bench --localstatedir=/var/lib/mysql --with-unix-socket-path=/var/lib/mys
ql/mysql.sock --with-mysqld-user=mysql --with-extra-charsets=all --with-inno
db --with-berkeley-db --enable-large-files=yes --enable-largefile=yes --with
-thread-safe-client --enable-assembler
Thanks
Lance Olson
EmailID: [EMAIL PROTECTED]
Cell: (303) 246-5386
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
