[Devel] [ openser-Bugs-1380823 ] openser_mysql.sh requires root password

[SourceForge.net]

Bugs item #1380823, was opened at 2005-12-14 21:06
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=743020&aid=1380823&group_id=139143

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: tools
Group: ver devel
Status: Open
Resolution: None
Priority: 5
Submitted By: Norman Brandinger (goestelecom)
Assigned to: Nobody/Anonymous (nobody)
Summary: openser_mysql.sh requires root password

Initial Comment:
openser_mysql.sh requires the user to physically enter
a MySQL root password regardless of the setting of the
exported PW variable in the code below:

export PW
if [ "$#" -ne 0 ]; then
  prompt_pw
fi

The "$#" value is the number of parameters passed to
openser_mysql.sh and has nothing to do with the success
or failure of the previous "export PW" statement.

I suggest replacing the conditional with

if [ $PW = "" ]; then

The above fix will bypass the password prompt if the
variable PW is set to a non null value.

This error makes it impossible to successfully issue
the command:

openser_mysql.sh backup > todays.backup


Additional Comments:

A review of openser_mysql.sh shows that MySQL root
permissions are used for most operations, even those
that do not require such high permissions.

The backup command really only requires read-only (and
on my system table_lock) permissions.

A review of this script probably should be placed on
the "roadmap".

Regards,
Norm

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=743020&aid=1380823&group_id=139143