I posted a message back in October, 2007 and the responses indicated I
needed to periodically run the CA licensing program to [re]create the
/ca_lic directory which should be good for 30 days. I set up a cron job to
execute on the 1st and 16th of every month.

The problem is that this license is now expiring more frequently to the
extent that a daily run doesn't always work.

Here are the entries in the errlog.log file:


E_CL2654_CI_CANT_OPEN Computer Associates Licensing -2H30- Can't open
license file. Please run the appropriate license program to properly
license your product. LRF=2H30,000c294f1d96,SCO_PentIII_1_*,[hostname
omitted]

This was a fully paid license when installed and yearly maintenance paid
until CA spun Ingres off, hence the licensing kludge. I should also point
out that we had to move the entire Ingres insallation to a new server in
2007 which triggered the problem to begin with.

Any suggestions as to what is happening and what can be done about it?

Thank you,
Lucky Leavell

Maybe helpful:
http://downloads.actian.com/media/PD..._Licensing.pdf

Regards
Gerhard


--
gerhard.hofmann (AT) planat (DOT) de
------------------------------------------------------------------------
gerhard.hofmann (AT) planat (DOT) de's Profile: http://community.actian.com/forum/member.php?userid=857
View this thread: http://community.actian.com/forum/sh...ad.php?t=14138

Hi Lucky,

A few years ago, Ingres Corp issued a bunch of of licenses with an expiry
date of 2035 so you don't have to keep re-licencing. You copy these into
ca.olf in the ca_lic directory. Actian Support should be able to locate this
for you.

regards
Paul

-----Original Message-----
From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of Lucky
Leavell
Sent: Tuesday, 3 January 2012 1:29 AM
To: Lucky Leavell
Subject: [Info-Ingres] Ingres II Licensing Issue

I posted a message back in October, 2007 and the responses indicated I
needed to periodically run the CA licensing program to [re]create the
/ca_lic directory which should be good for 30 days. I set up a cron job to
execute on the 1st and 16th of every month.

The problem is that this license is now expiring more frequently to the
extent that a daily run doesn't always work.

Here are the entries in the errlog.log file:


E_CL2654_CI_CANT_OPEN Computer Associates Licensing -2H30- Can't open
license file. Please run the appropriate license program to properly
license your product. LRF=2H30,000c294f1d96,SCO_PentIII_1_*,[hostname
omitted]

This was a fully paid license when installed and yearly maintenance paid
until CA spun Ingres off, hence the licensing kludge. I should also point
out that we had to move the entire Ingres insallation to a new server in
2007 which triggered the problem to begin with.

Any suggestions as to what is happening and what can be done about it?

Thank you,
Lucky Leavell

_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres

On Mon, 2 Jan 2012, Ingres Forums wrote:

Thank you very much (and also to Paul White). This looks very promising!

Lucky Leavell

That message is annoying but not fatal in 2.6 and after.


--
daryl.monge (AT) ingres (DOT) com
------------------------------------------------------------------------
daryl.monge (AT) ingres (DOT) com's Profile: http://community.actian.com/forum/member.php?userid=736
View this thread: http://community.actian.com/forum/sh...ad.php?t=14139

On Mon, 2 Jan 2012, Lucky Leavell wrote:

I downloaded and followed the instructions in the Ingres Licensing PDF and
it worked flawlwssly! Thank you VERY much!

Lucky Leavell

On Tue, 3 Jan 2012, Lucky Leavell wrote:

It's back:

E_CL2654_CI_CANT_OPEN Computer Associates Licensing -2H30- Can't open
license file. Please run the appropriate lic
ense program to properly license your product.
LRF=2H30,000c294f1d96,SCO_PentIII_1_*,gasboy.stl.l ocal,0

Here is the ca.olf file:
cat ca.olf
FEATURE CA_LICENSE CAI_lic_d 1.000 31-DEC-2035 0 ACC490A19E5FB2E074D1 "ANY 2H30[1]" ANY INGRES
3CF4A071F60BC8441972 INGRES #

They began sometime January 3 after I checked and logged off.

Here is the version.dat and version.rel

cat version.dat
## action performed status patch seq version
##
install 23-Jan-2002 19:50:52 valid 6900 1 II 2.0/0001
(sos.us5/00)
##
## File format information (DO NOT REMOVE):
## _filetype_b_filetype_
## _protocol_1_protocol_
##

cat version.rel
II 2.0/0001 (sos.us5/00)
6900
------------------------------------------------------------

Despite the numerous log messages, it ran and restarted several times
until today. I used the old license reset trick to get them up again:

E_CL2659_CI_TERMINATE Computer Associates Licensing -2H30- License
Failure. Terminating... Please run the appropri
ate license program to properly license your product.
LRF=2H30,000c294f1d96,SCO_PentIII_1_*,gasboy.stl.l ocal,0


I have an identical system, same OS and Ingres version to which I applied
the same license but I have no log entries about licensing. Of course mine
is lightly loaded and not up all the time.

I know what I did today will not last long. Is there anything else I can
try? Any idea why my system has had no noise log entries about licensing
or anything and they have?

