[Emerald] SQL woes with emerald and radius

Darren Clissold ( (no email) )
Thu, 27 May 1999 03:22:35 +1000

This is a multi-part message in MIME format.

------=_NextPart_000_00DC_01BEA7F0.29F0F740
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

We recently had our server go down due to a disk failure.

I now have a new server up but there are a couple of problems.

In the Radius auth log we keep getting the following:

ODBC Error:37000:2812:
[Microsoft][ODBC SQL Server Driver][SQL Server]Stored procedure =
'RadGetConfigs' not found.

The database was on another machine that was having hardware problems so =
we transfered it to the new one.

And now have SQL procedure problems.

Having problems trying to get a new user to work.

You can login to emerald but when you try to search the database, you =
get

SQL Command Failed!

Also can't delete MBR's, I created a test one when logged in as sa, but =
now I can't delete it I get.

Error Deleting Actions.

I just tried a subaccount entry, I could create it, but I can't delete =
it, I get

Error Deleting CallHistory

I can also still edit accounts.

I have installed the current Emeral2.5 from the download site as our =
copy was corrupt.

Everyone is logging in on modems OK and getting validated for email.

What's going on here?

Darren Clissold
Datafast, http://www.datafast.net.au
darren@datafast.net.au

------=_NextPart_000_00DC_01BEA7F0.29F0F740
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">

We recently had our server go down =due to a disk=20failure.
 
I now have a new server up but there =are a=20couple of problems.
 
In the Radius auth log we keep getting the=20following:
 
 ODBC =Error:37000:2812:
 [Microsoft][ODBC SQL=20Server Driver][SQL Server]Stored procedure 'RadGetConfigs' not=20found.
The database was on another machine =that was=20having hardware problems so we transfered it to the new =one.
 
And now have SQL procedure=20problems.
 
Having problems trying to get a new user to work.
 
You can login to emerald but when you try to search the database, =you=20get
 
SQL Command Failed!
 
Also can't delete MBR's, I created a =test one=20when logged in as sa, but now I can't delete it I get.
 
Error Deleting Actions.
 
I just tried a subaccount entry, I could create it, =but I=20can't delete it, I get
 
Error Deleting CallHistory
 
I can also still edit accounts.
 
I have installed the current =Emeral2.5 from the=20download site as our copy was corrupt.
 
Everyone is logging in on modems OK =and getting=20validated for email.
 
What's going on here?
 
Darren Clissold
Datafast, http://www.datafast.net.au
darren@datafast.net.au<=/DIV>------=_NextPart_000_00DC_01BEA7F0.29F0F740--