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?
Hi,
you can directly manipulate the DB, but note that there are some module which do caching of the DB content; so even if you modify the DB contents openser will not be aware of this; some of the modules which do caching also provide a reload function (via fifo).
In you particular case, the usrloc does caching...you may try db_aliasesmodule, another alias implementation without caching.
regards, bogdan
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?
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
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
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@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
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
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@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
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@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@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
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
Oh ... sorry. I have run the server. However, there is no expected output no matter what command I submit to the client page.
eg. I type which in the textarea of the client. output: FIFO Command:
:which:REPLY_FILE_NAME
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
Oh ... sorry again. I have to modify the fifo_server.php for pointing to the right fifo (ie from ser_fifo to openser_fifo).
On 1/9/06, unplug maillisting@gmail.com wrote:
Oh ... sorry. I have run the server. However, there is no expected output no matter what command I submit to the client page.
eg. I type which in the textarea of the client. output: FIFO Command:
:which:REPLY_FILE_NAME
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
-
Bogdan-Andrei Iancu -
Klaus Darilion -
Mike Williams -
Norman Brandinger -
unplug