Saw this popup,
Had a similar problem with an external database configuration.
I addressed it in a heavily modified script that I beefed up from from the demo
script.
https://github.com/jogalt/openxpki-setup-script/blob/main/OpenXPKI_Installer_v23.09.05.003.sh
look for the sed statement around line ~995
Sent from [Proton Mail](https://proton.me/mail/home) for iOS
On Mon, Apr 8, 2024 at 11:50, Stefan Goeman
<[[email protected]](mailto:On Mon, Apr 8, 2024 at 11:50, Stefan Goeman
<<a href=)> 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
[email protected]
https://lists.sourceforge.net/lists/listinfo/openxpki-users
