The mailing list for listmasters using Sympa

[TK CHEN <address@concealed>]

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

On Fri, Nov 6, 2020 at 12:33 PM Stefan Hornburg (Racke) <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> --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>
> ########################################################################
>
> 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.

Regards
         Racke

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