Re: [OpenXPKI-users] Integration Issue with Apache

2023-09-01 Thread Martin Bartosch via OpenXPKI-users
Hi Chris,

> 2023/09/01 16:28:21 ERR Error creating backend client Error while writing to 
> socket; __EVAL_ERROR__ => I18N_OPENXPKI_CLIENT_INIT_CONNECTION_FAILED; 
> __ERROR__ => Permission denied, __SOCKETFILE__ => 
> /var/openxpki/openxpki.socket [pid=2305|sid=[undef]]

The OpenXPKI Web UI executes within the scope of the Apache server and needs 
read/write access to the OpenXPKI socket file. So, according to the above error 
message, please check permissions and ownership of the socket file. Obviously 
something is configured incorrectly, hence fix the Apache configuration 
(runtime user) and/or OpenXPKI server configuration accordingly.

Best regards,

Martin



___
OpenXPKI-users mailing list
OpenXPKI-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openxpki-users


Re: [OpenXPKI-users] Integration Issue with Apache

2023-09-01 Thread chris via OpenXPKI-users
Hi oli, 
thanks for pointing that out i didnt have a dedicated error log set for 
SSL/Vhost, after setting it up i got some permission errors which was stopping 
it to write logs to /var/log/openxpki/webui.log, after fixing that now i'm 
getting a backend service not reachable or not responding error on web page, in 
webui.log im getting this:

2023/09/01 16:28:21 INF Start fcgi loop 2305 [pid=2305|sid=[undef]]
2023/09/01 16:28:21 ERR Error creating backend client Error while writing to 
socket; __EVAL_ERROR__ => I18N_OPENXPKI_CLIENT_INIT_CONNECTION_FAILED; 
__ERROR__ => Permission denied, __SOCKETFILE__ => /var/openxpki/openxpki.socket 
[pid=2305|sid=[undef]]
2023/09/01 16:28:21 INF Backend service is not reachable or not responding 
[pid=2305|sid=[undef]]
2023/09/01 16:28:21 ERR Error creating backend client Error while writing to 
socket; __EVAL_ERROR__ => I18N_OPENXPKI_CLIENT_INIT_CONNECTION_FAILED; 
__ERROR__ => Permission denied, __SOCKETFILE__ => /var/openxpki/openxpki.socket 
[pid=2305|sid=[undef]]
2023/09/01 16:28:21 INF Backend service is not reachable or not responding 
[pid=2305|sid=[undef]]
2023/09/01 16:28:39 ERR Error creating backend client Error while writing to 
socket; __EVAL_ERROR__ => I18N_OPENXPKI_CLIENT_INIT_CONNECTION_FAILED; 
__ERROR__ => Permission denied, __SOCKETFILE__ => /var/openxpki/openxpki.socket 
[pid=2305|sid=[undef]]
2023/09/01 16:28:39 INF Backend service is not reachable or not responding 
[pid=2305|sid=[undef]]
2023/09/01 16:28:39 ERR Error creating backend client Error while writing to 
socket; __EVAL_ERROR__ => I18N_OPENXPKI_CLIENT_INIT_CONNECTION_FAILED; 
__ERROR__ => Permission denied, __SOCKETFILE__ => /var/openxpki/openxpki.socket 
[pid=2305|sid=[undef]]
2023/09/01 16:28:39 INF Backend service is not reachable or not responding 
[pid=2305|sid=[undef]]






