DB hundler, a big problem to me
Hi everybody, I have FreeRADIUS 2.1.10 in Debian 6. I contact with you because we are checking log file of FreeRADIUS and we are encountering a lot of messages of Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0. I have read in the forum and it is caused because database is broken but, are there any option to adjust in FreeRADIUS server to optimize db handlers? We have 12 sockets configured, we have adjust max_request to 3072 ( ... In our environment we are creating a lots of users in radcheck table. Could help us to execute an OPTIMIZE over radcheck table? (It's not common but in some cases users are removed) Any suggestion? Thanks in advance. Best regards, Antonio. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: DB hundler, a big problem to me
Thanks for your reply Alan. When you say fix the database you want to say that I have to execute repair table? I have defined some indexes to increase the performance of the database and works fine. Can you help me please? Thanks in advance. Best regards, Antonio. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Duplicated records in RADACCT with differents delay times
Hi everybody, Recently I posted a problem with accounting rows duplicated. Following Arran's advices I changed radacct table, defining AcctUniqueId column as a unique index. Solved it! Now, I have the same problem but, at this time with AcctSesionId column. There are a lot of rows that have different AcctUniqueId value with the same AcctSessionId (Is the same record, about the same user). Should I to define AcctSessionId as a unique index? AcctSessionId is generated by the NAS. Will be problematic to make this change in the table? Records have not delay. In AcctStartTime column the difference between both rows is 21 seconds. Any ideas? Thank you very much. Regards, Antonio. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Duplicated records in RADACCT with differents delay times
Hi Arran, Could you tell me what is the reason why there are duplicated records in radacct? NAS's configuration mistakes? Why AcctUniqueId is not a UNIQUE INDEX by default? Is a bug? Could I have any problem after execute this alter into the radacct table? I hope your answer. Best regards, Antonio. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Duplicated records in RADACCT with differents delay times
Ok, thank you for your answer. Best regards, Antonio. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Duplicated records in RADACCT with differents delay times
Hi everybody, I have a problema with my FreeRADIUS accounting. I have detected that there are a lot of records duplicated but with different AcctStartDelay and AcctStopDelay. In raddact table appears for the same user more than one use when should appear only one. AN EXAMPLE === INSERT INTO `radacct` (`RadAcctId`, `AcctSessionId`, `AcctUniqueId`, `UserName`, `Realm`, `NASIPAddress`, `NASPortId`, `NASPortType`, `AcctStartTime`, `AcctStopTime`, `AcctSessionTime`, `AcctAuthentic`, `ConnectInfo_start`, `ConnectInfo_stop`, `AcctInputOctets`, `AcctOutputOctets`, `CalledStationId`, `CallingStationId`, `AcctTerminateCause`, `ServiceType`, `FramedProtocol`, `FramedIPAddress`, `AcctStartDelay`, `AcctStopDelay`, `XAscendSessionSvrKey`) VALUES (3970329, '80d0090b', '28e7b4a55f1dead8', 'ni334ROHUH', '', '192.168.1.102', '2161117451', 'Wireless-802.11', '2013-02-05 20:14:42', '2013-02-05 20:39:23', 1481, '', '', '', 1443428, 3321047, 'aptrevoli', 'E0:B9:BA:DB:B4:E4', 'Lost-Service', '', '', '172.21.0.31', 4, 4, ''); INSERT INTO `radacct` (`RadAcctId`, `AcctSessionId`, `AcctUniqueId`, `UserName`, `Realm`, `NASIPAddress`, `NASPortId`, `NASPortType`, `AcctStartTime`, `AcctStopTime`, `AcctSessionTime`, `AcctAuthentic`, `ConnectInfo_start`, `ConnectInfo_stop`, `AcctInputOctets`, `AcctOutputOctets`, `CalledStationId`, `CallingStationId`, `AcctTerminateCause`, `ServiceType`, `FramedProtocol`, `FramedIPAddress`, `AcctStartDelay`, `AcctStopDelay`, `XAscendSessionSvrKey`) VALUES (3970328, '80d0090b', '28e7b4a55f1dead8', 'ni334ROHUH', '', '192.168.1.102', '2161117451', 'Wireless-802.11', '2013-02-05 20:14:38', '2013-02-05 20:39:23', 1481, '', '', '', 1443428, 3321047, 'aptrevoli', 'E0:B9:BA:DB:B4:E4', 'Lost-Service', '', '', '172.21.0.31', 0, 4, ''); === Anybody knows how could I fix this? Regards, Antonio. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Duplicated records in RADACCT with differents delay times
Ok, thank you for your reply. We are going to study how to process the records that already exist in the table. Regards, Antonio. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
FreeRADIUS using InnoDB.
Hi everybody, Are there any problem known about FreeRADIUS use with InnoDB as engine of MySQL? I know that FreeRADIUS has been developed for using MyISAM as engine but I think that could improve FreeRADIUS' performance. Any ideas? Thanks everybody. Best regards, Antonio Fernández. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Fwd: MySQL and FreeRADIUS environment.
Hi everybody, In my company we are thinking to implement a FreeRADIUS server with MySQL on Linux. We need to duplicate FreeRADIUS service because we think that this is a critical service for us but the authentication process only could be done with the master server(FreeRADIUS and MySQL service, both in only one server). For the other hand, if we want to replicate the data base servers, we would have to synchronize two database servers but we would not know wich would be the best solution, cluster or synchronize. Maybe we will not to need a MySQL cluster service and we will need two servers only. First with master FreeRADIUS service and master MySQL service and the second with slave FreeRADIUS service and slave MySQL service. What do you think about the best solution to implement this environment? I hope your answer. Thank you very much. Regards, -- *Antonio Manuel Fernández Pérez* Ingeniero Técnico Informático Dpto. Informático Fabergames S.L. TLF:96626 / FAX:966551801 www.fabergames.com Fabergames respeta su privacidadhttp://www.fabergames.com/index.php/component/content/article/57/1-politica-de-privacidad * * * ADVERTENCIA LEGAL * * * Le informamos, como destinatario de este mensaje, que el correo electrónico y las comunicaciones por medio de Internet no permiten asegurar ni garantizar la confidencialidad de los mensajes transmitidos, así como tampoco su integridad o su correcta recepción, por lo que FABERGAMES S.L. no asume responsabilidad alguna por tales circunstancias. Si no consintiese en la utilización del correo electrónico o de las comunicaciones vía Internet le rogamos nos lo comunique y ponga en nuestro conocimiento de manera inmediata. Este mensaje va dirigido, de manera exclusiva, a su destinatario y contiene información confidencial y sujeta al secreto profesional, cuya divulgación no está permitida por la ley. En caso de haber recibido este mensaje por error, le rogamos que, de forma inmediata, nos lo comunique mediante correo electrónico remitido a nuestra atención o a través del teléfono (+ 34) 966 26 11 11 y proceda a su eliminación, así como a la de cualquier documento adjunto al mismo. Asimismo, le comunicamos que la distribución, copia o utilización de este mensaje, o de cualquier documento adjunto al mismo, cualquiera que fuera su finalidad, están prohibidas por la ley. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html