Installation Experience (Mysql Installation Error ! #1171 - All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead)

Install / Update Setup
1

Hi,
After some series of struggle with the conventions and package versions, I was finally able to complete the setup.

Meanwhile, I felt putting forward some immediate concerns as discussion with everyone.

  • Password Validation control
    case : our mysql installation wasn’t allowing MEDIUM strength validation. I had to alter the whole server configuration to pass through the installation.
    suggestion: a variable to allow password generator to generate random passwords with the required strength value

  • collation
    case : our server had a different connection collation / charset
    suggestion: allowing to pass the connection collation during the setup

  • Mysql Installation Error !! #1171 - All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
    case : mysql version 5.7+ doesn’t allow NULL values for primary keys
    I had to update the SQL line 174 to pass through.

2

Were you able to resolve this issue?

3

Hi,

Can you please tell the location and name of the file for line 174 for MySQL issue?

Thanks!

4