> Hi Chris,
> 
> Do you perhaps have a dedicated error log for SSL/vhost configured?
> Nothing in /var/log/openxpki ?
> 
> Use the browser dev tools (F12) and check what URLs are called and what
> they return - perhaps this gives you some idea. Educated guess would be
> you are not resolving the /cgi-bin stuff to run scripts and the server
> returns some HTML error page or the scripts source instead of a JSON
> object which can not be handled by the AJAX components.
> 
> Oli
> 
> On 01.09.23 11:54, chris via OpenXPKI-users wrote:
> 
> > Hi Martin,
> > 
> > this is the apache error log:
> > [Fri Sep 01 9:28:39.274836 2023] [mpm_event:notice] [pid 1660:tid 
> > 140501380126528] AH00491: caught SIGTERM, shutting down
> > [Fri Sep 01 9:28:39.373016 2023] [mpm_event:notice] [pid 1775:tid 
> > 140148171941696] AH00489: Apache/2.4.57 (Unix) OpenSSL/1.1.1v 
> > mod_fcgid/2.3.9 configured -- resuming normal operations
> > [Fri Sep 01 9:28:39.373056 2023] [core:notice] [pid 1775:tid 
> > 140148171941696] AH00094: Command line: '/usr/local/apache2/bin/httpd'
> > [Fri Sep 01 9:30:23.978631 2023] [fcgid:warn] [pid 1776:tid 
> > 140148171941696] mod_fcgid: cleanup zombie process 1893
> > 
> > > Hi Chris,
> > > 
> > > > Hi, I'm reaching out to the community seeking assistance with an issue 
> > > > I've encountered during an integration process. Having recently 
> > > > upgraded my Apache web server to the latest version from source, I 
> > > > referred to the documentation and adjusted the openxpki.conf settings 
> > > > in alignment with the default Apache2 configuration httpd.conf. 
> > > > However, when attempting to access the OpenXPKI web interface, I'm 
> > > > consistently greeted with an "unknown application" error. I've 
> > > > meticulously gone through the logs, and to my surprise, there are no 
> > > > error entries recorded. I'm unable to pinpoint the root cause. As 
> > > > someone relatively new to this endeavor, I'm open to learning from the 
> > > > community's collective wisdom. I would greatly appreciate any insights 
> > > > you could provide. It's possible that I've missed a step or overlooked 
> > > > a crucial configuration, and your guidance could prove instrumental in 
> > > > resolving this matter.
> > > 
> > > Without additional information it is very difficult to assess what went 
> > > wrong. Have a look in the Apache error log, I would expect some 
> > > enlightening information there.
> > 
> > ___
> > OpenXPKI-users mailing list
> > OpenXPKI-users@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/openxpki-users
> 
> --
> Protect your environment - close windows and adopt a penguin!
> 
> 
> 
> ___
> OpenXPKI-users mailing list
> OpenXPKI-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/openxpki-users


___
OpenXPKI-users mailing list
OpenXPKI-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openxpki-users


Re: [OpenXPKI-users] openxpkid cannot start: No next::method 'new' found for SQL::Abstract::More at /usr/lib/x86_64-linux-gnu/perl/5.36/mro.pm line 30

2023-09-01 Thread Oliver Welter

Hi Krzysztof,

glad to hear its working now - I did not check but likely the missing 
module should be installed via the "recommends" mechanism which gets 
broken during update?


Not adding the DB drivers as deps is intentional as we do not want to 
have unused deps packages, and this is also clearly mentiond in the 
Quickstart ;)


Oliver

On 01.09.23 10:57, Krzysztof Stryjek via OpenXPKI-users wrote:

Hi Jens,

On Thu, Aug 31, 2023 at 03:59:34PM +0200, Jens Berthold wrote:

Hi Krzysztof,

in addition to what Oliver said:

SQL::Abstract::More uses mro to handle inheritance. It calls mro‘s next::method to invoke 
the parents‘ "new" method. Parent class of SQL::Abstract::More should be 
SQL::Abstract::Classic per default and I think the error means that 
SQL::Abstract::Classic->new() does not exist.

So you might want to check your system for SQL::Abstract::Classic to see if it exists and 
contains a "sub new …", e.g. with

perl -e 'use SQL::Abstract::Classic; SQL::Abstract::Classic->new'


Thanks a lot for your help. Yes, indeed during upgrades
'libsql-abstract-classic-perl' was not installed.

Also I've found that afeter changing "setting" from mysql to mariadb it
was needed to install 'libdbd-mariadb-perl'. So maybe it is worth to add
this package to debian denedencies

So I think this issue could be closed.

Once again: thank you (and others) for your help.

Greetings,


--
Protect your environment -  close windows and adopt a penguin!



___
OpenXPKI-users mailing list
OpenXPKI-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openxpki-users


Re: [OpenXPKI-users] Integration Issue with Apache

2023-09-01 Thread Oliver Welter

Hi Chris,

Do you perhaps have a dedicated error log for SSL/vhost configured? 
Nothing in /var/log/openxpki ?


Use the browser dev tools (F12) and check what URLs are called and what 
they return - perhaps this gives you some idea. Educated guess would be 
you are not resolving the /cgi-bin stuff to run scripts and the server 
returns some HTML error page or the scripts source instead of a JSON 
object which can not be handled by the AJAX components.


