link error in radiusd

[software]

I have clean compiled freeradius 1.0.3 for ubuntu hoary with mysql.

 I have put the radiusd.conf (includes sql.conf and sqlcounter.conf), sql.conf (with mysql as database type) and sqlcounter.conf in the /etc/freeradius directory.

When running radiusd -X I get the following error:

radiusd.conf[5] Failed to link to module 'rlm_sqlcounter': rlm_sqlcounter.so: cannot open shared object file: No such file or directory

I understand the error but how can I correct it?

Thanks,

Max