Re: MySQL and OpenBSD 2.8/9

2001-09-05 Thread Derek Sivers
>I'm running OpenBSD 2.8 and MySQL 3.22.32 (recent cvs port). >After time (< 1day) the cpu load for the mysqld process goes up to 98%.. >There is a known problem in 2.8 thread library. I do not know >when will they fix it. You can ask them , though .. >I've seen that this has been addressed in th

NEW "MAKE" BUG? sigcontext.h

2001-04-02 Thread Derek Sivers
Doing a "make" on the newest MySQL stable 3.23.36 source tarball - on a stock Cobalt RaQ3 (Linux 386) which I've installed MySQL on many times before. Got this strange error: gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -I./../include -I./.. -I..-O6 -DDBUG_OFF -c readline.c In file include

MySQL problems on OpenBSD?

2001-01-28 Thread Derek Sivers
Running the standard (brand-new) OpenBSD install of MySQL from /usr/ports/databases/mysql/ Version 3.23.32 - the port that Brad made just a few days ago. No options. Just "make install". It works fine exceptI keep getting this error: ERROR 2006: MySQL server has gone away It comes back immed

PROJECT: for perl/sed/regex type...

2001-01-25 Thread Derek Sivers
More details if you're interested, but that's about it. The actual file is twice as big, but with no other surprises. (That's an actual example, above, just with some lines taken out.). Please reply by email, not to the whole list. Thanks! -- Derek Sivers [EMAIL PROTECTED]

PROJECT (for perl/sed/regex person)

2001-01-25 Thread Derek Sivers
E: Most fields are only one line, so the carriage return is the stopping point. But as you see there are just a few that have carriage returns, so on those we do "fieldname:" instead of "fieldname=" - then end it with "@END@" -- Derek Sivers, CD Baby [EMAIL PROT

Re: Undefined reference in libmysqlclient.a

2001-01-24 Thread Derek Sivers
>On RedHat there's no need to add "-lz" to the linker options, on Debian it >is (when using the statically libmyslclient.a). Is this a bug somewhere >in the makefile or anyways, should compress be in the .a lib or is it ought >to be added manually with -lz? Use -lz Read on: - THE PROBL

Re: Troubles installing MySQL-3.22.32

2001-01-24 Thread Derek Sivers
At 09:58 PM 1/23/01 , Manuel Leos wrote: >Hi everybody, I'm trying to install the RPM on a RH >7.0 everything looks normal but the server dies >sending this message >mysqld: Can't find file: 'host.ISM' (errno: 2) It's part of the first database/table that MySQL sets up for you. I get this error

PHP on Cobalt RaQ - general info

2001-01-24 Thread Derek Sivers
>Just a question of curiousity. Can you install PHP using tars files? >I was looking at purchasing a few servers last fall and when I looked at the >RAQ3/4 they (colbalt) told me that you could only install their stuff and >they didn't have new versions of MySQL and only PHP3. Yep! The Cobalts

Re: INSTALLATION QUESTION on Cobalt Raq3

2001-01-23 Thread Derek Sivers
Don't use RPM. The RPMs for the Cobalt RaQ3 suck. I have 8 different Cobalt RaQ3's and here's the way I've used to install: I've installed it this way successfully each time. Sounds like a bit of a pain, but puts you in much better control of MySQL. INSTALLATION INSTRUCTIONS #1 - down

Re: SECURITY issue in remote tcp/ip connecting?

2001-01-19 Thread Derek Sivers
> > Any measures I could take (like SSH) to encrypt the transaction? >Use CIPE tunnel. You can find it: >http://sites.inka.de/sites/bigred/devel/cipe.html Is this anything like ipsec? http://www.openbsd.org/faq/faq13.html (I'm using OpenBSD.) Or, rather, could I use ipsec for this same thing a

MySQL for Cobalt RaQ3 + INSTALLATION INSTRUCTIONS

2001-01-19 Thread Derek Sivers
At 11:39 AM 1/19/01 , you wrote: >Need some help. I need the RPM files for the Cobalt Rack 3. Any ideas. Don't use RPM. The RPMs for the Cobalt RaQ3 suck. I have 8 different Cobalt RaQ3's and here's the way I've used to install: I've installed it this way successfully each time. Sounds like a bi

SECURITY issue in remote tcp/ip connecting?

2001-01-19 Thread Derek Sivers
searched the lists & books & found no mention of this: Are there any security issues in doing lots of remote-connecting (TCP/IP) to my MySQL database server? (My Apache/PHP is on a different webserver from the MySQL server. And sometimes across the country.) Won't that password be somehow sn

TIPS for keeping MySQL on TCP/IP'd server from Apache?

2001-01-18 Thread Derek Sivers
this? -- Derek Sivers [EMAIL PROTECTED] - 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 PROTEC

keeping MySQL on a SEPARATE SERVER - lag time?

2001-01-16 Thread Derek Sivers
Has anyone done testing to show the difference between: #1 - having MySQL on the same server as Apache/PHP vs. #2 - having MySQL on its own dedicated computer, TCP/IP connected to the main Apache box NOTE: We use lots of little MySQL lookups in our PHP scripts. Nothing that intensive. Bu