Re: User Survey - Which DB backend do you use?
PostgreSQL 7.3.3 On Mon, 2003-07-14 at 11:04, Tim McCracken wrote: > MySql > > On Mon, 14 Jul 2003 10:30:52 +0300 > Peter Nixon <[EMAIL PROTECTED]> wrote: > >Hi List > > > >I would like to take a quick straw poll. > > > >a) If you use a Database backend for FreeRadius which one > >do you use? > > > >b) If you do not use a DB backend for FreeRadius, but do > >have a DB on your > >server or in your rack, what DB is it? > > > >c) If you do not use a DB backend for FreeRadius, but do > >have a DB on your > >server or in your rack, why don't you use it as a backend > >to FreeRadius? > > > >Please reply to this thread on the mailing list or to me > >directly (I am one of > >the developers) if you wish to keep the info private. > >I will post a summary in a few days. > > > >Thanks in Advance > > > >-- > > > >Peter Nixon > >http://www.peternixon.net/ > >PGP Key: http://www.peternixon.net/public.asc > > > > > >- > >List info/subscribe/unsubscribe? See > >http://www.freeradius.org/list/users.html > > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: User Survey - Which DB backend do you use?
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of > Peter Nixon > Sent: Monday, July 14, 2003 12:31 AM > To: [EMAIL PROTECTED] > Subject: User Survey - Which DB backend do you use? > > > Hi List > > I would like to take a quick straw poll. > > a) If you use a Database backend for FreeRadius which one do you use? > MySQL > b) If you do not use a DB backend for FreeRadius, but do have > a DB on your > server or in your rack, what DB is it? > > c) If you do not use a DB backend for FreeRadius, but do have > a DB on your > server or in your rack, why don't you use it as a backend to > FreeRadius? > > Please reply to this thread on the mailing list or to me > directly (I am one of > the developers) if you wish to keep the info private. > I will post a summary in a few days. > > Thanks in Advance > > -- > > Peter Nixon > http://www.peternixon.net/ > PGP Key: http://www.peternixon.net/public.asc > > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: User Survey - Which DB backend do you use?
On Mon July 14 2003 19:36, Miranda Gomez Miguel Angel wrote: > Postgres, using a modified version of Perter Nixon schema, i found that > some items in the insert querys doesnt have the corresponding column in the > schema, these mostly was complementary changes , i do agree with Peter, i > began using mysql, but switched to postgres after a couple of months, the > main reason was the lack of store procedures and triggers in mysql, the > Peter's voip schema is very simple and easy to understand. > Thanks to Peter for a great work, You are welcome. Glad to know someone else is using my stuff :-) If you have made any changes that you think would benefit others please send them to me... -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: User Survey - Which DB backend do you use?
> From: Peter Nixon [mailto:[EMAIL PROTECTED] > Subject: Updated User Survey - Which DB backend do you use? > d) If you do use a DB backend for FR do you use the default SQL queries that > come with FR or have you written your own? If you wrote your own, would you > mind sharing them with us (with a description please)? -- Postgres, using a modified version of Perter Nixon schema, i found that some items in the insert querys doesnt have the corresponding column in the schema, these mostly was complementary changes , i do agree with Peter, i began using mysql, but switched to postgres after a couple of months, the main reason was the lack of store procedures and triggers in mysql, the Peter's voip schema is very simple and easy to understand. Thanks to Peter for a great work, --- Miguel Miranda - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: User Survey - Which DB backend do you use?
Sorry, just getting around to reading all this stuff: Peter Nixon wrote: Hi List I would like to take a quick straw poll. a) If you use a Database backend for FreeRadius which one do you use? LDAP for Auth and Postgresql for Accounting. b) If you do not use a DB backend for FreeRadius, but do have a DB on your server or in your rack, what DB is it? I also have a mysql database but only use it for webapps that only work with it. c) If you do not use a DB backend for FreeRadius, but do have a DB on your server or in your rack, why don't you use it as a backend to FreeRadius? I don't use the RDMS for Authentication because LDAP is a far better authentication database with much more support (sendmail, pam, apache, proftpd, etc). Please reply to this thread on the mailing list or to me directly (I am one of the developers) if you wish to keep the info private. I will post a summary in a few days. Thanks in Advance - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: User Survey - Which DB backend do you use?
On Mon, Jul 14, 2003 at 10:30:52AM +0300, Peter Nixon wrote: > I would like to take a quick straw poll. > > a) If you use a Database backend for FreeRadius which one do you use? MySQL Simon. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: User Survey - Which DB backend do you use?
MySql On Mon, 14 Jul 2003 10:30:52 +0300 Peter Nixon <[EMAIL PROTECTED]> wrote: Hi List I would like to take a quick straw poll. a) If you use a Database backend for FreeRadius which one do you use? b) If you do not use a DB backend for FreeRadius, but do have a DB on your server or in your rack, what DB is it? c) If you do not use a DB backend for FreeRadius, but do have a DB on your server or in your rack, why don't you use it as a backend to FreeRadius? Please reply to this thread on the mailing list or to me directly (I am one of the developers) if you wish to keep the info private. I will post a summary in a few days. Thanks in Advance -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: User Survey - Which DB backend do you use?
On Mon, 14 Jul 2003 04:24 pm, Bernie, CTA wrote: > On 14 Jul 2003 at 10:30, Peter Nixon wrote: > > Hi List > > > > I would like to take a quick straw poll. > > > > a) If you use a Database backend for FreeRadius which one do you > > use? > > We are an BSDi / Open BSD environment>>> > > Accounting - Redundant Postgres DB > == to other DBMS such as MySQL, Oracle its: > 1. No license fee > 2. Less Security Vulnerabilities > 3. Easier to replacate > 4. Lends to a Decentralized / Virtually Centralized DBMS > topology, which is better for security applications > 5. Better Transaction Processing Performance > 6. Less overhead > 7. Control of source > 8. Scales well > 9. Faster Yep. No arguements from me on these :-) For general purpose DB work Postgres pretty much walks all over the competition when you take all these factors into account. I can only imagine needing to pay for a commercial DB if I was handling Terabytes of data. (Postgres happily handles many gigabytes of data per table for me currently) Do you mind telling me what replication system you use (Postgres has several) and how you find it? Are there any gotchas/problems? (I currently run my DBs standalone as I simply don't have the reliability issues with postgres that used to force me to replicate/cluster my MySQL boxes..) TIA -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: User Survey - Which DB backend do you use?
On 14 Jul 2003 at 10:30, Peter Nixon wrote: > Hi List > > I would like to take a quick straw poll. > > a) If you use a Database backend for FreeRadius which one do you > use? > We are an BSDi / Open BSD environment>>> Accounting - Redundant Postgres DB == to other DBMS such as MySQL, Oracle its: 1. No license fee 2. Less Security Vulnerabilities 3. Easier to replacate 4. Lends to a Decentralized / Virtually Centralized DBMS topology, which is better for security applications 5. Better Transaction Processing Performance 6. Less overhead 7. Control of source 8. Scales well 9. Faster Auth/Authr - Multiple flat files crypted pass (by Realm) with custom admin system (1000 and 5000 users per Realm / Group) Reason: Compared to DBMS its: 1. Faster 2. Easier to Maintain 3. More Reliable 4. More Secure 5. Independent Fault Tolerant 6. More flexibility for customization. > b) If you do not use a DB backend for FreeRadius, but do have a > DB on your server or in your rack, what DB is it? > see A > c) If you do not use a DB backend for FreeRadius, but do have a > DB on your server or in your rack, why don't you use it as a > backend to FreeRadius? > see A > Please reply to this thread on the mailing list or to me directly > (I am one of the developers) if you wish to keep the info > private. I will post a summary in a few days. > > Thanks in Advance > > -- > > Peter Nixon > http://www.peternixon.net/ > PGP Key: http://www.peternixon.net/public.asc > > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > - Bernie Chief Technology Architect Chief Security Officer [EMAIL PROTECTED] Euclidean Systems, Inc. *** // "There is no expedient to which a man will not go //to avoid the pure labor of honest thinking." // Honest thought, the real business capital. // Observe> Think> Plan> Think> Do> Think> *** - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: User Survey - Which DB backend do you use?
> a) If you use a Database backend for FreeRadius which one do you use? mysql with InnoDB table structure. It's locking only rows, not entire table. It is fast, and I never had problems with that. For Dial-IN accounting it works well. Def - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: User Survey - Which DB backend do you use?
We use LDAP for users info check. MySQL for accounting. Detail files for Accounting. And shifting to Oracle for Accounting. Hope that helps. Gene -Original Message- From: Peter Nixon [mailto:[EMAIL PROTECTED] Sent: Monday, July 14, 2003 3:31 AM To: [EMAIL PROTECTED] Subject: User Survey - Which DB backend do you use? Hi List I would like to take a quick straw poll. a) If you use a Database backend for FreeRadius which one do you use? b) If you do not use a DB backend for FreeRadius, but do have a DB on your server or in your rack, what DB is it? c) If you do not use a DB backend for FreeRadius, but do have a DB on your server or in your rack, why don't you use it as a backend to FreeRadius? Please reply to this thread on the mailing list or to me directly (I am one of the developers) if you wish to keep the info private. I will post a summary in a few days. Thanks in Advance -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: User Survey - Which DB backend do you use?
At 10:30 AM 7/14/03 +0300, you wrote: Hi List I would like to take a quick straw poll. a) If you use a Database backend for FreeRadius which one do you use? postgresql b) If you do not use a DB backend for FreeRadius, but do have a DB on your server or in your rack, what DB is it? n/a c) If you do not use a DB backend for FreeRadius, but do have a DB on your server or in your rack, why don't you use it as a backend to FreeRadius? n/a Please reply to this thread on the mailing list or to me directly (I am one of the developers) if you wish to keep the info private. I will post a summary in a few days. Thanks in Advance -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: User Survey - Which DB backend do you use?
Peter Nixon wrote: > a) If you use a Database backend for FreeRadius which one do you use? Postgres. -- Regards, Daryl Tester, Software Wrangler and Bit Herder, IOCANE Pty. Ltd. SCO Rep: "Linux must die! We shall prevail!" Offsider: "Bill, they can see your shirt sleeve." -- http://ars.userfriendly.org/cartoons/?id=20030609 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: User Survey - Which DB backend do you use?
Hi, > I would like to take a quick straw poll. > > a) If you use a Database backend for FreeRadius which one do you use? MySQL Manuel Sousa - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: User Survey - Which DB backend do you use?
The DB backend (ie rlm_sql). Accounting in particular, but any use of the DB backend interests me.. On Mon, 14 Jul 2003 10:57 am, Gene Parks wrote: > Clarification please. For what function of Freeradius do you want to > know about? > > > -Original Message- > From: Peter Nixon [mailto:[EMAIL PROTECTED] > Sent: Monday, July 14, 2003 3:31 AM > To: [EMAIL PROTECTED] > Subject: User Survey - Which DB backend do you use? > > > Hi List > > I would like to take a quick straw poll. > > a) If you use a Database backend for FreeRadius which one do you use? > > b) If you do not use a DB backend for FreeRadius, but do have a DB on > your > server or in your rack, what DB is it? > > c) If you do not use a DB backend for FreeRadius, but do have a DB on > your > server or in your rack, why don't you use it as a backend to FreeRadius? > > Please reply to this thread on the mailing list or to me directly (I am > one of > the developers) if you wish to keep the info private. > I will post a summary in a few days. > > Thanks in Advance -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: User Survey - Which DB backend do you use?
On Mon, Jul 14, 2003 at 09:53:35AM +0200, Oliver Graf wrote:
> On Mon, Jul 14, 2003 at 10:30:52AM +0300, Peter Nixon wrote:
> > I would like to take a quick straw poll.
> >
> > a) If you use a Database backend for FreeRadius which one do you use?
>
> MySQL
a) MySQL, but not for accounting.
b) I use detail logs for accounting.
c) There is so much fuckage in accounting packets. So I have a own
tool which does proper accounting (Start-Stop accounting actually
-- don't trust Session-Time) into a MySQL database. It also
handles duplicate sessions and vendor specific stuff (such as
64 bit counters for traffic).
d) No, my own. attached. I have one mysqld running on each radius.
The database is synced periodically from multiple user management
databases. So these are pure lookup tables.
The group and type columns tell what type the entry is, the source
column tells me from where the data orginates (which other
database).
Regards,
Oliver.
authcheck_table = "radiususers"
authreply_table = "radiususers"
groupcheck_table = "radiususers"
groupreply_table = "radiususers"
usergroup_table = "radusergroup"
authorize_check_query = "SELECT id,name,attr,value,op FROM ${authcheck_table}
WHERE name = '%{SQL-User-Name}' AND kind = 'user' AND type = 'check' ORDER BY id"
authorize_reply_query = "SELECT id,name,attr,value,op FROM ${authreply_table}
WHERE name = '%{SQL-User-Name}' AND kind = 'user' AND type = 'reply' ORDER BY id"
authorize_group_check_query = "SELECT
${groupcheck_table}.id,${groupcheck_table}.name,${groupcheck_table}.attr,${groupcheck_table}.value,${groupcheck_table}.op
FROM ${groupcheck_table},${usergroup_table} WHERE ${usergroup_table}.usr =
'%{SQL-User-Name}' AND ${usergroup_table}.grp = ${groupcheck_table}.name AND
${groupcheck_table}.kind = 'group' AND ${groupcheck_table}.type = 'check' ORDER BY
${groupcheck_table}.id"
authorize_group_reply_query = "SELECT
${groupreply_table}.id,${groupreply_table}.name,${groupreply_table}.attr,${groupreply_table}.value,${groupreply_table}.op
FROM ${groupreply_table},${usergroup_table} WHERE ${usergroup_table}.usr =
'%{SQL-User-Name}' AND ${usergroup_table}.grp = ${groupreply_table}.name AND
${groupcheck_table}.kind = 'group' AND ${groupcheck_table}.type = 'reply' ORDER BY
${groupreply_table}.id"
group_membership_query = "SELECT grp FROM ${usergroup_table} WHERE
usr='%{SQL-User-Name}'"
# MySQL dump 8.16
#
# Host: localhostDatabase: radius
#
# Server version3.23.47-log
#
# Table structure for table 'radiususers'
#
CREATE TABLE radiususers (
id int(10) unsigned NOT NULL auto_increment,
source tinyint(4) NOT NULL default '0',
name varchar(64) NOT NULL default '',
kind enum('user','group') NOT NULL default 'user',
type enum('check','reply') NOT NULL default 'check',
attr varchar(64) NOT NULL default '',
op char(2) NOT NULL default '=',
value varchar(253) NOT NULL default '',
PRIMARY KEY (id),
KEY name (name,kind,type)
) TYPE=MyISAM;
#
# Table structure for table 'radusergroup'
#
CREATE TABLE radusergroup (
id int(10) unsigned NOT NULL auto_increment,
usr varchar(64) NOT NULL default '',
grp varchar(64) NOT NULL default '',
source tinyint(4) NOT NULL default '0',
PRIMARY KEY (id),
KEY usr (usr)
) TYPE=MyISAM;
RE: User Survey - Which DB backend do you use?
A) MySQL -Original Message- From: Peter Nixon [mailto:[EMAIL PROTECTED] Sent: segunda-feira, 14 de Julho de 2003 8:31 To: [EMAIL PROTECTED] Subject: User Survey - Which DB backend do you use? Hi List I would like to take a quick straw poll. a) If you use a Database backend for FreeRadius which one do you use? b) If you do not use a DB backend for FreeRadius, but do have a DB on your server or in your rack, what DB is it? c) If you do not use a DB backend for FreeRadius, but do have a DB on your server or in your rack, why don't you use it as a backend to FreeRadius? Please reply to this thread on the mailing list or to me directly (I am one of the developers) if you wish to keep the info private. I will post a summary in a few days. Thanks in Advance -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: User Survey - Which DB backend do you use?
Clarification please. For what function of Freeradius do you want to know about? -Original Message- From: Peter Nixon [mailto:[EMAIL PROTECTED] Sent: Monday, July 14, 2003 3:31 AM To: [EMAIL PROTECTED] Subject: User Survey - Which DB backend do you use? Hi List I would like to take a quick straw poll. a) If you use a Database backend for FreeRadius which one do you use? b) If you do not use a DB backend for FreeRadius, but do have a DB on your server or in your rack, what DB is it? c) If you do not use a DB backend for FreeRadius, but do have a DB on your server or in your rack, why don't you use it as a backend to FreeRadius? Please reply to this thread on the mailing list or to me directly (I am one of the developers) if you wish to keep the info private. I will post a summary in a few days. Thanks in Advance -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: User Survey - Which DB backend do you use?
On Mon, Jul 14, 2003 at 10:30:52AM +0300, Peter Nixon wrote: > I would like to take a quick straw poll. > > a) If you use a Database backend for FreeRadius which one do you use? MySQL Oliver. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: User Survey - Which DB backend do you use?
On 10:30am, Peter Nixon wrote: > > > I would like to take a quick straw poll. > > a) If you use a Database backend for FreeRadius which one do you use? I don't use. > > b) If you do not use a DB backend for FreeRadius, but do have a DB on your > server or in your rack, what DB is it? IBM DB2 V8.1 > > c) If you do not use a DB backend for FreeRadius, but do have a DB on your > server or in your rack, why don't you use it as a backend to FreeRadius? Because we have more then one cisco over Internet, they act as originating, and terminating, they are far away from a database server, the VoIP streams on each of them are big (we use freeradius for VoIP accounting), so we use a Message Queue Service to join radiuses to the database, and we use Transaction Monitor to inserts the stream. We found it as the best schema which suite our needs. Gregory G. V. --- Any opinions in this posting are my own and not those of my present or previous employers. According Isham Research's Devil's IT Dictionary mainframe is: "an obsolete device still used by thousands of obsolete companies serving billions of obsolete customers and making huge obsolete profits for their obsolete shareholders. And this year's run twice as fast as last year's." - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
