SSL binaries
Anybody have a clue as to when we will see openssl binaries The mysql folks state:For maximum stability and performance, we recommend that you use the binaries we provide. I would love to play with this feature, but am not sure I want to go through the trouble of compiling with source. mysql,sql,database -- Michael Eklund [EMAIL PROTECTED] Keynote Systems -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql SSL Binaries Availability
I saw a message in November that said they would be out any time now. Any news on if they are available and in what forms are they available (tar.gz RPM, etc). Thanks, (mysql, sql, database) -- Michael Eklund [EMAIL PROTECTED] Netmechanic, Inc - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Show slave/master status permissions
What are the chances that mysql in the future will allow someone other then a user with process privileges to check the status of the master and or slaves. I would like to write a script to monitor this, but I dont want to put a script out there with process privileges. Thanks, Mike - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Repost: Show slave status permissions
What permissions do you need to have to issue a show slave status command? Thanks, database,sql,query,table -- Michael Eklund System Administrator Netmechanic, Inc. [EMAIL PROTECTED] http://www.netmechanic.com - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Show slave status permissions
What permissions do you need to have to issue a show slave status command? Thanks, database,sql,query,table -- Michael Eklund System Administrator Netmechanic, Inc. [EMAIL PROTECTED] http://www.netmechanic.com - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication problems involving time
Also my master.info ends up being wrong whenever the server is rebooted. (binlog.100 becomes binlog.100\n). Can you expand on that problem a bit? When I do a show slave status before a reboot I have this: +-+-+-+---+-+--+---+-+-+ | Master_Host | Master_User | Master_Port | Connect_retry | Log_File| Pos | Slave_Running | Replicate_do_db | Replicate_ignore_db | +-+-+-+---+-+--+---+-+-+ | db_server | repl| 3306| 0 | db1-bin.200 | 18378935 | Yes | | | +-+-+-+---+-+--+---+-+-+ After a reboot I will have something like this: +-+-+-+---+-+--+---+-+-+ | Master_Host | Master_User | Master_Port | Connect_retry | Log_File| Pos | Slave_Running | Replicate_do_db | Replicate_ignore_db | +-+-+-+---+-+--+---+-+-+ | db_server | repl| 3306| 0 | db1-bin.200 | 18378935 | Yes | | | +-+-+-+---+-+--+---+-+-+ And it will not replicate because it has a carriage return after the file name, and says it cannot find the file. Mike sql,mysql - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication problems involving time
Am I the only one that thinks that mysql ought to replicate NOW, CURRENT_DATE, etc. as the time when those actual inserts happened not as NOW,CURRENT_DATE,etc. If you are replicating accross a distance (12,15,20 hops) and there is a connectivity problem, then you end up with data that is out of sync. Also my master.info ends up being wrong whenever the server is rebooted. (binlog.100 becomes binlog.100\n). Thanks, Mike Eklund DB Admin Netmechanic, Inc [EMAIL PROTECTED] http://www.netmechanic.com - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Insert queries add TWO records to database
We saw a problem simlar to this caused by a browser add-on.
I believe flyswat was behind it, but it was that quickclick
browser add on that one of the tv networks is pushing.
Mike
On Wed, 4 Jul 2001 11:27:24 -0500
Rob Donat [EMAIL PROTECTED] wrote:
Thanks for the note, I will determine if this applies to
our situation.
However I believe I found the solution to my problems to
be apache related.
I found that after upgrading to apache 1.3.20, MANY of
our web server
requests were duplicated some times tripled when using
IE 5.5 (and
presumably others, but not telnetting straight to port
80). This meant that
the page would be loaded twice per actual request. This
was a problem
evident in the apache access_log (2 page executions per
refresh) whether
or not I hit the database (so possibly related to php but
not to database
(sybase) connectivity/functionality). I did not test
this with non-php
pages. This problem immediately went away when going
back to apache 1.3.9
which is where we were at before upgrading to php4.
Apache support states
it is not a bug with apache, but with IE hasn't done
anything about it.
As for the mention below, I don't see the original code
you're referencing,
but I don't see why that would run twice. The first
statement places the
return value of the mysql_query command into the variable
$res_insert_campaign -- NOT the entire executable
command of
mysql_query($sql,$conn). If later one evaluates that
variable (if
!$res_insert_campaign), there is no possibility it would
re-run that
command, since $res_insert_campaign, is a SCALAR
VARIABLE, not something
which knows anything about your mysql_query call. I
think the double-row
insertion problems people are experiencing are due to the
double-running of
each php command due to this odd apache issue.
Thanks,
Rob.
-Original Message-
From: Sebastiaan J.A. Kamp [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 04, 2001 6:21 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Insert queries add TWO records to database
It's more of a PHP than a MySQL 'problem' certainly
not a MySQL bug,
but...
Upon processing $res_insert_campaign=mysql_query($sql,$conn);
the script
will insert a line into your database.
Then, upon evaluating if (!$res_insert_campaign) { it
will do if
(!mysql_query($sql,$conn)) and insert another line...
Try being less 'indirect' about what you want:
$sql = INSERT INTO Campaign
(CampaignName,CampaignDesc,StartDate,EndDate,CompanyId,CampaignStatus,Admini
stratorId) VALUES
('$name','$desc','$start_date','$end_date',$company_id,0,1);
if (!mysql_query($sql,$conn);) {
return false;
}
Regards,
Sebastiaan J.A. Kamp
Operating system: WinNT4
PHP version: 4.0.6
PHP Bug Type: MySQL related
Bug description: Insert queries add TWO records to
database
All my insert queries seem to add two records to the
database instead of
one.
I was using MS Access 2000 and did not have the
problem. I am now using
MySQL and all insert queries add 2 recs?!
[...CUT...]
A guy in the US seems to be having the same problem
with Sybase. His
details are:
Rob Donat
Sedonatech, Inc.
1735 W. Diversey Suite 521
Chicago, IL 60614
[EMAIL PROTECTED]
312-501-1200 cell
773-388-0271(2) office(fax)
-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication out of sync
Actually, in my humble opinion, autoincrements need to have a host component, so each autoincrement is unique on each machine. Also you could have the master negotiate discrepencies, but this is far more complicated. Mike On Wed, 6 Jun 2001 12:25:16 +0200 Warren van der Merwe [EMAIL PROTECTED] wrote: Okay, do not do this. When your replication takes place, Site A adjusts Site B autoincrement number. ANd so this principle does not work! I really think this replication could be very good if you could specify not to replicate a particular column, or some better way of handling auto numbering. Comments from the MYSQL dev team? ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] ]On Behalf Of Warren van der Merwe Sent: 06 June 2001 11:11 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Replication out of sync Hi Well, what I did was dump my structure to file, then I went an manually added a line to the end of each table saying AUTO_INCREMENT=1 for Site A, Site B was set to 2 and so on, obviously there is a chance one day of Site A's auto_increment reaching 2 but it won't happen for many many many years in my environment. Regards ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 -Original Message- From: Michael Eklund [mailto:[EMAIL PROTECTED]] Sent: 05 June 2001 23:18 To: [EMAIL PROTECTED]; 'Warren van der Merwe' Subject: RE: Replication out of sync How did you work out the auto-ids on different servers issue? Mike -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 2:16 PM To: Warren van der Merwe Cc: [EMAIL PROTECTED] Subject: Re: Replication out of sync On Mon, Jun 04, 2001 at 05:45:44PM +0200, Warren van der Merwe wrote: Hello Firstly, big thank you to all who helped me get my replication going. When I was playing around, I managed to get one of my table out of sync, on the one server I have 8 records and on the other 9. I know exactly what happened, it was when server B was not replicating to the correct address. Now the question is, what is the easiest way of getting them in sync? Do I delete the table from the one server reload it? Run a LOAD TABLE table FROM MASTER on the slave to bring an updated copy of the table to the slave. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 11 days, processed 68,268,148 queries (71/sec. avg) - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Nulls appear not be respected
query should be: select user_id,screen_name,password,last_visit, second_to_last_visit from users where last_visit IS NULL; Just an sql-ism Mike -Original Message- From: Mark Stosberg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 2:18 PM To: [EMAIL PROTECTED] Subject: Nulls appear not be respected I'm using MySQL 3.23.32 and having trouble selecting values where a column is null. Any help is appreciated. An example is below: I need to get the rows where the last_visit column in the users table is NULL. I can see that there are some with this select statement: (last_visit is a date field) mysql select user_id,screen_name,last_visit, second_to_last_visit from users; +-+-++--+ | user_id | screen_name | last_visit | second_to_last_visit | +-+-++--+ | 1 | xx-fake | NULL | NULL | | 2 | xx-fake | NULL | NULL | | 3 | x-admin | 2001-05-24 | 2001-05-07 | | 4 | -admin | 2001-05-08 | 2001-05-07 | | 5 | x-admin | 2001-03-23 | 2001-03-21 | However, if I ask for the rows where last_visit = NULL, it says there are not any! : mysql select user_id,screen_name,password,last_visit, second_to_last_visit from users where last_visit = NULL; Empty set (0.00 sec) Ideas? Below is some more information about my environment. Thanks! -mark Release: mysql-3.22.32 (TCX binary) Environment: machine, os, target, libraries (multiple lines) System: SunOS sun01101.dn.net 5.6 Generic_105181-19 sun4u sparc SUNW,UltraSPARC-IIi-Engine Architecture: sun4 Some paths: /bin/perl /usr/ccs/bin/make /usr/local/bin/gmake /usr/local/bin/gcc /usr/ucb/cc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.6/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='-O3 -fomit-frame-pointer' CXX='gcc' CXXFLAGS='-O3 -fomit- frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=TCX binary' --with-low-memory --disable-shared Perl: This is perl, version 5.005_03 built for sun4-solaris - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Replication out of sync
How did you work out the auto-ids on different servers issue? Mike -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 2:16 PM To: Warren van der Merwe Cc: [EMAIL PROTECTED] Subject: Re: Replication out of sync On Mon, Jun 04, 2001 at 05:45:44PM +0200, Warren van der Merwe wrote: Hello Firstly, big thank you to all who helped me get my replication going. When I was playing around, I managed to get one of my table out of sync, on the one server I have 8 records and on the other 9. I know exactly what happened, it was when server B was not replicating to the correct address. Now the question is, what is the easiest way of getting them in sync? Do I delete the table from the one server reload it? Run a LOAD TABLE table FROM MASTER on the slave to bring an updated copy of the table to the slave. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 11 days, processed 68,268,148 queries (71/sec. avg) - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
