Subject: The mailing list for listmasters using Sympa
List archive
[sympa-users] 6.2.64 Sympa.pl --health_check does not create data base structure
- From: Edd Ramer <address@concealed>
- To: address@concealed
- Subject: [sympa-users] 6.2.64 Sympa.pl --health_check does not create data base structure
- Date: Mon, 23 Aug 2021 14:45:08 -0600
All help appreciated. Thank you.
I have successfully installed sympa 6.2.64 from package on Oracle Linux 7.9. I am going through the configuration process and when instructed to run sympa.pl --health_check to create the database structure if fails. Below are the results of the actual command, the sympa.conf database section and mysql showing the sympa user can log in and see the sympa database.
Command output: 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.
Database sympa defined in sympa.conf has not the right structure or is unreachable. Verify db_xxx parameters in sympa.conf.
Sympa.conf database section:
########################################################################
# Setup database
# See 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
# Setup database
# See 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)
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
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
-
[sympa-users] 6.2.64 Sympa.pl --health_check does not create data base structure,
Edd Ramer, 08/23/2021
-
Re: [sympa-users] 6.2.64 Sympa.pl --health_check does not create data base structure,
Phil Stracchino, 08/24/2021
- Re: [sympa-users] 6.2.64 Sympa.pl --health_check does not create data base structure, Edd Ramer, 08/24/2021
-
Re: [sympa-users] 6.2.64 Sympa.pl --health_check does not create data base structure,
Phil Stracchino, 08/24/2021
Archive powered by MHonArc 2.6.19+.