Can not login with valid ID
imp@access-info.co.nz
imp@access-info.co.nz
Mon, 08 Oct 2001 14:27:08 -1100 (NZDT)
I built a server a couple of weeks ago and all went fine.
I had to rebuild it becuase of a new adsl modem and I AM SURE I did everything
the same as before, even gone over my notes, but now I can not login to imp
with a valid user name and passwd.
When I try it goes back to the login screen again and I have this message in a
log.
Oct 8 14:33:35 mail IMP[718]: FAILED 192.168.1.2 to mail.heathcotes.co.nz:143
as strider
So here is the default.php3 page, any ideas?
<?php
/* file: defaults.php3 */
/* setup.php3 by Jason "ZeroDiVide" Orcutt < zerodiv@atcjet.net > */
/* For debugging purposes */
$default->error_level = 15;
/* The longest that things like file uploads and slow functions */
/* should be allowed to run. 0 means run until termination */
/* (forever if infinite loop). */
/* NOTE: you can't set this to 0 if safe_mode is on. */
$default->max_execution_time = 0;
/* Server Specific Configuration */
$default->localhost = 'mail.heathcotes.co.nz';
/* Web Server Configuration */
$default->root_url = '/horde/imp';
$default->include_dir = './templates';
$default->graphics_url = '/horde/imp/graphics';
/* Default IMAP Server Configuration */
$default->server = 'mail.heathcotes.co.nz';
$default->from_server = 'heathcotes.co.nz';
$default->port = '143';
/* Default IMAP Folder Configuration */
$default->folders = 'mail/';
$default->use_imap_subscribe = true;
$default->show_dotfiles = false;
$default->save_sent_mail = true;
$default->sent_mail = 'sent-mail';
$default->postponed = 'drafts';
/* Ldap searching */
$default->use_ldap_search = true;
/* Server list : user is presented with a list */
/* of available imap servers */
$default->use_server_list = false;
/* User changeable items */
$default->user_change_server = false;
$default->user_change_folder = false;
$default->user_change_from = false;
$default->user_change_fullname = true;
$default->user_use_addressbook = true;
/* Check For New Mail Configuration */
$default->newmail_popup = true;
$default->refresh_delay = '300';
/* External Binaries Configuration */
$default->path_to_sendmail = '/usr/sbin/sendmail'; /* Sendm$
$default->path_to_ispell = ''; /* ISpell */
$default->path_to_mswordview = '/usr/bin/wvHtml'; /* M$WordView$
$default->path_to_tar = '/bin/tar'; /* Tar */
/* Cyrus Configuration */
$default->personal_folders = ''; /* i.e. INBOX. */
/* Default Language Configuration */
$default->language = 'en';
/* Message Configuration */
$default->append_header = true;
$default->append_trailer = false;
/* Text Viewing */
$default->text_parts_inline = true;
/* Database Configuration */
$default->use_db = true;
$default->database_driver = 'mysql';
$default->db_user_name = 'hordemgr';
$default->db_password = 'newpasswd';
$default->db_security_nag = true;
$default->db_name = 'horde';
$default->db_server_name = 'localhost';
$default->db_pref_table = 'imp_pref';
$default->db_address_table = 'imp_addr';
$default->db_connect_string = '';
$default->db_server_port = '';
$default->db_server_options = '';
$default->db_server_tty = '';
?>
>From jefft@wciatl.com Date: Sun, 7 Oct 2001 23:33:00 -0400
Return-Path: <jefft@wciatl.com>
Mailing-List: contact imp-help@lists.horde.org; run by ezmlm
Delivered-To: mailing list imp@lists.horde.org
Received: (qmail 10992 invoked from network); 8 Oct 2001 03:33:01 -0000
Received: from dsl027-171-204.atl1.dsl.speakeasy.net (HELO alpha.cesmail.net) (216.27.171.204)
by clark.horde.org with SMTP; 8 Oct 2001 03:33:01 -0000
Received: (qmail 11971 invoked by uid 99); 8 Oct 2001 03:33:00 -0000
Received: from 208.61.48.3 ( [208.61.48.3])
as user jeff@cesmail.net@alpha.cesmail.net by alpha.cesmail.net with HTTP;
Sun, 7 Oct 2001 23:33:00 -0400
Message-ID: <1002511980.3bc11e6c9f9ba@alpha.cesmail.net>
Date: Sun, 7 Oct 2001 23:33:00 -0400
From: Jeff Tucker <jefft@wciatl.com>
To: imp@lists.horde.org
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 2.3.7-cvs
X-Originating-IP: 208.61.48.3
Subject: Re: [imp] OPTIONS menu item missing?
Sorry for not copying any context here. Hopefully those who need to can figure
it out by the subject. I just subscribed to the list and read this email off
the archive.
I just fought my way through this problem last night. I am using the latest CVS
PHP and the latest CVS Horde and IMP. I was struggling with the fact that IMP
wouldn't write anything into my database. No matter what I was doing, the
database was getting queries but not ever getting any data.
I found what I believe to be a bug in even the latest CVS version of PEAR. It's
late, so I won't give exact file numbers here. But, basically, in a file which
ended up in my system in /usr/local/lib/php/DB/mysql.php is the "quote"
function. This function is supposed to quote strings passed to MySQL. If you
look at your MySQL logs, you'll probably find that the queries look fine,
except that none of the strings have quotes around them like they are supposed
to.
In the quote function is a line with something like:
$outstr = "'" . mysql_escape_string($str) . "'";
This doesn't work. You need to double the apostrophes to make them actually
work. The line should look like:
$outstr = "''" . mysql_escape_string($str) . "''";
Check your SQL logs and I'll bet the strings start having single quotes around
them. And your DB will start working.
Good luck. It was 3:00 a.m. when I figured this out. Maybe I can save some
others some work.
Jeff
--
Jeff Tucker
Williams Consulting, Inc.
jefft@wciatl.com
-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/
>From jefft@wciatl.com Date: Sun, 7 Oct 2001 23:36:51 -0400
Return-Path: <jefft@wciatl.com>
Mailing-List: contact imp-help@lists.horde.org; run by ezmlm
Delivered-To: mailing list imp@lists.horde.org
Received: (qmail 11928 invoked from network); 8 Oct 2001 03:36:52 -0000
Received: from dsl027-171-204.atl1.dsl.speakeasy.net (HELO alpha.cesmail.net) (216.27.171.204)
by clark.horde.org with SMTP; 8 Oct 2001 03:36:52 -0000
Received: (qmail 11986 invoked by uid 99); 8 Oct 2001 03:36:51 -0000
Received: from 208.61.48.3 ( [208.61.48.3])
as user jeff@cesmail.net@alpha.cesmail.net by alpha.cesmail.net with HTTP;
Sun, 7 Oct 2001 23:36:51 -0400
Message-ID: <1002512211.3bc11f5378733@alpha.cesmail.net>
Date: Sun, 7 Oct 2001 23:36:51 -0400
From: Jeff Tucker <jefft@wciatl.com>
To: imp@lists.horde.org
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 2.3.7-cvs
X-Originating-IP: 208.61.48.3
Subject: IMP 2.3 address books
Hi,
In IMP 2.3, is it possible to use simple per-user address books stored in the
MySQL database? This works great for me in 2.2, but in 2.3 when I go to Options
and then Address Books, I'm prompted to login again and this login always
fails. Do I have to have Turba running? I'd really prefer just a real simple
address book like 2.2 had.
Thanks
Jeff
--
Jeff Tucker
Williams Consulting, Inc.
jefft@wciatl.com
-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/