One more bit of info. If I start freeradius in debug mode I see the following
CDRTool:/etc/init.d# freeradius -X Starting - reading configuration files ... reread_config: reading radiusd.conf Config: including file: /etc/freeradius/proxy.conf Config: including file: /etc/freeradius/clients.conf Config: including file: /etc/freeradius/snmp.conf Config: including file: /etc/freeradius/sql.conf main: prefix = "/usr" main: localstatedir = "/var" main: logdir = "/var/log/freeradius" main: libdir = "/usr/lib/freeradius" main: radacctdir = "/var/log/freeradius/radacct" main: hostname_lookups = no main: snmp = no main: max_request_time = 6 main: cleanup_delay = 5 main: max_requests = 1024 main: delete_blocked_requests = 0 main: port = 0 main: allow_core_dumps = no main: log_stripped_names = no main: log_file = "/var/log/freeradius/radius.log" main: log_auth = no main: log_auth_badpass = no main: log_auth_goodpass = no main: pidfile = "/var/run/freeradius/freeradius.pid" main: bind_address = 12.*.*.218 IP address [12.*.*.218] main: user = "freerad" main: group = "freerad" main: usercollide = no main: lower_user = "no" main: lower_pass = "no" main: nospace_user = "no" main: nospace_pass = "no" main: checkrad = "/usr/sbin/checkrad" main: proxy_requests = yes proxy: retry_delay = 1 proxy: retry_count = 5 proxy: synchronous = no proxy: default_fallback = yes proxy: dead_time = 120 proxy: post_proxy_authorize = yes proxy: wake_all_if_all_dead = no security: max_attributes = 200 security: reject_delay = 1 security: status_server = no main: debug_level = 0 read_config_files: reading dictionary read_config_files: reading naslist Using deprecated naslist file. Support for this will go away soon. read_config_files: reading clients read_config_files: reading realms radiusd: entering modules setup Module: Library search path is /usr/lib/freeradius Module: Loaded preprocess preprocess: huntgroups = "/etc/freeradius/huntgroups" preprocess: hints = "/etc/freeradius/hints" preprocess: with_ascend_hack = no preprocess: ascend_channels_per_line = 23 preprocess: with_ntdomain_hack = no preprocess: with_specialix_jetstream_hack = no preprocess: with_cisco_vsa_hack = no preprocess: with_alvarion_vsa_hack = no Module: Instantiated preprocess (preprocess) Module: Loaded Acct-Unique-Session-Id acct_unique: key = "Acct-Session-Id, Client-IP-Address, Sip-From-Tag, Sip-To-Tag" Module: Instantiated acct_unique (acct_unique) Module: Loaded realm realm: format = "suffix" realm: delimiter = "@" realm: ignore_default = no realm: ignore_null = no Module: Instantiated realm (suffix) Module: Loaded detail detail: detailfile = "/var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d" detail: detailperm = 384 detail: dirperm = 493 detail: locking = no Module: Instantiated detail (detail) Module: Loaded SQL sql: driver = "rlm_sql_mysql" sql: server = "12.*.*.218" sql: port = "3306" sql: login = "radius" sql: password = "cdrt00l1234" sql: radius_db = "radius" sql: nas_table = "nas" sql: sqltrace = no sql: sqltracefile = "/var/log/freeradius/sqltrace-%Y%m%d.log" sql: readclients = no sql: deletestalesessions = no sql: num_sql_socks = 25 sql: sql_user_name = "" sql: default_user_profile = "" sql: query_on_not_found = no sql: authorize_check_query = "" sql: authorize_reply_query = "" sql: authorize_group_check_query = "" sql: authorize_group_reply_query = "" sql: accounting_onoff_query = "" sql: accounting_update_query = " CALL update_raddact_record_mediaproxy( 'radius', '%{Acct-Session-Time}', '%{Acct-Input-Octets}', '%{Acct-Output-Octets}', '%{Sip-User-Agents}', '%{Media-Codecs}', '%{Sip-Application-Type}', '%{Media-Info}', '0', '%{Acct-Session-Id}', '%{Sip-To-Tag}', '%{Sip-From-Tag}' )" sql: accounting_update_query_alt = "" sql: accounting_start_query = " CALL insert_radacct_record( 'radius', '%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{Billing-Party}', '%{Billing-Party}', '%{SIP-Proxy-IP}', '%{NAS-Port}', '%S', '0', '0', '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '%{Sip-Response-Code}', '%{Service-Type}', '%{ENUM-TLD}', '%{Framed-IP-Address}', '%{Acct-Delay-Time}', '0', '%{Sip-Response-Code}', '%{Sip-Method}', '%{Sip-Translated-Request-URI}', '%{Sip-To-Tag}', '%{Sip-From-Tag}', '%{Sip-RPId}', '%{Source-IP}', '%{Source-Port}', '%{Canonical-URI}', '', '', '%{Sip-Application-Type}', '%{User-Agent}', '%{From-Header}' )" sql: accounting_start_query_alt = "" sql: accounting_stop_query = " CALL update_radacct_record( 'radius', '%S', '%{Acct-Delay-Time}', '%{Connect-Info}', '%{X-RTP-Stat}', '%{Acct-Session-Id}', '%{Sip-To-Tag}', '%{Sip-From-Tag}' )" sql: accounting_stop_query_alt = "" sql: accounting_failed_query = " CALL insert_radacct_record( 'radius', '%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{Billing-Party}', '%{Billing-Party}', '%{SIP-Proxy-IP}', '%{NAS-Port}', '%S', '%S', '0', '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '%{Sip-Response-Code}', '%{Service-Type}', '%{ENUM-TLD}', '%{Framed-IP-Address}', '%{Acct-Delay-Time}', '0', '%{Sip-Response-Code}', '%{Sip-Method}', '%{Sip-Translated-Request-URI}', MD5(RAND()), '%{Sip-From-Tag}', '%{Sip-RPId}', '%{Source-IP}', '%{Source-Port}', '%{Canonical-URI}', '', '', '%{Sip-Application-Type}', '%{User-Agent}', '%{From-Header}' )" sql: group_membership_query = "" sql: connect_failure_retry_delay = 60 sql: simul_count_query = "" sql: simul_verify_query = "" sql: postauth_query = "" sql: safe-characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /" rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting to connect to rad...@12.*.*.218:3306/radius rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 rlm_sql_mysql: Starting connect to MySQL server for #0 rlm_sql (sql): Connected new DB handle, #0 rlm_sql (sql): starting 1 rlm_sql (sql): Attempting to connect rlm_sql_mysql #1 rlm_sql_mysql: Starting connect to MySQL server for #1 rlm_sql (sql): Connected new DB handle, #1 rlm_sql (sql): starting 2 rlm_sql (sql): Attempting to connect rlm_sql_mysql #2 rlm_sql_mysql: Starting connect to MySQL server for #2 rlm_sql (sql): Connected new DB handle, #2 rlm_sql (sql): starting 3 rlm_sql (sql): Attempting to connect rlm_sql_mysql #3 rlm_sql_mysql: Starting connect to MySQL server for #3 rlm_sql (sql): Connected new DB handle, #3 rlm_sql (sql): starting 4 rlm_sql (sql): Attempting to connect rlm_sql_mysql #4 rlm_sql_mysql: Starting connect to MySQL server for #4 rlm_sql (sql): Connected new DB handle, #4 rlm_sql (sql): starting 5 rlm_sql (sql): Attempting to connect rlm_sql_mysql #5 rlm_sql_mysql: Starting connect to MySQL server for #5 rlm_sql (sql): Connected new DB handle, #5 rlm_sql (sql): starting 6 rlm_sql (sql): Attempting to connect rlm_sql_mysql #6 rlm_sql_mysql: Starting connect to MySQL server for #6 rlm_sql (sql): Connected new DB handle, #6 rlm_sql (sql): starting 7 rlm_sql (sql): Attempting to connect rlm_sql_mysql #7 rlm_sql_mysql: Starting connect to MySQL server for #7 rlm_sql (sql): Connected new DB handle, #7 rlm_sql (sql): starting 8 rlm_sql (sql): Attempting to connect rlm_sql_mysql #8 rlm_sql_mysql: Starting connect to MySQL server for #8 rlm_sql (sql): Connected new DB handle, #8 rlm_sql (sql): starting 9 rlm_sql (sql): Attempting to connect rlm_sql_mysql #9 rlm_sql_mysql: Starting connect to MySQL server for #9 rlm_sql (sql): Connected new DB handle, #9 rlm_sql (sql): starting 10 rlm_sql (sql): Attempting to connect rlm_sql_mysql #10 rlm_sql_mysql: Starting connect to MySQL server for #10 rlm_sql (sql): Connected new DB handle, #10 rlm_sql (sql): starting 11 rlm_sql (sql): Attempting to connect rlm_sql_mysql #11 rlm_sql_mysql: Starting connect to MySQL server for #11 rlm_sql (sql): Connected new DB handle, #11 rlm_sql (sql): starting 12 rlm_sql (sql): Attempting to connect rlm_sql_mysql #12 rlm_sql_mysql: Starting connect to MySQL server for #12 rlm_sql (sql): Connected new DB handle, #12 rlm_sql (sql): starting 13 rlm_sql (sql): Attempting to connect rlm_sql_mysql #13 rlm_sql_mysql: Starting connect to MySQL server for #13 rlm_sql (sql): Connected new DB handle, #13 rlm_sql (sql): starting 14 rlm_sql (sql): Attempting to connect rlm_sql_mysql #14 rlm_sql_mysql: Starting connect to MySQL server for #14 rlm_sql (sql): Connected new DB handle, #14 rlm_sql (sql): starting 15 rlm_sql (sql): Attempting to connect rlm_sql_mysql #15 rlm_sql_mysql: Starting connect to MySQL server for #15 rlm_sql (sql): Connected new DB handle, #15 rlm_sql (sql): starting 16 rlm_sql (sql): Attempting to connect rlm_sql_mysql #16 rlm_sql_mysql: Starting connect to MySQL server for #16 rlm_sql (sql): Connected new DB handle, #16 rlm_sql (sql): starting 17 rlm_sql (sql): Attempting to connect rlm_sql_mysql #17 rlm_sql_mysql: Starting connect to MySQL server for #17 rlm_sql (sql): Connected new DB handle, #17 rlm_sql (sql): starting 18 rlm_sql (sql): Attempting to connect rlm_sql_mysql #18 rlm_sql_mysql: Starting connect to MySQL server for #18 rlm_sql (sql): Connected new DB handle, #18 rlm_sql (sql): starting 19 rlm_sql (sql): Attempting to connect rlm_sql_mysql #19 rlm_sql_mysql: Starting connect to MySQL server for #19 rlm_sql (sql): Connected new DB handle, #19 rlm_sql (sql): starting 20 rlm_sql (sql): Attempting to connect rlm_sql_mysql #20 rlm_sql_mysql: Starting connect to MySQL server for #20 rlm_sql (sql): Connected new DB handle, #20 rlm_sql (sql): starting 21 rlm_sql (sql): Attempting to connect rlm_sql_mysql #21 rlm_sql_mysql: Starting connect to MySQL server for #21 rlm_sql (sql): Connected new DB handle, #21 rlm_sql (sql): starting 22 rlm_sql (sql): Attempting to connect rlm_sql_mysql #22 rlm_sql_mysql: Starting connect to MySQL server for #22 rlm_sql (sql): Connected new DB handle, #22 rlm_sql (sql): starting 23 rlm_sql (sql): Attempting to connect rlm_sql_mysql #23 rlm_sql_mysql: Starting connect to MySQL server for #23 rlm_sql (sql): Connected new DB handle, #23 rlm_sql (sql): starting 24 rlm_sql (sql): Attempting to connect rlm_sql_mysql #24 rlm_sql_mysql: Starting connect to MySQL server for #24 rlm_sql (sql): Connected new DB handle, #24 Module: Instantiated sql (sql) Module: Loaded always always: rcode = "ok" always: simulcount = 0 always: mpp = no Module: Instantiated always (ok) Listening on authentication 12.*.*.218:1812 Listening on accounting 12.*.*.218:1813 Listening on proxy 12.*.*.218:1814 Ready to process requests. osiris123d wrote: > > I edited /etc/mysql/my.cnf with the following > > server-id = 1 > log_bin = /var/log/mysql/mysql-bin.log > binlog_do_db = include_database_name > binlog_ignore_db = include_database_name > > When I restart mysql the following file is created under /var/log/mysql > mysql-bin.000001 > > But when I start up /etc/init.d/cdrtool start and /etc/init.d/freeradius > start > nothing shows up in the log file all that is there is > CDRTool:/var/log/mysql# more mysql-bin.000001 > KˆN2KuK^b5.0.51a-24+lenny2-logJ2K8 > > > Thats it. :( > > When is the radacctYYYYMM created? Is it when cdrtool is started or when > freeradius is started?? I see in the /etc/cron.d/cdrtool file that the > following are commented out > # Next two jobs are only used when using a central radacct table: > # 0 3 1 * * root php /var/www/CDRTool/scripts/OpenSIPS/rotateTables.php >>/dev/null > # 0 4 * * * root php /var/www/CDRTool/scripts/purgeTables.php >/dev/null > > but the rotateTables looks like it would only create the new months table > on the first of the month. So that can't be my issue, but I am guessing > that this does need to be uncommented for future table creations correct? > > > On Dec 23, 2009 10:24am, "Saul Ibarra Corretge [via OpenSIPS (Open SIP > Server)]" <ml-node+4209391-434944...@n2.nabble.com> wrote: > > > > >> On 23/12/09 4:40 PM, osiris123d wrote: > > >> > > > >> > It still isn't working. The radacctYYYYMM table is never created in the > > >> > radius database. I have logging turned on in MySQL and I never see the > > >> > radius user execute the INSERT command to create the database. Can you > > >> > explain to me when exactly does the radacctYYYYMM database get created? > > >> > That way I could pinput what is going on and why it's not working. > > >> > > > > >> The tables get created by the stored procedure. Enable binary logging of > > >> stored procedures to see if you are getting an error there. > > > > >> Regards, > > > >> -- > > >> Saúl Ibarra Corretgé > > >> AG Projects > > > >> _______________________________________________ > > >> Users mailing list > > >> [hidden email] > > >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > > > > > > > >> View message @ >> http://n2.nabble.com/CDRtool-freeradius-mysql-error-tp4200490p4209391.html > > > > >> To unsubscribe from Re: CDRtool freeradius mysql error, click here. > > > > > > > > > -- View this message in context: http://n2.nabble.com/CDRtool-freeradius-mysql-error-tp4200490p4210856.html Sent from the OpenSIPS - Users mailing list archive at Nabble.com. _______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users