Oli

On 01.09.23 11:54, chris via OpenXPKI-users wrote:

Hi Martin,

this is the apache error log:
[Fri Sep 01 9:28:39.274836 2023] [mpm_event:notice] [pid 1660:tid 
140501380126528] AH00491: caught SIGTERM, shutting down
[Fri Sep 01 9:28:39.373016 2023] [mpm_event:notice] [pid 1775:tid 
140148171941696] AH00489: Apache/2.4.57 (Unix) OpenSSL/1.1.1v mod_fcgid/2.3.9 
configured -- resuming normal operations
[Fri Sep 01 9:28:39.373056 2023] [core:notice] [pid 1775:tid 140148171941696] 
AH00094: Command line: '/usr/local/apache2/bin/httpd'
[Fri Sep 01 9:30:23.978631 2023] [fcgid:warn] [pid 1776:tid 140148171941696] 
mod_fcgid: cleanup zombie process 1893



Hi Chris,


Hi, I'm reaching out to the community seeking assistance with an issue I've encountered 
during an integration process. Having recently upgraded my Apache web server to the 
latest version from source, I referred to the documentation and adjusted the 
openxpki.conf settings in alignment with the default Apache2 configuration httpd.conf. 
However, when attempting to access the OpenXPKI web interface, I'm consistently greeted 
with an "unknown application" error. I've meticulously gone through the logs, 
and to my surprise, there are no error entries recorded. I'm unable to pinpoint the root 
cause. As someone relatively new to this endeavor, I'm open to learning from the 
community's collective wisdom. I would greatly appreciate any insights you could provide. 
It's possible that I've missed a step or overlooked a crucial configuration, and your 
guidance could prove instrumental in resolving this matter.


Without additional information it is very difficult to assess what went wrong. 
Have a look in the Apache error log, I would expect some enlightening 
information there.





___
OpenXPKI-users mailing list
OpenXPKI-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openxpki-users


--
Protect your environment -  close windows and adopt a penguin!



___
OpenXPKI-users mailing list
OpenXPKI-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openxpki-users


[OpenXPKI-users] OpenXPKI 3.26 debian 12 missing systemd service? openxpkid does not start after reboot

2023-09-01 Thread Krzysztof Stryjek via OpenXPKI-users
Hi,

