Hello Stefan,
did you enable the SSL module (a2enmod ssl) ?
Oliver
On 18.04.24 14:00, Stefan Goeman wrote:
Hi
Yes, maybe that is possible.
Now, I just started from scratch again.
Meaning, I have de-installed all packages, config files and databases
and then started the installation again as described in the quickstart
guide.
I don't run into this problem now.
However, I run into another problem now.
I am using the sample/demo configuration by running the shell script
sampleconfig.sh
Then I run "openxpkictl start" and I get the response that the server
is running and accepting request.
Then, I try to use the web interface to login into the CA. But, this
does not work.
When I do netstat -tln, I don't see anything listening on port 443 or
any other port related to a webinterface.
Apache2 is running, I checked that as well.
So, I still suspect that something is not correctly configured.
Much thanks in advance for your help.
Greetings,
Stefan.
------------------------------------------------------------------------
*Van:* Oliver Welter <m...@oliwel.de>
*Verzonden:* woensdag 10 april 2024 18:06
*Aan:* openxpki-users@lists.sourceforge.net
<openxpki-users@lists.sourceforge.net>
*Onderwerp:* Re: [OpenXPKI-users] Installing mariadb schema
Hi Stefan,
might it be the cast that you ran this command twice (or used the
sample config script before?)
I just tried this here and do not get any warnings or errors and the
table is properly built:
mysql -e "create database oxitest"
cat /usr/share/doc/libopenxpki-perl/examples/schema-mariadb.sql |
mysql oxitest
mysql oxitest -e "describe aliases;"
+------------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+------------------+------+-----+---------+-------+
| identifier | varchar(64) | YES | | NULL | |
| pki_realm | varchar(255) | NO | PRI | NULL | |
| alias | varchar(255) | NO | PRI | NULL | |
| group_id | varchar(255) | YES | | NULL | |
| generation | smallint(6) | YES | | NULL | |
| notafter | int(10) unsigned | YES | | NULL | |
| notbefore | int(10) unsigned | YES | | NULL | |
+------------+------------------+------+-----+---------+-------+
Oli
On 08.04.24 17:50, Stefan Goeman wrote:
Hi
I am trying to install openxpki on Debian 12
When I run this command:
cat /usr/share/doc/libopenxpki-perl/examples/schema-mariadb.sql |\
mysql -u root --password --database openxpki
I get the following error message:
ERROR 1068 (42000) at line 201: Multiple primary key defined
I think I did everything correctly according to the quick start
guide. Did I overlooked something?
When I look into the schema file on line 201 and 202 I see this:
ALTER TABLE 'aliases'
ADD PRIMARY KEY (`pki_realm`,`alias`),
I see two things there for the primary key. Is this correct?
Much thanks in advance for your help!
Greetings,
Stefan.
_______________________________________________
OpenXPKI-users mailing list
OpenXPKI-users@lists.sourceforge.net
<mailto:OpenXPKI-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/openxpki-users
<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
--
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
