On Sat, Jan 28, 2012 at 3:03 PM, Alan Buxey a.l.m.bu...@lboro.ac.uk wrote:
What??
You dont need that kind of hardware for job, sure. Throwing that kind of
horsepower might fix the speed but this is a DBA question.
Look at your mysql configuration and see how it can be adjusted (my.cnf)
look
YvesDM wrote:
Just wondering, do you see performance increase using postgres instead
of mysql?
Yes.
MySQL can be higher performance than older versions of PostGreSQL, if
you don't do database writes. Newer versions of Postgres have similar
performance to MySQL, with the benefit of
On Sun, Jan 29, 2012 at 11:36 AM, Alan DeKok al...@deployingradius.comwrote:
YvesDM wrote:
Just wondering, do you see performance increase using postgres instead
of mysql?
Yes.
MySQL can be higher performance than older versions of PostGreSQL, if
you don't do database writes. Newer
Hi,
Sorry to pick into this with a short question.
Just wondering, do you see performance increase using postgres instead of
mysql?
yes. I am a postgreSQL convert. though, that said - out of the box you get
slightly better and safer performance - but you'll still have to configure
Hi,
Our company is using freeradius as a VPN authentication
authorization system. In worse-case say we would have 1 Million users. Beside
scaling our market, we are going to develop an application to analyze
users with data mining algorithms.
Currently we use a server with the following
On 01/28/2012 09:57 AM, Morteza Milani wrote:
Hi,
Our company is using freeradius as a VPN authentication
authorization system. In worse-case say we would have 1 Million users. Beside
scaling our market, we are going to develop an application to analyze
users with data mining algorithms.
Dear,
i've got same problem in the first time that i use freeradius,
first of all, you need to tune your mysql ( my.cnf ) with right
optimization, you can enable slow query logging in order to check if is
mysql or freeradius problem.
when your mysql works fine, you can tune freeradius, like
On Sat, Jan 28, 2012 at 6:10 PM, Phil Mayers p.may...@imperial.ac.uk wrote:
On 01/28/2012 09:57 AM, Morteza Milani wrote:
Hi,
Our company is using freeradius as a VPN authentication
authorization system. In worse-case say we would have 1 Million users.
Beside
scaling our market, we are
What??
You dont need that kind of hardware for job, sure. Throwing that kind of
horsepower might fix the speed but this is a DBA question.
Look at your mysql configuration and see how it can be adjusted (my.cnf) look
at the engine in use and see if you can use better..(eg innodb instead of
1 mil of users and one server... ???
Good luck...
On 1/28/2012 10:57 AM, Morteza Milani wrote:
Hi,
Currently we use a server with the following features:
* RAM: 4 GB
* Processor: 1x E8400 3.0 GHz
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
It's do-able. Though I would be worried about failover and resiliancy.
alan
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Lorenzo Milesi wrote:
This radius has been successfully running for 4y now.
Problems raised since when we increased the number of users.
So? Since you're using the same configuration, the performance
problems must be related to your configuration.
So, by the way, seems like there are two
Don't. Fix the database so that it isn't too slow.
See the logs. If the DB is slow, the logs will usually say.
I have no slow queries on mysql-slow.log.
thanks
--
Lorenzo Milesi - lorenzo.mil...@yetopen.it
YetOpen S.r.l. - http://www.yetopen.it/
Via Carlo Torri Tarelli 19 - 23900 Lecco -
is the db on the same server as freeradius?
yes
there should be something on FR log file. If not, then run the server
in debug mode and see which part is slow or spitting out errors.
will try to look for something
--
Lorenzo Milesi - lorenzo.mil...@yetopen.it
YetOpen S.r.l. -
Lorenzo Milesi wrote:
Don't. Fix the database so that it isn't too slow.
See the logs. If the DB is slow, the logs will usually say.
I have no slow queries on mysql-slow.log.
Then it must be magic. Hire a wizard to fix the problem.
Something *you did* broke the server. Either say what
to.
I *DID* say what I did: increased the amount of accounted users, nothing else.
I said what changes I did to the server in order to improve mysql performance.
This doesn't look to me like saying it doesn't work.
And on the other hand, if I haven't been detailed enough you could have asked
more
there should be something on FR log file. If not, then run the server
in debug mode and see which part is slow or spitting out errors.
I ran in debug, and saw something which maybe could be wrong:
User-Name = MYUSERNAME
User-Password =
configuration* doesn't have the problem you described.
So... what did you change? adding users is *not* the answer I'm
looking for.
I said what changes I did to the server in order to improve mysql performance.
You edited radiusd.conf to improve MySQL performance? That's magic.
This doesn't
Lorenzo Milesi wrote:
there should be something on FR log file. If not, then run the server
in debug mode and see which part is slow or spitting out errors.
I ran in debug, and saw something which maybe could be wrong:
User-Name = MYUSERNAME
User-Password =
On Tue, Sep 20, 2011 at 8:23 PM, Lorenzo Milesi
lorenzo.mil...@yetopen.it wrote:
there should be something on FR log file. If not, then run the server
in debug mode and see which part is slow or spitting out errors.
There are several reasons why I suggest you run the server in debug
mode (as
For one, it can show you which part is slow (is it really the db, or
is it something else). Another one is it can show relevant parts of
the config which can help others pinpoint the problem. Pasting only
PART of the debug log will only get you (at best) partial guesses.
Ok, I missed this, I
On Tue, Sep 20, 2011 at 10:22 PM, Lorenzo Milesi
lorenzo.mil...@yetopen.it wrote:
For one, it can show you which part is slow (is it really the db, or
is it something else). Another one is it can show relevant parts of
the config which can help others pinpoint the problem. Pasting only
PART of
to improve MySQL performance? That's magic.
I never said that. I never mentioned the config file but the config option, so
I must have edited in the RIGHT place, that is for your check in
/etc/freeradius/sql.conf, which is included into radiusd.conf by $INCLUDE
${confdir}/sql.conf. Happy now?
I asked
Your output does not look llike it comes from FR2's debug log.
This first debug log was a -x.
And yes, it's FR 1.1.7! (yes, could have said that before)
Let's say most of the problems come from a newly deployed nas.
Then start from there.
If the db is slow and FR is late to respond,
Lorenzo Milesi wrote:
Ok, I missed this, I thought was a suggestion to me :-)
http://paste.ubuntu.com/693812/
Ugh. Upgrade to 2.1.x.
Another weird thing I noticed is that as you can see at line 155 in the
middle of an Access-Accept report there's another rad_recv, like it's mixing
up
On 2011/09/20 05:22 PM, Lorenzo Milesi wrote:
Ok, I missed this, I thought was a suggestion to me :-)
http://paste.ubuntu.com/693812/
What is:
Can't connect to SNMP agent with SMUX: Connection refused
Is an SNMP connetion of some sorts not maybe slowing it down while
authenticating?
--
Hi.
I have a Freeradius server with MySQL backend, which has worked great so far.
Right now we're increasing the users accounting here, and we're facing some
login issues. Freeradius is used as an accounting service for Chillispot.
I tried increasing num_sql_socks to 14, and raised
On Mon, Sep 19, 2011 at 7:33 PM, Lorenzo Milesi
lorenzo.mil...@yetopen.it wrote:
Hi.
I have a Freeradius server with MySQL backend, which has worked great so far.
Right now we're increasing the users accounting here, and we're facing some
login issues. Freeradius is used as an accounting
Lorenzo Milesi wrote:
Hi.
I have a Freeradius server with MySQL backend, which has worked great so far.
Right now we're increasing the users accounting here, and we're facing some
login issues. Freeradius is used as an accounting service for Chillispot.
I tried increasing num_sql_socks
29 matches
Mail list logo