The mailing list for listmasters using Sympa

[TK CHEN <address@concealed>]

Sure, I will do it. One more note, I have to create my sympa user with "mysql_native_password" option to let the upgrade runs, otherwise I get this error: 

err main::#271 > main::_load#1144 > Sympa::DatabaseManager::instance#54 > Sympa::DatabaseDriver::MySQL::connect#58 > Sympa::Database::connect#157 Can't connect to Database Sympa::DatabaseDriver::MySQL <db_host=localhost;db_name=sympa;db_user=sympa>: Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory

-TK

On Fri, Nov 6, 2020 at 1:01 PM Stefan Hornburg (Racke) <address@concealed> wrote:

On 11/6/20 9:55 PM, TK CHEN wrote:
> The patch seems to fix the problem. I was able to create sympa database schema in MySQL 8 now. 
>
> Thank you for the suggestion!
>
> TK

You are welcome. If you don't mind please leave a note on https://github.com/sympa-community/sympa/issues/1028 that
this patch works for you.

Thanks
         Racke

>
>
> On Fri, Nov 6, 2020 at 12:33 PM Stefan Hornburg (Racke) <address@concealed <mailto:address@concealed>> wrote:
>
>     On 11/6/20 9:07 PM, TK CHEN wrote:
>     > Is there anyone using MySQL version 8 for Sympa? I am not able to create the database schema for sympa server. 
>     >
>     > $sudo sympa.pl <http://sympa.pl> <http://sympa.pl <http://sympa.pl>> --health_check
>     > Database sympa defined in sympa.conf has not the right structure or is unreachable. Verify db_xxx parameters in
>     sympa.conf
>     >
>     >
>     > Here is my sympa.conf:
>     > ########################################################################
>     > # Setup database
>     > # See https://sympa-community.github.io/manual/install/setup-database.html
>     <https://sympa-community.github.io/manual/install/setup-database.html>
>     > <https://sympa-community.github.io/manual/install/setup-database.html
>     <https://sympa-community.github.io/manual/install/setup-database.html>>
>     > ########################################################################
>     >
>     > db_type             MySQL
>     > db_name             sympa
>     > db_host             localhost
>     > #db_port
>     > db_user             sympa
>     > db_passwd           (------)
>     > #db_env
>     >
>     > I have the MySQL user (sympa) and password listed in sympa.conf, and the sympa user is able to create tables
>     within the
>     > sympa database. Any suggestions on how to fix this?
>     >
>     > Thank you!
>     >
>     > TK
>
>     Please try the patch from https://github.com/sympa-community/sympa/issues/1028
>     <https://github.com/sympa-community/sympa/issues/1028>.
>
>     Regards
>              Racke
>
>     --
>     Ecommerce and Linux consulting + Perl and web application programming.
>     Debian and Sympa administration. Provisioning with Ansible.
>


--
Ecommerce and Linux consulting + Perl and web application programming.
Debian and Sympa administration. Provisioning with Ansible.