Re: Redundant mysql authorize not working

Okay for me this is a 99% solution. I use now value is 1 Thanks again i am very happy now... Michel It isn't a solution but an ugly hack :) Em Qui, 2005-02-10 às 20:44 +0100, Michel van Dop escreveu: Hi, This is the solution for slow redundant mysql authorize: echo 0

Re: Redundant mysql authorize not working

Hi Gilbert, I am not sure but i think also this is a bug im mysql driver! Same problems here! But i have a little solution i hope this is working on your situation. We have two location and every location have a own radius server and own mysql db. We also use mysql replication. So there is a

Re: Redundant mysql authorize not working

Hi, This is the solution for slow redundant mysql authorize: echo 0 /proc/sys/net/ipv4/tcp_syn_retries (default value is 5) Thanks to Tiago Micheld - Original Message - From: Michel van Dop [EMAIL PROTECTED] To: freeradius-users@lists.freeradius.org Sent: Thursday, February 10, 2005 3:30

Re: Fail_over mysql again!

driver? Michel - Original Message - From: Dustin Doris [EMAIL PROTECTED] To: freeradius-users@lists.freeradius.org Sent: Wednesday, February 02, 2005 4:41 PM Subject: Re: Fail_over mysql again! On Tue, 1 Feb 2005, Michel van Dop wrote: When i only connect freeradius to the slave db

Fail_over mysql again!

Hello, I have problems on FC1 freeradius 0.9.3 on failover and mysql db's. I use two mysql db's replication. One master db and slave db. So when master is down freeradius server go on on the second slave db whit accounting. So i think there is a bug in version 0.9.3 or sql/driver/module.

Re: Fail_over mysql again!

When i only connect freeradius to the slave db it works great! Same on only master db! I think there is a radiusd.conf problem i find on google more configs old/and very old but not a working solution. The fail-over document on the own radius directory is very old from 2000. Okay thank you for

sql failover

Hi, Sorry for my bad english! I have tryed everything to have it working with failover mysql db's. Somthing i not seeing. I now there is a bug in the accounting redundant.I hope someone can look at my configsand debuging log in this messages and can tell me the problem so i can use

Re: sql failover

Subject: Re: sql failover Michel van Dop said: Hi, Sorry for my bad english! I have tryed everything to have it working with failover mysql db's. Somthing i not seeing. I now there is a bug in the accounting redundant. I hope someone can look at my configs and debuging log in this messages and can tell

Re: Have anyone a good example failover mysql config?

