triggers
In a trigger I need to iterate thru a query result that will consist of more
than 1 row. Could someone please give me a general example of how this would be
accomplished. For example in php i would just use
while($row = $result-fetch_assoc)
{
..process the row
}
I have no idea how to do this with in the confines of a trigger.
Thanks
-
No need to miss a message. Get email on-the-go
with Yahoo! Mail for Mobile. Get started.
The x509 cert issuer seems not to be checked against the CA
Description: I configured mysql to check for the subject and issuer of a clients cert. It seems that mysql can check the issuer of a cert but does not verify if the cert was really signed by a CA that is known to the server. I could generate a second client cert from the same key but another totally faked CA (but with the same strings) and it was accepted, too. openssl verify does discover such attacks! How-To-Repeat: Configure and test SSL. Now generate a second CA. Then sign one of the clients keys with the second CA which happens to have the same strings (i.e. O=,CN=,OU=) but of course has another secret key. Try the old and new client key, they work both! $ mysql -umy --ssl-key=my-key.pem --ssl-cert=fakemy-cert.pem $ mysql -umy --ssl-key=my-key.pem --ssl-cert=my-cert.pem My mysqld setup: [mysqld] ssl-ca=/etc/mysql/cacert.pem ssl-cert=/etc/mysql/server-cert.pem ssl-key=/etc/mysql/server-key.pem MySQL should behave like openssl: $ openssl verify -CAfile /etc/mysql/cacert.pem my-cert.pem my-cert.pem: OK $ openssl verify -CAfile /etc/mysql/cacert.pem fakemy-cert.pem fakemy-cert.pem: /C=DE/ST=NRW/L=Aachen/[EMAIL PROTECTED] error 7 at 0 depth lookup:certificate signature failure Fix: Don't know. Submitter-Id: submitter ID Originator:Christian Hammers Organization: Debian Project MySQL support: none Synopsis: Missing x509 CA verification. Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-4.0.12 (Source distribution) Server: /usr/bin/mysqladmin Ver 8.40 Distrib 4.0.12, 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.0.12-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/run/mysqld/mysqld.sock Uptime: 2 min 35 sec Threads: 1 Questions: 9 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.058 C compiler:gcc (GCC) 3.2.3 20030316 (Debian prerelease) C++ compiler: c++ (GCC) 3.2.3 20030316 (Debian prerelease) Environment: System: Linux app109 2.4.20 #2 Tue Feb 25 20:11:12 CET 2003 i686 unknown unknown GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/3.2.3/specs Configured with: ../src/configure -v --enable-languages=c,c++,java,f77,proto,pascal,objc,ada --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --with-gxx-include-dir=/usr/include/c++/3.2 --enable-shared --with-system-zlib --enable-nls --without-included-gettext --enable-__cxa_atexit --enable-clocale=gnu --enable-java-gc=boehm --enable-objc-gc i386-linux Thread model: posix gcc version 3.2.3 20030316 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx1 root root 13 2003-03-25 21:47 /lib/libc.so.6 - libc-2.3.1.so -rwxr-xr-x1 root root 1104040 2003-03-21 17:19 /lib/libc-2.3.1.so -rw-r--r--1 root root 2338008 2003-03-21 17:19 /usr/lib/libc.a -rw-r--r--1 root root 178 2003-03-21 17:19 /usr/lib/libc.so -rw-r--r--1 root root 716080 2002-01-13 21:06 /usr/lib/libc-client.so.2001 Configure command: ./configure --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql --localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info --mandir=/usr/share/man --enable-shared --enable-static --enable-thread-safe-client --enable-assembler --enable-local-infile --with-raid --with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql --with-libwrap --with-client-ldflags=-lstdc++ --with-embedded-server --with-vio --with-openssl --without-docs --without-bench --without-readline --with-extra-charsets=all --with-berkeley-db --with-innodb -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Error in docs: X509 format for 4.x SSL ACL
Description: The docs seem to be wrong. Although openssl x509 -text -in mycert.pem write e.g. the Subject as C=DE, ST=NRW, L=Aachen..., MySQL needs the format that is used e openssl x509 -in mycert -subject: /C=DE/ST=NRW/L=Aachen How-To-Repeat: Just try it out :-) Fix: Fix the either docs or the code. I don't know which format other software uses. The used format seems to be sensible but you should print a big fat warning that -text shows it different and of course correct the docs at: Secure_GRANT.html Submitter-Id: submitter ID Originator:Christian Hammers Organization: Debian Project MySQL support: none Synopsis: x509 format doc bug Severity: non-critical Priority: low Category: mysql Class: doc-bug Release: mysql-4.0.12 (Source distribution) Server: /usr/bin/mysqladmin Ver 8.40 Distrib 4.0.12, 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.0.12-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/run/mysqld/mysqld.sock Uptime: 6 min 1 sec Threads: 2 Questions: 16 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 1 Queries per second avg: 0.044 C compiler:gcc (GCC) 3.2.3 20030316 (Debian prerelease) C++ compiler: c++ (GCC) 3.2.3 20030316 (Debian prerelease) Environment: System: Linux app109 2.4.20 #2 Tue Feb 25 20:11:12 CET 2003 i686 unknown unknown GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/3.2.3/specs Configured with: ../src/configure -v --enable-languages=c,c++,java,f77,proto,pascal,objc,ada --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --with-gxx-include-dir=/usr/include/c++/3.2 --enable-shared --with-system-zlib --enable-nls --without-included-gettext --enable-__cxa_atexit --enable-clocale=gnu --enable-java-gc=boehm --enable-objc-gc i386-linux Thread model: posix gcc version 3.2.3 20030316 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx1 root root 13 2003-03-25 21:47 /lib/libc.so.6 - libc-2.3.1.so -rwxr-xr-x1 root root 1104040 2003-03-21 17:19 /lib/libc-2.3.1.so -rw-r--r--1 root root 2338008 2003-03-21 17:19 /usr/lib/libc.a -rw-r--r--1 root root 178 2003-03-21 17:19 /usr/lib/libc.so -rw-r--r--1 root root 716080 2002-01-13 21:06 /usr/lib/libc-client.so.2001 Configure command: ./configure --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql --localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info --mandir=/usr/share/man --enable-shared --enable-static --enable-thread-safe-client --enable-assembler --enable-local-infile --with-raid --with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql --with-libwrap --with-client-ldflags=-lstdc++ --with-embedded-server --with-vio --with-openssl --without-docs --without-bench --without-readline --with-extra-charsets=all --with-berkeley-db --with-innodb -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
info-dir-section element missing in .texi (4.0.10)
Description: There is a missing element in the texi file. How-To-Repeat: N/A Fix: --- mysql-orig/Docs/manual.texi Wed Feb 27 23:45:07 2002 +++ mysql-patched/Docs/manual.texi Wed Feb 27 23:44:49 2002 @@ -56,6 +56,7 @@ @ifinfo @format +INFO-DIR-SECTION Database START-INFO-DIR-ENTRY * mysql: (mysql). MySQL documentation. END-INFO-DIR-ENTRY Submitter-Id: submitter ID Originator:Christian Hammers Organization: The Debian Project MySQL support: none Synopsis: info-dir-section missing in manual.texi (4.0.10) Severity: non-critical Priority: low Category: mysql Class: doc-bug Release: mysql-3.23.55 (Source distribution) Environment: System: Linux app109 2.4.20-app109-3 #4 Sun Feb 2 21:44:32 CET 2003 i686 unknown unknown GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/3.2.2/specs Configured with: ../src/configure -v --enable-languages=c,c++,java,f77,proto,pascal,objc,ada --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --with-gxx-include-dir=/usr/include/c++/3.2 --enable-shared --with-system-zlib --enable-nls --without-included-gettext --disable-__cxa_atexit --enable-java-gc=boehm --enable-objc-gc i386-linux Thread model: posix gcc version 3.2.2 Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 2003-02-12 00:47 /lib/libc.so.6 - libc-2.3.1.so -rwxr-xr-x1 root root 1102984 2003-02-04 15:58 /lib/libc-2.3.1.so -rw-r--r--1 root root 2337940 2003-02-04 15:59 /usr/lib/libc.a -rw-r--r--1 root root 178 2003-02-04 15:59 /usr/lib/libc.so -rw-r--r--1 root root 716080 2002-01-13 21:06 /usr/lib/libc-client.so.2001 Configure command: ./configure --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql --localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info --mandir=/usr/share/man --enable-shared --with-libwrap --enable-assembler --with-berkeley-db --with-innodb --enable-static --enable-shared --enable-local-infile --with-raid --enable-thread-safe-client --without-readline --with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql --without-bench --without-docs --with-client-ldflags=-lstdc++ --with-extra-charsets=all - 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
mysqldump --allow-keywords has no effect. Alias for -Q?
Description: The --allow-keywords option has no effect if the server can use the SHOW CREATE INFO command (it's the other else branch). All the new code only make use of opt_quoted which is set by the -Q option and quotes illegal table/column names instead of prepending them with the database name like --allow-keywods would do. How-To-Repeat: CREATE TABLE `by` (`char` char(30)); and then try to dump it using --allow-keywords and -Q. Fix: If it is backwards compatible to e.g. version 3.21 which didn't know the SHOW CREATE TABLE command, then make --allow-keywods just an alias for opt_quoted (-Q). Submitter-Id: submitter ID Originator:Christian Hammers Organization: Debian Project MySQL support: none Synopsis: mysqldump --allow-keywods has no effect Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-3.23.55 (Source distribution) Environment: System: Linux app109 2.4.20-app109-3 #3 Sat Jan 25 14:55:31 CET 2003 i686 unknown unknown GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/3.2.2/specs Configured with: ../src/configure -v --enable-languages=c,c++,java,f77,proto,pascal,objc,ada --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --with-gxx-include-dir=/usr/include/c++/3.2 --enable-shared --with-system-zlib --enable-nls --without-included-gettext --enable-__cxa_atexit --enable-clocale=gnu --enable-java-gc=boehm --enable-objc-gc i386-linux Thread model: posix gcc version 3.2.2 20030124 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 2003-01-23 13:49 /lib/libc.so.6 - libc-2.3.1.so -rwxr-xr-x1 root root 1102984 2003-01-21 23:15 /lib/libc-2.3.1.so -rw-r--r--1 root root 2337952 2003-01-21 23:15 /usr/lib/libc.a -rw-r--r--1 root root 178 2003-01-21 23:15 /usr/lib/libc.so -rw-r--r--1 root root 716080 2002-01-13 21:06 /usr/lib/libc-client.so.2001 Configure command: ./configure --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql --localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info --mandir=/usr/share/man --enable-shared --with-libwrap --enable-assembler --with-berkeley-db --with-innodb --enable-static --enable-shared --enable-local-infile --with-raid --enable-thread-safe-client --without-readline --with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql --without-bench --without-docs --with-client-ldflags=-lstdc++ --with-extra-charsets=all - 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
[patch] for 4.0.9 Makefile (my_inet_ntoa reference)
Description: While building 4.0.9: gcc -O3 -DDBUG_OFF -rdynamic -o test-ssl test-ssl.o -lstdc++ ../dbug/libdbug.a ../mysys/libmysys.a ../strings/libmystrings.a libvio.a -L/usr/lib -lssl -lcrypto -lz -lcrypt -lnsl -lm -lpthread libvio.a(viosocket.o)(.text+0x2b6): In function `vio_peer_addr': : undefined reference to `my_inet_ntoa' collect2: ld returned 1 exit status How-To-Repeat: build it Fix: The order of the libraries must change to: libvio.a ../mysys/libmysys.a ../strings/libmystrings.a Submitter-Id: submitter ID Originator:Christian Hammers Organization: Debian Project MySQL support: none Synopsis: Makefile problem in 4.0.9 (my_inet_ntoa reference) Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-3.23.55 (Source distribution) Environment: System: Linux app109 2.4.20-app109-3 #3 Sat Jan 25 14:55:31 CET 2003 i686 unknown unknown GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/3.2.2/specs Configured with: ../src/configure -v --enable-languages=c,c++,java,f77,proto,pascal,objc,ada --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --with-gxx-include-dir=/usr/include/c++/3.2 --enable-shared --with-system-zlib --enable-nls --without-included-gettext --enable-__cxa_atexit --enable-clocale=gnu --enable-java-gc=boehm --enable-objc-gc i386-linux Thread model: posix gcc version 3.2.2 20030124 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 2003-01-23 13:49 /lib/libc.so.6 - libc-2.3.1.so -rwxr-xr-x1 root root 1102984 2003-01-21 23:15 /lib/libc-2.3.1.so -rw-r--r--1 root root 2337952 2003-01-21 23:15 /usr/lib/libc.a -rw-r--r--1 root root 178 2003-01-21 23:15 /usr/lib/libc.so -rw-r--r--1 root root 716080 2002-01-13 21:06 /usr/lib/libc-client.so.2001 Configure command: ./configure --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql --localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info --mandir=/usr/share/man --enable-shared --with-libwrap --enable-assembler --with-berkeley-db --with-innodb --enable-static --enable-shared --enable-local-infile --with-raid --enable-thread-safe-client --without-readline --with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql --without-bench --without-docs --with-client-ldflags=-lstdc++ --with-extra-charsets=all - 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
Re: help with query
Hi Leo, how about this: select * from planttable where id like 01% or id like %02 CH Leonardo Javier Belén wrote: Thanks but actually I'm looking for a way to return all the relations upwards and downwards of a term. no matter the position (so I need general query to do that. Any ideas? Thanks in advance. Leo. - Original Message - From: Anthony Richardson To: Leonardo Javier BelÈn [EMAIL PROTECTED] Sent: Monday, January 13, 2003 9:52 PM Subject: Re: help with query Hi, I do not clearly understand your question, but if it's looking for query, please try the following: select * from planttable where substring(id, 1, 2)=01 and substring(id, 3,2)=02; Hi all! I would like to build a query that I can use to search hierichally from an char(4) id composed as followed 2positions for the class of plant (for example) and 2 positions for the type of flower (for example) if someone give me the id that means red rose tree, and I know there is another clasifications of tree and another colors for the rose, does anyone knows how to retrieve them. 0100 - Rose tree 0101 - pink rose tree 0102 - red rose tree 0103 - rococo rose tree 0200 - generic tree Thanks in advance Leonardo J. BelÈn. query mysql sql blah! - 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 -- tony ... but I was occupied all the more constantly on my silent route, with trying to fix, at least in its more comprehensible and characteristic details, that sense of the sublime and vast, which, as time advances, usually grows contracted in our minds. Goethe - 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 - 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
mysqlhotcopy should suggest ~/.my.cnf instead of --password
Description: The mysqlhotcopy manpage suggests giving the password via the command line option '--password'. This is higly insecure as every system user is able to read it. How-To-Repeat: RTFM ;-) Fix: Please apply the following patch: --- mysql-dfsg-3.23.54a/scripts/mysqlhotcopy.sh.orig2002-12-23 17:06:18.0 +0100 +++ mysql-dfsg-3.23.54a/scripts/mysqlhotcopy.sh 2002-12-23 17:18:06.0 +0100 @@ -49,7 +49,8 @@ -?, --help display this helpscreen and exit -u, --user=# user for database login if not current user - -p, --password=# password to use when connecting to server + -p, --password=# password to use when connecting to server if not set + in e.g. ~/.my.cnf -h, --host=#Hostname for local server when connecting over TCP/IP -P, --port=# port to use when connecting to local server with TCP/IP -S, --socket=# socket to use when connecting to local server @@ -893,7 +894,11 @@ =item -p, --password=# -password to use when connecting to server +password to use when connecting to server. Note that you are strongly encouraged +*not* to use this option as every user would be able to see the password in the +process list. Instead use the '[mysqlhotcopy]' section in one of the config +files, normally /etc/mysql/my.cnf or your personal ~/.my.cnf. +(See manual '4.1.2 my.cnf Option Files') =item -h, -h, --host=# Submitter-Id: submitter ID Originator:Christian Hammers Organization: The Debian Project MySQL support: none Synopsis: mysqlhotcopy manpage suggests --password instead of ~/.my.cnf Severity: non-critical Priority: low Category: mysql Class: doc-bug Release: mysql-4.0.6-gamma (Source distribution) Environment: System: Linux app109 2.4.20-app109-1 #4 Thu Dec 5 21:44:44 CET 2002 i686 unknown unknown GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20011002 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx1 root root 13 2002-11-20 02:56 /lib/libc.so.6 - libc-2.3.1.so -rwxr-xr-x1 root root 1109068 2002-11-19 19:13 /lib/libc-2.3.1.so -rw-r--r--1 root root 2344038 2002-11-19 19:14 /usr/lib/libc.a -rw-r--r--1 root root 178 2002-11-19 19:14 /usr/lib/libc.so -rw-r--r--1 root root 716080 2002-01-13 21:06 /usr/lib/libc-client.so.2001 Configure command: ./configure '--prefix=/usr' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--datadir=/usr/share' '--sysconfdir=/etc/mysql' '--localstatedir=/var/lib/mysql' '--includedir=/usr/include' '--infodir=/usr/share/info' '--mandir=/usr/share/man' '--enable-shared' '--enable-static' '--enable-thread-safe-client' '--enable-assembler' '--enable-local-infile' '--with-raid' '--with-unix-socket-path=/var/run/mysqld/mysqld.sock' '--with-mysqld-user=mysql' '--with-libwrap' '--with-client-ldflags=-lstdc++' '--with-embedded-server' '--with-vio' '--with-openssl' '--without-docs' '--without-bench' '--without-readline' '--with-extra-charsets=all' '--with-berkeley-db' '--with-innodb' - 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
Docs make wrong statement about Debians init scripts
Description: http://www.mysql.com/doc/en/Linux-x86.html says what to do to start MySQL on system boot in Debian GNU/Linux. I don't know if this holds true for some of your binary packages under Debian, but the official Debian package is configure by debconf. So this text is misleading for Debian users and should be removed completely. How-To-Repeat: Fix: remove the note Submitter-Id: submitter ID Originator:Christian Hammers (Debian maintainer of MySQL) Organization: The Debian Project MySQL support: none Synopsis: Wrong statement about Debian init scripts Severity: non-critical Priority: low Category: mysql Class: doc-bug Release: mysql-3.23.54 (Source distribution) Environment: System: Linux app109 2.4.20-app109-1 #4 Thu Dec 5 21:44:44 CET 2002 i686 unknown unknown GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20011002 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 2002-11-20 02:56 /lib/libc.so.6 - libc-2.3.1.so -rwxr-xr-x1 root root 1109068 2002-11-19 19:13 /lib/libc-2.3.1.so -rw-r--r--1 root root 2344038 2002-11-19 19:14 /usr/lib/libc.a -rw-r--r--1 root root 178 2002-11-19 19:14 /usr/lib/libc.so -rw-r--r--1 root root 716080 2002-01-13 21:06 /usr/lib/libc-client.so.2001 Configure command: ./configure '--prefix=/usr' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--datadir=/usr/share' '--sysconfdir=/etc/mysql' '--localstatedir=/var/lib/mysql' '--includedir=/usr/include' '--infodir=/usr/share/info' '--mandir=/usr/share/man' '--enable-shared' '--with-libwrap' '--enable-assembler' '--with-berkeley-db' '--with-innodb' '--enable-static' '--enable-local-infile' '--with-raid' '--enable-thread-safe-client' '--without-readline' '--with-unix-socket-path=/var/run/mysqld/mysqld.sock' '--with-mysqld-user=mysql' '--without-bench' '--without-docs' '--with-client-ldflags=-lstdc++' '--with-extra-charsets=all' - 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 . - 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
[patch] Error in Makefile prevents complete distclean
Description: The unpacked source differs from the source tree after a ./configure make make distclean. This should be considered as Makefile bug, as e.g. package maintainers like me depends on a souce that cleans up it self so that we can easyly produce diffs containing only our own modifications. How-To-Repeat: ./configure make make clean; diff -u --recursive ../orig . Fix: Some diffs: # # Cleans up the vio_* and ctype-* symlinks that are created by link_source # $ diff -u mysql-dfsg-4.0.6.gamma.orig/libmysql/Makefile.shared mysql-dfsg-4.0.6.gamma/libmysql/Makefile.shared --- mysql-dfsg-4.0.6.gamma.orig/libmysql/Makefile.shared2002-12-16 10:11:57.0 +0100 +++ mysql-dfsg-4.0.6.gamma/libmysql/Makefile.shared 2002-12-21 01:56:07.0 ++0100 @@ -84,6 +84,8 @@ rm -f `echo $(mystringsobjects) | sed s;\.lo;.c;g` \ `echo $(dbugobjects) | sed s;\.lo;.c;g` \ `echo $(mysysobjects) | sed s;\.lo;.c;g` \ + `echo $(vio_objects) | sed s;\.lo;.c;g` \ + $(CHARSET_SRCS) $(CHARSET_OBJS) \ $(mystringsextra) $(mystringsgen) $(mysysheaders) \ ctype_extra_sources.c net.c ../linked_client_sources There are some others.. maybe I search them later. Submitter-Id: submitter ID Originator:Christian Hammers Organization: The Debian Project MySQL support: none Synopsis: distclean target misses some files Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: 4.0.6 and probably mysql-3.23.54 (Source distribution) Environment: System: Linux app109 2.4.20-app109-1 #4 Thu Dec 5 21:44:44 CET 2002 i686 unknown unknown GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20011002 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 2002-11-20 02:56 /lib/libc.so.6 - libc-2.3.1.so -rwxr-xr-x1 root root 1109068 2002-11-19 19:13 /lib/libc-2.3.1.so -rw-r--r--1 root root 2344038 2002-11-19 19:14 /usr/lib/libc.a -rw-r--r--1 root root 178 2002-11-19 19:14 /usr/lib/libc.so -rw-r--r--1 root root 716080 2002-01-13 21:06 /usr/lib/libc-client.so.2001 Configure command: ./configure '--prefix=/usr' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--datadir=/usr/share' '--sysconfdir=/etc/mysql' '--localstatedir=/var/lib/mysql' '--includedir=/usr/include' '--infodir=/usr/share/info' '--mandir=/usr/share/man' '--enable-shared' '--with-libwrap' '--enable-assembler' '--with-berkeley-db' '--with-innodb' '--enable-static' '--enable-local-infile' '--with-raid' '--enable-thread-safe-client' '--without-readline' '--with-unix-socket-path=/var/run/mysqld/mysqld.sock' '--with-mysqld-user=mysql' '--without-bench' '--without-docs' '--with-client-ldflags=-lstdc++' '--with-extra-charsets=all' - 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 . - 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
Missing -lwrap on mysqld/mysqltest?
Description: gcc -O3 -DDBUG_OFF -rdynamic -o mysqltest mysqltest.o -lstdc++ ../libmysqld.a -lrt -ldl -lpthread -lz -lcrypt -lnsl -lm -lpthread ../libmysqld.a(lib_sql.o)(.text+0x2736): In function `handle_connections_sockets': : undefined reference to `request_init' ... make[4]: Leaving directory `/home/ch/debian/mysql-dfsg-4.0.6.gamma/libmysqld/examples' How-To-Repeat: Build with --embedded-server Fix: Makefile.in: add -lwrap to mysqltest_LDFLAGS or in your case defined this variable in Makefile.am. Submitter-Id: submitter ID Originator:Christian Hammers Organization: The Debian Project MySQL support: none Synopsis: Missing -lwrap to libmysqld/mysqltest Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-3.23.54 (Source distribution) Environment: System: Linux app109 2.4.20-app109-1 #4 Thu Dec 5 21:44:44 CET 2002 i686 unknown unknown GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20011002 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 2002-11-20 02:56 /lib/libc.so.6 - libc-2.3.1.so -rwxr-xr-x1 root root 1109068 2002-11-19 19:13 /lib/libc-2.3.1.so -rw-r--r--1 root root 2344038 2002-11-19 19:14 /usr/lib/libc.a -rw-r--r--1 root root 178 2002-11-19 19:14 /usr/lib/libc.so -rw-r--r--1 root root 716080 2002-01-13 21:06 /usr/lib/libc-client.so.2001 Configure command: ./configure '--prefix=/usr' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--datadir=/usr/share' '--sysconfdir=/etc/mysql' '--localstatedir=/var/lib/mysql' '--includedir=/usr/include' '--infodir=/usr/share/info' '--mandir=/usr/share/man' '--enable-shared' '--with-libwrap' '--enable-assembler' '--with-berkeley-db' '--with-innodb' '--enable-static' '--enable-local-infile' '--with-raid' '--enable-thread-safe-client' '--without-readline' '--with-unix-socket-path=/var/run/mysqld/mysqld.sock' '--with-mysqld-user=mysql' '--without-bench' '--without-docs' '--with-client-ldflags=-lstdc++' '--with-extra-charsets=all' - 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 . - 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
Docs make wrong statement about Debians init scripts
Description: http://www.mysql.com/doc/en/Linux-x86.html says what to do to start MySQL on system boot in Debian GNU/Linux. I don't know if this holds true for some of your binary packages under Debian, but the official Debian package is configure by debconf. So this text is misleading for Debian users and should be removed completely. How-To-Repeat: Fix: remove the note Submitter-Id: submitter ID Originator:Christian Hammers (Debian maintainer of MySQL) Organization: The Debian Project MySQL support: none Synopsis: Wrong statement about Debian init scripts Severity: non-critical Priority: low Category: mysql Class: doc-bug Release: mysql-3.23.54 (Source distribution) Environment: System: Linux app109 2.4.20-app109-1 #4 Thu Dec 5 21:44:44 CET 2002 i686 unknown unknown GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20011002 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 2002-11-20 02:56 /lib/libc.so.6 - libc-2.3.1.so -rwxr-xr-x1 root root 1109068 2002-11-19 19:13 /lib/libc-2.3.1.so -rw-r--r--1 root root 2344038 2002-11-19 19:14 /usr/lib/libc.a -rw-r--r--1 root root 178 2002-11-19 19:14 /usr/lib/libc.so -rw-r--r--1 root root 716080 2002-01-13 21:06 /usr/lib/libc-client.so.2001 Configure command: ./configure '--prefix=/usr' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--datadir=/usr/share' '--sysconfdir=/etc/mysql' '--localstatedir=/var/lib/mysql' '--includedir=/usr/include' '--infodir=/usr/share/info' '--mandir=/usr/share/man' '--enable-shared' '--with-libwrap' '--enable-assembler' '--with-berkeley-db' '--with-innodb' '--enable-static' '--enable-local-infile' '--with-raid' '--enable-thread-safe-client' '--without-readline' '--with-unix-socket-path=/var/run/mysqld/mysqld.sock' '--with-mysqld-user=mysql' '--without-bench' '--without-docs' '--with-client-ldflags=-lstdc++' '--with-extra-charsets=all' - 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 . - 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
Missing -lwrap on mysqld/mysqltest?
Description: gcc -O3 -DDBUG_OFF -rdynamic -o mysqltest mysqltest.o -lstdc++ ../libmysqld.a -lrt -ldl -lpthread -lz -lcrypt -lnsl -lm -lpthread ../libmysqld.a(lib_sql.o)(.text+0x2736): In function `handle_connections_sockets': : undefined reference to `request_init' ... make[4]: Leaving directory `/home/ch/debian/mysql-dfsg-4.0.6.gamma/libmysqld/examples' How-To-Repeat: Build with --embedded-server Fix: Makefile.in: add -lwrap to mysqltest_LDFLAGS or in your case defined this variable in Makefile.am. Submitter-Id: submitter ID Originator:Christian Hammers Organization: The Debian Project MySQL support: none Synopsis: Missing -lwrap to libmysqld/mysqltest Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-3.23.54 (Source distribution) Environment: System: Linux app109 2.4.20-app109-1 #4 Thu Dec 5 21:44:44 CET 2002 i686 unknown unknown GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20011002 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 2002-11-20 02:56 /lib/libc.so.6 - libc-2.3.1.so -rwxr-xr-x1 root root 1109068 2002-11-19 19:13 /lib/libc-2.3.1.so -rw-r--r--1 root root 2344038 2002-11-19 19:14 /usr/lib/libc.a -rw-r--r--1 root root 178 2002-11-19 19:14 /usr/lib/libc.so -rw-r--r--1 root root 716080 2002-01-13 21:06 /usr/lib/libc-client.so.2001 Configure command: ./configure '--prefix=/usr' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--datadir=/usr/share' '--sysconfdir=/etc/mysql' '--localstatedir=/var/lib/mysql' '--includedir=/usr/include' '--infodir=/usr/share/info' '--mandir=/usr/share/man' '--enable-shared' '--with-libwrap' '--enable-assembler' '--with-berkeley-db' '--with-innodb' '--enable-static' '--enable-local-infile' '--with-raid' '--enable-thread-safe-client' '--without-readline' '--with-unix-socket-path=/var/run/mysqld/mysqld.sock' '--with-mysqld-user=mysql' '--without-bench' '--without-docs' '--with-client-ldflags=-lstdc++' '--with-extra-charsets=all' - 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 . - 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
[patch] Error in Makefile prevents complete distclean
Description: The unpacked source differs from the source tree after a ./configure make make distclean. This should be considered as Makefile bug, as e.g. package maintainers like me depends on a souce that cleans up it self so that we can easyly produce diffs containing only our own modifications. How-To-Repeat: ./configure make make clean; diff -u --recursive ../orig . Fix: Some diffs: # # Cleans up the vio_* and ctype-* symlinks that are created by link_source # $ diff -u mysql-dfsg-4.0.6.gamma.orig/libmysql/Makefile.shared mysql-dfsg-4.0.6.gamma/libmysql/Makefile.shared --- mysql-dfsg-4.0.6.gamma.orig/libmysql/Makefile.shared2002-12-16 10:11:57.0 +0100 +++ mysql-dfsg-4.0.6.gamma/libmysql/Makefile.shared 2002-12-21 01:56:07.0 ++0100 @@ -84,6 +84,8 @@ rm -f `echo $(mystringsobjects) | sed s;\.lo;.c;g` \ `echo $(dbugobjects) | sed s;\.lo;.c;g` \ `echo $(mysysobjects) | sed s;\.lo;.c;g` \ + `echo $(vio_objects) | sed s;\.lo;.c;g` \ + $(CHARSET_SRCS) $(CHARSET_OBJS) \ $(mystringsextra) $(mystringsgen) $(mysysheaders) \ ctype_extra_sources.c net.c ../linked_client_sources There are some others.. maybe I search them later. Submitter-Id: submitter ID Originator:Christian Hammers Organization: The Debian Project MySQL support: none Synopsis: distclean target misses some files Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: 4.0.6 and probably mysql-3.23.54 (Source distribution) Environment: System: Linux app109 2.4.20-app109-1 #4 Thu Dec 5 21:44:44 CET 2002 i686 unknown unknown GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20011002 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 2002-11-20 02:56 /lib/libc.so.6 - libc-2.3.1.so -rwxr-xr-x1 root root 1109068 2002-11-19 19:13 /lib/libc-2.3.1.so -rw-r--r--1 root root 2344038 2002-11-19 19:14 /usr/lib/libc.a -rw-r--r--1 root root 178 2002-11-19 19:14 /usr/lib/libc.so -rw-r--r--1 root root 716080 2002-01-13 21:06 /usr/lib/libc-client.so.2001 Configure command: ./configure '--prefix=/usr' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--datadir=/usr/share' '--sysconfdir=/etc/mysql' '--localstatedir=/var/lib/mysql' '--includedir=/usr/include' '--infodir=/usr/share/info' '--mandir=/usr/share/man' '--enable-shared' '--with-libwrap' '--enable-assembler' '--with-berkeley-db' '--with-innodb' '--enable-static' '--enable-local-infile' '--with-raid' '--enable-thread-safe-client' '--without-readline' '--with-unix-socket-path=/var/run/mysqld/mysqld.sock' '--with-mysqld-user=mysql' '--without-bench' '--without-docs' '--with-client-ldflags=-lstdc++' '--with-extra-charsets=all' - 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 . - 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
Docs make wrong statement about Debians init scripts
Description: http://www.mysql.com/doc/en/Linux-x86.html says what to do to start MySQL on system boot in Debian GNU/Linux. I don't know if this holds true for some of your binary packages under Debian, but the official Debian package is configure by debconf. So this text is misleading for Debian users and should be removed completely. How-To-Repeat: Fix: remove the note Submitter-Id: submitter ID Originator:Christian Hammers (Debian maintainer of MySQL) Organization: The Debian Project MySQL support: none Synopsis: Wrong statement about Debian init scripts Severity: non-critical Priority: low Category: mysql Class: doc-bug Release: mysql-3.23.54 (Source distribution) Environment: System: Linux app109 2.4.20-app109-1 #4 Thu Dec 5 21:44:44 CET 2002 i686 unknown unknown GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20011002 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 2002-11-20 02:56 /lib/libc.so.6 - libc-2.3.1.so -rwxr-xr-x1 root root 1109068 2002-11-19 19:13 /lib/libc-2.3.1.so -rw-r--r--1 root root 2344038 2002-11-19 19:14 /usr/lib/libc.a -rw-r--r--1 root root 178 2002-11-19 19:14 /usr/lib/libc.so -rw-r--r--1 root root 716080 2002-01-13 21:06 /usr/lib/libc-client.so.2001 Configure command: ./configure '--prefix=/usr' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--datadir=/usr/share' '--sysconfdir=/etc/mysql' '--localstatedir=/var/lib/mysql' '--includedir=/usr/include' '--infodir=/usr/share/info' '--mandir=/usr/share/man' '--enable-shared' '--with-libwrap' '--enable-assembler' '--with-berkeley-db' '--with-innodb' '--enable-static' '--enable-local-infile' '--with-raid' '--enable-thread-safe-client' '--without-readline' '--with-unix-socket-path=/var/run/mysqld/mysqld.sock' '--with-mysqld-user=mysql' '--without-bench' '--without-docs' '--with-client-ldflags=-lstdc++' '--with-extra-charsets=all' - 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 . - 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
[patch] Error in Makefile prevents complete distclean
Description: The unpacked source differs from the source tree after a ./configure make make distclean. This should be considered as Makefile bug, as e.g. package maintainers like me depends on a souce that cleans up it self so that we can easyly produce diffs containing only our own modifications. How-To-Repeat: ./configure make make clean; diff -u --recursive ../orig . Fix: Some diffs: # # Cleans up the vio_* and ctype-* symlinks that are created by link_source # $ diff -u mysql-dfsg-4.0.6.gamma.orig/libmysql/Makefile.shared mysql-dfsg-4.0.6.gamma/libmysql/Makefile.shared --- mysql-dfsg-4.0.6.gamma.orig/libmysql/Makefile.shared2002-12-16 10:11:57.0 +0100 +++ mysql-dfsg-4.0.6.gamma/libmysql/Makefile.shared 2002-12-21 01:56:07.0 ++0100 @@ -84,6 +84,8 @@ rm -f `echo $(mystringsobjects) | sed s;\.lo;.c;g` \ `echo $(dbugobjects) | sed s;\.lo;.c;g` \ `echo $(mysysobjects) | sed s;\.lo;.c;g` \ + `echo $(vio_objects) | sed s;\.lo;.c;g` \ + $(CHARSET_SRCS) $(CHARSET_OBJS) \ $(mystringsextra) $(mystringsgen) $(mysysheaders) \ ctype_extra_sources.c net.c ../linked_client_sources There are some others.. maybe I search them later. Submitter-Id: submitter ID Originator:Christian Hammers Organization: The Debian Project MySQL support: none Synopsis: distclean target misses some files Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: 4.0.6 and probably mysql-3.23.54 (Source distribution) Environment: System: Linux app109 2.4.20-app109-1 #4 Thu Dec 5 21:44:44 CET 2002 i686 unknown unknown GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20011002 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 2002-11-20 02:56 /lib/libc.so.6 - libc-2.3.1.so -rwxr-xr-x1 root root 1109068 2002-11-19 19:13 /lib/libc-2.3.1.so -rw-r--r--1 root root 2344038 2002-11-19 19:14 /usr/lib/libc.a -rw-r--r--1 root root 178 2002-11-19 19:14 /usr/lib/libc.so -rw-r--r--1 root root 716080 2002-01-13 21:06 /usr/lib/libc-client.so.2001 Configure command: ./configure '--prefix=/usr' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--datadir=/usr/share' '--sysconfdir=/etc/mysql' '--localstatedir=/var/lib/mysql' '--includedir=/usr/include' '--infodir=/usr/share/info' '--mandir=/usr/share/man' '--enable-shared' '--with-libwrap' '--enable-assembler' '--with-berkeley-db' '--with-innodb' '--enable-static' '--enable-local-infile' '--with-raid' '--enable-thread-safe-client' '--without-readline' '--with-unix-socket-path=/var/run/mysqld/mysqld.sock' '--with-mysqld-user=mysql' '--without-bench' '--without-docs' '--with-client-ldflags=-lstdc++' '--with-extra-charsets=all' - 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 . - 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
Missing -lwrap on mysqld/mysqltest?
Description: gcc -O3 -DDBUG_OFF -rdynamic -o mysqltest mysqltest.o -lstdc++ ../libmysqld.a -lrt -ldl -lpthread -lz -lcrypt -lnsl -lm -lpthread ../libmysqld.a(lib_sql.o)(.text+0x2736): In function `handle_connections_sockets': : undefined reference to `request_init' ... make[4]: Leaving directory `/home/ch/debian/mysql-dfsg-4.0.6.gamma/libmysqld/examples' How-To-Repeat: Build with --embedded-server Fix: Makefile.in: add -lwrap to mysqltest_LDFLAGS or in your case defined this variable in Makefile.am. Submitter-Id: submitter ID Originator:Christian Hammers Organization: The Debian Project MySQL support: none Synopsis: Missing -lwrap to libmysqld/mysqltest Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-3.23.54 (Source distribution) Environment: System: Linux app109 2.4.20-app109-1 #4 Thu Dec 5 21:44:44 CET 2002 i686 unknown unknown GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20011002 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 2002-11-20 02:56 /lib/libc.so.6 - libc-2.3.1.so -rwxr-xr-x1 root root 1109068 2002-11-19 19:13 /lib/libc-2.3.1.so -rw-r--r--1 root root 2344038 2002-11-19 19:14 /usr/lib/libc.a -rw-r--r--1 root root 178 2002-11-19 19:14 /usr/lib/libc.so -rw-r--r--1 root root 716080 2002-01-13 21:06 /usr/lib/libc-client.so.2001 Configure command: ./configure '--prefix=/usr' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--datadir=/usr/share' '--sysconfdir=/etc/mysql' '--localstatedir=/var/lib/mysql' '--includedir=/usr/include' '--infodir=/usr/share/info' '--mandir=/usr/share/man' '--enable-shared' '--with-libwrap' '--enable-assembler' '--with-berkeley-db' '--with-innodb' '--enable-static' '--enable-local-infile' '--with-raid' '--enable-thread-safe-client' '--without-readline' '--with-unix-socket-path=/var/run/mysqld/mysqld.sock' '--with-mysqld-user=mysql' '--without-bench' '--without-docs' '--with-client-ldflags=-lstdc++' '--with-extra-charsets=all' - 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 . - 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
Docs make wrong statement about Debians init scripts
Description: http://www.mysql.com/doc/en/Linux-x86.html says what to do to start MySQL on system boot in Debian GNU/Linux. I don't know if this holds true for some of your binary packages under Debian, but the official Debian package is configure by debconf. So this text is misleading for Debian users and should be removed completely. How-To-Repeat: Fix: remove the note Submitter-Id: submitter ID Originator:Christian Hammers (Debian maintainer of MySQL) Organization: The Debian Project MySQL support: none Synopsis: Wrong statement about Debian init scripts Severity: non-critical Priority: low Category: mysql Class: doc-bug Release: mysql-3.23.54 (Source distribution) Environment: System: Linux app109 2.4.20-app109-1 #4 Thu Dec 5 21:44:44 CET 2002 i686 unknown unknown GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20011002 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 2002-11-20 02:56 /lib/libc.so.6 - libc-2.3.1.so -rwxr-xr-x1 root root 1109068 2002-11-19 19:13 /lib/libc-2.3.1.so -rw-r--r--1 root root 2344038 2002-11-19 19:14 /usr/lib/libc.a -rw-r--r--1 root root 178 2002-11-19 19:14 /usr/lib/libc.so -rw-r--r--1 root root 716080 2002-01-13 21:06 /usr/lib/libc-client.so.2001 Configure command: ./configure '--prefix=/usr' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--datadir=/usr/share' '--sysconfdir=/etc/mysql' '--localstatedir=/var/lib/mysql' '--includedir=/usr/include' '--infodir=/usr/share/info' '--mandir=/usr/share/man' '--enable-shared' '--with-libwrap' '--enable-assembler' '--with-berkeley-db' '--with-innodb' '--enable-static' '--enable-local-infile' '--with-raid' '--enable-thread-safe-client' '--without-readline' '--with-unix-socket-path=/var/run/mysqld/mysqld.sock' '--with-mysqld-user=mysql' '--without-bench' '--without-docs' '--with-client-ldflags=-lstdc++' '--with-extra-charsets=all' - 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 . - 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
[patch] Error in Makefile prevents complete distclean
Description: The unpacked source differs from the source tree after a ./configure make make distclean. This should be considered as Makefile bug, as e.g. package maintainers like me depends on a souce that cleans up it self so that we can easyly produce diffs containing only our own modifications. How-To-Repeat: ./configure make make clean; diff -u --recursive ../orig . Fix: Some diffs: # # Cleans up the vio_* and ctype-* symlinks that are created by link_source # $ diff -u mysql-dfsg-4.0.6.gamma.orig/libmysql/Makefile.shared mysql-dfsg-4.0.6.gamma/libmysql/Makefile.shared --- mysql-dfsg-4.0.6.gamma.orig/libmysql/Makefile.shared2002-12-16 10:11:57.0 +0100 +++ mysql-dfsg-4.0.6.gamma/libmysql/Makefile.shared 2002-12-21 01:56:07.0 ++0100 @@ -84,6 +84,8 @@ rm -f `echo $(mystringsobjects) | sed s;\.lo;.c;g` \ `echo $(dbugobjects) | sed s;\.lo;.c;g` \ `echo $(mysysobjects) | sed s;\.lo;.c;g` \ + `echo $(vio_objects) | sed s;\.lo;.c;g` \ + $(CHARSET_SRCS) $(CHARSET_OBJS) \ $(mystringsextra) $(mystringsgen) $(mysysheaders) \ ctype_extra_sources.c net.c ../linked_client_sources There are some others.. maybe I search them later. Submitter-Id: submitter ID Originator:Christian Hammers Organization: The Debian Project MySQL support: none Synopsis: distclean target misses some files Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: 4.0.6 and probably mysql-3.23.54 (Source distribution) Environment: System: Linux app109 2.4.20-app109-1 #4 Thu Dec 5 21:44:44 CET 2002 i686 unknown unknown GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20011002 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 2002-11-20 02:56 /lib/libc.so.6 - libc-2.3.1.so -rwxr-xr-x1 root root 1109068 2002-11-19 19:13 /lib/libc-2.3.1.so -rw-r--r--1 root root 2344038 2002-11-19 19:14 /usr/lib/libc.a -rw-r--r--1 root root 178 2002-11-19 19:14 /usr/lib/libc.so -rw-r--r--1 root root 716080 2002-01-13 21:06 /usr/lib/libc-client.so.2001 Configure command: ./configure '--prefix=/usr' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--datadir=/usr/share' '--sysconfdir=/etc/mysql' '--localstatedir=/var/lib/mysql' '--includedir=/usr/include' '--infodir=/usr/share/info' '--mandir=/usr/share/man' '--enable-shared' '--with-libwrap' '--enable-assembler' '--with-berkeley-db' '--with-innodb' '--enable-static' '--enable-local-infile' '--with-raid' '--enable-thread-safe-client' '--without-readline' '--with-unix-socket-path=/var/run/mysqld/mysqld.sock' '--with-mysqld-user=mysql' '--without-bench' '--without-docs' '--with-client-ldflags=-lstdc++' '--with-extra-charsets=all' - 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 . - 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
Missing -lwrap on mysqld/mysqltest?
Description: gcc -O3 -DDBUG_OFF -rdynamic -o mysqltest mysqltest.o -lstdc++ ../libmysqld.a -lrt -ldl -lpthread -lz -lcrypt -lnsl -lm -lpthread ../libmysqld.a(lib_sql.o)(.text+0x2736): In function `handle_connections_sockets': : undefined reference to `request_init' ... make[4]: Leaving directory `/home/ch/debian/mysql-dfsg-4.0.6.gamma/libmysqld/examples' How-To-Repeat: Build with --embedded-server Fix: Makefile.in: add -lwrap to mysqltest_LDFLAGS or in your case defined this variable in Makefile.am. Submitter-Id: submitter ID Originator:Christian Hammers Organization: The Debian Project MySQL support: none Synopsis: Missing -lwrap to libmysqld/mysqltest Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-3.23.54 (Source distribution) Environment: System: Linux app109 2.4.20-app109-1 #4 Thu Dec 5 21:44:44 CET 2002 i686 unknown unknown GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20011002 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 2002-11-20 02:56 /lib/libc.so.6 - libc-2.3.1.so -rwxr-xr-x1 root root 1109068 2002-11-19 19:13 /lib/libc-2.3.1.so -rw-r--r--1 root root 2344038 2002-11-19 19:14 /usr/lib/libc.a -rw-r--r--1 root root 178 2002-11-19 19:14 /usr/lib/libc.so -rw-r--r--1 root root 716080 2002-01-13 21:06 /usr/lib/libc-client.so.2001 Configure command: ./configure '--prefix=/usr' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--datadir=/usr/share' '--sysconfdir=/etc/mysql' '--localstatedir=/var/lib/mysql' '--includedir=/usr/include' '--infodir=/usr/share/info' '--mandir=/usr/share/man' '--enable-shared' '--with-libwrap' '--enable-assembler' '--with-berkeley-db' '--with-innodb' '--enable-static' '--enable-local-infile' '--with-raid' '--enable-thread-safe-client' '--without-readline' '--with-unix-socket-path=/var/run/mysqld/mysqld.sock' '--with-mysqld-user=mysql' '--without-bench' '--without-docs' '--with-client-ldflags=-lstdc++' '--with-extra-charsets=all' - 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 . - 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
Docs make wrong statement about Debians init scripts
Description: http://www.mysql.com/doc/en/Linux-x86.html says what to do to start MySQL on system boot in Debian GNU/Linux. I don't know if this holds true for some of your binary packages under Debian, but the official Debian package is configure by debconf. So this text is misleading for Debian users and should be removed completely. How-To-Repeat: Fix: remove the note Submitter-Id: submitter ID Originator:Christian Hammers (Debian maintainer of MySQL) Organization: The Debian Project MySQL support: none Synopsis: Wrong statement about Debian init scripts Severity: non-critical Priority: low Category: mysql Class: doc-bug Release: mysql-3.23.54 (Source distribution) Environment: System: Linux app109 2.4.20-app109-1 #4 Thu Dec 5 21:44:44 CET 2002 i686 unknown unknown GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20011002 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 2002-11-20 02:56 /lib/libc.so.6 - libc-2.3.1.so -rwxr-xr-x1 root root 1109068 2002-11-19 19:13 /lib/libc-2.3.1.so -rw-r--r--1 root root 2344038 2002-11-19 19:14 /usr/lib/libc.a -rw-r--r--1 root root 178 2002-11-19 19:14 /usr/lib/libc.so -rw-r--r--1 root root 716080 2002-01-13 21:06 /usr/lib/libc-client.so.2001 Configure command: ./configure '--prefix=/usr' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--datadir=/usr/share' '--sysconfdir=/etc/mysql' '--localstatedir=/var/lib/mysql' '--includedir=/usr/include' '--infodir=/usr/share/info' '--mandir=/usr/share/man' '--enable-shared' '--with-libwrap' '--enable-assembler' '--with-berkeley-db' '--with-innodb' '--enable-static' '--enable-local-infile' '--with-raid' '--enable-thread-safe-client' '--without-readline' '--with-unix-socket-path=/var/run/mysqld/mysqld.sock' '--with-mysqld-user=mysql' '--without-bench' '--without-docs' '--with-client-ldflags=-lstdc++' '--with-extra-charsets=all' - 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
[patch] Error in Makefile prevents complete distclean
Description: The unpacked source differs from the source tree after a ./configure make make distclean. This should be considered as Makefile bug, as e.g. package maintainers like me depends on a souce that cleans up it self so that we can easyly produce diffs containing only our own modifications. How-To-Repeat: ./configure make make clean; diff -u --recursive ../orig . Fix: Some diffs: # # Cleans up the vio_* and ctype-* symlinks that are created by link_source # $ diff -u mysql-dfsg-4.0.6.gamma.orig/libmysql/Makefile.shared mysql-dfsg-4.0.6.gamma/libmysql/Makefile.shared --- mysql-dfsg-4.0.6.gamma.orig/libmysql/Makefile.shared2002-12-16 10:11:57.0 +0100 +++ mysql-dfsg-4.0.6.gamma/libmysql/Makefile.shared 2002-12-21 01:56:07.0 ++0100 @@ -84,6 +84,8 @@ rm -f `echo $(mystringsobjects) | sed s;\.lo;.c;g` \ `echo $(dbugobjects) | sed s;\.lo;.c;g` \ `echo $(mysysobjects) | sed s;\.lo;.c;g` \ + `echo $(vio_objects) | sed s;\.lo;.c;g` \ + $(CHARSET_SRCS) $(CHARSET_OBJS) \ $(mystringsextra) $(mystringsgen) $(mysysheaders) \ ctype_extra_sources.c net.c ../linked_client_sources There are some others.. maybe I search them later. Submitter-Id: submitter ID Originator:Christian Hammers Organization: The Debian Project MySQL support: none Synopsis: distclean target misses some files Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: 4.0.6 and probably mysql-3.23.54 (Source distribution) Environment: System: Linux app109 2.4.20-app109-1 #4 Thu Dec 5 21:44:44 CET 2002 i686 unknown unknown GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20011002 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 2002-11-20 02:56 /lib/libc.so.6 - libc-2.3.1.so -rwxr-xr-x1 root root 1109068 2002-11-19 19:13 /lib/libc-2.3.1.so -rw-r--r--1 root root 2344038 2002-11-19 19:14 /usr/lib/libc.a -rw-r--r--1 root root 178 2002-11-19 19:14 /usr/lib/libc.so -rw-r--r--1 root root 716080 2002-01-13 21:06 /usr/lib/libc-client.so.2001 Configure command: ./configure '--prefix=/usr' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--datadir=/usr/share' '--sysconfdir=/etc/mysql' '--localstatedir=/var/lib/mysql' '--includedir=/usr/include' '--infodir=/usr/share/info' '--mandir=/usr/share/man' '--enable-shared' '--with-libwrap' '--enable-assembler' '--with-berkeley-db' '--with-innodb' '--enable-static' '--enable-local-infile' '--with-raid' '--enable-thread-safe-client' '--without-readline' '--with-unix-socket-path=/var/run/mysqld/mysqld.sock' '--with-mysqld-user=mysql' '--without-bench' '--without-docs' '--with-client-ldflags=-lstdc++' '--with-extra-charsets=all' - 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
Missing -lwrap on mysqld/mysqltest?
Description: gcc -O3 -DDBUG_OFF -rdynamic -o mysqltest mysqltest.o -lstdc++ ../libmysqld.a -lrt -ldl -lpthread -lz -lcrypt -lnsl -lm -lpthread ../libmysqld.a(lib_sql.o)(.text+0x2736): In function `handle_connections_sockets': : undefined reference to `request_init' ... make[4]: Leaving directory `/home/ch/debian/mysql-dfsg-4.0.6.gamma/libmysqld/examples' How-To-Repeat: Build with --embedded-server Fix: Makefile.in: add -lwrap to mysqltest_LDFLAGS or in your case defined this variable in Makefile.am. Submitter-Id: submitter ID Originator:Christian Hammers Organization: The Debian Project MySQL support: none Synopsis: Missing -lwrap to libmysqld/mysqltest Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-3.23.54 (Source distribution) Environment: System: Linux app109 2.4.20-app109-1 #4 Thu Dec 5 21:44:44 CET 2002 i686 unknown unknown GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20011002 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 2002-11-20 02:56 /lib/libc.so.6 - libc-2.3.1.so -rwxr-xr-x1 root root 1109068 2002-11-19 19:13 /lib/libc-2.3.1.so -rw-r--r--1 root root 2344038 2002-11-19 19:14 /usr/lib/libc.a -rw-r--r--1 root root 178 2002-11-19 19:14 /usr/lib/libc.so -rw-r--r--1 root root 716080 2002-01-13 21:06 /usr/lib/libc-client.so.2001 Configure command: ./configure '--prefix=/usr' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--datadir=/usr/share' '--sysconfdir=/etc/mysql' '--localstatedir=/var/lib/mysql' '--includedir=/usr/include' '--infodir=/usr/share/info' '--mandir=/usr/share/man' '--enable-shared' '--with-libwrap' '--enable-assembler' '--with-berkeley-db' '--with-innodb' '--enable-static' '--enable-local-infile' '--with-raid' '--enable-thread-safe-client' '--without-readline' '--with-unix-socket-path=/var/run/mysqld/mysqld.sock' '--with-mysqld-user=mysql' '--without-bench' '--without-docs' '--with-client-ldflags=-lstdc++' '--with-extra-charsets=all' - 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
mysql down problem.
Hello, all. when I direct telnet to mysql server the mysql daemon is down or restarted like this. telnet my.mysql.server 3306 [root@www tmp]# /usr/local/mysql/bin/mysql.server start [root@www tmp]# Starting mysqld daemon with databases from /usr/local/mysql/var and telnet to mysql port at this server the service is ended like this. [root@www tmp]# /usr/local/mysql/bin/safe_mysqld: line 273: 12704 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 021104 18:11:50 mysqld ended But when I started with mysql user, the service itself is down and when I started with root user, the mysql service is restarted. my mysql version is ./mysql -V ./mysql Ver 11.18 Distrib 3.23.52, for pc-linux-gnu (i686) Is this a mysql bug or not? Please how can I solve this problem. Thanks in advance. _ MSN Messenger¸¦ ÅëÇØ ¿Â¶óÀÎ»ó¿¡ Àִ ģ±¸¿Í ´ëȸ¦ ³ª´©¼¼¿ä. http://messenger.msn.co.kr - 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
Regarding Mysql4.0
hello sir,, I have downloaded Beta version of Mysql 4.0.3 I didnt find any source code in it.. Will u please inform me how can i get source code in it Thanking u... Kalyan __ Give your Company an email address like ravi @ ravi-exports.com. Sign up for Rediffmail Pro today! Know more. http://www.rediffmailpro.com/signup/ - 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
compile problem with 3.23.50
Description: I get the following error: c++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr\ - DDATADIR=\/var/lib/mysql\ -DSHAREDIR=\/usr/share/mysql\ -DHAVE_CONFIG_H -I../bdb/build_unix -I../innobase/includ e -I./../include -I./../regex - I. -I../include -I.. -I.-O3 -DDBUG_OFF -fno-implicit-templates -fno-except ions -fno-rtti -c mysqld.cc mysqld.cc: In function `void * handle_connections_sockets(void *)': /usr/include/tcpd.h:161: too few arguments to function `void sock_host(request_i nfo *)' mysqld.cc:2428: at this point in file /usr/include/tcpd.h:119: too few arguments to function `int hosts_access(request _info *)' mysqld.cc:2429: at this point in file /usr/include/tcpd.h:153: too few arguments to function `char * eval_client(reque st_info *)' mysqld.cc:2437: at this point in file make[4]: *** [mysqld.o] Error 1 make[4]: Leaving directory `/home/ch/debian/mysql-3.23.50/sql' make[3]: *** [all-recursive] Error 1 make[3]: Leaving directory `/home/ch/debian/mysql-3.23.50/sql' Desired=Unknown/Install/Remove/Purge/Hold | Status=Not/Installed/Config-files/Unpacked/Failed-config/Half-installed |/ Err?=(none)/Hold/Reinst-required/X=both-problems (Status,Err: uppercase=bad) ||/ Name VersionDescription +++-==-==- ii libwrap0 7.6-9 Wietse Venema's TCP wrappers library ii libwrap0-dev 7.6-9 Wietse Venema's TCP wrappers library, develo ii libc6 2.2.5-4GNU C Library: Shared libraries and Timezone ii libc6-dev 2.2.5-4GNU C Library: Development Libraries and Hea ii gcc2.95.4-14 The GNU C compiler. ii gcc-2.95 2.95.4-7 The GNU C compiler. ii gcc-3.0-base 3.0.4-7The GNU Compiler Collection (base package). How-To-Repeat: see above Fix: none Submitter-Id: submitter ID Originator:Christian Hammers Organization: Debian Project MySQL support: none Synopsis: compile problem 3.23.50 Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.49 (Source distribution) Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.49, 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 3.23.49-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/run/mysqld/mysqld.sock Uptime: 1 day 7 hours 39 min 28 sec Threads: 1 Questions: 621696 Slow queries: 0 Opens: 506 Flush tables: 1 Open tables: 12 Queries per second avg: 5.455 Environment: System: Linux xeniac 2.4.17 #2 Fre Jan 18 19:15:02 CET 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20011002 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Mär 26 15:17 /lib/libc.so.6 - libc-2.2.5.so -rwxr-xr-x1 root root 1153816 Mär 24 18:00 /lib/libc-2.2.5.so -rw-r--r--1 root root 2391274 Mär 24 18:00 /usr/lib/libc.a -rw-r--r--1 root root 178 Mär 24 18:01 /usr/lib/libc.so -rw-r--r--1 root root 726660 Mär 24 05:56 /usr/lib/libc-client.so.2001 Configure command: ./configure --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql --localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info --mandir=/usr/share/man --enable-shared --with-libwrap --enable-assembler --with-berkeley-db --with-innodb --enable-static --enable-shared --enable-local-infile --with-raid --enable-thread-safe-client --without-readline --with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql --without-bench --with-client-ldflags=-lstdc++ --with-extra-charsets=all - 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
patch: manpage safe_mysql(1)
Description: Attached is a short manpage bugfix. How-To-Repeat: man -k safe_mysqld Fix: --- safe_mysqld.1.orig Tue Nov 27 02:19:05 2001 +++ safe_mysqld.1 Tue Nov 27 02:19:56 2001 @@ -1,8 +1,7 @@ -.TH SAFE_MYSQLD 1 19 December 2000 safe_mysqld (mysql) mysql.com +.TH SAFE_MYSQLD 1 19 December 2000 .SH NAME -safe_mysqld \- start the mysqld daemon on Unix. -.SH USAGE -safe_mysqld [options] (On Debian System you use /etc/init.d/mysql!) +.BR safe_mysqld +is the recommended way to start a mysqld daemon on Unix. safe_mysqld adds some safety features such as restarting the server when an error occurs and logging r un-time information to a log file. .SH SYNOPSIS .B safe_mysqld .RB [ \-\-basedir=\fP\fIpath\fP ] @@ -22,8 +21,6 @@ .RB [ \-\-timezone=# ] .RB [ \-\-user=# ] .SH DESCRIPTION -safe_mysqld adds some safety features such as restarting the server when an err or occurs and logging run-time information to a log file. -.BR .TP .BR \-\-basedir=\fP\fIpath \fP .TP Submitter-Id: submitter ID Originator:Christian Hammers MySQL support: none Synopsis: patch for safe_mysqld manpage Severity: non-critical Priority: low Category: mysql Class: doc-bug Release: mysql-3.23.45 (Source distribution) Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.45, 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 3.23.45-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/run/mysqld/mysqld.sock Uptime: 1 min 33 sec Threads: 1 Questions: 12 Slow queries: 0 Opens: 7 Flush tables: 1 Open tables: 1 Queries per second avg: 0.129 Environment: System: Linux app109 2.4.13-ac5 #8 Fre Nov 9 01:01:18 CET 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20011006 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 14 10. Sep 23:30 /lib/libc.so.5 - libc.so.5.4.46 -rw-r--r--1 root root 566004 27. Mai 2001 /lib/libc.so.5.4.46 lrwxrwxrwx1 root root 13 3. Nov 22:11 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 1171196 30. Okt 23:44 /lib/libc-2.2.4.so -rw-r--r--1 root root 2669312 30. Okt 23:44 /usr/lib/libc.a -rw-r--r--1 root root 178 30. Okt 23:44 /usr/lib/libc.so lrwxrwxrwx1 root root 10 6. Nov 23:31 /usr/lib/libc-client.a - c-client.a lrwxrwxrwx1 root root 19 6. Nov 23:31 /usr/lib/libc-client.so - libc-client.so.2001 -rw-r--r--1 root root 713800 24. Okt 05:31 /usr/lib/libc-client.so.2001 Configure command: ./configure --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql --localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info --mandir=/usr/share/man --enable-shared --with-libwrap --enable-assembler --with-berkeley-db --with-innodb --enable-static --enable-shared --with-raid --enable-thread-safe-client --without-readline --with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql --without-bench --with-client-ldflags=-lstdc++ --with-extra-charsets=all - 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
myodbc uses bash'ism and should not have #!/bin/sh
Description: The following output occures when using ASH as /bin/sh. Your script seems to rely on non-POSIX features from bash and therefore should be called with #!/bin/bash. This works. -=(~/debian/mysql/ODBC/myodbc2.50.37-2.50.37)$ ./configure creating cache ./config.cache checking for a BSD compatible install... /usr/bin/install -c checking whether build environment is sane... configure: error: ls -t appears to fail. Make sure there is not a broken alias in your environment configure: error: newly created file is older than distributed files! Check your system clock How-To-Repeat: use the smaller (but fully POSIX compliant) /bin/ash as /bin/sh Fix: start the configure script with #!/bin/bash Submitter-Id: submitter ID Originator:Christian Hammers Organization: Debian GNU/Linux MySQL support: none Synopsis: configure relys on bash but uses /bin/sh Severity: non-critical Priority: low Category: myodbc Class: sw-bug Release: myodbc-2.50.37 Server: /usr/bin/mysqladmin Ver 8.19 Distrib 3.23.37, for pc-linux-gnu on i586 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 3.23.37-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/run/mysqld/mysqld.sock Uptime: 5 min 51 sec Threads: 1 Questions: 1 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.003 Environment: System: Linux lathspell 2.4.2 #4 Don Feb 22 18:51:59 CET 2001 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20010319 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='-O2 -fomit-frame-pointer -g' CXX='g++' CXXFLAGS='-O2 -fomit-frame-pointer -g -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 14 17.04 20:05 /lib/libc.so.5 - libc.so.5.4.46 -rw-r--r--1 root root 567684 13.04 21:14 /lib/libc.so.5.4.46 lrwxrwxrwx1 root root 13 27.03 21:14 /lib/libc.so.6 - libc-2.2.2.so -rwxr-xr-x1 root root 1108076 13.04 16:15 /lib/libc-2.2.2.so -rw-r--r--1 root root 2526954 24.03 08:02 /usr/lib/libc.a -rw-r--r--1 root root 178 24.03 08:02 /usr/lib/libc.so -rw-r--r--1 root root 665260 01.09.2000 /usr/lib/libc-client.so.4.7 Configure command: ./configure --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql --localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info --mandir=/usr/share/man --enable-shared --with-libwrap --enable-assembler --with-berkeley-db --with-innodb --enable-static --enable-shared --with-raid --without-readline --with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql --without-bench --with-extra-charsets=all - 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
innobase expects interactive input when disk is full
Description: My disc was full when I tried to restart mysql. The error log filled up with: Innobase encountered a problem with file /var/lib/mysql/ib_logfile0. Disk is full. Try to clean the disk to free space before answering the following: How to continue? (Y == freed some space: try again) (N == crash the database: will restart it)? Innobase encountered a problem with file /var/lib/mysql/ib_logfile0. Disk is full. Try to clean the disk to free space before answering the following: How to continue? (Y == freed some space: try again) (N == crash the database: will restart it)? Not clever for a daemon process :) How-To-Repeat: see above Fix: output error to STDERR and quit with exit 1 Submitter-Id: submitter ID Originator:Christian Hammers Organization: Debian GNU/Linux MySQL support: none Synopsis: innodb expects interactive input when disc is full Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-3.23.37 (Source distribution) Environment: Debian GNU/Linux unstable System: Linux lathspell 2.4.2 #4 Don Feb 22 18:51:59 CET 2001 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20010319 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='-O2 -fomit-frame-pointer -g' CXX='g++' CXXFLAGS='-O2 -fomit-frame-pointer -g -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 14 17.04 20:05 /lib/libc.so.5 - libc.so.5.4.46 -rw-r--r--1 root root 567684 13.04 21:14 /lib/libc.so.5.4.46 lrwxrwxrwx1 root root 13 27.03 21:14 /lib/libc.so.6 - libc-2.2.2.so -rwxr-xr-x1 root root 1108076 13.04 16:15 /lib/libc-2.2.2.so -rw-r--r--1 root root 2526954 24.03 08:02 /usr/lib/libc.a -rw-r--r--1 root root 178 24.03 08:02 /usr/lib/libc.so -rw-r--r--1 root root 665260 01.09.2000 /usr/lib/libc-client.so.4.7 Configure command: ./configure --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql --localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info --mandir=/usr/share/man --enable-shared --with-libwrap --enable-assembler --with-berkeley-db --with-innodb --enable-static --enable-shared --with-raid --without-readline --with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql --without-bench --with-extra-charsets=all - 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
wrong dependency to db.h
Description: sql/Makefile.in has a dependency to ../bdb/build_unix/db.h at line 621. This file is not presence in mysql-3.23.37. How-To-Repeat: N/A Fix: delete the reference? Submitter-Id: submitter ID Originator:Christian Hammers Organization: Debian GNU/Linux distribution MySQL support: none Synopsis: wrong dependency to db.h in sql/Makefile.in Severity: non-critical Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.36 (Source distribution) Server: /usr/bin/mysqladmin Ver 8.18 Distrib 3.23.36, for pc-linux-gnu on i586 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 3.23.36-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/run/mysqld/mysqld.sock Uptime: 3 hours 2 min 32 sec Threads: 1 Questions: 1 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.000 Environment: System: Linux lathspell 2.4.2 #4 Don Feb 22 18:51:59 CET 2001 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20010319 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='-O2 -fomit-frame-pointer -g' CXX='g++' CXXFLAGS='-O2 -fomit-frame-pointer -g -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 14 17.04 20:05 /lib/libc.so.5 - libc.so.5.4.46 -rw-r--r--1 root root 567684 13.04 21:14 /lib/libc.so.5.4.46 lrwxrwxrwx1 root root 13 27.03 21:14 /lib/libc.so.6 - libc-2.2.2.so -rwxr-xr-x1 root root 1108076 13.04 16:15 /lib/libc-2.2.2.so -rw-r--r--1 root root 2526954 24.03 08:02 /usr/lib/libc.a -rw-r--r--1 root root 178 24.03 08:02 /usr/lib/libc.so -rw-r--r--1 root root 665260 01.09.2000 /usr/lib/libc-client.so.4.7 Configure command: ./configure --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql --localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info --mandir=/usr/share/man --enable-shared --with-libwrap --enable-assembler --with-berkeley-db --with-innobase --enable-static --enable-shared --with-raid --without-readline --with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql --without-bench --with-extra-charsets=all - 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
another bug in substring_index in conjunction with UDF functions?
Description:
My udf function and an equal udf function I found in the internet
seem to work well as does substring_index. Only when I call them
together I get a bug. As my function (quotet below) is so simple
that it doubtly has a bug I guess substring_index has one.
How-To-Repeat:
mysql select substring_index("1.2.3.4/24","/",1) ;
+-+
| substring_index("1.2.3.4/24","/",1) |
+-+
| 1.2.3.4 |
+-+
1 row in set (0.00 sec)
mysql select ewu_aton("1.2.3.4");
+-+
| ewu_aton("1.2.3.4") |
+-+
|16909060 |
+-+
1 row in set (0.01 sec)
mysql select ewu_aton( substring_index("1.2.3.4/24","/",1) );
+-+
| ewu_aton( substring_index("1.2.3.4/24","/",1) ) |
+-+
| 3772388104 |
+-+
1 row in set (0.00 sec)
Here the correct value should had been 16909060 (0x01020304), too!
My Function:
/*
** inet_aton()
*/
my_bool ewu_aton_init(UDF_INIT *initid, UDF_ARGS *args, char *message)
{
if (args-arg_count != 1 || args-arg_type[0] != STRING_RESULT)
{
strmov(message,"Wrong arguments to ewu_aton; Use the source!");
return 1;
}
initid-max_length=20;
initid-maybe_null=0;
return 0;
}
long long ewu_aton(UDF_INIT *initid, UDF_ARGS *args,
char *is_null, char *error)
{
struct in_addrin;
inet_aton(((char*) args-args[0]), in);
*is_null=0;
return htonl(in.s_addr);
}
Fix:
I'd wish I'd have one :-)
Submitter-Id: submitter ID
Originator:Christian Hammers
Organization: WESTEND GmbH
MySQL support: none
Synopsis: substring_index bug with udf function
Severity: serious
Priority: medium
Category: mysql
Class: sw-bug
Release: mysql-3.23.30-gamma (Source distribution)
Server: /usr/bin/mysqladmin Ver 8.13 Distrib 3.23.30-gamma, for pc-linux-gnu on i586
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 3.23.30-gamma and 3.21.30
Protocol version10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 5 days 17 hours 34 min 27 sec
Threads: 3 Questions: 128800303 Slow queries: 1299 Opens: 260 Flush tables: 1
Open tables: 48 Queries per second avg: 260.062
Environment:
Testet on two different i386 architecture machins running with two
versions of Debian GNU/Linux (an old and the latest)
System: Linux han 2.4.0-test12 #1 Fre Dez 22 15:58:55 CET 2000 i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/local/pgcc/lib/gcc-lib/i686-pc-linux-gnu/pgcc-2.95.2/specs
gcc version pgcc-2.95.2 19991024 (release)
Compilation info: CC='gcc' CFLAGS='-O2 -fomit-frame-pointer -g' CXX='g++'
CXXFLAGS='-O2 -fomit-frame-pointer -g -felide-constructors -fno-exceptions -fno-rtti'
LDFLAGS=''
LIBC:
lrwxrwxrwx1 root root 13 Jan 19 09:25 /lib/libc.so.6 - libc-2.2.1.so
-rwxr-xr-x1 root root 1078540 Jan 14 07:51 /lib/libc-2.2.1.so
-rw-r--r--1 root root 2471916 Jan 14 07:53 /usr/lib/libc.a
-rw-r--r--1 root root 178 Jan 14 07:53 /usr/lib/libc.so
-rw-r--r--1 root root 2024202 Sep 6 15:18 /usr/lib/libc-client.a
-rw-r--r--1 root root 665260 Sep 6 15:18 /usr/lib/libc-client.so
-rw-r--r--1 root root 665260 Sep 6 15:18 /usr/lib/libc-client.so.4.7
Configure command: ./configure --prefix=/usr --exec-prefix=/usr
--libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql
--localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info
--mandir=/usr/share/man --enable-shared --with-libwrap --enable-assembler
--with-berkeley-db-includes=/home/ch/debian/mysql/mysql-3.23.30/debian/db-3.2.3g/build_unix
--with-berkeley-db-libs=/home/ch/debian/mysql/mysql-3.23.30/debian/db-3.2.3g/build_unix
--enable-static --enable-shared --with-raid
--with-unix-socket-path=/var
