On Friday, 3 December 2021 at 01:24:10 UTC-8, Paul Mason wrote:
Hi Rich,
This is an error trying to start the Ingres service. It gets installed as part of the installation.
If you don't care about starting Ingres as a service then it's not a show stopper. If you do then you can install it manually (see below)
A few questions:
What version of Suse is this?
Was this the rpm saveset or the ingbuild one?
Was it an upgrade?
Check whether you have the file $II_SYSTEM/ingres/files/rcfiles/ingresII.service. If you do you can manually install it with:
mksystemd -i
as root.
If you still have the output of the install terminal session it would be interesting to see if there are any errors relating to systemd.
Thanks
Paul
-----Original Message-----
From: info-ingr...@lists.planetingres.org <info-ingr...@lists.planetingres.org> On Behalf Of Rich Ford
Sent: 03 December 2021 03:44
To: info-...@lists.planetingres.org
Subject: [Info-ingres] Ingres Installation
I just installed 11.2 on SuSe
express_install.sh -licdir /ingres/license -interactive -no32bit
but got this error at the end:
redirecting to systemctl start ingresII.service
Failed to start ingresII.service: Unit ingresII.service not found.
Is there a fix for this?
Rich1) OS version is 15.2
_______________________________________________
Info-ingres mailing list
Info-...@lists.planetingres.org https://lists.planetingres.org/mailman/listinfo/info-ingres
2) Not sure of the distinction between saveset or inbuild.
I downloaded from Actian:
actianx-11.1.0-100-com-linux-rpm-x86_64-15692
3) New installation
Thanks,
Rich
Hi Rich,
This is an error trying to start the Ingres service. It gets installed as part of the installation.
If you don't care about starting Ingres as a service then it's not a show stopper. If you do then you can install it manually (see below)
A few questions:
What version of Suse is this?
Was this the rpm saveset or the ingbuild one?
Was it an upgrade?
Check whether you have the file $II_SYSTEM/ingres/files/rcfiles/ingresII.service. If you do you can manually install it with:
mksystemd -i
as root.
If you still have the output of the install terminal session it would be interesting to see if there are any errors relating to systemd.
Thanks
Paul
-----Original Message-----
From: info-ingr...@lists.planetingres.org <info-ingr...@lists.planetingres.org> On Behalf Of Rich Ford
Sent: 03 December 2021 03:44
To: info-...@lists.planetingres.org
Subject: [Info-ingres] Ingres Installation
I just installed 11.2 on SuSe
express_install.sh -licdir /ingres/license -interactive -no32bit
but got this error at the end:
redirecting to systemctl start ingresII.service
Failed to start ingresII.service: Unit ingresII.service not found.
Is there a fix for this?
Rich
_______________________________________________
Info-ingres mailing list
Info-...@lists.planetingres.org https://lists.planetingres.org/mailman/listinfo/info-ingres
On Friday, 3 December 2021 at 01:24:10 UTC-8, Paul Mason wrote:
Hi Rich,
This is an error trying to start the Ingres service. It gets installed as part of the installation.
If you don't care about starting Ingres as a service then it's not a show stopper. If you do then you can install it manually (see below)
A few questions:
What version of Suse is this?
Was this the rpm saveset or the ingbuild one?
Was it an upgrade?
Check whether you have the file $II_SYSTEM/ingres/files/rcfiles/ingresII.service. If you do you can manually install it with:
mksystemd -i
as root.
If you still have the output of the install terminal session it would be interesting to see if there are any errors relating to systemd.
Thanks
Paul
-----Original Message-----
From: info-ingr...@lists.planetingres.org <info-ingr...@lists.planetingres.org> On Behalf Of Rich Ford
Sent: 03 December 2021 03:44
To: info-...@lists.planetingres.org
Subject: [Info-ingres] Ingres Installation
I just installed 11.2 on SuSe
express_install.sh -licdir /ingres/license -interactive -no32bit
but got this error at the end:
redirecting to systemctl start ingresII.service
Failed to start ingresII.service: Unit ingresII.service not found.
Is there a fix for this?
Rich1) OS version is 15.2
_______________________________________________
Info-ingres mailing list
Info-...@lists.planetingres.org https://lists.planetingres.org/mailman/listinfo/info-ingres
2) Not sure of the distinction between saveset or inbuild.
I downloaded from Actian:
actianx-11.1.0-100-com-linux-rpm-x86_64-15692
3) New installation
Thanks,
Rich
You mentioned the rpm saveset -asked about having the output from the terminal when you installed.
actianx-11.1.0-100-com-linux-rpm-x86_64-15692
that doesn't use ingbuild, that would be the other saveset -
actianx-11.1.0-100-com-linux-ingbuild-x86_64-15692
I asked because the way things are done is slightly different.
Did you find the service file in $II_SYSTEM/ingres/files/rcfiles?
During the installation (either type) the service file first gets created and then gets installed. Your original error implies it was not installed but it would be interesting to know whether it failed getting created or just installed. That's why I
As I said before you should be able to install the service manually if you want it. A fix may be needed to the install process but you probably don't want to re-install Actian X just to get the service working.
When I get the time I'll try the install on Suse 15.2 myself and see if I can reproduce it. If you want to pursue this then you may want to open a Support issue.
Regards
Paul
-----Original Message-----
From: info-ingr...@lists.planetingres.org <info-ingr...@lists.planetingres.org> On Behalf Of Rich Ford
Sent: 03 December 2021 15:26
To: info-...@lists.planetingres.org
Subject: Re: [Info-ingres] Ingres Installation
On Friday, 3 December 2021 at 07:17:55 UTC-8, Rich Ford wrote:
On Friday, 3 December 2021 at 01:24:10 UTC-8, Paul Mason wrote:
Hi Rich,
This is an error trying to start the Ingres service. It gets installed as part of the installation.
If you don't care about starting Ingres as a service then it's not a show stopper. If you do then you can install it manually (see below)
A few questions:
What version of Suse is this?
Was this the rpm saveset or the ingbuild one?
Was it an upgrade?
Check whether you have the file $II_SYSTEM/ingres/files/rcfiles/ingresII.service. If you do you can manually install it with:
mksystemd -i
as root.
If you still have the output of the install terminal session it would be interesting to see if there are any errors relating to systemd.
Thanks
Paul
-----Original Message-----
From: info-ingr...@lists.planetingres.org <info-ingr...@lists.planetingres.org> On Behalf Of Rich Ford
Sent: 03 December 2021 03:44
To: info-...@lists.planetingres.org
Subject: [Info-ingres] Ingres Installation
I just installed 11.2 on SuSe
express_install.sh -licdir /ingres/license -interactive -no32bit
but got this error at the end:
redirecting to systemctl start ingresII.service
Failed to start ingresII.service: Unit ingresII.service not found.
Is there a fix for this?
Rich1) OS version is 15.2
_______________________________________________
Info-ingres mailing list
Info-...@lists.planetingres.org https://lists.planetingres.org/mailman/listinfo/info-ingres
2) Not sure of the distinction between saveset or inbuild.
I downloaded from Actian:
actianx-11.1.0-100-com-linux-rpm-x86_64-15692
3) New installation
Thanks,
Rich
Yes it's ingbuild called from running express_install.sh.
install/ingbuild
_______________________________________________
Info-ingres mailing list
Info-...@lists.planetingres.org https://lists.planetingres.org/mailman/listinfo/info-ingres
Hi Rich,services. However in the case of OpenSuSE 15 and SLES 15 a part of this compatibility layer is not installed by default.
First I must apologise. I misread this as you trying to install 11.2 not 11.1, despite the fact you clearly mentioned 11.1.
In 11.1 we are still using so-called "sysv" style service scripts. These are ones that get created in /etc/rc.d. Most modern Linux distros use systemd instead and provide compatibility scripts to make sysv scripts appear as if they were systemd
So in order to fix this you would need to install "insserv-compat" i.e. something like:
sudo zypper install insserv-compat
This then would allow the installing of the 11.1 sysv service scripts. Since you probably already installed the instance itself OK and don't want to re-install just to fix it you can install it manually:
$ source /opt/Actian/IngresII/.ingIIsh # or whatever your instance env script is
$ mkrc # this generates the scripts, specific to your instance
$ sudo -s
$ source /opt/Actian/IngresII/.ingIIsh
$ mkrc -i
We added full systemd support in 11.2 which uses mksystemd instead of mkrc (although you can still use sysv if you really want). So apologies because a lot of my previous comments refer to that.
This is a known problem and there was supposed to be a fix and/or note in the readme. However the "fix" will be the installer warning you that you need to install insserv-compat. I'll chase that up.
Regards
Paul
On Monday, 6 December 2021 at 03:44:09 UTC-8, Paul Mason wrote:services. However in the case of OpenSuSE 15 and SLES 15 a part of this compatibility layer is not installed by default.
Hi Rich,
First I must apologise. I misread this as you trying to install 11.2 not 11.1, despite the fact you clearly mentioned 11.1.
In 11.1 we are still using so-called "sysv" style service scripts. These are ones that get created in /etc/rc.d. Most modern Linux distros use systemd instead and provide compatibility scripts to make sysv scripts appear as if they were systemd
So in order to fix this you would need to install "insserv-compat" i.e. something like:
sudo zypper install insserv-compat
This then would allow the installing of the 11.1 sysv service scripts. Since you probably already installed the instance itself OK and don't want to re-install just to fix it you can install it manually:
$ source /opt/Actian/IngresII/.ingIIsh # or whatever your instance env script is
$ mkrc # this generates the scripts, specific to your instance
$ sudo -s
$ source /opt/Actian/IngresII/.ingIIsh
$ mkrc -i
We added full systemd support in 11.2 which uses mksystemd instead of mkrc (although you can still use sysv if you really want). So apologies because a lot of my previous comments refer to that.
This is a known problem and there was supposed to be a fix and/or note in the readme. However the "fix" will be the installer warning you that you need to install insserv-compat. I'll chase that up.
RegardsGood information. I have this configured now.
Paul
Rich
On Monday, 6 December 2021 at 08:39:20 UTC-8, Rich Ford wrote:services. However in the case of OpenSuSE 15 and SLES 15 a part of this compatibility layer is not installed by default.
On Monday, 6 December 2021 at 03:44:09 UTC-8, Paul Mason wrote:
Hi Rich,
First I must apologise. I misread this as you trying to install 11.2 not 11.1, despite the fact you clearly mentioned 11.1.
In 11.1 we are still using so-called "sysv" style service scripts. These are ones that get created in /etc/rc.d. Most modern Linux distros use systemd instead and provide compatibility scripts to make sysv scripts appear as if they were systemd
So in order to fix this you would need to install "insserv-compat" i.e. something like:
sudo zypper install insserv-compat
This then would allow the installing of the 11.1 sysv service scripts. Since you probably already installed the instance itself OK and don't want to re-install just to fix it you can install it manually:
$ source /opt/Actian/IngresII/.ingIIsh # or whatever your instance env script is
$ mkrc # this generates the scripts, specific to your instance
$ sudo -s
$ source /opt/Actian/IngresII/.ingIIsh
$ mkrc -i
We added full systemd support in 11.2 which uses mksystemd instead of mkrc (although you can still use sysv if you really want). So apologies because a lot of my previous comments refer to that.
This is a known problem and there was supposed to be a fix and/or note in the readme. However the "fix" will be the installer warning you that you need to install insserv-compat. I'll chase that up.
RegardsGood information. I have this configured now.
Paul
RichI made the changes and rebooted the server but now getting this error:
accessdb
E_LC0001 GCA protocol service (GCA_REQUEST) failure.
Internal service status E_GCfe05 -- Unable to make outgoing connection.
- Please check that the remote server (localhost/127.0.0.1) is correct
and that the port (44819) you are trying to connect to is open and
allowed through the firewall.
connect() failed with operating system error 107 (Transport endpoint is
not connected).
E_LQ0001 Failed to connect to DBMS session.
E_IC0061 Error starting INGRES.
Error '000094D4' occurred when Accessdb/Catalogdb tried to connect to
the database. The preceding error messages should explain what type of
error occurred. If not, then report this problem to your Site Technical Contact.
Rich
On Monday, 6 December 2021 at 08:39:20 UTC-8, Rich Ford wrote:
I made the changes and rebooted the server but now getting this error:
accessdb
E_LC0001 GCA protocol service (GCA_REQUEST) failure.
Internal service status E_GCfe05 -- Unable to make outgoing connection.
- Please check that the remote server (localhost/127.0.0.1) is correct
and that the port (44819) you are trying to connect to is open and
allowed through the firewall.
connect() failed with operating system error 107 (Transport endpoint is
not connected).
E_LQ0001 Failed to connect to DBMS session.
E_IC0061 Error starting INGRES.
Error '000094D4' occurred when Accessdb/Catalogdb tried to connect to
the database. The preceding error messages should explain what type of
error occurred. If not, then report this problem to your Site Technical
Contact.
Rich Ford wrote:
On Monday, 6 December 2021 at 08:39:20 UTC-8, Rich Ford wrote:[snip]
I made the changes and rebooted the server but now getting this error:
accessdb
E_LC0001 GCA protocol service (GCA_REQUEST) failure.
Internal service status E_GCfe05 -- Unable to make outgoing connection.
- Please check that the remote server (localhost/127.0.0.1) is correct
and that the port (44819) you are trying to connect to is open and
allowed through the firewall.
connect() failed with operating system error 107 (Transport endpoint is
not connected).
E_LQ0001 Failed to connect to DBMS session.
E_IC0061 Error starting INGRES.What do you get from running
Error '000094D4' occurred when Accessdb/Catalogdb tried to connect to
the database. The preceding error messages should explain what type of error occurred. If not, then report this problem to your Site Technical Contact.
iinamu show servers
If it shows 44819 the name server is confused.
Roy
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 418 |
Nodes: | 16 (2 / 14) |
Uptime: | 21:35:03 |
Calls: | 8,764 |
Calls today: | 7 |
Files: | 13,287 |
D/L today: |
3 files (1,633K bytes) |
Messages: | 5,964,647 |