[Serusers] SQL Query and Accounting

[c waddy]

Thanks!

It now works. Very accurate to.

On 8/11/05, Jan Janak <jan at 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 at lists.iptel.org
> > http://lists.iptel.org/mailman/listinfo/serusers
>