The mailing list for listmasters using Sympa

[Edd Ramer <address@concealed>]

Phil,

Before executing any of these commands I created the sympa database and did the Grant command to grant all privileges on the database sympa for the user sympa@localhost.  I had not done the "Flush Permissions" command.  This has not helped.  I get the same error.

Thanks,

Edd

You can reach me at:

Phone: 801-626-7843

Email: address@concealed

Address:

Residence Hall 3, RM 128

1375 Village Loop Rd, Dept. 2405

Ogden, UT 84408-2405

On Mon, Aug 23, 2021 at 6:09 PM Phil Stracchino <address@concealed> wrote:

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