[imp] Trying to logon to IMP

[Mark Worsdall]

Hi All,


>> >Running:
>> >
>> >FreeBSD 4.5
>> >Apache  1.3.19
>> >PHP     4.3.1
>> >Horde:  2.2.1
>> >IMP     3.2.1

mysql server 3.23.41

[snip]

>
>
>I had the same problem, and it was a password to configure for the MySQL
>database (you did not tell us that you installed MySQL). I solve my
>problem after changing the password in the following file:
>/var/www/html/horde/config/horde.php with the same password I configured
>during the installation of MySQL on my Red Hat 8

That was the very first thing I changed on installation of the new IMP.

To verify all s well I did:

mysql -uhordemgr -p

with correct password and all is well.

show tables;
+------------------+
| Tables_in_horde  |
+------------------+
| horde_categories |
| horde_prefs      |
| horde_users      |
+------------------+
3 rows in set (0.00 sec)


  describe horde_categories;
+---------------------+---------------+------+-----+---------+-------+
| Field               | Type          | Null | Key | Default | Extra |
+---------------------+---------------+------+-----+---------+-------+
| category_id         | int(11)       |      | PRI | 0       |       |
| group_uid           | varchar(255)  |      | MUL |         |       |
| user_uid            | varchar(255)  |      | MUL |         |       |
| category_name       | varchar(255)  |      | MUL |         |       |
| category_parents    | varchar(255)  |      |     |         |       |
| category_data       | text          | YES  |     | NULL    |       |
| category_serialized | smallint(6)   |      | MUL | 0       |       |
| category_updated    | timestamp(14) | YES  |     | NULL    |       |
+---------------------+---------------+------+-----+---------+-------+
8 rows in set (0.00 sec)

select * from horde_categories;
Empty set (0.00 sec)


describe horde_prefs;
+------------+--------------+------+-----+---------+-------+
| Field      | Type         | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+-------+
| pref_uid   | varchar(255) |      | PRI |         |       |
| pref_scope | varchar(16)  |      | PRI |         |       |
| pref_name  | varchar(32)  |      | PRI |         |       |
| pref_value | longtext     | YES  |     | NULL    |       |
+------------+--------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

select * from horde_prefs;
+-----------------+------------+------------+------------+
| pref_uid        | pref_scope | pref_name  | pref_value |
+-----------------+------------+------------+------------+
| smitha          | imp        | last_login | 1050093630 |
| smitha at DorisDay | imp        | last_login | 1050413273 |
+-----------------+------------+------------+------------+
2 rows in set (0.00 sec)



describe horde_users;
+-----------+--------------+------+-----+---------+-------+
| Field     | Type         | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+-------+
| user_uid  | varchar(255) |      | PRI |         |       |
| user_pass | varchar(32)  |      |     |         |       |
+-----------+--------------+------+-----+---------+-------+
2 rows in set (0.00 sec)


select * from horde_users;
Empty set (0.00 sec)


So I wiped all records from horde_prefs

This, as I thought made no difference to the logon failure.


So to recap on my settings:-


in file /horde/imp/config/servers.php

$servers['imap'] = array(
     'name' => 'IMAP Server',
     'server' => 'imap.hinwick.co.uk',
     'protocol' => 'imap',
     'port' => 143,
     'folders' => 'Mail/',
     'namespace' => '',
     'maildomain' => 'hinwick.demon.co.uk',
     'smtphost' => 'smtp.hinwick.co.uk',
     'realm' => 'DorisDay',
     'preferred' => ''
);


/horde/config/horde.php

$conf['debug_level'] = E_ALL;
$conf['max_exec_time'] = 0;
$conf['session_name'] = 'Horde';
$conf['cache_limiter'] = 'nocache';
$conf['session_timeout'] = 0;
$conf['use_ssl'] = 0;
$conf['compress_pages'] = true;
$conf['umask'] = 077;
$conf['tmpdir'] = null;

$conf['auth']['driver'] = 'imap';
$conf['auth']['params'] = array();
$conf['auth']['params']['dsn'] = '{imap.hinwick.co.uk:143/imap}INBOX';


$conf['prefs']['driver'] = 'sql';
$conf['prefs']['params'] = array();

$conf['prefs']['params']['phptype'] = 'mysql';
$conf['prefs']['params']['hostspec'] = 'localhost';
$conf['prefs']['params']['username'] = 'hordemgr';
$conf['prefs']['params']['password'] = 'XXXXXXXX';
$conf['prefs']['params']['database'] = 'horde';
$conf['prefs']['params']['table'] = 'horde_prefs';


these are left uncommented:-

// Database or other drivers might require configuration parameters
// here.
// $conf['sessionhandler']['params'] = array();
// $conf['sessionhandler']['params']['phptype'] = 'mysql';
// $conf['sessionhandler']['params']['hostspec'] = 'localhost';
// $conf['sessionhandler']['params']['username'] = 'horde';
// $conf['sessionhandler']['params']['password'] = '*****';
// $conf['sessionhandler']['params']['database'] = 'horde';

Is this the problem?

I am unsure about settings in /usr/local/etc/php.ini but using test.php 
and index.php all reports to be ok.
M.

-- 
Mark Worsdall
https://www.paypal.com/refer/pal=LS79YHQ9VUGLJ