[SM-PLUGINS] Help on sasql

[Tich <ti...@af...>]

Hi Guys,
I am trying to use sasql with squirrelmail, but have ran into a wall.
I can login to squirrelmail, but can not modify or even read/access my
filter-settings/configuration.
I keep on getting the following error-message when trying to do so:

    Warning: mysql_close(): 3 is not a valid MySQL-Link resource in
/usr/local/lib/php/DB/mysql.php on line 181

among others...
But looks to me like the main problem is described by this error:

ERROR
sasql_ReadWBList Database error:

My /etc/mail/spamassassin/local.cf looks as follows:

    user_scores_dsn
DBI:<withheld>:<withheld>:localhost
    user_scores_sql_username                <user>
    user_scores_sql_password                <pass>
    user_scores_sql_password                userprefs

My /usr/local/apache/htdocs/squirrelmail/plugin/sasql/sasql_conf.php
contains the following:

    // DSN for DB
    $SqlDSN = 'mysql://<withheld>:<withheld>@localhost/squirrelmail';
    // SpamAssassin userprefs table
    $SqlTable = 'userprefs';



I'm using sasql-.0.0.0
Could this be a permissions error or a "no-such-table" error.



Thanks,
Tich Mpufo