mysql-proxy on scalr 3.5/centos5.7 issues

[Chris]

the mysql-proxy add-on role does not appear to be working for centos. I cannot connect to localhost:4040 on the app roles, nor do i see anything using port 4040/3306 on the proxy server via netstat -nap, and nothing in xinetd, nor any .lua files and mysql-proxy is not running. Am i missing something?

[Chris]

trying to build the mysql-proxy role hangs on every version of ubuntu as well

Jul 9, 2012 07:12:06	Server status: running
Jul 9, 2012 07:10:05	Server status: running
Jul 9, 2012 07:08:06	Server status: running
Jul 9, 2012 07:07:52	Server status: running
Jul 9, 2012 07:06:07	Server status: running
Jul 9, 2012 07:04:05	Server status: running
Jul 9, 2012 07:02:06	Server status: running
Jul 9, 2012 07:00:07	Server status: running
Jul 9, 2012 06:58:06	Server status: running
Jul 9, 2012 06:56:07	Server status: running
Jul 9, 2012 06:54:06	Server status: running
Jul 9, 2012 06:52:06	Server status: running
Jul 9, 2012 06:50:07	Installing software [ OK ]
Jul 9, 2012 06:50:05	Server status: running
Jul 9, 2012 06:48:08	Creating runlist [ OK ]
Jul 9, 2012 06:48:08	Unpacking cookbooks [ OK ]
Jul 9, 2012 06:48:08	Creating chef configuration file [ OK ]
Jul 9, 2012 06:48:08	Installing chef [ OK ]
Jul 9, 2012 06:48:08	Installing rubygems [ OK ]
Jul 9, 2012 06:48:08	Unpacking rubygems [ OK ]
Jul 9, 2012 06:48:08	Downloading rubygems [ OK ]
Jul 9, 2012 06:48:08	Installing essential packages [ OK ]
Jul 9, 2012 06:48:08	Updating package list [ OK ]
Jul 9, 2012 06:48:05	Server status: running
Jul 9, 2012 06:46:09	Launching role builder routines on server
Jul 9, 2012 06:46:08	Uploading chef recipes...
Jul 9, 2012 06:46:07	Uploading builder scripts...
Jul 9, 2012 06:46:06	Initializing SSH2 session to the server
Jul 9, 2012 06:46:06	Server status: running
Jul 9, 2012 06:44:08	Bundle task status: preparing-environment
Jul 9, 2012 06:44:07	Server status: running

[Igor Savchenko]

Make sure that cronjobs on scalr properly installed. In this particular case cronjob BundleTasksManager responsible for building roles.

Regards,

Igor

--
You received this message because you are subscribed to the Google Groups "scalr-discuss" group.

To view this discussion on the web visit https://groups.google.com/d/msg/scalr-discuss/-/B9qrsX8SNUUJ.

To post to this group, send email to scalr-...@googlegroups.com.
To unsubscribe from this group, send email to scalr-discus...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/scalr-discuss?hl=en.

[Chris]

centos is capable of creating the role, however mysql-proxy does not seem compatible with the scalr scripts, the mysql-proxy binary which is installed does cannot read a config file, and has different parameter options than what is expected.

the log just sits at the following for all ubuntu installs for mysql-proxy.

root@ip-xxx:/var/log# tail -f role-builder.log

2012-07-09 17:14:32,924 - DEBUG - scalarizr.util.log - Enabling log messaging

2012-07-09 17:14:32,925 - DEBUG - scalarizr.handlers.hooks - Hook on 'hello'() {}

2012-07-09 17:14:32,925 - DEBUG - scalarizr.util.sqlite_server - create cursor 2513861

2012-07-09 17:14:32,927 - DEBUG - scalarizr.util.sqlite_server - Execute result: {'rowcount': -1, 'data': []}

2012-07-09 17:14:32,928 - DEBUG - scalarizr.handlers.script_executor - STATE[script_executor.in_progress]: None

2012-07-09 17:14:32,928 - DEBUG - scalarizr.util.sqlite_server - create cursor 2513861

2012-07-09 17:14:32,930 - DEBUG - scalarizr.util.sqlite_server - Execute result: {'rowcount': -1, 'data': []}

2012-07-09 17:14:32,930 - DEBUG - scalarizr.handlers.script_executor - Restoring 0 in-progress scripts

2012-07-09 17:14:32,930 - DEBUG - scalarizr.config - Reading file /etc/scalr/private.d/.state

2012-07-09 17:14:32,931 - DEBUG - scalarizr.handlers.hooks - Hook on 'start'() {}

2012-07-09 17:15:01,786 - DEBUG - scalarizr.messaging.p2p.producer - Sending message 'Log' into queue 'log'

2012-07-09 17:15:01,787 - DEBUG - scalarizr.util.sqlite_server - create cursor 2513837

2012-07-09 17:15:01,792 - DEBUG - scalarizr.util.sqlite_server - Execute result: {'rowcount': 1, 'data': []}

