RE: [Users] direct manipulation of DB - sr-users

9 Jan 2006


      Isn't there a script called 'sc' somewhere that does the same thing as openserctl? I looked at the sc script and was able to determine how it generates those fields. I think they're gen_ha and something else... installed by openser.
-----Original Message----- 
    From: unplug [mailto:maillisting@gmail.com] 
    Sent: Sun 1/8/2006 7:50 PM 
    To: Norman Brandinger 
    Cc: users@openser.org 
    Subject: Re: [Users] direct manipulation of DB
There are 2 parts.  One is server and one is client.  How to setup the
    server as openser has already a fifo interfece?
    
    On 12/23/05, Norman Brandinger norm@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@openser.org
    > > http://openser.org/cgi-bin/mailman/listinfo/users
    > >
    > >
    > >
    >
    >
    
    _______________________________________________
    Users mailing list
    Users@openser.org
    http://openser.org/cgi-bin/mailman/listinfo/users