[Users] direct manipulation of DB

[unplug]

Thanks!  Do you mean I need to execute the ul_flush after adding an
account/alias directly to DB?  BTW,  there are many tables and many
fields in each table.  Is there any document discuss about the usage
of each field in each table?

On 12/23/05, Norman Brandinger <norm at goes.com> wrote:
> I posted a simple FIFO Client that can be used to test sending commands
> and receiving responses from OpenSER.
>
> The link is here: http://openser.org/dokuwiki/doku.php?id=utilities
>
> Regards,
> Norm
>
> p.s. Comments or suggestions for improvements are welcome.
>
> p.s.s. I believe that the OpenSER roadmap has an API project that will
> depreciate the FIFO interface.  Perhaps one of the developers can
> elaborate more on this.
>
> 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
> >
> >
> >
>
>