Problem with Freeradius.net + Mysql in Win server 2008r2
I have installed Freeradius and mysql to use it for a Hostpot network on a Windows 7 64b on test lab and everithing is working fine. Now we are moving it to real server (Win server 2008r2 64b) to auth network clients in radius, and when i uncoment sql in radiussd.conf and i start in debug mode the server stops at: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting to connect to root@localhost:/radius rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 rlm_sql_mysql: Starting connect to MySQL server for #0 and i never go on far from here, and dont conect to db, or do nothing more, i reinstaled, reconfigured, triyed with all ips of mysql db ( is on localhost ) and nothing. any idea? thx -- View this message in context: http://freeradius.1045715.n5.nabble.com/Problem-with-Freeradius-net-Mysql-in... Sent from the FreeRadius - User mailing list archive at Nabble.com.
Turamarth wrote:
I have installed Freeradius and mysql to use it for a Hostpot network on a Windows 7 64b on test lab and everithing is working fine. Now we are moving it to real server (Win server 2008r2 64b) to auth network clients in radius, and when i uncoment sql in radiussd.conf and i start in debug mode the server stops at:
rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting to connect to root@localhost:/radius rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 rlm_sql_mysql: Starting connect to MySQL server for #0
and i never go on far from here, and dont conect to db, or do nothing more, i reinstaled, reconfigured, triyed with all ips of mysql db ( is on localhost ) and nothing.
There is no network connection between FreeRADIUS && MySQL. And FreeRADIUS *doesn't* run on Windows. There's a "freeradius.net", which is version 1.1.7. That is very old, and not supported. I suggest using a different OS. e.g. Linux or BSD. You can then run a recent version of the server. Alan DeKok.
i have no chance to change the OS. of server, and yes im using Freeradius.net. i review the sql.conf and radiussd.conf files looking for errors and nothing, the radius server still dont connect to mysql server. -------------------------------------------------- From: "Alan DeKok" <aland@deployingradius.com> Sent: Tuesday, May 29, 2012 8:11 AM To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org> Subject: Re: Problem with Freeradius.net + Mysql in Win server 2008r2
Turamarth wrote:
I have installed Freeradius and mysql to use it for a Hostpot network on a Windows 7 64b on test lab and everithing is working fine. Now we are moving it to real server (Win server 2008r2 64b) to auth network clients in radius, and when i uncoment sql in radiussd.conf and i start in debug mode the server stops at:
rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting to connect to root@localhost:/radius rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 rlm_sql_mysql: Starting connect to MySQL server for #0
and i never go on far from here, and dont conect to db, or do nothing more, i reinstaled, reconfigured, triyed with all ips of mysql db ( is on localhost ) and nothing.
There is no network connection between FreeRADIUS && MySQL.
And FreeRADIUS *doesn't* run on Windows. There's a "freeradius.net", which is version 1.1.7. That is very old, and not supported.
I suggest using a different OS. e.g. Linux or BSD. You can then run a recent version of the server.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Turamarth wrote:
i have no chance to change the OS. of server,
Nonsense. It should take you all of 2 hours to download a Linux distribution, and run it inside of a VM.
and yes im using Freeradius.net.
i review the sql.conf and radiussd.conf files looking for errors and nothing, the radius server still dont connect to mysql server.
There is nothing we can do. Alan DeKok.
the matter is not change the server Os. i have the same version of Freeradius.net running in a Win 7 64, and now need move it to Win server 2008r2, must be a way to make it work. i just cant change the os or run a vm with a linux inside. From: Alan DeKok-2 [via FreeRadius] Sent: Tuesday, May 29, 2012 9:00 AM To: Turamarth Subject: Re: Problem with Freeradius.net + Mysql in Win server 2008r2 Turamarth wrote:
i have no chance to change the OS. of server,
Nonsense. It should take you all of 2 hours to download a Linux distribution, and run it inside of a VM.
and yes im using Freeradius.net.
i review the sql.conf and radiussd.conf files looking for errors and nothing, the radius server still dont connect to mysql server.
There is nothing we can do. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -------------------------------------------------------------------------------- If you reply to this email, your message will be added to the discussion below: http://freeradius.1045715.n5.nabble.com/Problem-with-Freeradius-net-Mysql-in... To unsubscribe from Problem with Freeradius.net + Mysql in Win server 2008r2, click here. NAML -- View this message in context: http://freeradius.1045715.n5.nabble.com/Problem-with-Freeradius-net-Mysql-in... Sent from the FreeRadius - User mailing list archive at Nabble.com.
Turamarth wrote:
the matter is not change the server Os.
The problem is that we don't KNOW what the problem is. And we CANNOT help you.
i have the same version of Freeradius.net running in a Win 7 64, and now need move it to Win server 2008r2, must be a way to make it work.
Sure. Do it yourself. We CANNOT help you.
i just cant change the os or run a vm with a linux inside.
Nonsense. Alan DeKok.
On Tue, May 29, 2012 at 7:03 PM, Turamarth <admin@turamarth.com> wrote:
i have the same version of Freeradius.net running in a Win 7 64, and now need move it to Win server 2008r2, must be a way to make it work.
Yes, there is. A sufficiently-knowledgable windows sysadmin would know what adjustments to make to make applications work when migrating from one version to the other. However most users on this list (the ones that can give you good advice for free) uses recent version of freeradius (2.1.x) on unix-like OS. Which means they can mostly help in those implementation Since you use a rare setup, you need to either: - learn by yourself how to do it, OR - hire someone with more knowledge in that particular setup to do it for you.
i just cant change the os or run a vm with a linux inside.
Depending on the situation, it might be easier for you in the long term to do so. Really. Sticking with an unsupported software in a rare configuration is usually a bad thing. FWIW though, you might be able to workaround your problem by using IP of mysql server (e.g. 127.0.0.1) instead of localhost. IIRC mysql treats those two differently. -- Fajar
FWIW though, you might be able to workaround your problem by using IP of mysql server (e.g. 127.0.0.1) instead of localhost. IIRC mysql treats those two differently.
i had this problem on test machine with win 7, and i tried with all ips of machine. From: Fajar A. Nugraha-2 [via FreeRadius] Sent: Tuesday, May 29, 2012 9:57 AM To: Turamarth Subject: Re: Problem with Freeradius.net + Mysql in Win server 2008r2 On Tue, May 29, 2012 at 7:03 PM, Turamarth <[hidden email]> wrote:
i have the same version of Freeradius.net running in a Win 7 64, and now need move it to Win server 2008r2, must be a way to make it work.
Yes, there is. A sufficiently-knowledgable windows sysadmin would know what adjustments to make to make applications work when migrating from one version to the other. However most users on this list (the ones that can give you good advice for free) uses recent version of freeradius (2.1.x) on unix-like OS. Which means they can mostly help in those implementation Since you use a rare setup, you need to either: - learn by yourself how to do it, OR - hire someone with more knowledge in that particular setup to do it for you.
i just cant change the os or run a vm with a linux inside.
Depending on the situation, it might be easier for you in the long term to do so. Really. Sticking with an unsupported software in a rare configuration is usually a bad thing. FWIW though, you might be able to workaround your problem by using IP of mysql server (e.g. 127.0.0.1) instead of localhost. IIRC mysql treats those two differently. -- Fajar - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -------------------------------------------------------------------------------- If you reply to this email, your message will be added to the discussion below: http://freeradius.1045715.n5.nabble.com/Problem-with-Freeradius-net-Mysql-in... To unsubscribe from Problem with Freeradius.net + Mysql in Win server 2008r2, click here. NAML -- View this message in context: http://freeradius.1045715.n5.nabble.com/Problem-with-Freeradius-net-Mysql-in... Sent from the FreeRadius - User mailing list archive at Nabble.com.
Have you installed MySQL on the new machine and also is it started? localhost indicates that freeradius is looking for mysql on the machine from which it is running. Or is it running from a different machine? In which case you need to change the server parameter in sql.conf. You may need to open the firewall on port 3306 on the machine running mysql if accessing mysql over the network. On Tue, May 29, 2012 at 12:10 PM, Turamarth <admin@turamarth.com> wrote:
I have installed Freeradius and mysql to use it for a Hostpot network on a Windows 7 64b on test lab and everithing is working fine. Now we are moving it to real server (Win server 2008r2 64b) to auth network clients in radius, and when i uncoment sql in radiussd.conf and i start in debug mode the server stops at:
rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting to connect to root@localhost:/radius rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 rlm_sql_mysql: Starting connect to MySQL server for #0
and i never go on far from here, and dont conect to db, or do nothing more, i reinstaled, reconfigured, triyed with all ips of mysql db ( is on localhost ) and nothing.
any idea? thx
-- View this message in context: http://freeradius.1045715.n5.nabble.com/Problem-with-Freeradius-net-Mysql-in... Sent from the FreeRadius - User mailing list archive at Nabble.com. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
the mysql server is on same machine, is and server that is running for 1 year at least, i connect with same user and password that all other aplications, so is not login problem, or firewall problem, but radius still stop trying to connect, but never says error or something like this, just stay stopped on starting connect to mysql From: DOMINIE.ORG [via FreeRadius] Sent: Tuesday, May 29, 2012 8:44 AM To: Turamarth Subject: Re: Problem with Freeradius.net + Mysql in Win server 2008r2 Have you installed MySQL on the new machine and also is it started? localhost indicates that freeradius is looking for mysql on the machine from which it is running. Or is it running from a different machine? In which case you need to change the server parameter in sql.conf. You may need to open the firewall on port 3306 on the machine running mysql if accessing mysql over the network. On Tue, May 29, 2012 at 12:10 PM, Turamarth <[hidden email]> wrote: I have installed Freeradius and mysql to use it for a Hostpot network on a Windows 7 64b on test lab and everithing is working fine. Now we are moving it to real server (Win server 2008r2 64b) to auth network clients in radius, and when i uncoment sql in radiussd.conf and i start in debug mode the server stops at: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting to connect to root@localhost:/radius rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 rlm_sql_mysql: Starting connect to MySQL server for #0 and i never go on far from here, and dont conect to db, or do nothing more, i reinstaled, reconfigured, triyed with all ips of mysql db ( is on localhost ) and nothing. any idea? thx -- View this message in context: http://freeradius.1045715.n5.nabble.com/Problem-with-Freeradius-net-Mysql-in... Sent from the FreeRadius - User mailing list archive at Nabble.com. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -------------------------------------------------------------------------------- If you reply to this email, your message will be added to the discussion below: http://freeradius.1045715.n5.nabble.com/Problem-with-Freeradius-net-Mysql-in... To unsubscribe from Problem with Freeradius.net + Mysql in Win server 2008r2, click here. NAML -- View this message in context: http://freeradius.1045715.n5.nabble.com/Problem-with-Freeradius-net-Mysql-in... Sent from the FreeRadius - User mailing list archive at Nabble.com.
Turamarth wrote:
the mysql server is on same machine, is and server that is running for 1 year at least, i connect with same user and password that all other aplications, so is not login problem, or firewall problem,
but radius still stop trying to connect, but never says error or something like this, just stay stopped on starting connect to mysql
It's a problem. Since freeradius.net isn't a supported version of the server, there's really nothing we can do. Alan DeKok.
Hi,
I have installed Freeradius and mysql to use it for a Hostpot network on a Windows 7 64b on test lab and everithing is working fine. Now we are moving it to real server (Win server 2008r2 64b) to auth network clients in radius, and when i uncoment sql in radiussd.conf and i start in debug mode the server stops at:
rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting to connect to root@localhost:/radius rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 rlm_sql_mysql: Starting connect to MySQL server for #0
...and what does the MySQL server output show? forget the FreeRADIUS for a second here and check the MySQL part of it - have you added the right user priviledges to the MySQL? is the server running? etc alan
the mysql server is running, 2 websites uses it, and the radius uses the same credentials to log in. From: Alan Buxey [via FreeRadius] Sent: Tuesday, May 29, 2012 10:27 AM To: Turamarth Subject: Re: Problem with Freeradius.net + Mysql in Win server 2008r2 Hi,
I have installed Freeradius and mysql to use it for a Hostpot network on a Windows 7 64b on test lab and everithing is working fine. Now we are moving it to real server (Win server 2008r2 64b) to auth network clients in radius, and when i uncoment sql in radiussd.conf and i start in debug mode the server stops at:
rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting to connect to root@localhost:/radius rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 rlm_sql_mysql: Starting connect to MySQL server for #0
...and what does the MySQL server output show? forget the FreeRADIUS for a second here and check the MySQL part of it - have you added the right user priviledges to the MySQL? is the server running? etc alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -------------------------------------------------------------------------------- If you reply to this email, your message will be added to the discussion below: http://freeradius.1045715.n5.nabble.com/Problem-with-Freeradius-net-Mysql-in... To unsubscribe from Problem with Freeradius.net + Mysql in Win server 2008r2, click here. NAML -- View this message in context: http://freeradius.1045715.n5.nabble.com/Problem-with-Freeradius-net-Mysql-in... Sent from the FreeRadius - User mailing list archive at Nabble.com.
participants (5)
-
alan buxey -
Alan DeKok -
DOMINIE.ORG -
Fajar A. Nugraha -
Turamarth