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