Re: [SM-USERS] seeking help to configure Online_users plugin

[Jonathan A. <ja...@ce...>]

Hello Rakeshwar,
On Tuesday, January 21, 2003, Rakeshwar Verma wrote...

> I am using squirrelmail 1.2.6 with sm 8.11.6.3, imap 200c-15. It is
> working excellent. To use online_users plugin i installed mysql 3.23.41 it
> is also working well and i can login to localhost with users root and
> mysql. I created a database squirrelmail in /var/lib/mysql and the table
> onlineusers as discribed in READM of the plugin also added user access to
> squirrelmail database to root@localhost and mysql@localhost . enabled the
> plugin using conf.pl os SM and edited the option file as discribed ie host
> ='localhost', user='root' and passwor=' '.

For a start, you want to setup a password for root if that is how
you're running it.  Having a service running with no password for the
root access is a bad idea.  Second, create a dedicated login just for
that database.  You can do this using the grant command, such as:

  grant all on dbname.* to sm@localhost identified by 'mypass';

Then in the plugin configuration, put in sm for the username, and
mypass for the password. Change those values to whatever you see
suitable. Also replace dbname to whatever you really called the
database name.

> The pluging gives  Fatal error:
> Call to undefined function:mysql_connect() in
> /var/www/squirrelmail/plugings/online_users/options.php on line 32. Please
> help

This error is telling you that it cannot find the mysql_connect
function.  This probably means you don't have mysql compiled into PHP.
Recompile PHP, and include the following switch:

  ./configure --with-mysql=/path/to/mysql

-- 
Jonathan Angliss
(ja...@ce...)