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(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users