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