Re: freeradius-users@lists.freeradius.org
Ivan Kalik wrote: password = "radpass" This does not work. No wonder. What is the next config line in sql.conf, after these? Ivan Kalik Kalik Informatika ISP I don't know how I MISSED it? BIG THANKS. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
freeradius-users@lists.freeradius.org
Is there any way to setup freeRADIUS to connect to "my_db" instead of "radius" database? I have setup freeRADIUS successfully to connect to a backend PostgreSQL database. My original TEST setup is done by following the standard instruction bt creating a "radius" database & "radius" role/User. sql.con has the following instructions,which I believe make this connection; database = postgres server = "pg1" login = "radius" password = "radpass" When I start the RADIUS in the DEBUG mode, I see this line; rad...@pg1:/radius and it connects & no error is displayed. No I want to change the database to"my_db" & a Schema "radius". PostgreSQL is both of them created. I changed "sql.conf" to: database = postgres server = "pg1" login = "my_db" password = "radpass" This does not work. - Is there any way to further change the freeRADIUS configuration to have it connect to"my_db" & "radius" Schema? Is it possible that freeRADIUS software is hard coded that it will only connect to a "radius" Database with "radius" Schema? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Reading material!
1. Is there any written description of all the tables, columns, etc. What they are? What data goes in them? How & when they are created? 2. PostgreSQL/freeRADIUS: Where are the accounting tables? Where can I read about them? How are they created? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
freeRADIUS first test with PostgreSQL?
I am ready to test my first freeRADIUS server with PostgreSQK backend. He is my setup: freeRADIUS Server: -CentOS 5.3 -freeRADIUS V# 2.1.6 (RPM install) -PostgreSQL V# 8.3.7 (RPM install) - Client eth0: Connect to the Internet eth1: Connected to the backend server thru a hub Backend Server: -CentOS 5.3 -PostgreSQL V# 8.3.7 (RPM install) - Server eth0: Connects to freeRADIUSserver via a hub. Both servers talk. I have = First I configured the necessary files (without backend SQL) and tested the RADIUS server in debug mode: radtest testid testpw localhost 0 testing123 -and- NTRadPing Test was a SUCCESS!!! = Now I have configured so that freeRADIUS uses the backend for sql data/tables. I have created the radius database & radius role. I have created RADIUS tables from schema.sql text file. = Now I need HELP. I need to add a couple of USER/PW into the PostgreSQL tables to test. How do I do that? Is there a GUI to add UID/PW? Are UID/PW added manually? Where can read about it? (Please donotjust point to the manual. I have read them all. At least mention Chapter #) What else should I know? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
How to enter users in sql?
I have successfully setup a freeRADIUS server with PostgreSQL backend (separate) server. When I start freeRADIUS in test mode 'radiusd -X', it connects to the sql server and there is no error. I have two general questions: 1. I need to add one or two test UID & PW in the SQL database. Is there a GUI application available to accomplish that or I have to do it manually entering the data? 2. When the freeRADIUS server is live (on-line) how does user authentication data gets added into the database? In MD5, LINUX has an application to add USER Name & Group (created automatically) which both email program (such as Postfix) and freeRADIUS authenticate against. How is it done in PostgreSQL? I have tried to post this question as clearly as I can. Please ask and clarification! Jennifer K. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Create Database/Tables -PostgreSQL
Ivan Kalik wrote: Of course not by hand. Yes, there are procedures for creating databases, users, assigning users to databases, giving them permissions etc., even reading input from a file (there are actually several options for doing that). Perhaps you should first find out what these things are for: http://www.postgresql.org/docs/manuals/ Ivan Kalik Kalik Informatika ISP Ivan: I have gone through all 2,000+ pages of the manual you mentioned. Somehow I missed answer to my question. Will you be kind enough to let me know the chapter where it discusses creating data using a text file? Thanks. Jennifer - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Create Database/Tables -PostgreSQL
I am trying to create pgsql database/tables for freeRADIUS. I notice that PostgreSQL has a schema for freeRADUS. Is there any procedure to create the DB/Tables from this schema or I have to type all the lines to create table manually? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
How to: freeRADIUS with PostgreSQL Backend!
I have setup a working freeRADIUS server & now want to add PostgreSQL as backend for storage of data. I have read the freeRADIUS documentation and researched the internet on this subject. What I am looking for is any kind of Step-by-Step document detailing sequential steps needed to setup a PostgreSQL back end for freeRADIUS. Has someone written such a document? Is there such a writeup available? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: freeRADIUS - New Install testing!
John Dennis wrote: radtest is in the utils subpackage. Thanks.It works fine. Jennifer - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
freeRADIUS - New Install testing!
Installed freeradius-2.2.1 (RPM). Installation & configuration went well. RADIUS starts with no problem. "radiusd -XC" output shows no errors. Now I want to do some preliminary testing. In the older versions, I used to run the command: radtest localhost and see the output to verify that RADIUS server was up and running. After I did the above install, "radtest" command is not included. How does one test a new freeRADIUS installation? Is "radtest" replaced by another command? Is there any GUI testing tool for RADIUS? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: current RHEL/CentOS pre-built packages (Was: freeRADIUS)
John Dennis wrote: Did you read the FAQ listed at the top. The section "Why are there optional subpackages instead of just one package?" should have explained it, was it not clear? If so I'll update it to make it clearer if you explain what was not clear. Yes I read it and read it again after receiving the above email.Missed it both times. Thank for your HELP. Jennifer - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: current RHEL/CentOS pre-built packages (Was: freeRADIUS)
John Dennis wrote: Just E. Mail wrote: I am trying to install freeRADIUS on a CentOS 5.3 machine with PostgreSQL-8.3.7. My plan is to first install freeRADIUS and test it then setup PostgreSQL as the backend to store data. Is there any freeRADIUS RPMS V#2.1.4 or newer for CentOS? No, the version in RHEL and CentOS is 1.1.3. The following link explains why and also explains how to acquire and build a current FreeRADIUS RPM for RHEL/CentOS (but read the rest of this email, pre-built versions are coming). http://wiki.freeradius.org/Red_Hat_FAQ I read response from John Dennis and looked at the web site URL he provided. I am ready to install FR and I have one more question! In my setup, I plan to (1) Install FR and test it and if everything works, then (2) setup PostgreSQL backend at a SQL server and test it again. I noticed that at the URL listed by John Dennis, there are two files; freradius-2.2.1.6-1.el5.i386.rpm freradius-postgresql-2.2.1.6-1.el5.i386.rpm I am pretty new to FR so please advice; do I need to install both of these RPMs or just the second for my setup to work? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
freeRADIUS
I am trying to install freeRADIUS on a CentOS 5.3 machine with PostgreSQL-8.3.7. My plan is to first install freeRADIUS and test it then setup PostgreSQL as the backend to store data. Is there any freeRADIUS RPMS V#2.1.4 or newer for CentOS? Jennifer - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Which version?
OK.. I am ready to install freeRADIUS!. I have setup a LINUX server with: CentOS 5.2 mySQL-server-5.0.25-7 I noticed that 2.1.3 is the latest freeRADIUS version. Does it work with the above OS & mySQL versions or I need to fall back to a previous version of freeRADIUS? I am pretty new and this is my first freeRADIUS installation! Sam - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Accounting Software
Hello: My first try on freeRADIUS. I am going to setup a test freeRADIUS server with CentOS 5.2 & mySQL for learning about RADIUS server. Questions: 1. Is there a GUI application to setup freeRADIUS? 2. Is there a free accounting package (must interface with mySQL) I can use? Thanks. Sam - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html