Problem with replication
After much stress, I finally found the answer to my problem. Here is the error message that I was getting: 020322 11:54:29 Slave: Failed reading log event, reconnecting to retry, log 'bend149-bin.002' position 2407727 020322 11:54:29 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'bend149-bin.002' at position 2407727 020322 11:54:29 Slave: received 0 length packet from server, apparent master shutdown: (0) and the solution that I found was to make sure the all of the servers in the system, including the master db server, had unique server id's. it took me a while to realize that the master and one of the slaves had the same id. this is in part because we had to switch out the old master db and replace it with one of the slave machines and then built a new machine to take the place of the missing slave. This is just to help out the next person that comes across this problem. it took me a while to find the solution and I hope this makes their search much shorter. Jim Lucas www.bend.com sql, query, select, insert, update, replace, etc... is that enough... - 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: MySql 4.01 and libmysqlclient.so.10 - TEMP FIX
I would not recommend that. I completely messed up my RH 7.2 system when I tried to forced the MySQL install with 4.1. I had to reinstall the system to make it function right. There might have been an easier way to fix all the broken problems that I caused, but I couldn't. I just moved my data and reinstalled. It wasn't worth the time of trying to fix all the problems since an install can be done and have it up and running within 2 hours. Jim Lucas - Original Message - From: Land, Christopher [EMAIL PROTECTED] To: mySQL [EMAIL PROTECTED] Sent: Friday, March 01, 2002 1:52 PM Subject: RE: MySql 4.01 and libmysqlclient.so.10 - TEMP FIX Perhaps the rpm expects to perform a (forced) upgrade Ç: -Original Message- ... Your problem is because your new compile (or binary install) is expecting the layout previously used by mySQL v3. ... If anyone can offer us more, please do! LP I have installed MySql 3.23.49, PHP 4.06, and Apache 1.3.20 successfully on my RH 7.2 box. Now I try to install MySql 4.01 (after removing MySql 3.23.49) I get a Php-mysql.4.xx requires libmysqlclient.so.10. My attempt to install MySql 4.01 ends there. I did some reading and found that libmysqlclient.so.10 comes with MySql 3.23.xx. I surfed my directories to find that MySql 4.01 installs libmysqlclient.so.11 I installed theses packages using the RH RPM Manager. Am I missing something? - 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: need help debugging!
Try adding this to your mysql_query() function.
$search = mysql_query()
or die(ERROR: . mysql_error() . ( . mysql_errno(). ));
this will tell you whether or not the query is dieing for one reason or
another.
if it doesn't return the die() statement then you must assume that it was
successfull.
the best way to catch whether or not the result pointer is empty, is to run
a mysql_num_rows() on the pointer.
this will return to you the total number of rows returned by the select
statement.
if you wrap your while clause with an if statement and have the condition be
whether or not the returned value of the mysql_num_rows() is greater then
zero. upon failing, returning zero results, it will never run the while
loop, therefor never give you the error that it's tring to use an invalid
result pointer.
So, try this
?php
$db = mysql_connect(db30.pair.com, net3dual, rosevilleX1);
$db = mysql_select_db(rahs,$db);
$search = mysql_query(SELECT * FROM rahs) or die(ERROR: . mysql_error()
. ( . mysql_errno(). ));
if(mysql_num_rows($search))
{
while($num = mysql_fetch_array($search))
{
echo div align='center'
table border='0' cellpadding='0'
cellspacing='0' width=\40%\ align='center'
tr
td width=\70%\Name: .$num[name].
nbsp;nbsp;nbsp;nbsp; #.$num[number]./td
td width=\30%\Team:
.$num[team]./td
/tr
tr
td width=\100%\
colspan='2'Penalty.$num[penalty]./td
/tr
tr
td width=\50%\Groundballs:
.$num[groundballs]./td
td width=\50%\Shots:
.$num[shots]./td
/tr
tr
td width=\50%\Faceoffs Won:
.$num[faceoffs_won]./td
td width=\50%\Faceoffs Lost:
.$num[faceoffs_lost]./td
/tr
tr
td width=\100%\ colspan='2'p
align='center'Date .$num[date]./p/td
/tr
/table
/div;
}
} else {
die(didn't find any results);
}
?
- Original Message -
From: Alex Behrens [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, March 01, 2002 5:25 PM
Subject: need help debugging!
Hey All,
I am new to mysql and I need help debugging this peice of code for my
site:
?php
$db = mysql_connect(db30.pair.com, net3dual, rosevilleX1);
mysql_select_db(rahs,$db);
$search = mysql_query(SELECT * FROM rahs);
while($num=mysql_fetch_array($search)) {
printf (div align='center'centertable border='0' cellpadding='0'
cellspacing='0' width=\40%\trtd
width=\70%\Name:%snbsp;nbsp;nbsp;nbsp; #%s/tdtd
width=\30%\Team: %s/td/trtrtd width=\100%\
colspan='2'Penalty:
%s/td/trtrtd width=\50%\Groundballs: %s/tdtd
width=\50%\Shots: %s/td/trtrtd width=\50%\Faceoffs
Won:%s/tdtd width=\50%\Faceoffs Lost: %s/td/trtrtd
width=\100%\ colspan='2'p
align='center'Date:%s/td/tr/table/center/div,$num[name],$num[
number],$num[team],$num[penalty],$num[groundballs],$num[shots],$num
[faceoffs_won],$num[faceoffs_lost],$num[date]);
}
?
it says this error:
Warning: Supplied argument is not a valid MySQL result resource on line 17
line 17 would be this line:
while($num=mysql_fetch_array($search)) {
what is wrong with my code?
Thanks!
-Alex Big Al Behrens
E-mail: [EMAIL PROTECTED]
Urgent E-mail: [EMAIL PROTECTED] (Please be brief!)
Phone: 651-482-8779
Cell: 651-329-4187
Fax: 651-482-1391
ICQ: 3969599
Owner of the 3D-Unlimited Network:
http://www.3d-unlimited.com
Send News:
[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 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: Installing Mysql 4.0.1 on Redhat 7.2 with PHP 4.0.6
Is this what you had to do? If so, could you point me to a location on the web or in a book store to aquire knowledge on how to compile new software. I have only compiled one piece of software, Courier Mail Service. It was interesting! But, I feel that I would need a little more help with all the packages that i would have to recompile. Thanks Jim Lucas - Original Message - From: Trond Eivind Glomsrød [EMAIL PROTECTED] To: Jim Lucas [jimmysql] [EMAIL PROTECTED] Cc: Mysql [EMAIL PROTECTED] Sent: Thursday, January 24, 2002 6:35 AM Subject: Re: Installing Mysql 4.0.1 on Redhat 7.2 with PHP 4.0.6 On Wed, 23 Jan 2002, Jim Lucas [jimmysql] wrote: But I am installing all the apps from the RPM's that came from Redhat.com The apps coming from Red Hat Linux work together. You have downloaded and installed a different (development ) version of MySQL. It's not compatible with the old one. -- Trond Eivind Glomsrød Red Hat, 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
Installing Mysql 4.0.1 on Redhat 7.2 with PHP 4.0.6
When I tried installing MySQL 4.0.1 it said that I had conflicts. It listed the file libmysqlclient.so.10 as being needed by 5 different progs. [root@office2 RPMS]# rpm -Uvh MySQL-shared-4.0.1-2.i386.rpm error: failed dependencies: libmysqlclient.so.10 is needed by mod_auth_mysql-1.11-1 libmysqlclient.so.10 is needed by MyODBC-2.50.37-2 libmysqlclient.so.10 is needed by MySQL-python-0.9.0-2 libmysqlclient.so.10 is needed by perl-DBD-MySQL-1.2216-4 libmysqlclient.so.10 is needed by php-mysql-4.0.6-7 now, I went ahead an ran the command with the --nodeps option. now php doesn't know any mysql funciton commands. I tried reinstalling all my PHP stuff and when I got to php-mysql-4.0.6-7.i386.rpm I got this [root@office2 RPMS]# rpm -Uvh php-mysql-4.0.6-7.i386.rpm error: failed dependencies: libmysqlclient.so.10 is needed by php-mysql-4.0.6-7 I did some searching and come to find out. the file didn't exsist, but one called libmysqlclient.so.11 did. Shouldn't it recognize this as a newer file and use it instead, or am I missing something here? Has any body had this or a related problem. And if they did, please tell me if it is PHP problem or Mysql problem. Thanks in advance. Jim Lucas - 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
