Search Again: Re: Complex SQL queries allowed? From: Paul Farber Date: Tuesday, November 5, 2002 Time: 4:36:48 pm There should be documents that allow us to authenticate email, radius, ftp etc off the filemaker DB. Problem is that ODBC can be expensive (time wise). It is true that almost every application ISP's use (open source or not) has some sort of DB auth option (icradius, qmail, proftpd, apache, sqwebmail etc. At 10:53 AM 11/3/2002 +1100, you wrote: >some of the most common problems/complaints I have seen on this list are the >sql interface or lack of, and the web connector >Ideally opti should be an application that sits on top of any old database >or at least the most common breeds > >I am still struggling with the concept of needing an extra database to store >my accounting information (radius logs) another database to do odbc- radius >and email authentication. >Most if not all other isp billing applications I have seen store everthing >in one db > >Having another db is just another point of failure. > >I can see some merit in having another db, but this should be a mirror of >the necessary tables in otpi >for radius and email authentication. > >Opti is supposed to save me time, not cost me time writing scripts and >checking that everthing has worked > > >regards > >Tim > > > > > >--------------------------------------------------- >To subscribe, unsubscribe or to search list archive >please visit http://www.optigold.com/lists/isp.html >--------------------------------------------------- Customer Care Farber Technology Get FREE Internet! Sign up a friend and receive 1 free month of Internet access! For more information, go to http://www.f-tech.net/freeinternet.html --------------------------------------------------- To subscribe, unsubscribe or to search list archive please visit http://www.optigold.com/lists/isp.html ---------------------------------------------------

Messages In This Thread: Complex SQL queries allowed? by Paul Farber on Oct 31, 2002 at 7:39:04 pm Re: Complex SQL queries allowed? by Shawn Hogan on Oct 31, 2002 at 7:45:55 pm Re: Complex SQL queries allowed? by Paul Farber on Nov 1, 2002 at 4:55:56 pm Re: Complex SQL queries allowed? by Matthew Bailey on Nov 1, 2002 at 5:04:46 pm Re: Complex SQL queries allowed? by Fernando Huerta =?iso-8859-1?Q?Zu=F1iga?= on Nov 1, 2002 at 5:26:32 pm Re: Complex SQL queries allowed? by Shawn Hogan on Nov 1, 2002 at 5:40:15 pm Re: Complex SQL queries allowed? by Shawn Hogan on Nov 1, 2002 at 5:41:28 pm Re: Complex SQL queries allowed? by Michael J. Colvin on Nov 1, 2002 at 5:57:40 pm Re: Complex SQL queries allowed? by Paul Farber on Nov 2, 2002 at 3:06:46 pm Re: Complex SQL queries allowed? by Paul Farber on Nov 2, 2002 at 3:09:40 pm Re: Complex SQL queries allowed? by Paul Farber on Nov 2, 2002 at 3:14:00 pm Re: Complex SQL queries allowed? by Tim Atcheson on Nov 2, 2002 at 3:51:48 pm Re: Complex SQL queries allowed? by Shawn Hogan on Nov 2, 2002 at 5:13:56 pm Re: Complex SQL queries allowed? by Matthew Bailey on Nov 2, 2002 at 7:26:32 pm Re: Complex SQL queries allowed? by Tim Atcheson on Nov 3, 2002 at 11:27:54 am Re: Complex SQL queries allowed? by InterCape on Nov 3, 2002 at 7:45:54 pm Re: Complex SQL queries allowed? by Paul Farber on Nov 5, 2002 at 4:36:48 pm