The mailing list for listmasters using Sympa

[Steven Jones <address@concealed>]

Hi,

Is sympa compatible with mysql 8.0?  some apps are not.    Which password hash should I be using?  I am using the native mysql at the moment.

I can create tables OK.

MySQL [sympa]> show databases;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| sympa              |

+--------------------+

2 rows in set (0.00 sec)

MySQL [sympa]>

MySQL [sympa]> CREATE TABLE testssj (name VARCHAR(20), owner VARCHAR(20));

Query OK, 0 rows affected (0.06 sec)

MySQL [sympa]> show tables;

+-----------------+

| Tables_in_sympa |

+-----------------+

| testssj         |

+-----------------+

1 row in set (0.00 sec)

MySQL [sympa]>

=========

sympa log is zero length,

-rw-r-----. 1 root   root             0 Feb 18 11:37 sympa.log

=========

RHEL7 uses rsyslog not syslog so this might be the issue.

regards

Steven

Wellington, NZ

---

From: address@concealed on behalf of Stefan Hornburg (Racke)
Sent: Tuesday, February 18, 2020 7:03 PM
To: address@concealed
Subject: Re: [sympa-users] Stumped on unable to make a database on mysql 8

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.