triggers

2007-04-11 Thread ch h
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

The x509 cert issuer seems not to be checked against the CA

2003-03-31 Thread ch
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

Error in docs: X509 format for 4.x SSL ACL

2003-03-30 Thread ch
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

info-dir-section element missing in .texi (4.0.10)

2003-02-12 Thread ch
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

mysqldump --allow-keywords has no effect. Alias for -Q?

2003-02-01 Thread ch
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

[patch] for 4.0.9 Makefile (my_inet_ntoa reference)

2003-01-29 Thread ch
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

Re: help with query

2003-01-14 Thread CH Tsang
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

mysqlhotcopy should suggest ~/.my.cnf instead of --password

2002-12-23 Thread ch
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: ---

Docs make wrong statement about Debians init scripts

2002-12-22 Thread ch
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.

[patch] Error in Makefile prevents complete distclean

2002-12-22 Thread ch
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

Missing -lwrap on mysqld/mysqltest?

2002-12-22 Thread ch
' ... 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

Docs make wrong statement about Debians init scripts

2002-12-22 Thread ch
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.

Missing -lwrap on mysqld/mysqltest?

2002-12-22 Thread ch
' ... 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

[patch] Error in Makefile prevents complete distclean

2002-12-22 Thread ch
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

Docs make wrong statement about Debians init scripts

2002-12-21 Thread ch
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.

[patch] Error in Makefile prevents complete distclean

2002-12-21 Thread ch
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

Missing -lwrap on mysqld/mysqltest?

2002-12-21 Thread ch
' ... 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

Docs make wrong statement about Debians init scripts

2002-12-21 Thread ch
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.

[patch] Error in Makefile prevents complete distclean

2002-12-21 Thread ch
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

Missing -lwrap on mysqld/mysqltest?

2002-12-21 Thread ch
' ... 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

Docs make wrong statement about Debians init scripts

2002-12-20 Thread ch
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.

[patch] Error in Makefile prevents complete distclean

2002-12-20 Thread ch
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

Missing -lwrap on mysqld/mysqltest?

2002-12-20 Thread ch
' ... 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

mysql down problem.

2002-11-04 Thread SB CH
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

Regarding Mysql4.0

2002-09-17 Thread ch kalyan
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 @

compile problem with 3.23.50

2002-04-23 Thread ch
*)' 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

patch: manpage safe_mysql(1)

2001-11-26 Thread ch
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

myodbc uses bash'ism and should not have #!/bin/sh

2001-04-28 Thread ch
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

innobase expects interactive input when disk is full

2001-04-23 Thread ch
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

wrong dependency to db.h

2001-04-21 Thread ch
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:

another bug in substring_index in conjunction with UDF functions?

2001-02-06 Thread ch
ecdir=/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/