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
--
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
