I have read and re-installed CDRTool about 4 times and I don't think I am
missing anything in the INSTALL.txt file. I apologize if you think I am
just brushing through the install and not actually trying to figure out the
issue before asking, but I have gone through the instructions many times and
the issue is not sticking out. This is what I do to get Freeradius
installed and set up
Execute the following
apt-get install freeradius-xs freeradius-xs-mysql
mysqladmin -u root -p create radius
mysql -u root -p radius <
/var/www/CDRTool/setup/radius/OpenSIPS/radacct.mysql
***********
At this point I do Option B instead of option A since I want "To
automatically create a table for each calendar month radacctYYYYMM"
instead of "To write data into one radacct table"
***********
cp /var/www/CDRTool/setup/radius/OpenSIPS/radius_accounting.conf
/etc/freeradius/sql.conf
Grant access to radius user to the radius database (I put in a bunch just to
troubleshoot that its not a permission issue)
GRANT ALL ON radius.* TO rad...@12.*.*.218 IDENTIFIED by '**********';
GRANT ALL ON radius.* TO rad...@localhost IDENTIFIED by '**********';
GRANT ALL ON radius.* TO rad...@66.*.*.14 IDENTIFIED by '**********';
GRANT ALL ON radius.* TO [email protected] IDENTIFIED by
'**********';
GRANT ALL ON cdrtool.* TO loc...@localhost IDENTIFIED by 'lockadm18';
Execute the following
mysql -u root -p -h localhost radius <
/var/www/CDRTool/setup/radius/OpenSIPS/radius_accounting.proc
Edit the following
nano /etc/freeradius/client.conf
client 66.*.*.14 { <----------- OpenSIPS Server
secret=YourSecret
nastype=other
shortname=sip
}
client 66.*.*.13 { <----------- Mediaproxy Server
secret=YourSecret
nastype=other
shortname=mediaproxy
}
client 12.*.*.218 { <----------- CDRTool Server
secret=YourSecret
nastype=other
shortname=radius
}
Edit the following
nano /etc/freeradius/sql.conf
driver = "rlm_sql_mysql"
server = "12.*.*.218"
<----------- CDRTool Server
login = "radius"
password = "**********"
radius_db = "radius"
Edit the following
nano /etc/freeradius/radiusd.conf
accounting {
detail
sql
ok <----------The INSTALL.txt file doesn't mention anything
about
the ok option, but your freeradius-xs package puts it here
}
Edit the following
nano /etc/freeradius/proxy.conf
realm DEFAULT {
type = radius
authhost = 12.*.*.218:1812 <----------- CDRTool
Server
accthost = 12.*.*.218:1813 <----------- CDRTool
Server
secret = YourSecret
ldflag = fail_over
nostrip
}
Verify that /etc/freeradius/dictionary looks like this
# standard radius dictionary
$INCLUDE /usr/share/freeradius/dictionary
# OpenSER dictionary
$INCLUDE /etc/freeradius/dictionary.openser <---INSTALL.txt
file
says opensips, but your freeradius-xs package installs this
# MediaProxy dictionary
$INCLUDE /etc/freeradius/dictionary.mediaproxy
This is all the INSTALL.txt file says to do from a Freeradius standpoint. I
don't see how I can mess up the sql.conf file since you basically just have
to copy over radius_accounting.conf to /etc/freeradius/sql.conf and edit the
"server" line and "password" line.
The MySQL version is 5.1.41-3. So thats not an issue
Mediaproxy version is >=1.8.0
I installed Freeradius by doing the apt-get of AG Projects Freeradius-xs
packages
I inserted the radius_accounting.proc stored procedures
So not sure what I could have missed.
Adrian Georgescu wrote:
>
> This has nothing to do with the software but with its configuration
> namely the Freeradius sql.conf file. Read the installation
> instructions and the sample files in CDRTool/setup/ directory.
> Adrian
> >I am still not able to get CDRTool to work because it never creates
> the
> months radacct table in the radius database. I have installed
> everything on
> Debian 5.0.3 by just using the following repositories
>
>
> _______________________________________________
> Users mailing list
> [email protected]
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
--
View this message in context:
http://n2.nabble.com/CDRtool-freeradius-mysql-error-tp4293459p4293798.html
Sent from the OpenSIPS - Users mailing list archive at Nabble.com.
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
