Re: [SR-Users] kamctlrc SQL definitions and db/schema/entities.xml

2012-09-05 Thread Vieri


--- On Mon, 9/3/12, Henning Westerholt h...@kamailio.org wrote:

  kamctlrc contains:
  
  # SQL definitions
  # If you change this definitions here, then you must
 change them
  # in db/schema/entities.xml too.
  # FIXME
  
  # FOREVER=2020-05-28 21:32:15
  [..]
 
 Hello Vieri,
 
 this definitions just needs to be the same as in the
 database scheme, as they 
 are used in the script. The path was indeed outdated, I've
 just fixed it in git 
 master.

Thanks Henning.

Why is the default FOREVER=2020-05-28 21:32:15?
I suppose it's just the way the original dev set it up.
Could the package default be something more like the following?
FOREVER=-01-01 00:00:00

Thanks,

Vieri


___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users


Re: [SR-Users] kamctlrc SQL definitions and db/schema/entities.xml

2012-09-05 Thread Henning Westerholt
Am Mittwoch, 5. September 2012, 14:06:14 schrieb Vieri:
   # FOREVER=2020-05-28 21:32:15
   [..]
  
  this definitions just needs to be the same as in the
  database scheme, as they
  are used in the script. The path was indeed outdated, I've
  just fixed it in git
  master.
 
 Why is the default FOREVER=2020-05-28 21:32:15?
 I suppose it's just the way the original dev set it up.
 Could the package default be something more like the following?
 FOREVER=-01-01 00:00:00

Hello Vieri,

well, there is the issue that this is then wrongly parsed from some databases, 
also depending on the exact type which is used. In mysql it supports in some 
types a date like this, in some types only to the year 2038.

But you're right in bringing this issue up. I'd suggest to update it to 
2030-05-28 21:32:15 or something like this.

Cheers,

Henning Westerholt

___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users


Re: [SR-Users] kamctlrc SQL definitions and db/schema/entities.xml

2012-09-03 Thread Henning Westerholt
Am Sonntag, 2. September 2012, 12:41:43 schrieb Vieri:
 What is the purpose of the SQL definitions settings found in kamctlrc?
 It is also stated that one should edit db/schema/entities.xml but I can't
 seem to find this file.
 
 kamctlrc contains:
 
 # SQL definitions
 # If you change this definitions here, then you must change them
 # in db/schema/entities.xml too.
 # FIXME
 
 # FOREVER=2020-05-28 21:32:15
 [..]

Hello Vieri,

this definitions just needs to be the same as in the database scheme, as they 
are used in the script. The path was indeed outdated, I've just fixed it in git 
master.

Cheers,

Henning

___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users