Problems with Provision Verify on CentOS 5.3

Events happening in the community are now at Drupal community events on www.drupal.org.
g8's picture

When running drush.php provision verify, it seems provision is unable to find the master_db_host, master_db_user and master_db_passwd, resulting in an error: Could not connect to the master database. An error occurred at function : drush_provision_mysql_provision_verify_validate. If I pass the three options to the verify command as arguments, (eg. drush.php provision verify --master_db_host=localhost --master_db_user=user --master_db_passwd=passwd), provision verify works, and proceeds to creating the drushrc.php file, with NULL values for master_url and master_db.

Has anyone seen this? Am I missing something really basic here? I've verified the basics over and over; drush is located in ~/ and provision is located in ~/.drush... aegir.apache own everything under /var/aegir - I'm running CentOS 5.3, with PHP upgraded to 5.2.10.

Thanks!

Comments

Take a look

Are you sure that is the right link?

pearcec's picture

It seems that links to something relating to php-gd.

--
Christian

--
Christian

Similar issue

pearcec's picture

I can't verify the database.

function provision_db_connect() {
  if (_provision_db_connection()) {
    return TRUE;
  }
  $connection = mysql_connect(drush_get_option('master_db_host'), drush_get_option('master_db_user'), drush_get_option('master_db_passwd'));

  if (!$connection) {
    drush_set_error('PROVISION_MASTER_DB_FAILED', dt('Could not connect to the master database.'), 'error');
  }

I removed the @ in front of the mysql_connect to get a better error message. It gave me this

mysql_connect(): Access denied for user 'pearcec'@'localhost' (using [warning]
password: NO) [0.126 sec]
Could not connect to the master database. [0.126 sec] [error]

I can't figure out why it is pulling in my "pearcec" username when I am sudo'd as aegir with I run the verify.

When I pass in the parameters, then I get this.

Could not select the mysql database. [error]

I was running 0.2 fine. I started from scratch with 0.3. Now I can't get it going. I am using ubuntu 9.04, and provisioned everything from CVS using the 0.3 BRANCH.

--
Christian

--
Christian

I've got the exact same

kyle_mathews's picture

I've got the exact same problem -- the script is using my non-aegir username and no password. Weird.

Kyle Mathews

Kyle Mathews

Hosting Module Casuing The Problem?

g8's picture

After seeing Adrian's post about the new release candidate, I wiped my 5.x Aegir installation, and performed a fresh 0.3 install, which went off without a hitch. Without debugging the provision verify issue I originally experienced, I'm guessing it probably has something to do with the hosting module - I imagine, for whatever reason, the hosting module wasn't properly setting the master_db options, preventing provision from grabbing them - just a hunch.

Good to here

pearcec's picture

I guess I will have to start over again. The installation instructions are a tad crufty. I basically follow the ones in the INSTALL.txt but want to run from a CVS checkout.

When does the drushrc.php get created in the platform directories? Do the platform directories need to be own by the apache users so it can get written?

--
Christian

--
Christian

provision verify creates the

g8's picture

provision verify creates the drushrc.php file once it passes all the checks, and yes, the apache group should be on everything. If you run "useradd aegir --home=/var/aegir -g apache" it will make the aegir user's default group apache, which in turn will automatically create the home directory and everything under it with apache group ownership. Also, be sure to append the aegir user to apache in /etc/group and chmod 777 on the drupal/sites and drupal/sites/default folders. Good luck!

I got the same problem even

kelvinwong's picture

I got the same problem even on version 0.3. After spending nearly half day on try and error. I found out that the system doesn't allow password contain symbols for the master DB user. It would be nice if someone could fix it.

Fedora

davidburns's picture

I'm running Fedora 10, PHP 5.2.10, w/ Aegir 0.3RC2 and I'm having the same issue.
After changing my database user and password so they do not have symbols, then running from command line I do not recieve any errors and drushrc.php is created.

drush provision verify --master_db_host=localhost --master_db_user=USERNAME --master_db_passwd=PASSWORD

Still unable to complete they verify task from within the aegir site.

I wish I was back on Ubuntu, this wouldn't be such a problem.

EDIT: Created an issue for this here >> http://drupal.org/node/547522

Why not use Debian/Ubuntu? I

Macronomicus's picture

Why not use Debian/Ubuntu?

I dont think much focus has been applied outside debian/ubuntu just yet .. tho the time will come im sure.
Is there some particular reason your using centOS? Most of what ive read and heard around Aegir is most if not all testing and instructions are Debian/Ubuntu, its the starting point before branching out to other os's. Prolly have a lot less trouble going that route.

Just my two cents. ^_^

drush provision not verified

gmmurugan's picture

hi genius.

i fed up with trying Aegor 3 with Ubuntu [localhost] and Centos[my vps server]

both held up with same error.
errors:[druspl6.13]- i am using aegir as separate user and drush symbolic linked by root. FYI

The command 'drush.php provision verify' could not be found.
An error occurred at function : drush_hosting_hosting_task


i used to put provision in .drush folder only.

and why the aegir account should have root folder as var/aegir/ as home directory?

is it a protocol.?

or shall i have it whole aegir installation in my Desktop of aegir user.
wats the difference.

moreover.
1.wats the problem in installing it in CentOS. report if any.
2.whether drush and .drush needs to be in root of aegir account/root account to identify provision?
3.i followed Install.txt only..
4.whether we need separate apache/mysql group account.
5.can i get a zip file where aegir installed with expoted .sql with passwords?[please upload]

GM

@gmmurugan You really need

Macronomicus's picture

@gmmurugan

You really need to follow the directions .. when I first started working with Aegir .. I was messing things up .. also known as "user error" I can tell you that since then I have successfully installed Aegir on ubuntu more than 20 times. And have several servers running it without any trouble.

var/aegir should be the home directory because thats how its supposed to be .. sure you may be able to change it but you'd have to probably hack the code which is not a good idea.

To answer your questions..
1. Never used CentOS for Aegir .. and im not sure its supported, its an unknown .. so why bother? Ubuntu/Debian is supported and therefore a smarter route to go since we are all using it successfully.
2. Drush can be anywhere you want it to be .. just make sure that you create a proper link to it so its usable .. and also enter that link when filling out the hostmaster installation pages. I have my drush installed in /var/aegir/drush
3. If you followed the directions exactly then perhaps there is something extraneous going on with your server? Try starting with a clean fresh ubuntu/debian.
4. The directions explain each step pretty well ... make sure your reading the latest install.txt
5. Did you also look in... http://groups.drupal.org/node/4701/documentation there is a shell install script that's a handy shortcut and worked for me when I tested it.

I'm sorry your having some trouble with this but stay strong and keep trying because you will be very happy you did, Aegir rocks!

Cheers!

There's nothing inherently debian about it

adrian's picture

The primary development platform (for me) has been Mac OSX for most of the lifetime.

It's only been in the last few weeks that I have been primarily testing on virtual machines running Ubuntu.

I have installed Aegir on CentOS myself, and other people have installed it successfully on FreeBSD.

It should work on any unix like system.

The home directory requirement is because of Drush. Drush loads command files from several different places, but the ~/.drush just happens to be the most straight forward place to put it for us. It can also be installed in /usr/share/drush for instance, and even that is configurable.

The documentation is mostly slanted towards debian because most of the developers are using debian, for no other reason.

jcathcart's picture

I am learning both Aegir and Drupal, but I got them working on an existing SUSE Enterprise Linux server that was already running Apache, PHP, and MySQL for other purposes. My Apache server is not dedicated to Aegir, and I can add and remove Aegir without affecting the other non-Drupal Apache virtual hosts.

I am a career Unix / Linux administrator and I admit I encountered some problems. I got it working on the second installation attempt by starting over, by deleting the aegir user and directories and using what I learned the first time.

I did not use /var/aegir. I used /srv/www/aegir for the "aegir" user $HOME, but this did not cause any of my problems. You can put the $HOME anywhere you want and the user does not have to be called "aegir." My problems were largely with drush, provision, PEAR, and settings.php. The PEAR issue may have been a "red herring" (a possibly unrelated problem with an earlier version and the Console_Table library).

Over a year ago, I installed SLES (OpenSUSE is nearly identical). At the time, I used the SUSE software installer YaST2 to install Apache and PHP. This is where various Linux "brands" create problems for us - location of various parts of Apache can vary greatly from Linux to Linux (to Unix to Unix).

I installed PEAR manually for the user "aegir" in the "aegir" $HOME (e.g., /var/aegir/pear). This may have been unnecessary.

Important: Follow the latest Aegir INSTALL.txt revision! ...and adapt any Linux "brand"-specific (e.g., Debian) instructions to your own methods (RPM, YaST, yum, ...). I read 2 or 3 tutorials for installing Aegir that I found using Google. These tutorials combined helped me better understand the Aegir installation structure and how the parts are related.

Check $HOME/drupal*/ for the file drushrc.php. This is created during the install process and must contain the proper MySQL data (I found it near the end of my drushrc.php).

Ensure you copy sites/default/default.settings.php to sites/default/settings.php. I think this addressed in INSTALL.txt.

If you do not use the drush --root= option, then you must run drush from the drupal directory or the specific site directory. The command "drush status" should produce something like:

  PHP configuration : /etc/php5/cli/php.ini
  Drupal Root       : /srv/aegir/drupal
  Drupal version    : 6.13
  Site Path         : sites/default  (or sites/mysite.mydomain.tld)
  Site URI          : http://default (or http://mysite.mydomain.tld)
  Database Driver   : mysql
  Database Hostname : localhost
  Database Username : aegiruser
  Database Name     : aegirdb
  Database Password : S00per.secret.passwort.known.only.2.me.and.my.housecat
  Database          : Connected
  Drupal Bootstrap  : Successful
  Drupal User       : Anonymous

I apologize both for the length and the disorganization of this post. Also - this post is growing off-topic, sorry to contribute to its delinquency. If my notes above are in error, please politely let me know. I installed this six days ago and do not clearly remember what I did -- I tried many things and didn't take notes at the time.

Jason

Can you help with any tips,

bmx269's picture

Can you help with any tips, instructions. I have a client that wants to install Aegir on SUSE 11, and I have never used the OS.

I have sort or figured out how to used YAST, but it only gets files from the disk, which is not in the server.

Do you have some online repositories to use?

Any and ALL help would be really great, Thanks.

Very cool to know about the

Macronomicus's picture

Very cool to know about the other linux flavors .. I just figured since all the directions were debian/ubuntu thats the easier route to go. The bonus is that I prefer ubuntu and am not required to use anything on my servers. Makes total sense that it would work with any and apparently it does.

Sorry... I didnt mean to imply that debian/ubuntu was the only choice .. just that its the easiest.

Installation issue in centos (help needed)

tusharkanta's picture

I installed aegir on centos folllowing line by line of installation instructions. It fails during site verification stage. You can view the verification log in http://peppervillage.net/node/6 (user name is: peppervillageAdmin and password: peppervillageAdmin). The log says:

Web server could not be restarted. Changes might not be available until this has been done.

Though I have given the necessary permissions in /etc/sudoers (using sudo visudo).

Please help me solve this issue at the earliest.

apache not restarting on CentOS

kd7vnn's picture

When I had this problem I had forgot the following step (http://groups.drupal.org/node/19170).

You need to also comment out the line

Defaults requiretty

from your sudoers file.

Aegir hosting system

Group organizers

Group categories

Group notifications

This group offers an RSS feed. Or subscribe to these personalized, sitewide feeds:

Hot content this week