Bug 902456

Summary: mysql-proxy Init script is incorrect, so service doesn't start
Product: [Fedora] Fedora EPEL Reporter: john.r.moser
Component: mysql-proxyAssignee: Dominic Hopf <dmaphy>
Status: CLOSED ERRATA QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: high Docs Contact:
Priority: unspecified    
Version: el6CC: dheche, dmaphy, john.r.moser, sales
Target Milestone: ---   
Target Release: ---   
Hardware: x86_64   
OS: Linux   
Whiteboard:
Fixed In Version: mysql-proxy-0.8.4-1.el6 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2014-07-12 19:45:24 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
delete /etc/sysconfig/mysql-proxy content
none
initscript to use defaults-file option
none
mysql-proxy.cnf none

Description john.r.moser 2013-01-21 17:43:23 UTC
Description of problem:
The mysql-proxy version in EPEL doesn't use --admin-username and such.


Version-Release number of selected component (if applicable):
0.8.2-1.el6

How reproducible:
Always.

Steps to Reproduce:
1. Install mysql-proxy
2. Start it
3. dmesg|tail
  
Actual results:
Won't start, even if configured correctly

Expected results:
Should start

Additional info:
Remove ADMIN_USER, ADMIN_PASS, ADMIN_LUA_SCRIPT from /etc/sysconfig/mysql-proxy

Change the init script to contain:

start() {
    echo -n $"Starting $prog: "
    daemon $prog $PROXY_OPTIONS --pid-file=$PROXY_PID --user=$PROXY_USER
    RETVAL=$?
    echo
    if [ $RETVAL -eq 0 ]; then
        touch /var/lock/subsys/mysql-proxy
    fi
}

Comment 1 Alves 2013-07-05 13:55:02 UTC
Could you be so kind as to publish the full service script?
I am RHEL 6.4 user and compiled mysql-proxy it from sources, but it has no service script. I found one on-line but does not work at all. If there are any changes to make this work under RHEL 6.X, please point them to me. I am not trained to write service scripts.

Comment 2 Teguh DC 2013-08-27 02:12:44 UTC
if you want to use --admin-* option, you have to add admin plugin first (and don't forget add proxy plugin too).

/etc/sysconfig/mysql-proxy

...
PROXY_OPTIONS="--daemon --log-level=info --log-use-syslog --plugins=admin --plugins=proxy"
...

Comment 3 Teguh DC 2013-08-27 02:24:27 UTC
Created attachment 790734 [details]
delete /etc/sysconfig/mysql-proxy content

move mysql-proxy content to mysql-proxy.cnf

Comment 4 Teguh DC 2013-08-27 02:27:06 UTC
Created attachment 790735 [details]
initscript to use defaults-file option

using defaults-file option and move all related option to that file

Comment 5 Teguh DC 2013-08-27 02:30:46 UTC
Created attachment 790736 [details]
mysql-proxy.cnf

mysql-proxy.cnf after i move option from /etc/sysconfig/mysql-proxy and initscript

Comment 6 Teguh DC 2013-08-27 04:29:44 UTC
You can grab source rpm from here http://dheche.fedorapeople.org/rpms/mysql-proxy/

Comment 7 Fedora Update System 2014-06-27 10:24:36 UTC
mysql-proxy-0.8.4-1.el6 has been submitted as an update for Fedora EPEL 6.
https://admin.fedoraproject.org/updates/mysql-proxy-0.8.4-1.el6

Comment 8 Fedora Update System 2014-06-27 15:29:32 UTC
Package mysql-proxy-0.8.4-1.el6:
* should fix your issue,
* was pushed to the Fedora EPEL 6 testing repository,
* should be available at your local mirror within two days.
Update it with:
# su -c 'yum update --enablerepo=epel-testing mysql-proxy-0.8.4-1.el6'
as soon as you are able to.
Please go to the following url:
https://admin.fedoraproject.org/updates/FEDORA-EPEL-2014-1759/mysql-proxy-0.8.4-1.el6
then log in and leave karma (feedback).

Comment 9 Fedora Update System 2014-07-12 19:45:24 UTC
mysql-proxy-0.8.4-1.el6 has been pushed to the Fedora EPEL 6 stable repository.  If problems still persist, please make note of it in this bug report.

Comment 10 Red Hat Bugzilla 2023-09-14 01:40:36 UTC
The needinfo request[s] on this closed bug have been removed as they have been unresolved for 1000 days