User not known
Your message reads (in part):
Received: from walnut.iea-software.com (unverified [207.53.165.8]) by webserver.netsis.it
(EMWAC SMTPRS 0.83) with SMTP id <B0000172832@webserver.netsis.it>
Fri, 18 Sep 1998 19:18:26 +0200
Received: from walnut.iea-software.com (walnut.iea-software.com [207.53.165.8]) by walnut.iea-software.com (NTMail 4.00.0020/NT6651.00.c89adb95) with ESMTP id za000912 for <emerald@iea-software.com> Fri, 18 Sep 1998 09:54:11 +0100
Received: from [206.151.4.1] by walnut.iea-software.com (NTMail 4.00.0020/NT6651.00.c89adb95) with ESMTP id wyiaaaaa for <emerald@iea-software.com> Fri, 18 Sep 1998 09:54:11 +0100
Received: from rockbridge.net ([206.151.4.6]) by ns.rockbridge.net
(Post.Office MTA v3.1.2 release (PO205-101c)
ID# 0-36508U2500L250S0) with ESMTP id AAA128
for <emerald@iea-software.com> Fri, 18 Sep 1998 12:54:05 -0400
Message-ID: <36029057.8DC89697@rockbridge.net>
Date: Fri, 18 Sep 1998 12:54:47 -0400
From: "Dusan Janjic" <djanjic@rockbridge.net>
Organization: RGV
X-Mailer: Mozilla 4.05 [en] (WinNT; I)
MIME-Version: 1.0
To: emerald@iea-software.com
Subject: Frustrated
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-ListMember: filippo@netsis.it [emerald@iea-software.com]
I am getting frustrated with the lack of any response from Dale or
anyone else from tech support. We are having problems with the new
version of Radius on our backup server. We have sent our questions few
times, without any response. The problems we are experiancing were
caused by the upgrade which is not well documented to begin with. The
lack of response indicates to us that we are either, simply ignored, or
no one can help us. In both cases it is not acceptable to us to have a
semi working envorinment, considering the fact that the problems were
caused by the upgrade that was not well documented. This is not a stab
to Dale or anyone else. It is just a request to get some help like any
other paying customer. Here is the copy of the original message from two
days ago which was not answerd.
Hi Dale,
I am still having problems with RadiusNT 2.5 Let me give you the sumary
of your help so far. Also a note that it works in text mode.
I originaly asked the question after installing it on our backup server,
after witch it did stop working. Let me also say that calls online and
accounting was working correctly prior to the upgrade. Here is waht you
had us do in order to solve the problem:
> > > I am not sure how to solve this??
> >
> > Run the rad25_up2.sql script against your Emerald database. It
includes
> > the missings fields noted.
>
> This seemed to fix the problem but only partially. I have noticed more
then
> usual number of users that Radius reports as logged in. Here is the
portion of
> the messages from the log file:
>
> Fri Aug 28 13:45:42 1998: ODBC Error:23000:547:
> [Microsoft][ODBC SQL Server Driver][SQL Server]INSERT statement
conflicted
> with COLUMN FOREIGN KEY constraint 'FK__RadLogs__RadLogM__1E1A7EA3'.
The
> conflict occurred in database 'Emerald', table 'RadLogMsgs', column
> 'RadLogMsgID'
The other common issue is that you don't have any entries in the
RadLogMsgs table. Because of constraints, you can't put an entry into
the RadLogs table w/out a defining entry in the RadLogMsgs table.
Run these lines in isql_w to populate the table:
INSERT RadLogMsgs VALUES(0, "Generic Message", 0)
INSERT RadLogMsgs VALUES(1, "Generic Error", 5)
INSERT RadLogMsgs VALUES(10, "User Not Found", 3)
INSERT RadLogMsgs VALUES(11, "Bad Password", 3)
INSERT RadLogMsgs VALUES(12, "User Expired", 2)
INSERT RadLogMsgs VALUES(13, "User OverDue", 2)
INSERT RadLogMsgs VALUES(14, "Over Login Limit", 1)
INSERT RadLogMsgs VALUES(15, "No Time Left", 1)
INSERT RadLogMsgs VALUES(16, "Port Not Allowed", 2)
INSERT RadLogMsgs VALUES(19, "No Attributes", 3)
INSERT RadLogMsgs VALUES(50, "Bad Request", 4)
INSERT RadLogMsgs VALUES(51, "No Username", 4)
INSERT RadLogMsgs VALUES(52, "No Password", 4)
INSERT RadLogMsgs VALUES(53, "Bad Digest", 6)
INSERT RadLogMsgs VALUES(54, "Bad username", 3)
INSERT RadLogMsgs VALUES(60, "Parse Error", 5)
INSERT RadLogMsgs VALUES(100, "Chap Not Allowed", 5)
I ran the suggested script and after that I have sent you another
question to which I never got a response. I also included the folowing
error log with the same question, but didn't receive anything from you.
Mon Aug 31 10:18:33 1998: ODBC Error:S0022:207:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name
'Data'.
Mon Aug 31 10:18:36 1998: ODBC Error:S0022:207:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name
'RadVendorID'.
Mon Aug 31 10:18:36 1998: ODBC Error:S0022:207:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name
'RadVendorID'.
Mon Aug 31 10:18:36 1998: rwallace: PPP-Ed has no RADIUS default
attributes.
Mon Aug 31 10:18:36 1998: ODBC Error:S0022:207:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name
'Data'.
Mon Aug 31 10:18:37 1998: ODBC Error:S0022:207:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name
'RadVendorID'.
Mon Aug 31 10:18:37 1998: ODBC Error:S0022:207:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name
'RadVendorID'.
Mon Aug 31 10:18:37 1998: canoe_va: PPP has no RADIUS default
attributes.
*** RETURNED MESSAGE TRUNCATED ***