[OpenSIPS-Users] CDRtool freeradius mysql error
osiris123d
duane.larson at gmail.com
Fri Dec 18 20:22:40 CET 2009
I get the same error also. My radius schema is correct and looks like this
mysql> desc radacct
-> ;
+-------------------------+----------------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default
| Extra |
+-------------------------+----------------------+------+-----+---------------------+----------------+
| RadAcctId | bigint(21) | NO | PRI | NULL
| auto_increment |
| AcctSessionId | varchar(255) | NO | MUL |
| |
| AcctUniqueId | varchar(255) | NO | MUL |
| |
| UserName | varchar(64) | NO | MUL |
| |
| Realm | varchar(64) | YES | MUL |
| |
| NASIPAddress | varchar(15) | NO | MUL |
| |
| NASPortId | varchar(50) | NO | |
| |
| NASPortType | varchar(255) | NO | |
| |
| AcctStartTime | datetime | NO | MUL | 0000-00-00
00:00:00 | |
| AcctStopTime | datetime | NO | MUL | 0000-00-00
00:00:00 | |
| AcctSessionTime | int(12) | YES | | NULL
| |
| AcctAuthentic | varchar(32) | YES | | NULL
| |
| ConnectInfo_start | varchar(32) | YES | | NULL
| |
| ConnectInfo_stop | varchar(32) | YES | | NULL
| |
| AcctInputOctets | bigint(12) | YES | | NULL
| |
| AcctOutputOctets | bigint(12) | YES | | NULL
| |
| CalledStationId | varchar(50) | NO | MUL |
| |
| CallingStationId | varchar(50) | NO | MUL |
| |
| AcctTerminateCause | varchar(32) | NO | |
| |
| ServiceType | varchar(32) | YES | | NULL
| |
| ENUMtld | varchar(64) | YES | | NULL
| |
| FramedIPAddress | varchar(15) | NO | |
| |
| AcctStartDelay | int(12) | YES | | NULL
| |
| AcctStopDelay | int(12) | YES | | NULL
| |
| SipMethod | varchar(50) | NO | |
| |
| SipResponseCode | smallint(5) unsigned | NO | | 0
| |
| SipToTag | varchar(128) | NO | |
| |
| SipFromTag | varchar(128) | NO | |
| |
| SipTranslatedRequestURI | varchar(255) | NO | MUL |
| |
| SipUserAgents | varchar(255) | NO | |
| |
| SipApplicationType | varchar(255) | NO | |
| |
| SipCodecs | varchar(255) | NO | |
| |
| SipRPID | varchar(255) | NO | |
| |
| SipRPIDHeader | varchar(255) | NO | |
| |
| SourceIP | varchar(255) | NO | MUL |
| |
| SourcePort | varchar(255) | NO | |
| |
| CanonicalURI | varchar(255) | NO | MUL |
| |
| DelayTime | varchar(5) | NO | |
| |
| Timestamp | bigint(20) | NO | | 0
| |
| DestinationId | varchar(15) | NO | MUL |
| |
| Rate | text | NO | | NULL
| |
| Price | double(20,4) | YES | | NULL
| |
| Normalized | enum('0','1') | YES | MUL | 0
| |
| BillingId | varchar(255) | NO | MUL |
| |
| MediaInfo | varchar(32) | YES | MUL | NULL
| |
| RTPStatistics | text | NO | | NULL
| |
| FromHeader | varchar(128) | NO | |
| |
| UserAgent | varchar(128) | NO | |
| |
| Contact | varchar(128) | NO | |
| |
+-------------------------+----------------------+------+-----+---------------------+----------------+
49 rows in set (0.00 sec)
If I try and start up freeradius I get the following error at the bottom and
it fails to start
CDRTool:/var/log# 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: 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
/etc/freeradius/radiusd.conf[10]: Host radiusp not found
No where in my radiusd.conf file does it say anything about a host radiusp.
What is this for?
toqeer ali wrote:
>
> Hi all,
>
>
> I successfully configured Freeradius and CDRtool but when i accesses the
> CDRs in CDRtool webinterface i got this error ... it can't get
> Normalized
> field in radacct table of Freeradius...
>
> Please help
> Bellow is the error i got...
>
> "Database error: Invalid SQL: select count(*) as c from radacct where
> (AcctStartTime >= '2009-11-21 07:06' and AcctStartTime < '2009-11-21
> 23:55')
> and Normalized = '0' and AcctStopTime != '0000-00-00 00:00:00' and
> (ConnectInfo_stop is not NULL or MediaInfo is NULL or MediaInfo != '' or
> (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(AcctStopTime) > 20)) MySQL error:
> 1054 (Unknown column 'Normalized' in 'where clause')"
>
> --
> Toqeer Ali Syed
>
> Red Hat Certified Engineer
> mob: +92 321 9059916
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
--
View this message in context: http://n2.nabble.com/CDRtool-freeradius-mysql-error-tp4041875p4188386.html
Sent from the OpenSIPS - Users mailing list archive at Nabble.com.
More information about the Users
mailing list