Snipe-IT: Fresh install on Kubernetes (AKS) leeds to HTTP 500

[davidseidel]

Hi,

i have tried to install the Version 3.3.0 of the Helm-Chart on Kubernetes, but it leeds to a HTTP 500 when I try to run the Setup. I'm able to open the Pre-Flight-Check and it tells me, that everything is fine, but when I try to run the next step, it result in this:

Module ssl disabled. To activate the new configuration, you need to run: service apache2 restart Migrating: 2015_02_26_091228_add_accessories_user_table

Illuminate\Database\QueryException : SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'accessories_users' already exists (SQL: create table accessories_users (id int unsigned not null auto_increment primary key, user_id int null, accessory_id int null, assigned_to int null, created_at timestamp null, updated_at timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)

at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:669 665| // If an exception occurs when attempting to run a query, we'll format the error 666| // message to include the bindings with SQL, which will make this exception a 667| // lot more helpful to the developer instead of just the database's errors. 668| catch (Exception $e) {

669| throw new QueryException( 670| $query, $this->prepareBindings($bindings), $e 671| ); 672| } 673|

Exception trace:

1 Doctrine\DBAL\Driver\PDO\Exception::("SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'accessories_users' already exists") /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18

2 Doctrine\DBAL\Driver\PDO\Exception::new() /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:114

Please use the argument -v to see more details. Configuration cache cleared! Configuration cache cleared! Configuration cached successfully!

Environment:

• Azure AKS
• Azure MySQL-Flexible (also tested with no external Database)

Any ideas what is wrong here?

Cheers, David

[davidseidel]

I have checked the logs files before opening the Browser-Page and it looks like the migration triggered by the docker file results in an error:

---

Migrating: 2015_07_31_015430_add_accepted_to_assets Module ssl disabled. To activate the new configuration, you need to run: service apache2 restart Migrating: 2015_09_22_003413_migrate_mac_address

Exception : couldn't save customfieldset

at /var/www/html/database/migrations/2015_09_22_003413_migrate_mac_address.php:20 16| 17| $f2=new \App\Models\CustomFieldset(['name' => "Asset with MAC Address"]); 18| $f2->timestamps=false; //when this model was first created, it had no timestamps. But later on it gets them. 19| if(!$f2->save()) {

20| throw new Exception("couldn't save customfieldset"); 21| } 22| $macid=DB::table('custom_fields')->insertGetId([ 23| 'name' => "MAC Address", 24| 'format' => \App\Models\CustomField::PREDEFINED_FORMATS['MAC'],

Exception trace:

1 MigrateMacAddress::up() /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:392

2 Illuminate\Database\Migrations\Migrator::Illuminate\Database\Migrations{closure}() /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:401

Please use the argument -v to see more details. Configuration cache cleared! Configuration cache cleared! Configuration cached successfully!

[davidseidel]

The problem is a database issue. After switching to mysql 8.0 everthing is working fine.