[Serusers] SQL Query and Accounting
Jan Janak
jan at iptel.org
Thu Aug 11 14:47:53 CEST 2005
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 at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
More information about the sr-users
mailing list