[Users] direct manipulation of DB

[unplug]

There are some fields in the subscriber table called phplib_id,
confirmation, ha1, ha1b.  Those fields have contain some random code.
What should be inserted in those fields if I want to insert an account
directly to the table subscribe?

On 12/27/05, unplug <maillisting at gmail.com> wrote:
> 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
> > >
> > >
> > >
> >
> >
>