The mailing list for listmasters using Sympa

["Stefan Hornburg (Racke)" <address@concealed>]

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.

Attachment: OpenPGP_0x5B93015BFA2720F8.asc
Description: application/pgp-keys

Attachment: OpenPGP_signature
Description: OpenPGP digital signature