owaspsamm / dashboard-webapp

21 stars 8 forks source link

Samm app is not creating initial database properly #11

Open Pat-Duarte opened 2 years ago

Pat-Duarte commented 2 years ago

We have reports that the app initial mysql import has some problems.

My tests with mariadb 10 reported me this:

❯ wget https://raw.githubusercontent.com/OWASP/samm/master/Supporting%20Resources/app/samm.sql
--2021-03-31 10:53:22--  https://raw.githubusercontent.com/OWASP/samm/master/Supporting%20Resources/app/samm.sql
Resolving raw.githubusercontent.com (raw.githubusercontent.com)... 185.199.108.133, 185.199.111.133, 185.199.110.133, ...
Connecting to raw.githubusercontent.com (raw.githubusercontent.com)|185.199.108.133|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 118243 (115K) [text/plain]
Saving to: ‘samm.sql’
samm.sql                                100%[==============================================================================>] 115.47K  --.-KB/s    in 0.07s   
2021-03-31 10:53:23 (1.62 MB/s) - ‘samm.sql’ saved [118243/118243]
❯ mysqladmin -uroot create samm
❯ mysql -uroot samm < samm.sql
ERROR 1005 (HY000) at line 1248: Can't create table `samm`.`user_roles` (errno: 150 "Foreign key constraint is incorrectly formed")

History from old repo: @fzipi created this issue on Mar 31, 2021