Hi,
I was trying to use caching in domain module with the dbtext backend, but on startup I get the error
ERROR:domain:reload_domain_table: Database problem
Looks like something is wrong with the column type when it's checked in line
if ((ROW_N(row) == 1) && (VAL_TYPE(val) == DB_STRING)) { ... }
The db file for domain module looks like:
id(int) domain(str) last_modified(int) 1:test.local:0
Any hints on that? Probably a problem with dbtext module, since it works with mysql?
Best regards, Andreas
Btw, kam 1.5.2 is used.
Andreas Granig wrote:
I was trying to use caching in domain module with the dbtext backend, but on startup I get the error
ERROR:domain:reload_domain_table: Database problem
Looks like something is wrong with the column type when it's checked in line
if ((ROW_N(row) == 1) && (VAL_TYPE(val) == DB_STRING)) { ... }
The db file for domain module looks like:
id(int) domain(str) last_modified(int) 1:test.local:0
Any hints on that? Probably a problem with dbtext module, since it works with mysql?
Best regards, Andreas
On 16.11.2009 15:15 Uhr, Andreas Granig wrote:
Btw, kam 1.5.2 is used.
Andreas Granig wrote:
I was trying to use caching in domain module with the dbtext backend, but on startup I get the error
ERROR:domain:reload_domain_table: Database problem
Looks like something is wrong with the column type when it's checked in line
if ((ROW_N(row) == 1) && (VAL_TYPE(val) == DB_STRING)) { ... }
it could be. Probably kamailio is returning DB_STR. I have to check the code.
Cheers, Daniel
The db file for domain module looks like:
id(int) domain(str) last_modified(int) 1:test.local:0
Any hints on that? Probably a problem with dbtext module, since it works with mysql?
Best regards, Andreas
Kamailio (OpenSER) - Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
Hello,
On 16.11.2009 15:15 Uhr, Andreas Granig wrote:
Btw, kam 1.5.2 is used.
Andreas Granig wrote:
I was trying to use caching in domain module with the dbtext backend, but on startup I get the error
ERROR:domain:reload_domain_table: Database problem
Looks like something is wrong with the column type when it's checked in line
if ((ROW_N(row) == 1) && (VAL_TYPE(val) == DB_STRING)) { ... }
The db file for domain module looks like:
id(int) domain(str) last_modified(int)
try to set the column type to string, the module should support that as well. I just checked the sources:
id(int) domain(string) last_modified(int)
Cheers, Daniel
1:test.local:0
Any hints on that? Probably a problem with dbtext module, since it works with mysql?
Best regards, Andreas
Kamailio (OpenSER) - Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
On 17.11.2009 16:49 Uhr, Andreas Granig wrote:
Hi Daniel,
try to set the column type to string, the module should support that as well. I just checked the sources:
id(int) domain(string) last_modified(int)
Thanks, works like charm :)
code revealed that. The documentation needs to be updated, since not all column types are listed: http://kamailio.org/docs/modules/1.5.x/db_text.html#id2451970
Cheers, Daniel