Recent Posts by PKHunter

Topic: General / MySQL and PostgreSQL together in a stack

Thanks. It works great.

However, the Postgresql should really be compiled with “readline” support so that inside the shell of psql, arrow keys work. This is pretty fundamental.

Or can I enable this in some way that I am missing? On Mac OSX.

Thanks

Topic: General / MySQL and PostgreSQL together in a stack

I had asked this in 2008.

Any idea if BitNami is considering this in 2011 or not?

Topic: Stacks suggestions / Apache/MySQL 5.1/PHP5/Postgresql 8.4

This stack would be incredibly useful to many of us. When is this planned?

Topic: MAMPStack / PHP extension mysqli

How can I recompile PHP myself? I want to include both the mysqli and the pgsql components from PHP. Any advice? I cannot wait until you grapple with VMWare and all that. So would appreciate any pointers. Thanks.

Topic: MAPPStack / Using MySQL with MAPP

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

Topic: MAPPStack / Using MySQL with MAPP

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?

Topic: MAPPStack / LC_COLLATE = UTF8: How to?

Actually this doesn’t work either. I think the whole database needs to be installed with UTF-8 enabled during compile time :(

Topic: MAPPStack / Using MySQL with MAPP

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.

Topic: MAPPStack / 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!

Topic: MAPPStack / LC_COLLATE = UTF8: How to?

Thanks Daniel. The export command alone did not work. PG still installs with SQL_ASCII. Looking around the initdb help, I found that I need to issue this command:

/Applications/mappstack09/postgresql/bin/initdb -U postgres—lc-collate=UTF-8—encoding=UTF8

Hope this helps someone. Thanks!

Topic: MAPPStack / UTF8 by default please

Thanks antonio. Any update?

Also, most people who have to develop for Postgresql also need MySQL for some purposes. Would it be possible to have a MAMPP stack for such people? (My guess is that all your developer audience would like this)

Thanks!

Topic: General / Best Metadata/Tagging in Free CMS?

Wordpress does this all and more. It may have started as a stupid blog thing but it has come a long way and can be really powerful in the right hands.

Topic: General / MAMPP?

Hi. I need to use both MySQL and Postgresql. After racking my brains with many tools, I finally settled for Bitnami, and am happy.

But because MAMP and MAPP are only available separately, I have two separate installations just to have MySQL and Postgresql :(

My questions:

(1) Is there a “MAMPP” under development? I see many, many developers who actually need both the databases for web development.

(2) Secondly, is there any possibility of having Postgresql to default to UTF-8 locales etc instead of the “C” thing? No one I know uses the C thing anymore, the whole world practically used UTF-8 now. The reason this is essential to do at install time is that the PG engine is built with the locale. If one wishes to change it, one has to rebuild it.

Thanks!

Topic: MAPPStack / LC_COLLATE = UTF8: How to?

Hi. I have been told that LC_COLLATE is set at the initdb stage. Which means I will have to reinstall Postgresql.

Could someone please tell me how I can use MAPP but specify LC_COLLATE as UTF8 instead of the defaults?

Thanks

Topic: MAPPStack / UTF8 by default please

Hi. For PGSQL may I request that you setup the database with LC_COLLATE etc as “en_US.UTF-8” please if possible? Currently it’s the stock install which results in initdb choosing “C” as the value, which is not suitable for most modern (global) databases.

Thanks!

/>lc_collate                      | en_US.UTF-8                           | Shows the collation order locale.
lc_ctype                        | en_US.UTF-8                           | Shows the character classification and case conversion locale.
lc_messages                     | en_US.UTF-8                           | Sets the language in which messages are displayed.
lc_monetary                     | en_US.UTF-8                           | Sets the locale for formatting monetary amounts.
lc_numeric                      | en_US.UTF-8                           | Sets the locale for formatting numbers.
lc_time                         | en_US.UTF-8   
[/code]

Topic: MAPPStack / Using psql in Terminal, enabling plpgsql, etc.

Thanks. This is very useful. It’s working. I have uninstalled all other postgresql from my system. I so love this product! Thanks!

Now, one problem. One site that I want to test uses both “mysqli” (MySQL) and postgresql code.

So I have installed both MAMP and MAPP. This leads to useless repetition of Apache and PHP, but so be it. What I am trying to do is that I would like to start both pgsql and mysql (in their own stacks) but use one Apache installation across both. Everything basically works with paths inside my httpd.conf, but the problem I think is with PHP.INI.

Inside the MAPP stack (which is my main one, this apache is what I want to use), I have changed the php.ini to include the “mysql port” and “mysql.sock” commands—which I found to be different across the two stacks by running diff.

But this does not work.

Any idea how I can get both mysql and pgsql to work with the same apache and php install? Basically I am looking for a stack called “MAMPP” :)

Thanks

Topic: MAPPStack / Using psql in Terminal, enabling plpgsql, etc.

Hi. Great work with the basic MAPPstack. Lovely. It works. phpPhpAdmin is a charm.

However, there are many things that are missing in the postgresql installation it seems. Where can I enable plpgsql?

Topic: General / MAMPP? Or, are stacks mutually exclusive?

Hi. I have installed XAMPP (Apache, MySQL, PHP, Perl). Sadly the second P in that is Perl and not PostgreSQL.

I want these on my Mac OSX:

(1) Apache
(2) PHP
(3) MySQL (with phpMyAdmin)
(4) PostgreSQL (with phpPgAdmin)

I notice from BitNami that there are separate stacks for MySQL and PostgreSQL. Is there a way to install these four so that I don’t install Apache and PHP twice? Once I have these installed, I’d like to install Wordpress but I don’t need a stack for that. My WP will simply be a folder in the “htdocs” of Apache.

Thanks for any suggestions!