The mailing list for listmasters using Sympa

[Steven Jones <address@concealed>]

Hi,

I am a bit stumped following the RHEL7 guide at trying to make a database to test installing sympa.

mysql 8 version,

=====

vuwunicomysqlt4 ~]$ rpm -q mysql-server

mysql-server-8.0.17-3.module+el8.0.0+3898+e09bb8de.x86_64

=====

Error message,

=====

[root@vuwunicomailmd2 sympa]#  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

[root@vuwunicomailmd2 sympa]#

=====

I can log in fine directly so password and permissions are OK,

=====

[root@vuwunicomailmd2 sympa]# mysql -u svc_db_sympa -h vuwunicomysqlt4.ods.vuw.ac.nz -p

Enter password:

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MySQL connection id is 30

Server version: 8.0.17 Source distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MySQL [(none)]> use sympa;

Database changed

MySQL [sympa]> show tables;

Empty set (0.01 sec)

MySQL [sympa]> quit;

Bye

[root@vuwunicomailmd2 sympa]#

=====

sympa.conf

=====

#db_type             (You must define this parameter)

db_type             MySQL

db_name             sympa

#db_host

db_host vuwunicomysqlt4.ods.vuw.ac.nz

#db_host 10.101.136.10

#db_port

#db_user             user_name

db_user             svc_db_sympa

#db_passwd           (secret)

db_passwd           xxxxxxxxx!

#db_env

=====

So I am stumped.  There is no database structure, can I build it manually of all else fails?  if so what are the commands please?

regards

Steven Jones