Hi Stefano,ignore the last mail, looks like the config was broken on our side before. Can you please try the following:
Open /etc/openxpki/log.conf, search this line log4perl.category.openxpki.auth = INFO, Logfile, DBI and remove the "DBI", restart OXI and report if the system works again.If not, please provide the error message from apache server log and webui.log (if its too large use pastebin or send it directly to me).
Oliver Am 08.06.2016 um 23:45 schrieb Stefano Martinelli:
Hello everyone,
I have OpenXPKI installed on a Debian jessie machine. Last night it was
updated to version 1.10.0-1 by "apt-get upgrade", but since the update,
I have a problem I'm not able to solve.
On a first step, after the upgrade, I got an error during the login phase:
Unknown error (server dbi dbh execute failed)
Looking at the logs, I found a couple of errors about accessing these
two tables:
*seq_application_log:*
Server Error Msg: $VAR1 = {
'SERVICE_MSG' => 'ERROR',
'LIST' => [
{
'LABEL' =>
'I18N_OPENXPKI_SERVER_DBI_DBH_EXECUTE_FAILED',
'PARAMS' => {
'__ERRNO__' => '1146',
'__ERRVAL__' => 'Table
\'openxpki.seq_application_log\' doesn\'t exist',
'__QUERY__' => 'INSERT INTO
seq_application_log (seq_number, dummy) VALUES (NULL, 0)'
}
}
]
};
I18N_OPENXPKI_SERVER_DBI_DBH_EXECUTE_FAILED
*application_log:*
Server Error Msg: $VAR1 = {
'SERVICE_MSG' => 'ERROR',
'LIST' => [
{
'LABEL' =>
'I18N_OPENXPKI_SERVER_DBI_DBH_EXECUTE_FAILED',
'PARAMS' => {
'__QUERY__' => 'insert into
application_log(application_log_id, logtimestamp, workflow_id, category,
priority, message) values (?, ?, ?, ?, ?, ?)',
'__ERRVAL__' => 'Table
\'openxpki.application_log\' doesn\'t exist',
'__ERRNO__' => '1146'
}
}
]
};
I18N_OPENXPKI_SERVER_DBI_DBH_EXECUTE_FAILED
These two tables were not in the database (MySQL -> openxpki), so I
manually created them by using part of the script in schema-mysql.sql:
CREATE TABLE IF NOT EXISTS `application_log` (
`application_log_id` bigint(20) unsigned NOT NULL,
`logtimestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP,
`workflow_id` decimal(49,0) NOT NULL,
`priority` int(3) DEFAULT 999,
`category` varchar(255) NOT NULL,
`message` longtext,
PRIMARY KEY (`application_log_id`),
KEY (`workflow_id`),
KEY (`workflow_id`,`priority`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `seq_application_log` (
`seq_number` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`dummy` int(11) DEFAULT NULL,
PRIMARY KEY (`seq_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
After creating the two tables, the DBI login error went away, but I
cannot still get into a standard login page, as the welcome page is BLANK.
To me. it looks like a fast-cgi error, but I'm not an expert and it's
just a guess. This is what I found in the apache logs:
[Wed Jun 08 22:27:22.892887 2016] [core:error] [pid 30983] [client
1.2.3.4:63614 <http://1.2.3.4:63614>] End of script output before
headers: webui.fcgi, referer: https://FQDN/
[Wed Jun 08 22:27:23.715084 2016] [fcgid:warn] [pid 30984]
(104)Connection reset by peer: [client 1.2.3.4:55975] mod_fcgid: error
reading data from FastCGI server, referer: https://FQDN/
I checked, in order:
- openxpkiadm version --> Version (core): 1.10.0
- openxpkictl status --> OpenXPKI Server is running and accepting requests.
- tried by restarting openxpki server AND apache2
- file permissions looks fine
- mod_fastcgi is ENABLED
- when I try to access https://FQDN/cgi-bin/webui.fcgi I get "500
INTERNAL SERVER ERROR"
As this is a test install, I could simply reinstall the whole package
from scratch, but I'd like to know if I made any error (hard to think,
as I just ran an apt-get upgrade on a functioning install and got here),
I mean, I'd like to understand what went wrong, in order to prevent this
to happen on a future production machine.
Your help will be highly appreciated, thanks!
Stefano
--
GnuPG KeyID: *F0574713*
GnuPG Key Fingerprint: *4F82 D852 C56E 5ED3 7958 9505 F3C1 CDBA F057 4713*
Minilock Id: *zRfzVg4SxnDn1xDx9a9vKPiCbzrwkgdzeHki2da9mJHBk*
------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are
consuming the most bandwidth. Provides multi-vendor support for NetFlow,
J-Flow, sFlow and other flows. Make informed decisions using capacity
planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
_______________________________________________
OpenXPKI-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openxpki-users
-- Protect your environment - close windows and adopt a penguin!
smime.p7s
Description: S/MIME Cryptographic Signature
------------------------------------------------------------------------------ What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic patterns at an interface-level. Reveals which users, apps, and protocols are consuming the most bandwidth. Provides multi-vendor support for NetFlow, J-Flow, sFlow and other flows. Make informed decisions using capacity planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
_______________________________________________ OpenXPKI-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openxpki-users
