Hi Stefano,I am sorry for this - long story short, we added a new feature that requires a new SQL table but I was pretty sure it wont hurt as long is it not activated.
So question: Did you update only the code or did you also update the Config?
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
