The mailing list for listmasters using Sympa

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

On 2/18/20 3:05 AM, Steven Jones wrote:
> 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,

Hello Steven,

please check if your sympa logs contain more information than that 
boilerplate error.

Also, even if you can login with the same credentials it doesn't mean that 
you are allowed
to create tables.

Regards
        Racke

> 
> =====
> [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
> 
> 


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

Attachment: signature.asc
Description: OpenPGP digital signature