phpMyAdmin for OpenShift JBoss Cartridge

[simas_ch]

There is a project called jsp-myadmin that works more or less and has some features of phpMyAdmin (at least you can execute SQL):

http://code.google.com/p/jsp-myadmin/

Caution: Username, Password, Host and Port must be hard coded in login.jsp!

Have fun.

[theute]

Sounds like something that worth a try ! Thanks

[refon]

Thank you for the resource !

[maxandersen]

bwt. I found this article [1] about OpenShift and phpmyadmin and I just tried it on my AS7 project and it actually just works.

Not sure why it didn't work on Thomas' application - maybe he typed the cartridge name wrong.

But its very simple, here is my commands/output (sans passwords

[max@greybeard ~/git]$ rhc-ctl-app -a super -e add-mysql-5.1
Password: 
Contacting https://openshift.redhat.com
Contacting https://openshift.redhat.com
API version:    1.1.1
Broker version: 1.1.1


RESULT:


Mysql 5.1 database added.  Please make note of these credentials:


   Root User: admin
   Root Password: <secret>
   Database Name: super


Connection URL: mysql://127.1.60.1:3306/


 [max@greybeard ~/git]$ rhc-ctl-app -a super -e add-phpmyadmin-3.4
Password: 
Contacting https://openshift.redhat.com
Contacting https://openshift.redhat.com
API version:    1.1.1
Broker version: 1.1.1


RESULT:


phpMyAdmin 3.4 added.  Please make note of these credentials:


   Root User: admin
   Root Password: <secret>


Connection URL: https://super-man.rhcloud.com/phpmyadmin/

So it actually does work on any openshift app no matter its type.

[1] https://www.redhat.com/openshift/blogs/phpmyadmin-your-way-into-openshift-express-database-management-bliss

[simas_ch]

Hey cool!

When you execute rhc-ctl-app it only displays mysql-5.1 but when you execute rhc-ctl-app -a <your app> -e <invalid type> then it says:

Invalid type specified. Valid embedded types are (mysq-5.1, phpmyadmin-3.4)

[maxandersen]

Weird, I get it listed in both cases.

Maybe you are running an older version of the jboss type on your app ?

Does it happen for newly created app too ?

[theute]

Doh !

Indeed it does work, use the same command as you on the app I used during demo and:

https://javaee-jbossepp.rhcloud.com/phpmyadmin/ (well you don't have my secret password )

I feel happy that it works but stupid that I didn't get it to work during demo :-/ (for my excuse the feature was released the day before my demo  )

[simas_ch]

Yes it happens as well for new created apps. Strange.

What ever - OpenShift is cool. JBoss AS 7 with MySQL and phpMyAdmin the perfect runtime for many apps.