First Good Result

Hi all!

We found a strange problem in MySQL

  • Create MYSQL database
    mysql: [Warning] Using a password on the command line interface can be insecure.
    • Found MYSQL server version 5.7.27-0ubuntu0.18.04.1
    • Drop database seiscomp3
      mysql: [Warning] Using a password on the command line interface can be insecure.
    • Create database seiscomp3
      mysql: [Warning] Using a password on the command line interface can be insecure.
    • Setup user roles
      mysql: [Warning] Using a password on the command line interface can be insecure.
      ERROR 1819 (HY000) at line 1: Your password does not satisfy the current policy requirements
    • Failed to setup database
      error: module ‘scmaster’ failed to setup
  • setup trunk

and it was successfully solved ! What we have now:

seiscomp3/bin/seiscomp enable seedlink scautopick scautoloc scamp scmag scevent
enabled seedlink
enabled scautopick
enabled scautoloc
enabled scamp
enabled scmag
enabled scevent
sysop@lyudmila-Lenovo-ideapad-100-15IBY:~$ seiscomp3/bin/seiscomp start
starting spread
starting scmaster
starting scamp
starting scautoloc
starting scautopick
starting scevent
starting scmag
starting seedlink
maximum number of open files set to 1048576
We hope, many new stations will be connected with SC3.

I_love_seiscomp3

Hi
Its due to validate_password plugin activated during your MySQL installation. Your password is much simple to validate MySQL norms. So you need to uninstall this plugin or set a stronger password for MySQL containing numbers, uppercase and special characters (e.g. @&$) and reinstall SC3.
To uninstall this plugin and set a new password login into MySQL and:
mysql > uninstall plugin validate_password;
then the following may solve your problem (considering root as your mysql user):
mysql > ‫‪ALTER‬‬ ‫‪USER‬‬ ‫’‪’root’@'localhost‬‬ ‫‪IDENTIFIED‬‬ ‫‪WITH‬‬ ‫‪mysql_native_password‬‬ ‫‪BY‬‬ ‫;'‪’your_password‬‬
mysql > FLUSH PRIVILEGES;
mysql > EXIT;