https://bugs.contribs.org/show_bug.cgi?id=10808

            Bug ID: 10808
           Summary: db init script to create user backupuser
    Classification: Contribs
           Product: SME Contribs
           Version: 9.2
          Hardware: ---
                OS: ---
            Status: CONFIRMED
          Severity: normal
          Priority: P3
         Component: smeserver-automysqlbackup
          Assignee: [email protected]
          Reporter: [email protected]
        QA Contact: [email protected]
  Target Milestone: ---

in the rpm spec we can find this:

%post
SMEDB=automysqlbackup
MYSQLUSER=backupuser
# Expland template
/etc/e-smith/events/actions/initialize-default-databases
/sbin/e-smith/expand-template /etc/cron.d/runmysqlbackup

echo "***********************************************************************"
echo "  "
echo "Creating backup user for default mysql53 database"
#create backupuser and give rights
MYSQLPASS=$(/sbin/e-smith/config getprop $SMEDB DbPassword)
mysql -e " GRANT EVENT,SELECT,LOCK TABLES ON *.* TO $MYSQLUSER@'localhost' "
mysql -u root -e "SET PASSWORD FOR $MYSQLUSER@localhost = PASSWORD(
'$MYSQLPASS' ) "
mysqladmin flush-privileges
/etc/rc.d/init.d/mysql.init start
echo "done"
echo "*** If you add mysql55/mysql57 you must add a backup user ***"
echo "You can use the password from config show automysqlbackup"
echo "e.g.: "
echo "mysql55 -e \" GRANT EVENT,SELECT,LOCK TABLES ON *.* TO
$MYSQLUSER@\'localhost\' \" "
echo "mysql55 -u root -e \"SET PASSWORD FOR $MYSQLUSER@localhost = PASSWORD(
\'$MYSQLPASS\' ) \" "
echo "  "
echo "***********************************************************************"



this should not be there and a fragment to create a migrate script foreach db
should be provided
further more this hack laucnh one more time the
actions/initialize-default-databases which is triggered later by yum

and finally post should not expand-templates

-- 
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/

Reply via email to