Re: Re:

2001-06-14 Thread Whit Blauvelt
d and you then run configure, check the Makefile and see if -lz has found its way in. If not, the installation docs give some sample manual gcc lines, adding -lz to that would do it. Not sure where it belongs in the Makefile if you're trying to use make to compile. Whit On Wed, Jun 13, 2001 at 09:1

Re: Daemon crashing (I'm going nuts here)

2001-06-13 Thread Whit Blauvelt
em running 3.23.37, so it's probably a new bug - but then the *.37 system is running from the binary tar, while the *.38 is from the official RPM, which you're also using. Whit On Wed, Jun 13, 2001 at 11:48:36AM -0400, Walker, Brian wrote: > Here is what happens: > > [root@www

Anyone have stunnel MySQL replication running with _current_ MySQL?

2001-06-13 Thread Whit Blauvelt
plication resumed in log 'FIRST' at position 4 010613 12:04:45 Error reading packet from server: Binary log is not open (read_errno 0,server_errno=2000) - This when I know the binary log is open and being written to on the master. Whit --

Re: mysql and php3

2001-06-13 Thread Whit Blauvelt
/var/lib/mysql/mysql.sock" to php.ini (at least for PHP4) - or you could just set up a symlink from /tmp/mysql.sock (which you might have to recreate on reboot if your system flushes /tmp), or you can specify where mysql.sock will go in my.cnf. Whit On Wed, Jun 13, 2001 at 02:13:31PM -05

Re:

2001-06-13 Thread Whit Blauvelt
Even if you have the zlib library, you may have to add the flag for it manually - it's not properly found by the configure routine as of 3.23.37, at least on Debian Linux 2.2. On Wed, Jun 13, 2001 at 03:11:42PM +0300, Sinisa Milivojevic wrote: > [EMAIL PROTECTED] writes: > > >Description: > > Una

Re: how to install mysql replication ?

2001-06-13 Thread Whit Blauvelt
l. The pretense that questioning its scripture is bad faith is not really in the long-term shared interest of making MySQL a thoroughly superior solution, IMHO. Whit - Before posting, please check: http://www.mysql.com/manual.php (t

Re: Re: how to install mysql replication ?

2001-06-12 Thread Whit Blauvelt
to hear reports that the current version of replication is working in the field. Had it working fine between 3.23.27 master and slave for many months, but it underwent an improvement at 3.23.29, they say. Whit - Before posting, pl

Re: Replication still not working

2001-06-12 Thread Whit Blauvelt
is not open" is an odd report, unless the log can be open for writing when not for reading. Ideas? Is it time for a formal bug report? Thanks, Whit - Before posting, please check: http://www.mysql.com/manual.p

Re: How to upgrade MySQL without breaking PHP/Apache?

2001-06-12 Thread Whit Blauvelt
Think you're right, but I've hundreds of mysql_connects on the server. The php.ini trick did it though. Thanks. Whit On Tue, Jun 12, 2001 at 04:32:10PM -0500, Joe Stump wrote: > You can also put this in your mysql_connect ... check out the syntax for it > but I believe

Re: How to upgrade MySQL without breaking PHP/Apache?

2001-06-12 Thread Whit Blauvelt
when there's less traffic on the server. Since I didn't have this set in either my.cnf or php.ini at all, I guess MySQL decided to change the default location of the file from /tmp. Whit - Before posting, pleas

How to upgrade MySQL without breaking PHP/Apache?

2001-06-11 Thread Whit Blauvelt
ly dealt with in the documentation, if not avoided through clever programming and/or making sure the PHP team has early access to any interface changes coming along? Whit - Before posting, please check: http://www.mysql.com/manu

Okay, now the binary log is open and not open at same time

2001-06-11 Thread Whit Blauvelt
? Is there really some way the binary log can be open for writing but not for reading, or is the error message in error? Whit - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.co

Re: Installation help

2001-06-11 Thread Whit Blauvelt
ing up a gcc symlink, in case you have reason to switch back. Whit On Mon, Jun 11, 2001 at 12:23:03PM -0400, Bernd Prager wrote: > Hi, > > I downloaded the mysql-3.23.38 source rpm. > When I try to build it I get the error message: > > checking for gcc... egcs > checking w

Why would password not be recognized?

2001-06-11 Thread Whit Blauvelt
nal problem with the database use on the server though. Restarting both servers makes no difference. What am I missing? Whit - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Solved stunnel - replication still fails

2001-06-11 Thread Whit Blauvelt
emoving the master.info file so it would be recreated with the change. Same result though. I suppose I should upgrade MySQL on the slave, but upgrading MySQL usually brings its own problems, and these versions aren't that far apart. Whit --

stunnel problem - libwrap

2001-06-11 Thread Whit Blauvelt
ought it only applied to inet.d-invoked stuff, haven't run into problems with it before, kind of wish it wasn't there if it's going to be problematic like this - I've got good firewalls on both ends to worry about what connects to what. Whit

Re: PHP Prob contd.

2001-06-10 Thread Whit Blauvelt
sult resource in >c:\inetpub\wwwroot/php/X-TopSites/admin/admin.php on line 11 > You have an error in your SQL syntax near 'from sitesats where validated = '1'' at >line 1 > What could be wrong now? Get rit if the comma a

Re: Solved last Q, now to stunnel problem

2001-06-10 Thread Whit Blauvelt
nfo and restarting the slave server doesn't fix it. And it gets recreated on startup exactly the same as before. Whit - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mys

Re: Another PHP/MySQL question

2001-06-10 Thread Whit Blauvelt
On Sun, Jun 10, 2001 at 07:13:01PM -0700, Vladimir Kravtsov wrote: > $sql = "select id, siteurl, sitename, from sitesats where validated = "$validated""; >// Line 8 Actually, using '$validated' might w

Re: Another PHP/MySQL question

2001-06-10 Thread Whit Blauvelt
On Sun, Jun 10, 2001 at 07:13:01PM -0700, Vladimir Kravtsov wrote: > $sql = "select id, siteurl, sitename, from sitesats where validated = "$validated""; >// Line 8 > What's wrong here? Try \"$validated\" -

Re: Solved last Q, now to stunnel problem

2001-06-10 Thread Whit Blauvelt
'll try removing the file, like the docs say not to unless you really know what you're doing, which IMHO you don't if you're depending on the docs. (But you have to love it once it's running right.) Whit -

Solved last Q, now to stunnel problem

2001-06-10 Thread Whit Blauvelt
s in the same way as when it was working before. If I do a "show processlist" on the slave server I see: "waiting to reconnect after a failed read". Is there some change between 3.23.27 and 3.23.37 that breaks stunnel port forwarding? Whit ---

zlib seems missing from static libraries in binary distro

2001-05-10 Thread whit
>Description: Your tar binary distribution mysql-3.23.37-pc-linux-gnu-i686.tar.gz does not work for compiling proftpd (unless and -lz is added in proftpd's Make.rules) because of references to 'compress' and 'uncompress' in mysqlclient where those functions aren't found. The same failure happens