[imp] Composing Message

[Brent J. Nordquist]

On Wed, 13 Jun 2001, Taidus Toht <taidus@bns.ee> wrote:

> What for is there port?

It's fine for that to be blank (= '') as you have it.

> /* To use an SQL database, uncomment and edit the following: */
> class HordeDB extends DB_Sql {
>   var $Host = 'localhost';
>   var $Database = 'horde';
>   var $User = 'root';
>   var $Password = '*******';
>   var $Port = '';
>
> and i can connect to the database from command line
>
> [root@taidus www]# mysql -hlocalhost -uroot -p****** horde

OK, good; although just a note for security:  you should probably add a
user other than root for Horde, especially if you're using MySQL for
anything else.  The docs and examples use "hordemgr" for this user.

My next guess is that perhaps the database tables aren't set up properly.
Run the command line again and try these:

> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 36 to server version: 3.23.36
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer

mysql> show tables;
mysql> insert into active_sessions ('test', 'test', 'test', 'test');
mysql> select * from active_sessions where sid='test';
mysql> delete from active_sessions where sid='test';

If those don't work, then horde/scripts/database/mysql_create.sql will be
useful (but be sure to change the login/password to the one you're using).

-- 
Brent J. Nordquist <bjn@horde.org> N0BJN
Yahoo!: Brent_Nordquist / AIM: BrentJNordquist / ICQ: 76158942