Thank you,
Lucky Leavell

Hi Lucky,

I think the license check occurs each time an Ingres Net (or OpenROAD)
connection is made. Make sure you check $II_SYSTEM/ingres/files/errlog.log
and /ca_lic/lic98.log after a connection is made. Make sure the log files
are writeable by Ingres UserID.

I presume you restarted Ingres after applying the license changes?

Your /ca_lic/ca.olf file looks like it is missing bits at the top?
I would expect to see lines beginning with

ID_2 ABC1234 "Site Name"
ID_3 DEF123456 "SiteID"
SERVER CAI 7152
DAEMON CAI_LIC_D/USR/BIN
FEATURE xxx
FEATURE xxx
FEATURE xxx

Under Windows, the licensing was performed by a license service
logwatnt.exe. Under Solaris I found there was no service needed. I don't
know for sure whether the licensing under SCO requires a service. Check the
installation documentation.

You might consider opening a support call with Actian so you can get the
problem resolved? It will cost you :-)
Your client is probably getting a bit frustrated this old technology.


regards

Paul White





-----Original Message-----
From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of Lucky
Leavell
Sent: Tuesday, 31 January 2012 11:52 AM
To: Ingres and related product discussion forum
Subject: Re: [Info-Ingres] Ingres II Licensing Issue



On Tue, 3 Jan 2012, Lucky Leavell wrote:

It's back:

E_CL2654_CI_CANT_OPEN Computer Associates Licensing -2H30- Can't open
license file. Please run the appropriate lic
ense program to properly license your product.
LRF=2H30,000c294f1d96,SCO_PentIII_1_*,gasboy.stl.l ocal,0

Here is the ca.olf file:
cat ca.olf
FEATURE CA_LICENSE CAI_lic_d 1.000 31-DEC-2035 0 ACC490A19E5FB2E074D1 "ANY
2H30[1]" ANY INGRES
3CF4A071F60BC8441972 INGRES #

They began sometime January 3 after I checked and logged off.

Here is the version.dat and version.rel

cat version.dat
## action performed status patch seq version
##
install 23-Jan-2002 19:50:52 valid 6900 1 II 2.0/0001
(sos.us5/00)
##
## File format information (DO NOT REMOVE):
## _filetype_b_filetype_
## _protocol_1_protocol_
##

cat version.rel
II 2.0/0001 (sos.us5/00)
6900
------------------------------------------------------------

Despite the numerous log messages, it ran and restarted several times
until today. I used the old license reset trick to get them up again:

E_CL2659_CI_TERMINATE Computer Associates Licensing -2H30- License
Failure. Terminating... Please run the appropri
ate license program to properly license your product.
LRF=2H30,000c294f1d96,SCO_PentIII_1_*,gasboy.stl.l ocal,0


I have an identical system, same OS and Ingres version to which I applied
the same license but I have no log entries about licensing. Of course mine
is lightly loaded and not up all the time.

I know what I did today will not last long. Is there anything else I can
try? Any idea why my system has had no noise log entries about licensing
or anything and they have?

Thank you,
Lucky Leavell

_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres

On Tue, 31 Jan 2012, Paul White wrote:

This may have been it!. I made user ingres owner of /ca_lic and everything
in it except the CAMtype file, stopped and started ingres (after putting
the ca.olf file back). There are no licensing errors in either the
errlog.log or ca98.log files.

I found no licensing daemon anywhere on the system so I left those lines
out of the ca.olf. The only lines in the errlog.log that were of some
concern was the third line here:

sodrel0 ::[ , 00000000]: Tue Jan 31 20:13:09 2012
E_GC0152_GCN_SHUTDOWN Name Server normal shutdown.
sodrel0 ::[ , 00000000]: Tue Jan 31 20:13:16 2012
E_GC0151_GCN_STARTUP Name Server normal startup.
sodrel0 ::[ , 00000001]: Tue Jan 31 20:13:34 2012
E_CLFE06_BS_WRITE_ERR Write to peer process failed
; it may have exited.

I have seen it before but do not know its significance.


yes

See above. I think the problem was ingres could not write to the ca98.log
file though the messages indicated it could not read the licensing file.

We'll see ...

they they have told me several times they want to move to another system
but they never do. My consulting business has long ago declined to the
point I have a "day" job. I have used other RDBMSes and still think Ingres
is the best with the possible exception of PostgreSQL. (I don't work with
Oracle as a DBA but prepping Linux systems for Oracle installs and
think it horrid!)

I think it must be a tribute to Ingres that it has run all these years
with only this licensing glitch and not even that until their old hardware
died.

My own Ingres copy started out as SCO Open Desktop until I availed myself
of CAI's offer to convert to a full Ingres license independent of SCO.

Thank you for your help,
Lucky Leavell

sodrel0 ::[ , 00000001]: Tue Jan 31 20:13:34 2012
E_CLFE06_BS_WRITE_ERR Write to peer process failed; it may have exited.

Is probably the client application exiting without closing down the
dbsession.

Paul