Posted by redpuma on February 1, 2010 at 5:07pm
I've been using Aegir in my development VM which is now distributed to three other developers. While for us creates consistency when creating a new site/project I find the use of site_X for the database name causes some slowdown in work.
Is there an option to name the database when creating a new site?
Some times I need to go and look in a DB and having to SSH in and run "drush -l sitename status" or open the settings.php for that site to check the DB name is a distraction.
I'm aware that Aegir's intended purpose might not be that to which I'm using it in this case.
Comments
There is a ticket for this.
There is a ticket for this. It has not yet been implemented, but it may be in the future.
Also see some comments in this ticket
That's good to hear. I
That's good to hear. I understand the comment about 16 characters might be an issue but being able to optionally insert some text would be useful. Some kind of project related abbreviation so you endup with "site_myabbrev_0" so it keeps the "site_" name space.
DB = Node #
As an alternate workaround to the ssh and settings.php methods you listed above, the db name is the same as the node number assigned when a site is created. Also, the platform name in vhost.d is assigned the same way.
On your aegir site, hosted sites page, if you mouse-over a site name the node number appears on the bottom of the screen (within firefox). Or simply click the site name and the node number will be in the address bar.
The db name will be appended if certain tasks are undertaken in aegir so site_334 can becomes site_334_0.
It has been my experience with 04-Alpha3 that imported sites do not have the node number assigned to the db.