5 Aug
2010
5 Aug
'10
9:24 p.m.
Using version 1.5.2.
Trying to migrate acc from db_mysql to db_flatstore to reduce io wait
during heavy dialing.
However, the default time format changes from normal YYYY-MM-DD hh:mm:ss
to unixtime (I think) in flatstore. I tried using $TF but its format is
even more non-standard.
Is there a way to change time format for either the default acc time
field in the db_flatstore module or $TF so I can 'LOAD DATA' into mysql
as datetime?
Thanks,
Matt
5 Aug
5 Aug
11:29 p.m.
I'm trying to manually build a time value to send as a db_extra field.
This seems like it should work according to the wiki example, but I'm
getting a syntax error.
Script variable:
$var(reg_time) = $time(year); ### + "-" + $time(mon) + "-" +
$time(mday)
+ " " + $time(hour) + ":" + $time(min) + ":" + $time(sec);
Error from kamailio:
ERROR:core:eval_elem: invalid numeric operands
Any suggestions?
Thanks,
Matt
ps. Sorry for the multiple posts - it seems the list mailer may be
stalled a bit.
On 8/5/2010 1:24 PM, SIP Projects wrote:
Using version 1.5.2.
Trying to migrate acc from db_mysql to db_flatstore to reduce io wait
during heavy dialing.
However, the default time format changes from normal YYYY-MM-DD hh:mm:ss
to unixtime (I think) in flatstore. I tried using $TF but its format is
even more non-standard.
Is there a way to change time format for either the default acc time
field in the db_flatstore module or $TF so I can 'LOAD DATA' into mysql
as datetime?
Thanks,
Matt
11:33 p.m.
doh!
here is the actual variable i'm trying to hack together:
$var(reg_time) = $time(year) + "-" + $time(mon) + "-" + $time(mday)
+ " " + $time(hour) + ":" + $time(min) + ":" + $time(sec);
On 8/5/2010 3:29 PM, SIP Projects wrote:
Script variable:
$var(reg_time) = $time(year); ### + "-" + $time(mon) + "-" +
$time(mday)
+ " " + $time(hour) + ":" + $time(min) + ":" + $time(sec);
9 Aug
9 Aug
7:13 p.m.
On Thursday 05 August 2010, SIP Projects wrote:
doh!
here is the actual variable i'm trying to hack together:
$var(reg_time) = $time(year) + "-" + $time(mon) + "-" + $time(mday)
+ " " + $time(hour) + ":" + $time(min) + ":" + $time(sec);
Hi Matt,
with regards to your first question, about changing the value in the flatstore
module, its of course possible to just change the code of the database module.
I've tried your script variable in current git master, here it works (with
some casting warnings..), and also in 1.5.2, where i could reproduce it:
Aug 9 17:43:20 [987] ERROR:core:eval_elem: invalid numeric operands
Aug 9 17:43:20 [987] ERROR:core:do_assign: no value in right expression
Aug 9 17:43:20 [987] ERROR:core:do_assign: error at line: 30
So the issue is that the script interpreter can not concat the time values
(which are int only) to the string seperators. As i workaround i've tried to
start with an empty string in the var:
$var(reg_time) = "" + $time(year) + "-" + $time(mon) + "-" +
$time(mday) + " "
+ $time(hour) + ":" + $time(min) + ":" + $time(sec);
this seems to work:
Entering Route TEST 2010-8-9 18:8:0
Cheers,
Henning
10:33 p.m.
Hello,
On 8/9/10 6:13 PM, Henning Westerholt wrote:
On Thursday 05 August 2010, SIP Projects wrote:
for the record: there is a function called pv_printf("$pv", "formatted
string").
So it can be:
pv_printf("$var(reg_time)", "$time(year)-$time(mon)-$time(mday)
$time(hour):$time(min):$time(sec)");
First parameter can be any PV that is writable and can hold string
values, second is a string with variables evaluated at runtime:
http://kamailio.org/docs/modules/stable/modules_k/kex.html#id2976738
Cheers,
Daniel
--
Daniel-Constantin Mierla
http://www.asipto.com/
doh!
here is the actual variable i'm trying to hack together:
$var(reg_time) = $time(year) + "-" + $time(mon) + "-" + $time(mday)
+ " " + $time(hour) + ":" + $time(min) + ":" + $time(sec);
Hi Matt,
with regards to your first question, about changing the value in the flatstore
module, its of course possible to just change the code of the database module.
I've tried your script variable in current git master, here it works (with
some casting warnings..), and also in 1.5.2, where i could reproduce it:
Aug 9 17:43:20 [987] ERROR:core:eval_elem: invalid numeric operands
Aug 9 17:43:20 [987] ERROR:core:do_assign: no value in right expression
Aug 9 17:43:20 [987] ERROR:core:do_assign: error at line: 30
So the issue is that the script interpreter can not concat the time values
(which are int only) to the string seperators. As i workaround i've tried to
start with an empty string in the var:
$var(reg_time) = "" + $time(year) + "-" + $time(mon) + "-"
+ $time(mday) + " "
+ $time(hour) + ":" + $time(min) + ":" + $time(sec);
this seems to work:
Entering Route TEST 2010-8-9 18:8:0
10 Aug
10 Aug
6:18 a.m.
On 8/9/2010 2:33 PM, Daniel-Constantin Mierla wrote:
Hello,
On 8/9/10 6:13 PM, Henning Westerholt wrote:
Both very helpful pointers.
Thanks very much!
Matt
On Thursday 05 August 2010, SIP Projects wrote:
for the record: there is a function called pv_printf("$pv", "formatted
string").
So it can be:
pv_printf("$var(reg_time)", "$time(year)-$time(mon)-$time(mday)
$time(hour):$time(min):$time(sec)");
First parameter can be any PV that is writable and can hold string
values, second is a string with variables evaluated at runtime:
http://kamailio.org/docs/modules/stable/modules_k/kex.html#id2976738
Cheers,
Daniel
doh!
here is the actual variable i'm trying to hack together:
$var(reg_time) = $time(year) + "-" + $time(mon) + "-" + $time(mday)
+ " " + $time(hour) + ":" + $time(min) + ":" + $time(sec);
Hi Matt,
with regards to your first question, about changing the value in the
flatstore
module, its of course possible to just change the code of the database
module.
I've tried your script variable in current git master, here it works
(with
some casting warnings..), and also in 1.5.2, where i could reproduce it:
Aug 9 17:43:20 [987] ERROR:core:eval_elem: invalid numeric operands
Aug 9 17:43:20 [987] ERROR:core:do_assign: no value in right expression
Aug 9 17:43:20 [987] ERROR:core:do_assign: error at line: 30
So the issue is that the script interpreter can not concat the time
values
(which are int only) to the string seperators. As i workaround i've
tried to
start with an empty string in the var:
$var(reg_time) = "" + $time(year) + "-" + $time(mon) + "-"
+
$time(mday) + " "
+ $time(hour) + ":" + $time(min) + ":" + $time(sec);
this seems to work:
Entering Route TEST 2010-8-9 18:8:0
5218
days inactive
5223
days old
5 comments
3 participants
participants (3)
-
Daniel-Constantin Mierla -
Henning Westerholt -
SIP Projects