I was searching list archive also github sources. But I failed :-(((

I've found that in previous versions there is (should be) systemd
starting script:
lrwxrwxrwx 1 root root 37 2020-01-16 
/etc/systemd/system/multi-user.target.wants/openxpkid.service -> 
/lib/systemd/system/openxpkid.service

And after upgrades '/lib/systemd/system/openxpkid.service' desappeared.

So I've found on github, that there is systemd script:
https://github.com/openxpki/openxpki/blob/develop/package/debian/core/libopenxpki-perl.openxpkid.service

So I've copied it to my Debian system as
'/lib/systemd/system/openxpkid.service'. 

Unfortunatelly after reboot (I'm able to do meny reboots :-))) )
openxpkid does not start. Of course after login I'm able to start
openxpkid via:
service openxpkid start

So question is: what I'm doing wrong?

I'm not super familair with Debian so I've found that 'systemctl'
command disappeared in Debian 12. There is package 'systemctl' but it is
kind of wrapper (old version?) and this command complains about:
[Service]
Type=exec
^^

Thank you very much for any suggestions which can help resolve this
issue.

Greetings,
-- 
Krzysztof Stryjek
UNIX administrator, Network Security Specialist
email: admin (at) codenix (dot) pl
GPG fingerprint: 8BD7 40CE 8994 0BBE CE6C 91CD 1292 8959 DC61 0E76



___
OpenXPKI-users mailing list
OpenXPKI-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openxpki-users


Re: [OpenXPKI-users] Integration Issue with Apache

2023-09-01 Thread chris via OpenXPKI-users


Hi Martin,

this is the apache error log:
[Fri Sep 01 9:28:39.274836 2023] [mpm_event:notice] [pid 1660:tid 
140501380126528] AH00491: caught SIGTERM, shutting down
[Fri Sep 01 9:28:39.373016 2023] [mpm_event:notice] [pid 1775:tid 
140148171941696] AH00489: Apache/2.4.57 (Unix) OpenSSL/1.1.1v mod_fcgid/2.3.9 
configured -- resuming normal operations
[Fri Sep 01 9:28:39.373056 2023] [core:notice] [pid 1775:tid 140148171941696] 
AH00094: Command line: '/usr/local/apache2/bin/httpd'
[Fri Sep 01 9:30:23.978631 2023] [fcgid:warn] [pid 1776:tid 140148171941696] 
mod_fcgid: cleanup zombie process 1893


> Hi Chris,
> 
> > Hi, I'm reaching out to the community seeking assistance with an issue I've 
> > encountered during an integration process. Having recently upgraded my 
> > Apache web server to the latest version from source, I referred to the 
> > documentation and adjusted the openxpki.conf settings in alignment with the 
> > default Apache2 configuration httpd.conf. However, when attempting to 
> > access the OpenXPKI web interface, I'm consistently greeted with an 
> > "unknown application" error. I've meticulously gone through the logs, and 
> > to my surprise, there are no error entries recorded. I'm unable to pinpoint 
> > the root cause. As someone relatively new to this endeavor, I'm open to 
> > learning from the community's collective wisdom. I would greatly appreciate 
> > any insights you could provide. It's possible that I've missed a step or 
> > overlooked a crucial configuration, and your guidance could prove 
> > instrumental in resolving this matter.
> 
> 
> Without additional information it is very difficult to assess what went 
> wrong. Have a look in the Apache error log, I would expect some enlightening 
> information there.





___
OpenXPKI-users mailing list
OpenXPKI-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openxpki-users


Re: [OpenXPKI-users] openxpkid cannot start: No next::method 'new' found for SQL::Abstract::More at /usr/lib/x86_64-linux-gnu/perl/5.36/mro.pm line 30

2023-09-01 Thread Krzysztof Stryjek via OpenXPKI-users
Hi Jens,

On Thu, Aug 31, 2023 at 03:59:34PM +0200, Jens Berthold wrote:
> Hi Krzysztof,
> 
> in addition to what Oliver said:
> 
> SQL::Abstract::More uses mro to handle inheritance. It calls mro‘s 
> next::method to invoke the parents‘ "new" method. Parent class of 
> SQL::Abstract::More should be SQL::Abstract::Classic per default and I think 
> the error means that SQL::Abstract::Classic->new() does not exist.
> 
> So you might want to check your system for SQL::Abstract::Classic to see if 
> it exists and contains a "sub new …", e.g. with
> 
> perl -e 'use SQL::Abstract::Classic; SQL::Abstract::Classic->new'
> 
Thanks a lot for your help. Yes, indeed during upgrades
'libsql-abstract-classic-perl' was not installed.

Also I've found that afeter changing "setting" from mysql to mariadb it
was needed to install 'libdbd-mariadb-perl'. So maybe it is worth to add
this package to debian denedencies

So I think this issue could be closed.

Once again: thank you (and others) for your help.

Greetings,
-- 
Krzysztof Stryjek
UNIX administrator, Network Security Specialist
email: admin (at) codenix (dot) pl
GPG fingerprint: 8BD7 40CE 8994 0BBE CE6C 91CD 1292 8959 DC61 0E76



___
OpenXPKI-users mailing list
OpenXPKI-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openxpki-users


Re: [OpenXPKI-users] Integration Issue with Apache

2023-09-01 Thread Martin Bartosch via OpenXPKI-users
Hi Chris,

> Hi, I'm reaching out to the community seeking assistance with an issue I've 
> encountered during an integration process. Having recently upgraded my Apache 
> web server to the latest version from source, I referred to the documentation 
> and adjusted the openxpki.conf settings in alignment with the default Apache2 
> configuration httpd.conf. However, when attempting to access the OpenXPKI web 
> interface, I'm consistently greeted with an "unknown application" error. I've 
> meticulously gone through the logs, and to my surprise, there are no error 
> entries recorded. I'm unable to pinpoint the root cause. As someone 
> relatively new to this endeavor, I'm open to learning from the community's 
> collective wisdom. I would greatly appreciate any insights you could provide. 
> It's possible that I've missed a step or overlooked a crucial configuration, 
> and your guidance could prove instrumental in resolving this matter. 

Without additional information it is very difficult to assess what went wrong. 
Have a look in the Apache error log, I would expect some enlightening 
information there.

Cheers

Martin



___
OpenXPKI-users mailing list
OpenXPKI-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openxpki-users