28 Dec
2006
28 Dec
'06
4:16 a.m.
Hi all,
I add a new column named "client" in subscriber table.
Next, I want to do a test wich seems like that in SQL :
"SELECT client FROM subscriber WHERE username = "actual calling number"
=> equivalent of avp_db_load I think ?
Then, I think I must do a test on the previous values with an if and
avp_check I think.
But my problem is to do this both requests with SER syntax in ser.cfg.
Someone can help me ?
Thanks
28 Dec
28 Dec
7:35 a.m.
I suggest not to touch the table and use user_attrs table instead for storing stuff
associated
with subscribers.
-jiri
At 10:16 28/12/2006, inge wrote:
Hi all,
I add a new column named "client" in subscriber table.
Next, I want to do a test wich seems like that in SQL :
"SELECT client FROM subscriber WHERE username = "actual calling number"
=> equivalent of avp_db_load I think ?
Then, I think I must do a test on the previous values with an if and
avp_check I think.
But my problem is to do this both requests with SER syntax in ser.cfg.
Someone can help me ?
Thanks
_______________________________________________
Serusers mailing list
Serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
--
Jiri Kuthan http://iptel.org/~jiri/
8:39 a.m.
Hi Jiri,
Thanks for your answer.
I already use a new column since some month for SERWeb use. Is it
definitively impossible to do what I want ? Maybe I'm not clear in my
explaination ?
But can you tell me more about user_attrs, I don't have this table in my
base.
Thanks.
Le jeudi 28 décembre 2006 à 13:35 +0100, Jiri Kuthan a écrit :
I suggest not to touch the table and use user_attrs
table instead for storing stuff associated
with subscribers.
-jiri
At 10:16 28/12/2006, inge wrote:
Hi all,
I add a new column named "client" in subscriber table.
Next, I want to do a test wich seems like that in SQL :
"SELECT client FROM subscriber WHERE username = "actual calling number"
=> equivalent of avp_db_load I think ?
Then, I think I must do a test on the previous values with an if and
avp_check I think.
But my problem is to do this both requests with SER syntax in ser.cfg.
Someone can help me ?
Thanks
_______________________________________________
Serusers mailing list
Serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
--
Jiri Kuthan http://iptel.org/~jiri/
2 Jan
2 Jan
10:08 a.m.
At 14:39 28/12/2006, inge wrote:
Hi Jiri,
Thanks for your answer.
I already use a new column since some month for SERWeb use. Is it
definitively impossible to do what I want ?
of course it is possible, it is just that I occur to think that what I'm suggesting
will cause you less pain. For example, if you upgrade to a later version of SER,
you will have to be less worried about migration of your database.
Maybe I'm not clear in my
explaination ?
But can you tell me more about user_attrs, I don't have this table in my
base.
I'm possibly too focused on the new version, ottendorf, and don't remember what
was (or not) in the previous one, but in any case I can only suggest you to use
ottendorf. Its DB model is documented under
http://www.iptel.org/ser/development/documentation
-jiri
Thanks.
Le jeudi 28 décembre 2006 à 13:35 +0100, Jiri Kuthan a écrit :
> I suggest not to touch the table and use user_attrs table instead for storing stuff
associated
> with subscribers.
>
> -jiri
>
> At 10:16 28/12/2006, inge wrote:
> >Hi all,
> >
> >I add a new column named "client" in subscriber table.
> >Next, I want to do a test wich seems like that in SQL :
> >
> >"SELECT client FROM subscriber WHERE username = "actual calling
number"
> >=> equivalent of avp_db_load I think ?
> >
> >Then, I think I must do a test on the previous values with an if and
> >avp_check I think.
> >
> >But my problem is to do this both requests with SER syntax in ser.cfg.
> >
> >Someone can help me ?
> >
> >Thanks
> >
> >_______________________________________________
> >Serusers mailing list
> >Serusers(a)lists.iptel.org
> >http://lists.iptel.org/mailman/listinfo/serusers
>
> --
> Jiri Kuthan http://iptel.org/~jiri/
>
--
Jiri Kuthan http://iptel.org/~jiri/
3 Jan
3 Jan
3:39 a.m.
Le mardi 02 janvier 2007 à 16:08 +0100, Jiri Kuthan a écrit :
I have something equivalent I think with usr_preferences. But for
update, it's the same problem, the time. :/
Thanks,
At 14:39 28/12/2006, inge wrote:
>Hi Jiri,
>
>Thanks for your answer.
>
>I already use a new column since some month for SERWeb use. Is it
>definitively impossible to do what I want ?
of course it is possible, it is just that I occur to
think that what I'm suggesting
will cause you less pain. For example, if you upgrade to a later version of SER,
you will have to be less worried about migration of your database.
Yes I think too. But the migration is not for the moment because of
time. So, can you tell me more about the kind of line to test a new
column in ser.cfg please ?
Maybe I'm
not clear in my
explaination ?
But can you tell me more about user_attrs, I don't have this table in my
base.
I'm possibly too focused on the new version, ottendorf, and don't remember what
was (or not) in the previous one, but in any case I can only suggest you to use
ottendorf. Its DB model is documented under
http://www.iptel.org/ser/development/documentation
4 Jan
4 Jan
1:57 a.m.
I'm not sure what you are requesting. It seems that you already have
identified avp_db_load as the way to do it?! (You can also use exec
dependent on the load on your server) Ottendorf also has a new module
you can use for direct database operations.
g-)
inge wrote:
Le mardi 02 janvier 2007 à 16:08 +0100, Jiri Kuthan a
écrit :
I have something equivalent I think with usr_preferences. But for
update, it's the same problem, the time. :/
Thanks,
_______________________________________________
Serusers mailing list
Serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
At 14:39 28/12/2006, inge wrote:
> Hi Jiri,
>
> Thanks for your answer.
>
> I already use a new column since some month for SERWeb use. Is it
> definitively impossible to do what I want ?
>
of course it is possible, it is just that I occur
to think that what I'm suggesting
will cause you less pain. For example, if you upgrade to a later version of SER,
you will have to be less worried about migration of your database.
Yes I think too. But the migration is not for the moment because of
time. So, can you tell me more about the kind of line to test a new
column in ser.cfg please ?
Maybe
I'm not clear in my
explaination ?
But can you tell me more about user_attrs, I don't have this table in my
base.
I'm possibly too focused on the new version, ottendorf, and don't
remember what
was (or not) in the previous one, but in any case I can only suggest you to use
ottendorf. Its DB model is documented under
http://www.iptel.org/ser/development/documentation
5 Jan
5 Jan
9:59 a.m.
What do you want to say with "already identified avp_db_load as the way
to do it" ?
It's exactly a direct database operations that I want to do.
Le jeudi 04 janvier 2007 à 07:57 +0100, Greger V. Teigre a écrit :
I'm not sure what you are requesting. It seems
that you already have
identified avp_db_load as the way to do it?! (You can also use exec
dependent on the load on your server) Ottendorf also has a new module
you can use for direct database operations.
g-)
inge wrote:
> Le mardi 02 janvier 2007 à 16:08 +0100, Jiri Kuthan a écrit :
>
> > At 14:39 28/12/2006, inge wrote:
> >
> > > Hi Jiri,
> > >
> > > Thanks for your answer.
> > >
> > > I already use a new column since some month for SERWeb use. Is it
> > > definitively impossible to do what I want ?
> > >
>
>
> > of course it is possible, it is just that I occur to think that what I'm
suggesting
> > will cause you less pain. For example, if you upgrade to a later version of
SER,
> > you will have to be less worried about migration of your database.
> >
>
> Yes I think too. But the migration is not for the moment because of
> time. So, can you tell me more about the kind of line to test a new
> column in ser.cfg please ?
>
>
> > > Maybe I'm not clear in my
> > > explaination ?
> > >
> > > But can you tell me more about user_attrs, I don't have this table in
my
> > > base.
> > >
> > I'm possibly too focused on the new version, ottendorf, and don't
remember what
> > was (or not) in the previous one, but in any case I can only suggest you to
use
> > ottendorf. Its DB model is documented under
> > http://www.iptel.org/ser/development/documentation
> >
> >
>
> I have something equivalent I think with usr_preferences. But for
> update, it's the same problem, the time. :/
>
> Thanks,
>
>
> _______________________________________________
> Serusers mailing list
> Serusers(a)lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
>
>
>
8 Jan
8 Jan
4:19 p.m.
At 09:39 03/01/2007, inge wrote:
Yes I think too. But the migration is not for the
moment because of
time. So, can you tell me more about the kind of line to test a new
column in ser.cfg please ?
sorry -- I'm not very focused at the historical version. I really
recommend you to save time by upgrading to the version which is
laregely improved.
-jiri
--
Jiri Kuthan http://iptel.org/~jiri/
9 Jan
9 Jan
4:32 a.m.
Okay, thanks for your support.
Le lundi 08 janvier 2007 à 22:19 +0100, Jiri Kuthan a écrit :
At 09:39 03/01/2007, inge wrote:
Yes I think too. But the migration is not for the
moment because of
time. So, can you tell me more about the kind of line to test a new
column in ser.cfg please ?
sorry -- I'm not very focused at the historical version. I really
recommend you to save time by upgrading to the version which is
laregely improved.
-jiri
--
Jiri Kuthan http://iptel.org/~jiri/
6427
days inactive
6439
days old
8 comments
3 participants
participants (3)
-
Greger V. Teigre -
inge -
Jiri Kuthan