https://bugs.koozali.org/show_bug.cgi?id=12736

            Bug ID: 12736
           Summary: first build for sme11
    Classification: Contribs
           Product: SME Contribs
           Version: 11.0
          Hardware: ---
                OS: ---
            Status: CONFIRMED
          Severity: normal
          Priority: P3
         Component: smeserver-phpmyadmin
          Assignee: [email protected]
          Reporter: [email protected]
        QA Contact: [email protected]
  Target Milestone: ---

installed correctly
pulls phpMyAdmin-5.2.1-1.el8.remi.noarch


post event shows
Sep 13 12:11:06 rocky8 esmith::event[2742657]: Processing event: temp
Sep 13 12:11:06 rocky8 esmith::event[2742657]: Running event handler:
/etc/e-smith/events/actions/generic_template_expand
Sep 13 12:11:06 rocky8 esmith::event[2742657]: expanding
/etc/e-smith/sql/init/phpmyadmin
Sep 13 12:11:06 rocky8 esmith::event[2742657]: expanding
/etc/httpd/conf/httpd.conf
Sep 13 12:11:07 rocky8 esmith::event[2742657]: expanding
/etc/opt/remi/php74/php-fpm.d/www.conf
Sep 13 12:11:07 rocky8 esmith::event[2742657]: expanding
/etc/phpMyAdmin/config.inc.php
Sep 13 12:11:07 rocky8 esmith::event[2742657]:
generic_template_expand=action|Event|temp|Action|generic_template_expand|Start|1726243866
483142|End|1726243867 248985|Elapsed|0.765843
Sep 13 12:11:07 rocky8 esmith::event[2742657]: Running event handler:
/etc/e-smith/events/temp/S88systemd-default
Sep 13 12:11:09 rocky8 esmith::event[2742657]: Unit
/etc/systemd/system/systemd-timedated.service is masked, ignoring.
Sep 13 12:11:10 rocky8 esmith::event[2742657]:
S88systemd-default=action|Event|temp|Action|S88systemd-default|Start|1726243867
249446|End|1726243870 797851|Elapsed|3.548405
Sep 13 12:11:10 rocky8 esmith::event[2742657]: Running event handler:
/etc/e-smith/events/temp/S89systemd-reload
Sep 13 12:11:11 rocky8 esmith::event[2742657]:
S89systemd-reload=action|Event|temp|Action|S89systemd-reload|Start|1726243870
798352|End|1726243871 196345|Elapsed|0.397993
Sep 13 12:11:11 rocky8 esmith::event[2742657]: Running event handler:
/etc/e-smith/events/actions/adjust-services
Sep 13 12:11:11 rocky8 esmith::event[2742657]: adjusting non-supervised
httpd-e-smith (restart)
Sep 13 12:11:13 rocky8 esmith::event[2742657]: adjusting non-supervised
php72-php-fpm (restart)
Sep 13 12:11:13 rocky8 httpd[2742910]: Server configured, listening on: port
443, port 80
Sep 13 12:11:14 rocky8 esmith::event[2742657]: adjusting non-supervised
php73-php-fpm (restart)
Sep 13 12:11:15 rocky8 esmith::event[2742657]: adjusting non-supervised
php74-php-fpm (restart)
Sep 13 12:11:16 rocky8 esmith::event[2742657]: adjusting non-supervised
php80-php-fpm (restart)
Sep 13 12:11:17 rocky8 esmith::event[2742657]: adjusting non-supervised
php81-php-fpm (restart)
Sep 13 12:11:17 rocky8 esmith::event[2742657]: adjusting non-supervised
php82-php-fpm (restart)
Sep 13 12:11:18 rocky8 esmith::event[2742657]: adjusting non-supervised
php83-php-fpm (restart)
Sep 13 12:11:19 rocky8 esmith::event[2742657]: adjusting non-supervised
mysql.init (restart)
Sep 13 12:11:19 rocky8 esmith::event[2742657]: Job for mysql.init.service
failed because the control process exited with error code.
Sep 13 12:11:19 rocky8 esmith::event[2742657]: See "systemctl status
mysql.init.service" and "journalctl -xe" for details.
Sep 13 12:11:19 rocky8 esmith::event[2742657]: serviceControl: Couldn't system(
/usr/bin/systemctl restart mysql.init.service): No such file or directory
Sep 13 12:11:19 rocky8 esmith::event[2742657]:
adjust-services=action|Event|temp|Action|adjust-services|Start|1726243871
196966|End|1726243879 543749|Elapsed|8.346783


after loging in we see
mysqli::real_connect(): (HY000/1698): Access denied for user
'phpmyadmin'@'localhost'

La connexion au « controluser » telle que définie dans la configuration a
échoué.




during install 2 issues :
# Job for mysql.init.service failed because the control process exited with
error code.
# serviceControl: Couldn't system( /usr/bin/systemctl restart
mysql.init.service): No such file or directory



I would say 


REPLACE INTO user (  
                     host,
                     user,
                     password)
            VALUES ( 
                     'localhost',
                     'phpmyadmin',
                     PASSWORD ('j---'));

and  REPLACE INTO table ...
should be 

CREATE OR REPLACE USER '$user'\@'localhost' IDENTIFIED VIA
mysql_native_password USING PASSWORD ('$pass');

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER,
CREATE TEMPORARY TABLES, LOCK TABLES ON $db.* TO '$user'\@'localhost';

-- 
You are receiving this mail because:
You are the QA Contact for the bug.
You are the assignee for the bug.
_______________________________________________
Mail for each SME Contribs bug report
To unsubscribe, e-mail [email protected]
Searchable archive at https://lists.contribs.org/mailman/public/contribteam/

Reply via email to