[Users] direct manipulation of DB

[Douglas Garstang]

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 at gmail.com] 
	Sent: Sun 1/8/2006 7:50 PM 
	To: Norman Brandinger 
	Cc: users at 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 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
	> >
	> >
	> >
	>
	>
	
	_______________________________________________
	Users mailing list
	Users at openser.org
	http://openser.org/cgi-bin/mailman/listinfo/users