2012-07-09 17:15:01,794 - DEBUG - scalarizr.messaging.p2p.producer - Delivering message 'Log' <?xml version="1.0" ?><message id="79ebdfd0-ab00-4caa-aec2-33cfcbb84b2e" name="Log"><meta><szr_version>0.9.r3629</szr_version><server_id>b2d20736-7a04-4ef3-ac7b-13e974a7c126</server_id><timestamp>Mon 09 Jul 2012 17:15:01 UTC</timestamp></meta><body><entries><item><stack_trace></stack_trace><pathname>/usr/lib/pymodules/python2.7/scalarizr/__init__.py</pathname><name>scalarizr</name><level>INFO</level><msg>[pid: 11561] Starting scalarizr 0.9.r3629</msg><lineno>675</lineno></item><item><stack_trace></stack_trace><pathname>/usr/lib/pymodules/python2.7/scalarizr/config.py</pathname><name>scalarizr.config</name><level>INFO</level><msg>State: importing</msg><lineno>928</lineno></item><item><stack_trace></stack_trace><pathname>/usr/lib/pymodules/python2.7/scalarizr/handlers/mysqlproxy.py</pathname><name>scalarizr.handlers.mysqlproxy</name><level>INFO</level><msg>Updating mysql-proxy backends list</msg><lineno>145</lineno></item><item><stack_trace></stack_trace><pathname>/usr/lib/pymodules/python2.7/scalarizr/__init__.py</pathname><name>scalarizr</name><level>INFO</level><msg>Starting API server onhttp://0.0.0.0:8010</msg><lineno>345</lineno></item><item><stack_trace></stack_trace><pathname>/usr/lib/pymodules/python2.7/scalarizr/messaging/p2p/consumer.py</pathname><name>scalarizr.messaging.p2p.consumer</name><level>INFO</level><msg>Building message consumer server on 0.0.0.0:8013</msg><lineno>56</lineno></item><item><stack_trace></stack_trace><pathname>/usr/lib/pymodules/python2.7/scalarizr/handlers/lifecycle.py</pathname><name>scalarizr.handlers.lifecycle</name><level>INFO</level><msg>Server will be imported into Scalr</msg><lineno>170</lineno></item></entries></body></message>

2012-07-09 17:15:01,795 - DEBUG - scalarizr.messaging.p2p.security - Encrypting message

2012-07-09 17:15:02,134 - DEBUG - scalarizr.messaging.p2p.producer - Message 'Log' delivered (message_id: 79ebdfd0-ab00-4caa-aec2-33cfcbb84b2e)

2012-07-09 17:15:02,135 - DEBUG - scalarizr.util.sqlite_server - create cursor 2485061

2012-07-09 17:15:02,199 - DEBUG - scalarizr.util.sqlite_server - Execute result: {'rowcount': 1, 'data': []}

here is the process list, with one defunct scalr process.

root@ip-10-176-23-49:/var/log# ps xau |grep scal

root       707  0.0  0.0  13132  1600 ?        Ss   17:10   0:00 /bin/bash /tmp/scalr-builder.sh

root     11561  0.5  1.1 196028 20000 ?        Sl   17:14   0:02 /usr/bin/python /usr/local/bin/scalarizr --import -y -o server-id=b2d20736-7a04-4ef3-ac7b-13e974a7c126 -o role-name=db-proxy -o crypto-key=tz4hx/mCnKiu+AzXkfG9Ks0VO+qUm0rX5Pe05jI2VRW25eZ0BrnPfw== -o platform=ec2 -o behaviour=,chef,mysqlproxy -o queryenv-url=http://xxx/query-env -o messaging-p2p.producer-url=http://xxx/messaging

root     11570  0.0  0.0      0     0 ?        Zs   17:14   0:00 [scalarizr] <defunct>

root     11601  0.0  1.3  98888 22644 ?        S    17:14   0:00 /usr/bin/python /usr/local/bin/scalarizr --import -y -o server-id=b2d20736-7a04-4ef3-ac7b-13e974a7c126 -o role-name=db-proxy -o crypto-key=tz4hx/mCnKiu+AzXkfG9Ks0VO+qUm0rX5Pe05jI2VRW25eZ0BrnPfw== -o platform=ec2 -o behaviour=,chef,mysqlproxy -o queryenv-url=http://xxx/query-env -o messaging-p2p.producer-url=http://xxx/messaging

root     11726  0.0  0.0   7976   908 pts/0    S+   17:22   0:00 grep --color=auto scal

here is the output of the cronjob, repeated over and over

2012-07-09 12:23:26,101 - INFO [tran4ffb138dd7a8c:Logger@36] - 'Starting BundleTasksManager cronjob...'

2012-07-09 12:23:26,101 - INFO [tran4ffb138dd7a8c:Logger@24] - 'Found 3 bundle tasks.'

2012-07-09 12:23:28,101 - INFO [tran4ffb138dd7a8c:Logger@382] - 'Open stream to: ssh2.sftp://CONNECTION/var/log/role-builder-output.log'

2012-07-09 12:23:28,101 - INFO [tran4ffb138dd7a8c:Logger@382] - 'Open stream to: ssh2.sftp://CONNECTION/var/log/role-builder-output.log'

2012-07-09 12:23:28,101 - INFO [tran4ffb138dd7a8c:Logger@382] - 'Open stream to: ssh2.sftp://CONNECTION/var/log/role-builder-output.log'

2012-07-09 12:23:28,101 - INFO [tran4ffb138dd7a8c:Logger@387] - 'Reading: /var/log/role-builder-output.log'

2012-07-09 12:23:28,101 - INFO [tran4ffb138dd7a8c:Logger@387] - 'Reading: /var/log/role-builder-output.log'

2012-07-09 12:23:28,101 - INFO [tran4ffb138dd7a8c:Logger@387] - 'Reading: /var/log/role-builder-output.log'

Igor

To unsubscribe from this group, send email to scalr-discuss+unsubscribe@googlegroups.com.

[Marat]

MySQLProxy is not supported by Scalarizr on CentOS 5. Please use Ubuntu.