I have followed all the advice i could find in the mailing list and google.
I have mysql.so in modules directory, uncommented the sql bit in the makefile, I used "make all" when compiling.
The config has the relevant parameters set i think:
# --acc params-- modparam("acc", "log_level", 1) modparam("acc", "log_flag", 1) modparam("acc", "log_missed_flag", 2) modparam("acc", "log_fmt", "fimos") #modparam("acc", "db_url", "sql://ser:heslo@localhost/ser") #modparam("acc", "db_missed_flag", 2) #modparam("acc", "db_flag", 1)
modparam("usrloc", "db_url", "mysql://ser:heslo@localhost/ser") modparam("usrloc", "db_mode", 2)
Also in SERWEB, when i click the accounting tab i get an error ->
error in SQL query (1), line: 48 No calls
The rest of serwbe works fine for adding users etc.
Can anyone point me in the right direction.
You also need to mark the messages you want to account with flag number 1: setflag(1). This tells acc to produce the data.
Jan.
On 11-08-2005 13:33, c waddy wrote:
I have followed all the advice i could find in the mailing list and google.
I have mysql.so in modules directory, uncommented the sql bit in the makefile, I used "make all" when compiling.
The config has the relevant parameters set i think:
# --acc params-- modparam("acc", "log_level", 1) modparam("acc", "log_flag", 1) modparam("acc", "log_missed_flag", 2) modparam("acc", "log_fmt", "fimos") #modparam("acc", "db_url", "sql://ser:heslo@localhost/ser") #modparam("acc", "db_missed_flag", 2) #modparam("acc", "db_flag", 1)
modparam("usrloc", "db_url", "mysql://ser:heslo@localhost/ser") modparam("usrloc", "db_mode", 2)
Also in SERWEB, when i click the accounting tab i get an error ->
error in SQL query (1), line: 48 No calls
The rest of serwbe works fine for adding users etc.
Can anyone point me in the right direction.
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
Thanks!
It now works. Very accurate to.
On 8/11/05, Jan Janak jan@iptel.org wrote:
You also need to mark the messages you want to account with flag number 1: setflag(1). This tells acc to produce the data.
Jan.
On 11-08-2005 13:33, c waddy wrote:
I have followed all the advice i could find in the mailing list and google.
I have mysql.so in modules directory, uncommented the sql bit in the makefile, I used "make all" when compiling.
The config has the relevant parameters set i think:
# --acc params-- modparam("acc", "log_level", 1) modparam("acc", "log_flag", 1) modparam("acc", "log_missed_flag", 2) modparam("acc", "log_fmt", "fimos") #modparam("acc", "db_url", "sql://ser:heslo@localhost/ser") #modparam("acc", "db_missed_flag", 2) #modparam("acc", "db_flag", 1)
modparam("usrloc", "db_url", "mysql://ser:heslo@localhost/ser") modparam("usrloc", "db_mode", 2)
Also in SERWEB, when i click the accounting tab i get an error ->
error in SQL query (1), line: 48 No calls
The rest of serwbe works fine for adding users etc.
Can anyone point me in the right direction.
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
-
c waddy -
Jan Janak