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 fr

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: J

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 @fo

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 func

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 qu

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: --- mysql-dfsg-3.23

[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
est_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 Mak

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 debcon

Missing -lwrap on mysqld/mysqltest?

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

[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-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 debcon

Missing -lwrap on mysqld/mysqltest?

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

[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

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 debcon

Missing -lwrap on mysqld/mysqltest?

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

[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

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 debcon

Missing -lwrap on mysqld/mysqltest?

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

[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

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 debcon

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 th

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 @ ravi-expor

compile problem with 3.23.50

2002-04-23 Thread ch
sr/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 director

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 2

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 creatin

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 t

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: >Originator:Christian Hammers >Organization: Debian GNU/L

another bug in substring_index in conjunction with UDF functions?

2001-02-06 Thread ch
t.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/sha