Many simmultaneos connection with Mysql - VOIP
Hi I have two machines with freeradius and mysql, and the max number of sockets with freeradius and mysql is 256, have any trouble if I change that in the source code and compiled again?. And how I resolve this problem Wed Aug 9 17:16:13 2006 : Error: rlm_sql (sql) in sql_accounting: stop packet with zero session length. [user '200.182.99.75 ', nas '200.182.99.79'] have many thats in my log. The Freeradius and the mysql is used for store the information of the ciscos gateways(voip) and when load the traffic of information the freeradius died, anybody here have this problem? Thanks for all, Thiago Cesar de Oliveira Rodrigues ICQ 41369776 MSN thiago_rodrigues@hotmail.com Yahoo Messeger thiago_ce@yahoo.com http://www.kionux.com.br ----------------------------<br> http://kionux.com.br
<thiago@kionux.com.br> wrote:
Hi I have two machines with freeradius and mysql, and the max number of sockets with freeradius and mysql is 256, have any trouble if I change that in the source code and compiled again?.
No. But it won't do what you want. You have to change the kernel to support more than 256 sockets. The number in FreeRADIUS is just a "best guess".
And how I resolve this problem
Wed Aug 9 17:16:13 2006 : Error: rlm_sql (sql) in sql_accounting: stop packet with zero session length. [user '200.182.99.75 ', nas '200.182.99.79']
Make the NAS send real accounting packets?
The Freeradius and the mysql is used for store the information of the ciscos gateways(voip) and when load the traffic of information the freeradius died, anybody here have this problem?
What version are you running? Alan DeKok. -- http://deployingradius.com - The web site of the book http://deployingradius.com/blog/ - The blog
Hi Alan the version of my freeradius is 1.1.2 and modified rlm_preprocess.c for understand the packets of cisco gateway(Voip) and I modified the sql.conf file too. Per day I have 534 mb data storage in mysql, because per day the radius generate new radacct tables. Thanks for all, If you can help me , It will very apreciate. Em 09.08.2006 às 18:39:40, Alan DeKok <aland@deployingradius.com> escreveu:
<thiago@kionux.com.br> wrote:
Hi I have two machines with freeradius and mysql, and the max number of sockets with freeradius and mysql is 256, have any trouble if I change that in the source code and compiled again?.
No. But it won't do what you want. You have to change the kernel to support more than 256 sockets. The number in FreeRADIUS is just a "best guess".
And how I resolve this problem
Wed Aug 9 17:16:13 2006 : Error: rlm_sql (sql) in sql_accounting: stop packet with zero session length. [user '200.182.99.75 ', nas '200.182.99.79']
Make the NAS send real accounting packets?
The Freeradius and the mysql is used for store the information of the ciscos gateways(voip) and when load the traffic of information the freeradius died, anybody here have this problem?
What version are you running?
Alan DeKok. -- http://deployingradius.com - The web site of the book http://deployingradius.com/blog/ - The blog - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Thiago Cesar de Oliveira Rodrigues ICQ 41369776 MSN thiago_rodrigues@hotmail.com Yahoo Messeger thiago_ce@yahoo.com http://www.kionux.com.br ----------------------------<br> http://kionux.com.br
Em 09.08.2006 às 20:31:27, <thiago@kionux.com.br> escreveu: How I can improve perfomace with Freeeradius and Mysql?
Hi Alan the version of my freeradius is 1.1.2 and modified rlm_preprocess.c for understand the packets of cisco gateway(Voip) and I modified the sql.conf file too.
Per day I have 534 mb data storage in mysql, because per day the radius generate new radacct tables.
Thanks for all, If you can help me , It will very apreciate.
Em 09.08.2006 às 18:39:40, Alan DeKok <aland@deployingradius.com> escreveu:
<thiago@kionux.com.br> wrote:
Hi I have two machines with freeradius and mysql, and the max number of sockets with freeradius and mysql is 256, have any trouble if I change that in the source code and compiled again?.
No. But it won't do what you want. You have to change the kernel to support more than 256 sockets. The number in FreeRADIUS is just a "best guess".
And how I resolve this problem
Wed Aug 9 17:16:13 2006 : Error: rlm_sql (sql) in sql_accounting: stop packet with zero session length. [user '200.182.99.75 ', nas '200.182.99.79']
Make the NAS send real accounting packets?
The Freeradius and the mysql is used for store the information of the ciscos gateways(voip) and when load the traffic of information the freeradius died, anybody here have this problem?
What version are you running?
Alan DeKok. -- http://deployingradius.com - The web site of the book http://deployingradius.com/blog/ - The blog - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Thiago Cesar de Oliveira Rodrigues ICQ 41369776 MSN thiago_rodrigues@hotmail.com Yahoo Messeger thiago_ce@yahoo.com http://www.kionux.com.br
----------------------------<br> http://kionux.com.br - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Thiago Cesar de Oliveira Rodrigues ICQ 41369776 MSN thiago_rodrigues@hotmail.com Yahoo Messeger thiago_ce@yahoo.com http://www.kionux.com.br ----------------------------<br> http://kionux.com.br
thiago@kionux.com.br wrote:
Em 09.08.2006 às 20:31:27, <thiago@kionux.com.br> escreveu:
How I can improve perfomace with Freeeradius and Mysql?
Change the table engine from MyISAM to InnoDB (esp on radacct). That will avoid table locking when inserting rows into the accounting table. Also keeping that table small by archiving old data will help. I try to keep ours to around 6 months of data. I noticed a huge difference once we got more than 8 months of data in the table. Your system will vary depending on number of rows and machine specs. Also make sure you have proper indexes on the tables. See the MySQL docs for EXPLAIN and performace. -- Dennis Skinner Systems Administrator BlueFrog Internet http://www.bluefrog.com
participants (3)
-
Alan DeKok -
Dennis Skinner -
thiago＠kionux.com.br