[EMAIL PROTECTED] To: freeradius-users@lists.freeradius.org Sent: Sunday, January 30, 2005 5:58 PM Subject: Re: Have anyone a good example failover mysql config? Michel van Dop wrote: accounting { redundant { sql1 { ok = return

Have anyone a good example failover mysql config?

Hello Freeradius users, Have anyone a good example of failover mysql config (radiusd.conf)? I want to use SQL1, if it's down, try SQL2. I reed the configurable_failover document but it don't work, or not understanding. If now one of my mysql server go down, radius server work slow and failt

Re: Have anyone a good example failover mysql config?

When i shutdown mysql (sql1) he get slow on starting (240 seconds) and after 20 times i get a response. Both mysql servers are working! I test it on a single db radius config. I do this in radiusd.conf $INCLUDE ${confdir}/sql1.conf # sql sql1 { server 1 options } $INCLUDE ${confdir}/sql2.conf

Re: Have anyone a good example failover mysql config?

: Have anyone a good example failover mysql config? Michel van Dop wrote: When i shutdown mysql (sql1) he get slow on starting (240 seconds) and after 20 times i get a response. Both mysql servers are working! I test it on a single db radius config. [...] accounting { redundant { sql1 sql2

Slow second db on freeradius

Hello freeradius users, I use two freeradius servers and two mysql db's (master and slave) On the first db (sql1) is works great.. fast starting and fast response. When is stop the master db (first sql1 db for radius) he must use the second db (slave) When is start radiusd i can wait 80 second

Re: Slow second db on freeradius

I use already the outsite ip address in my second config /etc/raddb/sql2.conf Only on testing radtest is use localhost. But on my radius client i use te outsite ip address. Thank you Mandy Well, I had a similar problem when starting freeradius, it took a loong time, and everybody accused

Re: Slow second db on freeradius

Hello freeradius users, When is start radiusd (master db is down) i use failover db. See log, it take from 13:41 to 13:44 to start connect to the second db. Can any one see in this log whats go wrong? Thu Jan 27 13:41:32 2005 : Info: Using deprecated naslist file. Support for this will go

Re: Slow second db on freeradius

There is a frequntie in it. So i can when i have lucky i can login every 240 seconds. I use second db failover first db is down. Thu Jan 27 14:29:07 2005 : Auth: Login OK: [user/password] (from client nas3.domain.nl port 1812) Thu Jan 27 14:29:10 2005 : Info: rlm_sql (sql1): Trying to

Re: Slow second db on freeradius

I have already make the sub-domains in my named server. I change the domain names in the log i send to this mailinglist. I think this is not a dns problem but i am not a exper. When i change sql1.conf to sql2.conf it works. So second db is working and i use same nas radius client. So i have also

Re: Slow second db on freeradius

updated = 3 reject = return userlock = 4 invalid = 5 handled = 6 } } } - Original Message - From: Alan DeKok [EMAIL PROTECTED] To: freeradius-users@lists.freeradius.org Sent: Thursday, January 27, 2005 8:04 PM Subject: Re: Slow second db on freeradius Michel van Dop

Re: SQL db failover

@lists.freeradius.org Sent: Saturday, January 15, 2005 1:26 AM Subject: Re: SQL db failover Michel van Dop [EMAIL PROTECTED] wrote: So i leave the default config in radiusd.conf include the file sql.conf and put this in my radiusd.conf: $INCLUDE ${confdir}/sql.conf modules { Once again, the include for sql.conf

Re: SQL db failover

Hi, I have to run TWO MySQL servers and have FreeRadius fall over between them modules { # same place where this $INCLUDE ${confdir}/sql.conf $INCLUDE ${confdir}/sql1.conf $INCLUDE ${confdir}/sql2.conf On 'authorize' section of radiusd.conf i change the 'sql' entry to a 'group' one: group

Re: SQL db failover

15, 2005 5:58 PM Subject: Re: SQL db failover Michel van Dop [EMAIL PROTECTED] wrote: Okay i understand that ( i hope so): Now i do this in radiusd.conf: Yup, that should work. I get this error cat /var/log/radius/radius.log Sat Jan 15 13:35:19 2005 : Error: ERROR: Cannot find a configuration

Re: SQL db failover

notfound = return noop = 2 ok = return updated = 3 reject = return userlock = 4 invalid = 5 handled = 6 } } - Original Message - From: Michel van Dop [EMAIL PROTECTED] To: freeradius-users@lists.freeradius.org Sent: Saturday, January 15, 2005 8:11 PM

SQL db failover

Hi, The mirroring between the two mysql db (3.23.58-4) work with the replication mechanism of mysql and I have two sql.conf to describe the way to connect to each db and right config on radiusd.conf I use freeradius-0.9.3-1.1 and freeradius-mysql-0.9.3-1.1 I now this is old but this is the last

Re: SQL db failover

Subject: Re: SQL db failover Michel van Dop [EMAIL PROTECTED] wrote: I use freeradius-0.9.3-1.1 and freeradius-mysql-0.9.3-1.1 I now this is old but this is the last stap! I would suggest upgrading. See http://www.freeradius.org/security.html I have this in the radiusd.conf $INCLUDE ${confdir

Re: dialup_admin - blank right frames

I had the same problems. This is my solutions: [EMAIL PROTECTED] dialup]# pwd /var/www/html/dialup [EMAIL PROTECTED] dialup]# ln -s /usr/local/dialup_admin/htdocs htdocs [EMAIL PROTECTED] dialup]# ls -l total 0 lrwxrwxrwx 1 root root 30 Jan 13 21:15 htdocs - /usr/local/dialup_admin/htdocs [EMAIL

Re: dialup_admin - blank right frames

Hi Lewis, I have the same problem (blank right screen). Phpmyadmin works good on this server (httpd)?! If you start httpd services get you also this error? [EMAIL PROTECTED] root]# service httpd restart Stopping httpd:[ OK ] Starting httpd: httpd:

Re: dialup_admin - blank right frames

the MIME configuration# file mime.types for specific file types.#AddType application/x-tar .tgzAddType application/x-httpd-php .phpAddType application/x-httpd-php .php3and restart your apache then it will display correctly.I hope this help.Quoting Michel van Dop [EMAIL PROTECTED]: Hi

Re: dialup_admin - blank right frames

Kalevras [EMAIL PROTECTED] To: freeradius-users@lists.freeradius.org Sent: Tuesday, January 11, 2005 6:46 PM Subject: Re: dialup_admin - blank right frames On Tue, 11 Jan 2005, Michel van Dop wrote: Hi, Thank you for the fast response but i add this in my httpd.conf: AddType application/x-tar .tgz

Re: Freeradius on two Mysql servers?

on the second server ? sql1.conf refer to localhost so it is OK on both server. # Connect info server = "xxx.xxx.xxx.xxx" login = "radius" password = "xx" diane -Original Message-From: Michel van Dop [mailto:

Re: Accounting proxying

Hi, I am using chillispot software on more than 5 wrt54gs and we use freeradius . We have 2 freeradius server on 2 mysql we use replication so there is a master db and a slave db. We want use one freeradius server (use master db), only when freeradius (use master db) is offline we want to second

How to change personal fields dialup_admin?

Hello, I wanne change in the dialup_admin the Personal Information page fields. I now i can change in the admin.conf the user-info tabelname. But how can i change the tabel fields, i can change the the user_info.php3. But i thing there is a better solutions for this, but i don't now how? Thank

Re: Ttotacct is empty in mysql db, how to?

: NO) - Original Message - From: Kostas Kalevras [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 09, 2004 11:45 PM Subject: Re: Ttotacct is empty in mysql db, how to? On Thu, 9 Dec 2004, Michel van Dop wrote: Hello, I using freeradius-mysql-0.9.3-1.1 on fedora 1, i

Ttotacct is empty in mysql db, how to?

Hello, I using freeradius-mysql-0.9.3-1.1 on fedora 1,i connect to mysql server 3.58.x db.It workokay mysql on username and groupname. Mytotacct is empty in mysql db. Can anyone tell me how to config this or can me send a good link with information about this. Thank you to read my problem,