Using MySQL with MAPP

Hi. I have a MAPP installation. With some variations I have finally managed to run Postgresql in UTF8 collation (the default installed by Bitnami’s MAPP is “SQL_ASCII” which no one uses these days!)

So far so good. PG is working. Apache is working. I can see localhost in my browser. Yipppeee!

But I also need to have MySQL working with this installation. How can I do this? I went through the trouble of installing MAMP just for MySQL, and MySQL itself now works on my machine too.

But how should I associate MySQL with Apache on MAPP? I went into the php.ini of my MAPP installation and uncommented these lines:

extension=php_mysql.dll
extension=php_mysqli.dll

And then restarted Apache, but this still does not work. PHPMYADMIN (tied to Apache’s localhost path on MAPP, not in MAMP) gives me this message:

Cannot load mysql extension. Please check your PHP configuration.

Any ideas of how I can make my MySQL work with the Apache on MAPP? Then I will have MAMP only to have MySQL on my Mac OSX, but nothing else. Thanks!

Hi,

The lines that you have uncommented only runs well on Windows system. Take a look the modules *. dll extension. Currently it is not possible to have in the same Stack MySQL and PostgreSQL but we have in our TODO list for the future. Cheers.

Well I really hope two things are made for Postgresql developers who are the target audience for MAPP Stack:

1. That both MySQL and PG work within the same apache/php installation. No point limiting to one or the other. What’s the logic? Neither php nor httpd pose any limitations. Both DBs can be activated by modules.

2. That the PG install is not SQL_ASCII but UTF-8. Changing this basic collation after the install is a pain in any enterprise database. Please consider immediately for the next update of MAPP, because almost everyone is-and should be-using UTF8.

Thanks.

Hi,

1. That both MySQL and PG work within the same apache/php installation. No point limiting to one or the other. What’s the logic? Neither php nor httpd pose any limitations. Both DBs can be activated by modules.

Currently a Stack which supports PosgreSQL and MySQl is not in our todo list but we will considerer for future versions. Thanks for the suggestion.

2. That the PG install is not SQL_ASCII but UTF-8. Changing this basic collation after the install is a pain in any enterprise database. Please consider immediately for the next update of MAPP, because almost everyone is-and should be-using UTF8.

Yes, we are working on this and the new release will fix this problem.

Cheers.

Currently a Stack which supports PosgreSQL and MySQl is not in our todo list but we will considerer for future versions. Thanks for the suggestion.

I know it is not. But the question is why? Is it really that complicated?

Any update on this? I’m sure there are many folks now who want both MySQL and PG for their local testing.

Hi,

You are right, it is not complicated at all and we have in our TODO list, it is only a matter of priorities. The community suggestions are very present on our goals, so I apologize for the delay on this task. I’m also sure that a LAMPP is a nice Stack for a lot developers.

Cheers.

I’m glad to tell you that we have released a PostgreSQL module (http://bitnami.org/stack/postgresql) that you can install over the LAMPStack, MAMPStack, WAMPStack or RubyStack. This module ships and configure PostgreSQL database server and phpPgAdmin application to handle the administration of PostgreSQL over the Web. I hope it would be helpful for you :)