Hi. I have installed qmail server on redhat. while configuration on global address book with below link:
http://wiki.qmailtoaster.com/index.p...l_Address_Book.
I am getting below error while running sqweb_gabook.sh script.
------------------------------------------------------------------------------------------------------
#Squirrelmail global address book updater...
PHP Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in /etc/qmailfile/sqweb_gabook.php on line 45
Global Address for hometest.com is available at /etc/qmailfile/hometest.com_gabook
Enter the fullpath using Squirrelmail config utility
select 6. Address Books option and configure address book in 3. Global file address book
More info:
http://www.squirrelmail.org/docs/adm...n-7.html#ss7.5
-----------------------------------------------------------------------------------
I have pasted sqweb_gabook.php script below:
$domainname="****";
// your domain table name inside vpopmail database
$tablename="***";
$username="****";
$password="******";
$database="****";
$hostname="localhost";
$filename=$domainname."_gabook";
$global_abook="/etc/qmailfile/".$filename;
// process
$handle = fopen($global_abook, 'a');
$conn = mysql_connect($hostname, $username, $password) or die ('Error
connecting to mysql');
mysql_select_db($database);
$query = "select pw_name,pw_gecos from $tablename";
$result = mysql_query($query);
while(list($email,$name) = mysql_fetch_row($result))
{
$data=$email."|".$name."||".$email."@".$domainname."|\n";
fwrite($handle, $data);
}
mysql_close($conn);
fclose($handle);
?>
.
All username and password of mysql are working fine.
Please let me know that changes need to be done.
Br,
pradeep
