[Emerald] Incomplete upgrade..

Rick Knospler ( rick@skylands.net )
Sat, 12 Dec 1998 06:22:13 -0500

I upgraded a copy of my database to Emerald 2.5 RC3 and these are the error
messages displayed during the database update... How can I fix this..?

-Rick

Invalid column name 'AuthPort'.
IF (SELECT COUNT(*) FROM RadRoamServers WHERE RadRoamServerID = -1) = 0
BEGIN
SET IDENTITY_INSERT RadRoamServers ON
INSERT INTO RadRoamServers(RadRoamServerID, IPAddress, Server, Secret,
Timeout, Retries, TreatAsLocal, StripDomain, AuthPort, AcctPort, AllowRLogin)
VALUES(-1, 'None', 'None', '', 0, 0, 0, 0, 1645, 1646, 0)
SET IDENTITY_INSERT RadRoamServers OFF
END

---------------

Invalid column name 'AuthPort'.
IF (SELECT COUNT(*) FROM RadRoamServers) = 0
BEGIN
SET IDENTITY_INSERT RadRoamServers ON
INSERT INTO RadRoamServers(RadRoamServerID, IPAddress, Server, Secret,
Timeout, Retries, TreatAsLocal, StripDomain, AuthPort, AcctPort,
AllowRLogin) VALUES(0, 'None', 'None', '', 0, 0, 0, 0, 1645, 1646, 0)
SET IDENTITY_INSERT RadRoamServers OFF
END

---------------

Invalid object name 'RadRoamCache'.
GRANT EXECUTE ON RadCheckDomain TO EmeraldApps
GRANT EXECUTE ON RadCheckServer TO EmeraldApps
GRANT EXECUTE ON RadCheckOnline TO EmeraldApps
GRANT EXECUTE ON RadCheckPort TO EmeraldApps
GRANT EXECUTE ON RadCheckTrigger TO EmeraldApps
GRANT EXECUTE ON RadGetATConfigs TO EmeraldApps
GRANT EXECUTE ON RadGetConfigs TO EmeraldApps
GRANT EXECUTE ON RU_AT TO EmeraldApps
GRANT EXECUTE ON RU_RATC TO EmeraldApps
GRANT EXECUTE ON RU_RC TO EmeraldApps
GRANT EXECUTE ON RadUserSpecifics TO EmeraldApps
GRANT EXECUTE ON RadUserDefaults TO EmeraldApps
GRANT EXECUTE ON RadCheckOnlineSNMP TO EmeraldApps
GRANT EXECUTE ON VerifyMailUser TO EmeraldApps
GRANT EXECUTE ON VerifyFTPUser TO EmeraldApps
GRANT EXECUTE ON VerifyNewsUser TO EmeraldApps
GRANT EXECUTE ON SendMailUsers TO EmeraldApps
GRANT EXECUTE ON ListMailUsers TO EmeraldApps
GRANT EXECUTE ON RadGetCacheUsers TO EmeraldApps
GRANT EXECUTE ON RadGetUser TO EmeraldApps
GRANT EXECUTE ON RadRoamCache TO EmeraldApps
GRANT EXECUTE ON RadGetRejects TO EmeraldApps

---------------

For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html