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.
