As requested by anarcat I open this issue separately from the discussion here http://drupal.org/node/553348

Nearly Verbatim text, sorry for the late laziness

"Got it :)"

Call me stubborn but I wanted to find the bottom of it and for once stubbornness paid of because I would have had the same problem with RC4.

I managed to install remote Eclipse-PDT - CLI debugging through my NAT-ed home computer to my main coloc server, something that could prove useful (for me at least) in the future (if it is such a common skill forget I ever wrote this sentence but if some people are interested I could write a short doc)
This lead to the line

$connection = @mysql_connect(drush_get_option('master_db_host'), drush_get_option('master_db_user'), drush_get_option('master_db_passwd'));

as the one that provoked a run-time failure and thus the command failure.

Now guess what ?

On my FreeBSD box I installed the PhP extensions with mysqli because it is the recommended "modern" PhP interface for Mysql, but not the "Mysql" extensions proper.

It is mandatory to have the "old school mysql" extensions support and not only the "mysqli extensions" to use Drush / AEgir.
PHP Mysql supports must be understood in the literal sense for now. :)

That information is somewhat hidden in the apt-get install php5 php5-cli php5-mysql line in INSTALL.TXT under a debian-ism :)

Since Drupal supports either Mysql extensions or MysqlI extensions, I was none the wiser on the Drupal front but obviously the AEgir modules do not .... hence the problem.

I will now wipe out the full install and redo it following step by step the new RC4 instruction and report anything unclear, odd or non obvious.

I'll have questions on the recommended file structure and upgrade policy (I have bad gut feelings about it) but I will first follow the instruction to the letter and ask about it after that.

Thanks a lot to the AEgir team.

Comments

steveparks’s picture

Hi Annakan

I'll make the need for the older mysql extension clearer in the documentation.

Do you have any outstanding issues with this ticket? or is it okay to mark it as closed now?

Anarcat - are you keeping this ticket as a placeholder for possible future mysqli support? or is it okay to close?

Thanks
Steve

jonhattan’s picture

Title: MySQL vs MySQLI extensions for drush » Use PDO in provision's db_server instead of "old school" mysql (that may be a failure if only mysqli if available)
Project: Hosting » Provision

php5-mysql for debian provides mysql, mysqli and PDO-mysql.

Drush does use PDO to verify database credentials, and so I think provision will do to connect to mysql.

/me moving the issue to provision and changing the title.

Annakan’s picture

I did not do a full re install (with the core packages on the os and such) since then, so I did not check on this issue yet.

The issue is not, per see, blocking me once you know that you need msqli/pdo available to be able to install aegir (I did trace the problem to a msqlI call, for reference).

It is something that can trip very badly users where installing mysql, mysqli and PDO are separate packages since the error only show off late in the install when provisioning and it quite cryptic.

Either it is a call or a few call that are not up to the AEgir standard or way of doing DB calls OR it must be prominently documented that"s all :).

anarcat’s picture

Category: bug » feature
Status: Active » Closed (duplicate)