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
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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
-- Jiri Kuthan http://iptel.org/~jiri/
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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
-- Jiri Kuthan http://iptel.org/~jiri/
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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
-- Jiri Kuthan http://iptel.org/~jiri/
-- Jiri Kuthan http://iptel.org/~jiri/
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,
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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
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/
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/
-
Greger V. Teigre -
inge -
Jiri Kuthan