freeradius sql accounting/simultaeneous use

  I am running FreeRadius 0.9.3 and I currently have it configured for Postgresql support. I want to make Sure that it logs currently connected users as well as past users who logged in into a SQL database. I also want to make sure it correctly only allows a username to connect only

SQL Accoiunting

I am running Freeradius using SQL authentication and wondering how I can handle accounting to the radacct table. Also I am wondering if there is a way to stop duplicate users from logging in with SQL. I read the doc/duplicate_users file and it sayd it only works with users or pam??? -Roy

Re: Custom SQL Query

Thanks for reply But in the sql.conf there are only authorise and accounting queries only. Can I add my query end of to that queries. Then how ?What I would like to do is After I received accounting query. I need to do some calculation and update some tables on 2 different database. Kevin Bonner <[

Re: Custom SQL Query

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Monday 15 December 2003 18:03, Amgaabaatar Purevjal wrote: > Hello > I need to put some custom query after I receive accounting packet. Where I > should look into it? rlm_sql.c is that correct file? Or I could add into > accounting query? Thanks sq

Custom SQL Query

Hello I need to put some custom query after I receive accounting packet. Where I should look into it? rlm_sql.c is that correct file? Or I could add into accounting query? Thanks    

Re: SQL falls through to users file

Gary Algier <[EMAIL PROTECTED]> wrote: > I have some basic SQL functionality working, but I discovered that if > the SQL module returns "ok", FreeRadius still falls through to the > users file. Is there any way to prevent this? doc/configurable_failover Alan DeKok

Re: SQL falls through to users file

Rob Genovesi wrote: Do you need the users file at all? If not comment out the "files" entry. -Rob Yes I do. For those people not explicitly listed in the SQL, I need to do one of two Proxy-To-Realm entries, depending upon Client-IP-Address. Or is there a way to put DEFAULT entries in

Re: SQL falls through to users file

Do you need the users file at all? If not comment out the "files" entry. -Rob At 01:06 PM 12/11/2003 -0500, you wrote: I have some basic SQL functionality working, but I discovered that if the SQL module returns "ok", FreeRadius still falls through to the users file. Is ther

SQL falls through to users file

I have some basic SQL functionality working, but I discovered that if the SQL module returns "ok", FreeRadius still falls through to the users file. Is there any way to prevent this? I even tried to set "Fall-Through := 0" in the SQL. That did not help. Here's a sni

Re: Freeradius 0.9.3 gone nuts when auth from sql??

ocks? > rlm_realm: Preparing to proxy authentication request to realm > "infinite.net.au" That would seem to be relevant. > rlm_sql (sql): Released sql socket id: 4 > modcall[authorize]: module "sql" returns ok for request 0 It's not an SQL problem. > modca

Freeradius 0.9.3 gone nuts when auth from sql??

yer to realm infinite.net.au rlm_realm: Adding Realm = "infinite.net.au" rlm_realm: Preparing to proxy authentication request to realm "infinite.net.au" modcall[authorize]: module "suffix" returns updated for request 0 radius_xlat: '[EMAIL PROTECTED]' rlm_sql

Re: MRTG graphing from radacct sql data

( Joe Maimon wrote: Hello all, I have put togetother a couple scripts and a program that allows me to MRTG graph dialup users from the radius accounting sql table. Very unpolished. If anyone is interested in helping me develop/test, please drop me a line. Thanks, Joe - List info/subs

Re: MRTG graphing from radacct sql data

On Monday 01 December 2003 00:53, Joe Maimon wrote: > Hello all, > > I have put togetother a couple scripts and a program that allows me to > MRTG graph dialup users from the radius accounting sql table. > > Very unpolished. If anyone is interested in helping me develop/test,

Re: MRTG graphing from radacct sql data

i am also intrested John Hengstler wrote: I second it... Regards, John -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Vector Sent: Sunday, November 30, 2003 6:10 PM To: [EMAIL PROTECTED] Subject: Re: MRTG graphing from radacct sql data I'm inter

Re: MRTG graphing from radacct sql data

Joe Maimon wrote: Hello all, I have put togetother a couple scripts and a program that allows me to MRTG graph dialup users from the radius accounting sql table. Very unpolished. If anyone is interested in helping me develop/test, please drop me a line. Thanks, Joe - List info/subscribe

RE: MRTG graphing from radacct sql data

I second it... Regards, John -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Vector Sent: Sunday, November 30, 2003 6:10 PM To: [EMAIL PROTECTED] Subject: Re: MRTG graphing from radacct sql data I'm interestedthanks, vec - Original Me

Re: MRTG graphing from radacct sql data

I'm interestedthanks, vec - Original Message - From: "Joe Maimon" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, November 30, 2003 3:53 PM Subject: MRTG graphing from radacct sql data > Hello all, > > I have put togetother a couple scr

MRTG graphing from radacct sql data

Hello all, I have put togetother a couple scripts and a program that allows me to MRTG graph dialup users from the radius accounting sql table. Very unpolished. If anyone is interested in helping me develop/test, please drop me a line. Thanks, Joe - List info/subscribe/unsubscribe? See

Re: Freeradius-Proxied-To not showing up in sql accounting

"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > OK, but the attribute is getting written to the accouting detail file, > so if it is getting into the accounting detail file (which is just a text > file) then why can I not write it to MySQL. I don't know. See the

Re: using SQL with both dynamic user entries and static DEFAULTs

quot;dynamic" user entrees first, then the "static" DEFAULTs last. The SQL module doesn't have the concept of a "DEFAULT" user... Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Freeradius and oracle sql failure (availabiliy prob)

Hello, I m running the 0.91 version of freeradius with oracle support. I m facing a big problem and would like to know if you have an idea on how to configure freeradius to improve the availability. It seems that if the oracle db crashed or is unavailable because of a network problem the radius

Re: Freeradius-Proxied-To not showing up in sql accounting

> > The request is logged to the accounting detail file, and THEN the > FreeRADIUS-Proxied-To is generated, and the packet is proxied. > > Order is important. Since the packet was logged before it was > proxied, there is no FreeRADIUS-Proxied-To attribute to log. > OK, but the attribute is ge

Re: Freeradius-Proxied-To not showing up in sql accounting

"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > I guess what has me stumped, is if it is showing up in the detail file > then why wouldn't it show up sqltrace.sql ? > > When I use NTRadping, I add the Freeradius-Proxied-To = 111.222.111.222 > and it is sent by NTRadping as a name/value pair and g

Re: Freeradius-Proxied-To not showing up in sql accounting

> > 2. But when I use something like NTRadping to test the accounting start > > and accounting stop and send the additional attributes > > "Freeradius-Proxied-To" > > it gets written to both the master detail file and my radacct table. > > Find out what's different between the packets from the N

Re: Freeradius-Proxied-To not showing up in sql accounting

table. Odds are that the attribute is added to the request after it's logged to SQL. > 1. Under normal operation when our "NAS's are using our radius, I can tail > my detail file and see that "Freeradius-Proxied-To" is getting properly > written to the detail

Freeradius-Proxied-To not showing up in sql accounting

HI, I am using FreeRADIUS-0.9.1 primarily to proxy requests to other ISP's radius servers. I have 4 dial up accelerator servers that are acting as NAS's (clients to our radius server). I have added the vendors dictionary to FreeRADIUS and all seems to be working well, requests are proxied reliab

using SQL with both dynamic user entries and static DEFAULTs

Hi, I have a Freeradius server where I currently use both MySQL and the users file for authorization. The database is for "dynamic" users, whose entries in the tables are created and destroyed by another application. As you might expect, they are only valid for a finite time, then deleted. I

Re: Huntgroup file & SQL syntax, solved

At 09:12 PM 19/11/2003 -0500, you wrote: Disregard, I made an error in the huntgroups syntax. Hi all, Could someone please verify I'm using the right syntax for the huntgroups file and a sample row of data from the "radcheck" table in an SQL DB. huntgroups: # Group 1 group1

Huntgroup file & SQL syntax.

Hi all, Could someone please verify I'm using the right syntax for the huntgroups file and a sample row of data from the "radcheck" table in an SQL DB. huntgroups: # Group 1 group1 NAS-IP-Address == 10.100.50.6 NAS-IP-Address == 10.100.50.7 # Group 2 group2

Sql Counter ?

try to run radiusd in debugging mode ... it will show the next reset ... in your case this will be reset @ first day of december. = wilfredo pahilanga apellido jr. technical support mactan online bacolod city, philippines +63 34 4348311 If you can't hear me, it's because i'm in parentheses.

Sql Counter ?

How Sql Counter reset account expiration date ? emm ... Example : user first connection is 12 Nov 2003 , sql counter (mountly max session) will be reset on 12 Dec or 1 dec ? is it reset every mount or after 30 day of activitation ? -- It's a poor workman who blames his tools. - List

Re: Max 6000 Sql

Sorry about replying to a reply... but I didn't see the original message. > > I have just got a new Max6000 Nas but the problem is, it is sending all > > sorts of other info such as dialin number where the username is suposed to > > be > ... > > Why would this be? This happens when you have enab

Re: Max 6000 Sql

"Rhys (Gallamda)" <[EMAIL PROTECTED]> wrote: > I have just got a new Max6000 Nas but the problem is, it is sending all > sorts of other info such as dialin number where the username is suposed to > be ... > Why would this be? Ask the NAS vendor. Alan DeKok. - List info/subscribe/unsubscribe

Max 6000 Sql

Hello, I have a installed FreeRadius and it works fine with Sql support I have an Old NT4 box as a Radius Client, this works fine with teh radius server I have just got a new Max6000 Nas but the problem is, it is sending all sorts of other info such as dialin number where the username is suposed

Re: command-line SQL management utilities

is mainly for web applications, perl for command line utils. And it would be nice to also have command line utils in companion with dialupadmin mainly for mass user creation/administration. > > I'm willing to share my (ugly) code with anyone that wants it. I figure I'm > not the only

Re: command-line SQL management utilities

management utility (expire, reactivate users, change passwords, put users on hold), so the next step is user creation and generic attribute management. I'm willing to share my (ugly) code with anyone that wants it. I figure I'm not the only one who wants command-line control of the use

Re: command-line SQL management utilities

Damian Gerow <[EMAIL PROTECTED]> wrote: > Are there any commandline utilities for SQL user management (creation, > removal, static address assignment, etc.)? I'm about to embark on writing a > couple of utilities, and I'd like to avoid re-creating the wheel if > possi

command-line SQL management utilities

Are there any commandline utilities for SQL user management (creation, removal, static address assignment, etc.)? I'm about to embark on writing a couple of utilities, and I'd like to avoid re-creating the wheel if possible. - List info/subscribe/unsubscribe? See http://www.freeradiu

Re: Different SQL backend for different realms

Leon Li <[EMAIL PROTECTED]> wrote: > I tried according to doc/Autz-Type, still no luck. What it mentions > seems to be clear and easy. > I added something like > > DEFAULT >Realm == "companyA.com", > Autz-Type := sql_a Which won't do what you want. Please use t

Different SQL backend for different realms

Thanks for the help. I tried according to doc/Autz-Type, still no luck. What it mentions seems to be clear and easy. I added something like DEFAULT Realm == "companyA.com", Autz-Type := sql_a into users file and Autz-Type sql_a { sql2 } into "authorize

Re: Different SQL backend for different realms

ype, etc. But still not clear. cause in this case, proxy is not > what I want, user requests from different > realms will not be proxied to another radius server, they just need to > go different sql backends. > [...] >From what I see in doc/Autz-Type, it will work... ---snip

Different SQL backend for different realms

ill not be proxied to another radius server, they just need to go different sql backends. I hope this is just a configuration issue for me because of my shortage in Freeradius. Anyone can shed some lights on it will be highly appreciated. Best regards, Jason - List info/subscribe/unsubscribe

huntgroups & sql

is it possible to do the following via SQL? given a huntgroups file that contains: netscreen NAS-IP-Address == 128.205.10.75 ccfw-beane NAS-IP-Address == 128.205.10.76 construct SQL entries that function the same as the following "users" file entries: jcmurphy Auth-Ty

RE: Sql table sample

> From: Stefano Costantini > Sent: Tuesday, 14 October 2003 8:25 AM > I've lost my mysql table for freeradius. Somebody can give me the scheme to > rebuild it? It should be in the tarball. src/modules/rlm_sql/drivers/rlm_sql_mysql/db_mysql.sql -- Paul "TBBle" Hampson Bubblesworth Pty Ltd (ABN:

Sql table sample

I've lost my mysql table for freeradius. Somebody can give me the scheme to rebuild it? Tks Stefano - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

huntgroups phrasing via SQL

lace the user into different groups depending upon which device they connect to. i was able to do this via the 'users' file, but i'm having trouble figuring how what i need to insert into the sql tables. hints? thanks! jeff - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: SQL queries being executed twice

"Das, Anindya Kishore" <[EMAIL PROTECTED]> wrote: > I am trying to configure accounting on my MySQL server and everything > seems to be working fine... except for the fact that there are two > "INSERT" queries executed for every user logging in. Excerpt from the > "radiusd -x" command is below: ...

SQL queries being executed twice

/radius/radacct/202.183.67.218/detail-20031009' rlm_detail: /usr/local/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d expands to /usr/local/var/log/radius/radacct/ 202.183.67.218/detail-20031009 modcall[accounting]: module "detail" returns ok modcall[accounting]: module

Re: FreeRadius 0.9.1, Accounting, SQL & Total Control

I re-read the example you had below and used it. That worked perfectly. Thanks! Bill - Original Message - From: Alan DeKok To: [EMAIL PROTECTED] Sent: Tuesday, September 30, 2003 3:20 PM Subject: Re: FreeRadius 0.9.1, Accounting, SQL & Total Control "Bill

Re: FreeRadius 0.9.1, Accounting, SQL & Total Control

ll - Original Message - From: Alan DeKok To: [EMAIL PROTECTED] Sent: Tuesday, September 30, 2003 3:20 PM Subject: Re: FreeRadius 0.9.1, Accounting, SQL & Total Control "Bill" <[EMAIL PROTECTED]> wrote: > I just started using FreeRadius with SQL for ac

Re: FreeRadius 0.9.1, Accounting, SQL & Total Control

"Bill" <[EMAIL PROTECTED]> wrote: > I just started using FreeRadius with SQL for accounting today and > noticed that the Total Control's connection speed values are not being > recorded into the ConnectInfo_start or stop fields of the mySQL database. I > trie

FreeRadius 0.9.1, Accounting, SQL & Total Control

I just started using FreeRadius with SQL for accounting today and noticed that the Total Control's connection speed values are not being recorded into the ConnectInfo_start or stop fields of the mySQL database. I tried changing all the dictionary.usr attributes from "USR-Connect

freeradius and sql password attribute

I'm using freeradius with Ldap ; I store an md5 password and a Nt password in Ldap.When a user want to login to my cisco 7100 radius use username and the attribute User Password (where i store the md5 password).When the user is making a vpn from a windows client ( using mschap) radius use username

Freeradius and SQL trouble

Hi all! Installed and configured freeradius for working woth MSSQL2K. It perfectly works, but when there are no queries to freeradius in a long time it cannot connect to DB Handle #0 when new query arrives. I use rlm_sql_unixodbc through freetds 0.6.1. Where was i wrong? Cheers, SaLiK. - List

RE: [Patch] SQL authentication logging

> From: Nicolas Baradakis > Sent: Monday, 22 September 2003 11:48 PM > Paul Hampson wrote: > > > > I think it'd be better to have a separate patch to fix > > > sql_finish_query() usage everywhere and not only in > > > rlm_sql_postauth() > > SOunds good. Are you going to make it call it always? I

Re: [Patch] SQL authentication logging

Paul Hampson wrote: > > I think it'd be better to have a separate patch to fix > > sql_finish_query() usage everywhere and not only in > > rlm_sql_postauth() > > SOunds good. Are you going to make it call it always? I expect > such a function would be safe to call at any time... From memory, > th

RE: [Patch] SQL authentication logging

> From: Nicolas Baradakis > Sent: Monday, 22 September 2003 1:30 AM > Paul Hampson wrote: > > > > > With one minor change, to call > > > > > (inst->module->sql_finish_query)(sqlsocket, inst->config); > > > > > even for failed queries. (As is done in _some_ of the other > > > > > sql_ function in

RE: [Patch] SQL authentication logging

Paul Hampson wrote: > > > > With one minor change, to call > > > > (inst->module->sql_finish_query)(sqlsocket, inst->config); > > > > even for failed queries. (As is done in _some_ of the other > > > > sql_ function in rlm_sql.c. And PostgresSQL's docs also do > > > > it... Only postgres and Sybas

RE: [Patch] SQL authentication logging

> From: Nicolas Baradakis > Sent: Friday, 19 September 2003 6:28 PM > Paul Hampson wrote: > > > > > The following patch allow for SQL logging after authentication. It > > > > extends the rlm_sql module so now you can put one more query in your > > > &

Re: large (?) radius server: LDAP or SQL

On Fri, 19 Sep 2003, Zoilo wrote: > I need to create a radius server with >100,000 users. > > Should I use LDAP or SQL? Both should work ok. LDAP is just more general and you can base other services on it along with radius. Check the list archives for detailed discussion on this t

Re: [Patch] SQL authentication logging

Paul Hampson wrote: > > > The following patch allow for SQL logging after authentication. It > > > extends the rlm_sql module so now you can put one more query in your > > > sql.conf file. > > > > I'll commit this once either you tell me that it doesn

large (?) radius server: LDAP or SQL

I need to create a radius server with >100,000 users. Should I use LDAP or SQL? Z. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

RE: [Patch] SQL authentication logging

> From: Paul Hampson > Sent: Friday, 19 September 2003 1:47 AM > > From: Nicolas Baradakis > > Sent: Wednesday, 17 September 2003 11:35 PM > > The following patch allow for SQL logging after authentication. It > > extends the rlm_sql module so now you can put one m

RE: [Patch] SQL authentication logging

> From: Nicolas Baradakis > Sent: Wednesday, 17 September 2003 11:35 PM > When you have multiple freeradius servers, you want to store > authentication attempts in a database rather than a flat file. > The following patch allow for SQL logging after authentication. It > e

[Patch] SQL authentication logging

When you have multiple freeradius servers, you want to store authentication attempts in a database rather than a flat file. The following patch allow for SQL logging after authentication. It extends the rlm_sql module so now you can put one more query in your sql.conf file. The following patch

Re: SQL user generation script

On Sunday 07 September 2003 2:40 am, jc fulknier wrote: > is there a script to auto generate users and passwds > into a mySQL DB? Here is one I use: = #!/bin/sh # # usage: radadd # # creates a range of users from start to end with randomized passwords # "format" should be a format string

Re: SQL user generation script | scripts/create-users.pl rewrite

I just did a little rewrite on the script I use... http://www.bcore.de/data/create-users.tar.gz It should now fit to the most common needs... Cheers, OoLee Am Son, 2003-09-07 um 11.40 schrieb jc fulknier: > is there a script to auto generate users and passwds > into a mySQL DB? > Thanks > JC

SQL user generation script

is there a script to auto generate users and passwds into a mySQL DB? Thanks JC __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/us

RE: Setting internal attribute Group from SQL modules

Hi, Thanks for answers.. I'll try Sql-Group.. I do not use radgroupreply due to some access problems. I don't have total control over this DB, hence some people might change this table and I might not be aware of that. So it's better to keep this kind of configuration in users fil

RE: Setting internal attribute Group from SQL modules

> From: Ali Gunduz > Sent: Wednesday, 27 August 2003 6:23 PM > We have a problem with getting the group name into Group attribute from > SQL and then checking it in users file. > user <-> group matching info is stored in Postgresql. > > A sample entry (Id fi

Re: Setting internal attribute Group from SQL modules

On Wed, 27 Aug 2003, Ali Gunduz wrote: > Hi, > > We have a problem with getting the group name into Group attribute from > SQL and then checking it in users file. > > authorize module setup is like this: > > authorize { > preprocess > chap

Setting internal attribute Group from SQL modules

Hi, We have a problem with getting the group name into Group attribute from SQL and then checking it in users file. authorize module setup is like this: authorize { preprocess chap mschap suffix sql_pgsql files } user <-> group matching i

Segmentation fault in SQL accounting with ORACLE

} sql2_redundant { fail = 1 notfound = return noop = return ok = ret

FreeRADIUS+SQL: Huntgroups + Concunency checks

Two questions... 1) I want to check that users are allowed access to NASs based on where the NAS is located (We are a WISP providing access at several apartment complexes) my huntgroups file looks like... # Apartment complex 1 PBNAS-IP-Address == 10.1.2.90 PBNAS-IP-Add

How Override Attributes in sql module?

Hello. FreeRadius, rlm_sql. Configured, started, tested = worked. Task. Control users access via per group basis. (If user in some group, then his has (has not) access). I have "main group" - dialup. In that group i setup "default values" Auth-Type := PAP And Reply Framed-Protocol := PPP Service

RE: Advantages of Using SQL ?

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Peter Nixon Sent: Tuesday, August 05, 2003 2:34 AM To: [EMAIL PROTECTED] Subject: Re: Advantages of Using SQL ? On Tue August 5 2003 08:32, SIMICRO ML wrote: > Peter Nixon wrote: > > On Tue August 5 2

RE: SQL scripts

Ahh 404 392-9536 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dwight Ringdahl Sent: Monday, August 11, 2003 5:45 PM To: [EMAIL PROTECTED] Subject: SQL scripts Has anyone made a good script for SQL like users2mysql.pl that will update a record or delete

Re: Login-Time + SQL ?

*blonde moment* Its workin now... Thanks Patrick - Original Message - From: "Oliver Graf" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 06, 2003 2:30 PM Subject: Re: Login-Time + SQL ? | On Wed, Aug 06, 2003 at 02:31:50PM +0200,

Re: FR SQL flexibility

On Sun, Aug 10, 2003 at 01:58:33PM -, Sinisa Burina wrote: > Is it possible, or could it be possible in the future to have users authenticated > against different SQL tables/databases, optionally wven with different queries, > depending on values of auth request attributes? So

Re: FR SQL flexibility

That's it, thank you very much! -- Best Regards, Sinisa Burina - Original Message - From: "Oliver Graf" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, August 11, 2003 05:52 Subject: Re: FR SQL flexibility > Define multiple sql in

SQL scripts

Has anyone made a good script for SQL like users2mysql.pl that will update a record or delete a record? Preferably with the same file format as users2mysql.pl TIA Dwight DialAccess.Net - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Advantages of Using SQL ?

On Tue, 5 Aug 2003 10:51:45 -0400 Robert LaGrasse <[EMAIL PROTECTED]> wrote: > If I could remember the names and numbers of millions of girlfriends > simultaneously, I could still call any of them faster myself. Having a > secretary to keep track of my dates and remind me when special occasions >

FR SQL flexibility

Hello! Is it possible, or could it be possible in the future to have users authenticated against different SQL tables/databases, optionally wven with different queries, depending on values of auth request attributes? Some way of dynamic definition of currently statically defined SQL queries

Re: Login-Time + SQL ?

On Wed, Aug 06, 2003 at 02:31:50PM +0200, Patrick wrote: > Hi, > > im just reposting this after trawling the mailing lists i still havent > seem to have come up with anything usefull... im trying to run login time > but here is my confusing bit ... currently im using both use

RE: Advantages of Using SQL ?

But the argument was never about effiency, it was about speed. SQL makes a lot more sense if you have a lot of users. The maintence would be easier as well. Jeremy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Evren Yurtesen Sent: Tuesday, August 05

Re: Login-Time + SQL ?

0 | > | 4 | XSInetDaytime | Framed-Protocol | := | PPP |0 | > | 6 | XSInetDaytime | Login-Time | := | Al-0020 |0 | > ++---+-++-+--+ > 3 rows in set (0.00 sec) So don't you see that it's a *check* item in y

RE: Advantages of Using SQL ?

ginal Message- From: SIMICRO ML [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 1:32 AM To: [EMAIL PROTECTED] Subject: Re: Advantages of Using SQL ? Peter Nixon wrote: > On Tue August 5 2003 06:37, Evren Yurtesen wrote: > Its like saying that example B is faster than examp

Re: Advantages of Using SQL ?

On Tue, 05 Aug 2003 18:02:24 -0700 Evren Yurtesen <[EMAIL PROTECTED]> wrote: > maybe thats the problem, you are not designed to remember millions of > girlfriends names/numbers etc. thats why you are inefficient by design > in this area particular area of operation. > > so you hire a secretary

Login-Time + SQL ?

Hi,   im just reposting this after trawling the mailing lists i still havent seem to have come up with anything usefull... im trying to run login time but here is my confusing bit ... currently im using both users file and sql database ... i add the line into the users file with login

Re: Advantages of Using SQL ?

From: SIMICRO ML [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 1:32 AM To: [EMAIL PROTECTED] Subject: Re: Advantages of Using SQL ? Peter Nixon wrote: On Tue August 5 2003 06:37, Evren Yurtesen wrote: Its like saying that example B is faster than example A in the following scenario: A

Re: Advantages of Using SQL ?

: Tuesday, August 05, 2003 2:34 AM To: [EMAIL PROTECTED] Subject: Re: Advantages of Using SQL ? On Tue August 5 2003 08:32, SIMICRO ML wrote: Peter Nixon wrote: On Tue August 5 2003 06:37, Evren Yurtesen wrote: Its like saying that example B is faster than example A in the following scenario: A) You

Re: Advantages of Using SQL ?

> > About the operating system stuff, the load of exchanging few messages in > > memory can not be so overwhelming compared to an inefficient search of a > > few hundred thousands of users from a text database even when its in > > memory already. > > What is so inefficient about the search algorit

Re: Advantages of Using SQL ?

On Tue August 5 2003 08:32, SIMICRO ML wrote: > Peter Nixon wrote: > > On Tue August 5 2003 06:37, Evren Yurtesen wrote: > > > > Its like saying that example B is faster than example A in the following > > scenario: > > > > A) You need to call your girlfriend. You know her number, so you dial it >

Re: Advantages of Using SQL ?

Peter Nixon wrote: On Tue August 5 2003 06:37, Evren Yurtesen wrote: Its like saying that example B is faster than example A in the following scenario: A) You need to call your girlfriend. You know her number, so you dial it and talk to her. B) You need to call your girlfriend, You don't know

Re: Advantages of Using SQL ?

I hit the wrong button - please see the remainder of message below. On Mon, 04 Aug 2003 15:55:46 -0500 "Tim McCracken" <[EMAIL PROTECTED]> wrote: My numbers (atleast) were a joke. The reality of it is (IMHO) that benchmarks are only useful to marketing departments because they are rarely done

Re: Advantages of Using SQL ?

My numbers (atleast) were a joke. The reality of it is (IMHO) that benchmarks are only useful to marketing departments because they are rarely done in an equitable manner. There are way too many differences to benchmark accross hardware platforms, and rarely does anyone tune OS parameters to m

Re: Advantages of Using SQL ?

My numbers (atleast) were a joke. The reality of it is (IMHO) that benchmarks are only useful to marketing departments because they are rarely done in an equitable manner. There are way too many differences to benchmark accross hardware platforms, and rarely does anyone tune OS parameters to m

Re: Advantages of Using SQL ?

How do you test this? or joke? :) I would like to keep record of my server performances relative to each other too, it sounds like a cool idea Evren Tim McCracken wrote: My testing confirms Alan's numbers, however he neglected to mention: Solaris: 2.5 VMS on Alpha: 8.0 :) On Mon, 04 Aug 200

Re: Advantages of Using SQL ?

My testing confirms Alan's numbers, however he neglected to mention: Solaris: 2.5 VMS on Alpha: 8.0 :) On Mon, 04 Aug 2003 16:07:58 -0400 "Alan DeKok" <[EMAIL PROTECTED]> wrote: Evren Yurtesen <[EMAIL PROTECTED]> wrote: Everybody argue about something and usually its so difficult to come to

Re: Advantages of Using SQL ?

Evren Yurtesen <[EMAIL PROTECTED]> wrote: > Everybody argue about something and usually its so difficult to come to > a conclusion. Microsoft says windows is good, linux people say linux is > better, I say FreeBSD is best :) NetBSD... > Microsoft always says the newer version of windows works

  1   2   3   4   5   6   7   8   >