Was this of any help?
Omar
On Sat, Aug 28, 1999 at 09:17:28PM -0400, Omar Thameen wrote:
> Is this what you're looking for?
>
> Thanks for your continued help on this.
> Omar
>
> # MySQL dump 5.13
> #
> # Host: localhost Database: radiator
> #--------------------------------------------------------
> # Server version 3.22.22
>
> #
> # Table structure for table 'ACCOUNTING'
> #
> CREATE TABLE ACCOUNTING (
> USERNAME char(50) DEFAULT '' NOT NULL,
> CLIENT_ID char(22),
> TIME_STAMP int(11),
> ACTUAL_TIME char(50),
> ACCTSTATUSTYPE char(10),
> ACCTDELAYTIME int(11),
> ACCTINPUTOCTETS int(11),
> ACCTOUTPUTOCTETS int(11),
> ACCTSESSIONID char(30),
> ACCTSESSIONTIME int(11),
> ACCTTERMINATECAUSE char(30),
> NAS_IDENTIFIER char(50),
> NAS_IP_ADDRESS char(22),
> NAS_PORT int(11),
> NAS_PORT_TYPE char(10),
> ACCTAUTHENTIC char(10),
> SERVICE_TYPE char(20),
> USR_MODEM_TIME int(11),
> USR_INTERFACE int(11),
> USR_CHASSIS_SLOT int(11),
> USR_CHASSIS_SPAN int(11),
> USR_CHASSIS_CHANNEL int(11),
> USR_UNAUTH_TIME int(11),
> CALLING_STATION_ID char(10),
> CALLED_STATION_ID char(10),
> USR_MODULATION_TYPE char(20),
> USR_SMNP_LEVELS char(20),
> USR_SimplifiedV42BIS_USAGE char(20),
> USR_CONNECT_SPEED char(20),
> FRAMED_PROTOCOL char(10),
> FRAMED_IP_ADDRESS char(22),
> USR_MP_MRRU int(11),
> ACCTLINKCOUNT int(11),
> ACCTMULTISESSION_ID char(10),
> ORIGIN char(20),
> KEY ACCOUNTING_I (USERNAME)
> );
>
> #
> # Table structure for table 'RADLOG'
> #
> CREATE TABLE RADLOG (
> TIME_STAMP int(11),
> PRIORITY int(11),
> MESSAGE char(200),
> ACTUAL_TIME char(40)
> );
>
> #
> # Table structure for table 'RADONLINE'
> #
> CREATE TABLE RADONLINE (
> USERNAME char(50) DEFAULT '' NOT NULL,
> CLIENT_ID char(22),
> TIME_STAMP int(11),
> ACTUAL_TIME char(50),
> ACCTSTATUSTYPE char(10),
> ACCTDELAYTIME int(11),
> ACCTINPUTOCTETS int(11),
> ACCTOUTPUTOCTETS int(11),
> ACCTSESSIONID char(30) DEFAULT '' NOT NULL,
> ACCTSESSIONTIME int(11),
> ACCTTERMINATECAUSE char(30),
> NAS_IDENTIFIER char(50) DEFAULT '' NOT NULL,
> NAS_IP_ADDRESS char(22),
> NAS_PORT int(11) DEFAULT '0' NOT NULL,
> NAS_PORT_TYPE char(10),
> ACCTAUTHENTIC char(10),
> SERVICE_TYPE char(20),
> USR_MODEM_TIME int(11),
> USR_INTERFACE int(11),
> USR_CHASSIS_SLOT int(11),
> USR_CHASSIS_SPAN int(11),
> USR_CHASSIS_CHANNEL int(11),
> USR_UNAUTH_TIME int(11),
> CALLING_STATION_ID char(10),
> CALLED_STATION_ID char(10),
> USR_MODULATION_TYPE char(20),
> USR_SMNP_LEVELS char(20),
> USR_SimplifiedV42BIS_USAGE char(20),
> USR_CONNECT_SPEED char(20),
> FRAMED_PROTOCOL char(10),
> FRAMED_IP_ADDRESS char(22),
> USR_MP_MRRU int(11),
> ACCTLINKCOUNT int(11),
> ACCTMULTISESSION_ID char(10),
> ORIGIN char(25),
> UNIQUE RADONLINE_I (NAS_IDENTIFIER,NAS_PORT),
> KEY RADONLINE_I2 (USERNAME)
> );
>
> On Thu, Aug 26, 1999 at 04:31:11PM +1000, Hugh Irvine wrote:
> >
> > I sent a message earlier asking for a copy of your database schema. This is
> > because I have been testing your configuration here, with no problems, against
> > a local mysql database. The only thing I can think of is that there is a
> > field type mismatch between your AcctColumnDef's and your database.
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
