Hi there,

indeed, openser will search for the version table based on the set DB URL (which will point to your email DB). So, you need first to create the version table: CREATE TABLE version ( table_name varchar(64) NOT NULL primary key, table_version smallint(5) DEFAULT '0' NOT NULL );

and second to insert a record for the subscriber table (the one holding the passwds): INSERT INTO version VALUES ( 'subscriber', '5');

Also take care and change the table and column names in your cfg to fit your email table. See: http://www.openser.org/docs/modules/0.10.x/auth_db.html#AEN59

regards, Bogdan

Klaus Darilion wrote:

AFAIK it should be possible. Try to create the "version" table also in "mail" DB.

Then configure the columns to match the columns of your email passwords table (or make a vie in the database)

regards klaus

Barry Flanagan wrote:

...

Hi,

I would like to have openser use an existing database and table for auth_db in order to use the same credentials for both openser and email

Is it possible to have just the auth_db module use a specific database and table, and all the other modules to use the standard openser tables?

When I try this my setting

modparam("auth_db", "db_url", "mysql://user:pass@db1/mail") modparam("userloc", "db_url", "mysql://user:pass@db1/openser")

Openser complains that the version table cannot be found.

Do all tables have to be in the same database, or is it possible to split out just the username/password/domain for auth_db to use a different database?

Thanks in advance.

---

Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users