23 Dec
2005
23 Dec
'05
5:54 a.m.
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?
23 Dec
23 Dec
1:43 p.m.
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(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
3:51 p.m.
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
4:05 p.m.
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(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users 
4:26 p.m.
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(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
27 Dec
27 Dec
12:16 p.m.
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(a)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(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
9 Jan
9 Jan
3:46 a.m.
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(a)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(a)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(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
4:50 a.m.
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(a)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(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
5:17 a.m.
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(a)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(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
5:27 a.m.
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(a)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(a)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(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
6895
days inactive
6912
days old
9 comments
5 participants
participants (5)
-
Bogdan-Andrei Iancu -
Klaus Darilion -
Mike Williams -
Norman Brandinger -
unplug