Re: how mysql sends its data to clients.
I do have ssl compiled in but I just want to compare the ssl connection with the regular connection to make sure that I'm actually encrypting the data. call me paranoid. thanks, craig. Egor Egorov wrote: Craig Harding [EMAIL PROTECTED] wrote: MySQL protocol is a binary protocol. Still it's not encrypted and data could be sniffed. Use MySQL-Max and SSL connections to encrypt data in protocol. I'm wondering how mysql actually sends its data to a mysql client? Is it binary data or plain text or encrypted with some general function? When I use ethereal to capture the packets all I can see is anything but plain text. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
how mysql sends its data to clients.
I'm wondering how mysql actually sends its data to a mysql client? Is it binary data or plain text or encrypted with some general function? When I use ethereal to capture the packets all I can see is anything but plain text. Thanks, Craig. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL not finidng openssl/opensslv.h
No one else has had this problem? Just wondering if this may be a bug in the configure script... craig. Craig Harding wrote: I'm configuring mysql-4.0.20 source and I have openssl (OpenSSL 0.9.7d 17 Mar 2004) installed in /usr/local/ssl (default) Below is the output from a make after configuring as follows: ./configure --prefix=/usr/local/mysql --with-openssl I also tried --with-openssl --with-openssl-includes=/usr/local/ssl/include/ --with-openssl-libs=/usr/local/ssl/lib/ and it breaks at the same point. When it's configuring and spurting out the output it does find OpenSSL: checking for OpenSSL... yes Any other people in the same boat? I've checked online and some other people have had the same issue and putting -I/usr/local/ssl/include in the path seems to work but shouldn't this work from the configure command? thanks, craig. - Making all in strings make[2]: Entering directory `/usr/src/mysql-4.0.20/strings' if gcc -DHAVE_CONFIG_H -I. -I. -I.. -I./../include -I../include-O3 -DDBUG_OFF -MT strxmov.o -MD -MP -MF .deps/strxmov.Tpo \ -c -o strxmov.o `test -f 'strxmov.c' || echo './'`strxmov.c; \ then mv -f .deps/strxmov.Tpo .deps/strxmov.Po; \ else rm -f .deps/strxmov.Tpo; exit 1; \ fi In file included from strxmov.c:33: ../include/my_global.h:1129:30: openssl/opensslv.h: No such file or directory make[2]: *** [strxmov.o] Error 1 make[2]: Leaving directory `/usr/src/mysql-4.0.20/strings' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/src/mysql-4.0.20' make: *** [all] Error 2 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL not finidng openssl/opensslv.h
I'm configuring mysql-4.0.20 source and I have openssl (OpenSSL 0.9.7d 17 Mar 2004) installed in /usr/local/ssl (default) Below is the output from a make after configuring as follows: ./configure --prefix=/usr/local/mysql --with-openssl I also tried --with-openssl --with-openssl-includes=/usr/local/ssl/include/ --with-openssl-libs=/usr/local/ssl/lib/ and it breaks at the same point. When it's configuring and spurting out the output it does find OpenSSL: checking for OpenSSL... yes Any other people in the same boat? I've checked online and some other people have had the same issue and putting -I/usr/local/ssl/include in the path seems to work but shouldn't this work from the configure command? thanks, craig. - Making all in strings make[2]: Entering directory `/usr/src/mysql-4.0.20/strings' if gcc -DHAVE_CONFIG_H -I. -I. -I.. -I./../include -I../include-O3 -DDBUG_OFF -MT strxmov.o -MD -MP -MF .deps/strxmov.Tpo \ -c -o strxmov.o `test -f 'strxmov.c' || echo './'`strxmov.c; \ then mv -f .deps/strxmov.Tpo .deps/strxmov.Po; \ else rm -f .deps/strxmov.Tpo; exit 1; \ fi In file included from strxmov.c:33: ../include/my_global.h:1129:30: openssl/opensslv.h: No such file or directory make[2]: *** [strxmov.o] Error 1 make[2]: Leaving directory `/usr/src/mysql-4.0.20/strings' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/src/mysql-4.0.20' make: *** [all] Error 2 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
question.
I have a table (menus) with the following fields: TABLE: MENUS id int(11) url varchar(100) items varchar(35) An example row: ID URL ITEMS 158 programs/graduate 21,22,23,24,25,26,27,28,160 I want to select the ITEMS and then do another subselect that can uses each ITEM as the ID in the subselect. 'select items from menus where id = 158' returns: 21,22,23,24,25,26,27,28,160 Each of these ITEMS is an id in the table also. I want to get each row that corresponds to id = 21, 22, 23, 24, 25 ... I know how to do this in php, but I need to do this on the command line. Remember that ITEMS is a varchar type, so I'm not sure if there's a way to do some kind of loop within this to select the items or create the long query string with OR id = 21 OR id = 22 OR id = 23 ... which I started to do: select CONCAT('id = ', substring(items,1,LOCATE(',', items, 1)-1), ' OR id = ', substring(items, 4,locate(',', items,2)-1)) AS STR from menus where items != '' and id = 158; but this can be pretty long since it only grabs the first two digits from ITEMS! The ITEMS always has NO spaces between commas and numbers and some numbers may be single digit, two digits or even three in the row. thanks in advance, craig. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
search and replace.
Is there is a way to do a search and replace on the mysql cmd prompt? I want to replace text in about 20 rows that has the same pattern with a replacement. I have a table that has a column 'name' and a column 'url' which holds menu items for a website. Both columns are type varchar. 'url' has about 20 rows starting with 'disciplines/someurl' and I want to replace 'disciplines' with 'programs'. Is there a way to do this in mysql? I know I can do it in php, but it would be cool to do it, (and probably faster) to do it in mysql. I know how do use the regexp for SEARCHING, but can I do a replace on the same cmd with an UPDATE? thanks in advance, Craig. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]