Skip to Content.
Sympa Menu

en - Re: [sympa-users] 6.2.64 Sympa.pl --health_check does not create data base structure

Subject: The mailing list for listmasters using Sympa

List archive

Chronological Thread  
  • From: Phil Stracchino <address@concealed>
  • To: address@concealed
  • Subject: Re: [sympa-users] 6.2.64 Sympa.pl --health_check does not create data base structure
  • Date: Mon, 23 Aug 2021 20:09:08 -0400

On 8/23/21 4:45 PM, Edd Ramer wrote:
> ########################################################################
> # 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         (hidden from you)
> #db_env
>
> Mysql results for sympa user:
> mysql -u sympa -p
> Enter password:
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 11
> Server version: 8.0.26 MySQL Community Server - GPL
>
> Copyright (c) 2000, 2021, Oracle and/or its affiliates.
>
> Oracle is a registered trademark of Oracle Corporation and/or its
> affiliates. Other names may be trademarks of their respective
> owners.
>
> Type 'help;' or '\h' for help. Type '\c' to clear the current input
> statement.
>
> mysql> show databases;
> +--------------------+
> | Database           |
> +--------------------+
> | information_schema |
> | sympa              |
> +--------------------+
> 2 rows in set (0.01 sec)
>
>
> Thanks,
> Edd


Edd,
It appears you already created the 'sympa' database and user. What
PERMISSIONS did you grant to the sympa user? It should have full rights
(ALL PRIVILEGES ON sympa.*). Don't forget to execute a FLUSH PRIVILEGES
after you grant the permissions.


--
Phil Stracchino
Babylon Communications
address@concealed
address@concealed
Landline: +1.603.293.8485
Mobile: +1.603.998.6958



Archive powered by MHonArc 2.6.19+.

Top of Page