https://bugs.koozali.org/show_bug.cgi?id=13233
bunkobugsy <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |IN_PROGRESS
Resolution|FIXED |---
--- Comment #5 from bunkobugsy <[email protected]> ---
# mariadb -e "SELECT User,Host FROM mysql.user" | grep mailstats
mailstats_rw localhost
# mariadb -e "drop user mailstats_rw@localhost"
# mariadb -e "SELECT User,Host FROM mysql.user" | grep mailstats
# mariadb -e "show databases" | grep mailstats
mailstats
# mariadb -e "drop database mailstats"
# mariadb -e "show databases" | grep mailstats
# config show mailstats
mailstats=report
DBPass=x+ZpK-Eq5QMQxON=
status=enabled
# config delete mailstats
# config show mailstats
# rm -f /etc/e-smith/sql/init/99smeserver-mailstats.sql
# rm -f /etc/e-smith/templates/etc/e-smith/sql/init/99smeserver-mailstats.sql
dnf install
http://koji.koozali.org/kojifiles/packages/smeserver-mailstats/11.1/14.el8.sme/noarch/smeserver-mailstats-11.1-14.el8.sme.noarch.rpm
Upgraded:
smeserver-mailstats-11.1-14.el8.sme.noarch
esmith::event[240696]: Running event handler:
/etc/e-smith/events/actions/adjust-services
esmith::event[240696]: adjusting non-supervised httpd-e-smith (restart)
esmith::event[240696]: adjusting non-supervised mysql.init (restart)
httpd[240989]: Server configured, listening on: port 443, port 80
su[241034]: (to www) root on none
esmith::event[240696]: Job for mysql.init.service failed because the control
process exited with error code.
esmith::event[240696]: See "systemctl status mysql.init.service" and
"journalctl -xe" for details.
esmith::event[240696]: serviceControl: Couldn't system( /usr/bin/systemctl
restart mysql.init.service): No such file or directory
mysql.init[241024]: ERROR 1064 (42000) at line 9: You have an error in your SQL
syntax; check the manual that corresponds to your MariaDB server version for
the right syntax to use near '{mailstats_rw} IDENTIFIED BY
'{%yNleCQneIU13EUP}'' at line 1
# grep { /etc/e-smith/sql/init/99mailstats
CREATE USER {mailstats_rw} IDENTIFIED BY '{%yNleCQneIU13EUP}';
GRANT SELECT, INSERT, UPDATE, DELETE ON mailstats.* TO {mailstats_rw};
--
You are receiving this mail because:
You are the QA Contact 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/
