[Users] Integrating openser auth with other application

[Bogdan-Andrei Iancu]

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