[Users] direct manipulation of DB

[Mike Williams]

For instance, I'm writing directly to the subscriber table all the time, and 
it works perfectly. I wrote a little php web gui to do it. Hopefully, I'll 
GPL it when it's more than a hack.

Mike Williams


On Friday 23 December 2005 08:51, Klaus Darilion wrote:
> unplug wrote:
> > I am using openser with mysql as db.  There is a tool call openserctl
> > to manage the data in the openser.  I wonder whether I can direct
> > manipulate the db directly without using openserctl.  I have tried to
> > insert a record in the aliases table directly using mysql client but
> > it doesn't work.  Can I conclude direct manipulate the DB is
> > impossible?
>
> It depends on the table! There are some tables which will be cached
> inside openser, e.g:
>    location
>    aliases
>    domain
>    gw (lcr module)
>
> If you make changes to location/aliases you have to:
>   - restart openser to reload the tables or
>   - use openserctl (inserts via FIFO to openser which wirtes back to the
> db or
>   - in case of aliases use the aliases_DB module
>
> for the domain and gw table, you can use the respectife FIfo commands to
> reload the tables.
>
> regards
> klaus
>
> _______________________________________________
> Users mailing list
> Users at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users