Hi, first thanks to Peter Mann for the needed perl-libs. (http://sourceforge.net/mailarchive/forum.php?thread_name=20080112164116.GA24139%40pm1.uvt.tuke.sk&forum_name=openxpki-users)
since revision 1206 there are some Perl-Libs added. But i have some questions: - Are my test results OK? Failed Test Stat Wstat Total Fail Failed List of Failed ------------------------------------------------------------------------------- t/20_xml/8_xinclude_relative_dir. 255 65280 6 12 200.00% 1-6 t/60_workflow/15_csr_and_certific 255 65280 24 8 33.33% 19-20 22-24 t/60_workflow/20_certificate_revo 17 4352 23 17 73.91% 5 7-17 19-23 t/60_workflow/40_certificate_revo 10 2 20.00% 8-9 (104 subtests UNEXPECTEDLY SUCCEEDED), 20 tests and 39 subtests skipped. Failed 4/115 test scripts, 96.52% okay. 30/2196 subtests failed, 98.63% okay. make: *** [test_dynamic] Fehler 255 - If I initialize a SQLight DB everithing works fine, but if I write the schema into an MySQL DB I get following error: I think its a Problem with MySQL v5 openXpki:/# openxpkiadm initdb Database type: MySQL Setting up database 'log' ERROR: init_schema on 'log' failed (I18N_OPENXPKI_SERVER_DBI_DBH_PREPARE_FAILED; __ERRNO__ => 1; __ERRVAL__ => table workflow_context already exists(1) at dbdimp.c line 271; __QUERY__ => create table workflow_context (workflow_id NUMERIC(49,0) NOT NULL, workflow_context_key TEXT NOT NULL, workflow_context_value TEXT, PRIMARY KEY (workflow_id, workflow_context_key)) ) Could not initialize database. openXpki:/# mysql -u openxpki -p openxpki Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 15 Server version: 5.0.32-Debian_7etch5-log Debian etch distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> create table workflow_context (workflow_id NUMERIC(49,0) NOT NULL, workflow_context_key TEXT NOT NULL, workflow_context_value TEXT, PRIMARY KEY (workflow_id, workflow_context_key)); ERROR 1170 (42000): BLOB/TEXT column 'workflow_context_key' used in key specification without a key length - if I use the WEBinterface, sometimes apache do not map the language. /etc/apache/conf.d/openxpki-mason-mod_perl.conf: "SetEnv OPENXPKI_LOCALE_PREFIX /usr/share/locale/" I attached my notes of the installation. Perhaps I can help anybody? Thank you in advance jochen #################################################### #################################################### # I started with a clean debian etch system. switched the src repos and # installed all the needed stuff. # in Sourclisten etch durch lenny ersetzen: # deb-src http://ftp.sk.debian.org/debian/ lenny main # deb-src http://security.debian.org lenny/updates main vi /etc/apt/sources.list aptitude update aptitude upgrade apt-get install perl-modules openssl libssl-dev build-essential dh-make-perl unzip lynx ftp gnupg less ncftp bzip2 subversion mysql-server perl-doc debconf-utils apache apache-ssl apache-perl apt-get install liblog-log4perl-perl libcgi-session-perl libdbi-perl libtimedate-perl libdatetime-perl libdigest-sha1-perl libipc-sharelite-perl libmail-rfc822-address-perl libnet-ip-perl libnet-server-perl libnet-ldap-server-perl libtest-pod-perl libtest-pod-coverage-perl libtest-exception-perl libxml-sax-perl libxml-sax-writer-perl libxml-parser-perl libxml-simple-perl libversion-perl libtext-csv-perl libtree-dagnode-perl libclass-factory-perl libdatetime-format-strptime-perl libtest-exception-perl libio-prompt-perl libdata-page-perl libmath-round-perl libcache-cache-perl libclass-container-perl libhtml-mason-perl libtest-www-mechanize-perl libapache-mod-perl libio-socket-ssl-perl libapache-request-perl libtest-simple-perl libnetaddr-ip-perl libclass-dbi-sqlite-perl libclass-dbi-mysql-perl libintl-perl apt-get build-dep libclass-std-perl apt-get -b source libclass-std-perl dpkg -i libclass-std-perl_0.0.9-2_all.deb apt-get build-dep libconfig-std-perl apt-get -b source libconfig-std-perl dpkg -i libconfig-std-perl_0.0.4-3_all.deb apt-get build-dep libtemplate-perl apt-get -b source libtemplate-perl dpkg -i libtemplate-perl_2.19-1_i386.deb apt-get build-dep libexception-class-perl apt-get -b source libexception-class-perl dpkg -i libexception-class-perl_1.24-1_all.deb apt-get -y build-dep libhook-lexwrap-perl apt-get -t testing -b source libhook-lexwrap-perl dpkg -i libhook-lexwrap-perl_0.20-2_all.deb \end{lstlisting} dh-make-perl --build --cpan Devel::StackTrace dpkg -i libdevel-stacktrace-perl_1.1901-1_all.deb dh-make-perl --build --cpan Data::Password dpkg -i libdata-password-perl_1.07-1_all.deb dh-make-perl --build --cpan Locale::TextDomain dpkg -i libintl-perl_1.16-1_i386.deb dh-make-perl --build --cpan Proc::ProcessTable dpkg -i libproc-processtable-perl_0.42-1_i386.deb dh-make-perl --build --cpan Sys::SigAction dpkg -i libsys-sigaction-perl_0.10-1_all.deb dh-make-perl --build --cpan Class::Observable dpkg -i libclass-observable-perl_1.04-1_all.deb dh-make-perl --build --cpan DBD::Mock dpkg -i libdbd-mock-perl_1.37-1_all.deb dh-make-perl --build --cpan Workflow dpkg -i libworkflow-perl_0.31-1_all.deb dh-make-perl --build --cpan XML::Filter::XInclude dpkg -i libxml-filter-xinclude-perl_1.0-1_all.deb dh-make-perl --build --cpan XML::Validator::Schema dpkg -i libxml-validator-schema-perl_1.10-1_all.deb dh-make-perl --build --cpan Data::Serializer dpkg -i libdata-serializer-perl_0.46-1_all.deb dh-make-perl --build --cpan DateTime::Format::DateParse dpkg -i libdatetime-format-dateparse-perl_0.04-1_all.deb dh-make-perl --build --cpan Regexp::Common dpkg -i libregexp-common-perl_2.122-1_all.deb dh-make-perl --build --cpan Data::SpreadPagination dpkg -i libdata-spreadpagination-perl_0.1.2-1_all.deb dh-make-perl --build --cpan HTTP::Server::Simple::Mason dpkg -i libhttp-server-simple-mason-perl_0.09-1_all.deb dh-make-perl --build --cpan Test::HTTP::Server::Simple dpkg -i libtest-http-server-simple-perl_0.09-1_all.deb ########################### # checkout the source cd /usr/src/ svn co https://openxpki.svn.sourceforge.net/svnroot/openxpki svn-openxpki # Kernmodule von OpenXPKI cd /usr/src/svn-openxpki/trunk/perl-modules/core/trunk perl Makefile.PL make make install # Clientmodule von OpenXPKI cd ../../../clients/perl/OpenXPKI-Client perl Makefile.PL make make install # Sprachdateien von OpenXPKI cd i18n/ make scan make make install # Webfrontend von OpenXPKI cd ../OpenXPKI-Client-HTML-Mason/ perl Makefile.PL make make install # SCEP Client von OpenXPKI cd ../OpenXPKI-Client-SCEP/ perl Makefile.PL make make install # Deployment-Tools für OpenXPKI cd ../deployment/ ./configure make make install adduser --system --group openxpki mysqladmin --user=root password freiheit # MySQL Datenbank anlegen mysqladmin -u root -p create openxpki Enter password: freiheit # MySQL User anlegen mysql -u root -p Enter password: freiheit mysql> CREATE USER 'openxpki'@'localhost' IDENTIFIED BY 'openxpki'; mysql> CREATE DATABASE IF NOT EXISTS `openxpki` ; mysql> GRANT ALL PRIVILEGES ON `openxpki` . * TO 'openxpki'@'localhost'; mysql> FLUSH PRIVILEGES; mysql> quit # MySQL testen mysql -u openxpki -p openxpki Enter password: openxpki mysql> quit openxpkiadm deploy --template quickstart # XML Konfigurationsdateien erzeugen und konfigurieren openxpki-configure --createdirs #... #auth.xml... *** NOTE: Password for user <John Doe> is: nyfDiQm9 #*** NOTE: Password for user <root> is: LikEY2+8 #*** NOTE: Password for user <raop> is: Fut/gBTZ #... #* Checking directories #openxpkistatedir: /usr/var/openxpki: CREATED #openxpkisessiondir: /usr/var/openxpki/session: CREATED #dataexchange: /usr/var/openxpki/dataexchange: CREATED #tmpdir: /usr/var/tmp: CREATED # #OpenXPKI instance configured successfully. # OpenXPKI Schema in Datenbank schreiben openxpkiadm initdb # OpenXpki testen openxpkictl start openxpkictl stop #webfrontend cd /usr/src/svn-openxpki/trunk/clients/perl/OpenXPKI-Client-HTML-Mason/ cp -r htdocs /var/www/openxpki cp -av eg/openxpki-mason-mod_perl.conf /etc/apache/conf.d/ echo "LoadModule env_module /usr/lib/apache/1.3/mod_env.so" >> /etc/apache/modules.conf # mason apache config bearbeiten vi /etc/apache/conf.d/openxpki-mason-mod_perl.conf addgroup www-data openxpki mkdir /usr/var/openxpki/mason_sessions chown -R openxpki:openxpki /usr/var/openxpki/ /etc/init.d/apache restart openxpkictl start #################################################### #################################################### ------------------------------------------------------------------------- Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite open source project, along with a healthy diet, reduces your potential for chronic lameness and boredom. Vote Now at http://www.sourceforge.net/community/cca08 _______________________________________________ OpenXPKI-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openxpki-users
