Question: Which MySQL versions are compatible for use as back-end? I experience proble

I have the same problem. from the logs: <div class="snippet-clipboard-content

<div class="snippet-clipboard-content notranslate position-relative overflow-auto" data-snippet-clip

MySQL foreign key constraints about sshportal HOT 3 OPEN

fbarmentlo commented on September 22, 2024

MySQL foreign key constraints

from sshportal.

Comments (3)

firecyberice commented on September 22, 2024

I have the same problem.
from the logs:

error: Error 1451: Cannot delete or update a parent row: a foreign key constraint fails (`sshportal`.`host_group_acls`, 
CONSTRAINT `fk_host_group_acls_acl` FOREIGN KEY (`acl_id`) REFERENCES `acls` (`id`))

And while importing a backup I got this:

Error 1452: Cannot add or update a child row: a foreign key constraint fails (`sshportal`.`events`, 
CONSTRAINT `fk_events_author` FOREIGN KEY (`author_id`) REFERENCES `users` (`id`))

I have used docker.io/moul/sshportal:1.19.3 and mariadb:latest
It seems like there is no problem with the docker.io/moul/sshportal:1.18.5 image.

from sshportal.

fdabe commented on September 22, 2024

Error 1452: Cannot add or update a child row: a foreign key constraint fails (`sshportal`.`events`, 
CONSTRAINT `fk_events_author` FOREIGN KEY (`author_id`) REFERENCES `users` (`id`))

it arrive because user system does not exist in table users with id "0".
So when you start server it test to update user 0 as author_id but user id not present.

I create user with id 0 and no worries after.
Hope is the good solution and help :)

from sshportal.

yumitsu commented on September 22, 2024

Same problem with latest github version when using MySQL.
When trying to add new host:

Error 1452: Cannot add or update a child row: a foreign key constraint fails (`db`.`hosts`, CONSTRAINT `fk_hosts_hop` FOREIGN KEY (`hop_id`) REFERENCES `hosts` (`id`))

After inserting a new row with ID = 0 new hosts can be added, but when trying to delete one:

Error 1451: Cannot delete or update a parent row: a foreign key constraint fails (`db`.`host_host_groups`, CONSTRAINT `fk_host_host_groups_host` FOREIGN KEY (`host_id`) REFERENCES `hosts` (`id`))

from sshportal.

Recommend Projects