[gentoo-user] Set up drupal with postgres
Hi All,
I am trying to set up drupal on a box that has postgresql instead of mysql.
The problem is that the script offered in the Gentoo Wiki[1] is for mysql as
quoted below:
USE mysql;
INSERT INTO user (host, user, password, select_priv, insert_priv, update_priv)
VALUES ('localhost', 'drupal', PASSWORD('passwd'), 'Y', 'Y', 'Y');
CREATE database drupal;
USE drupal;
GRANT ALL PRIVILEGES ON drupal.* TO drupal@'%' IDENTIFIED BY 'passwd';
FLUSH privileges;
Where 'passwd' is the password required to log in as the MySQL user.
Then execute the script:
# mysql -u root -p drupal-script
This will create a new user 'drupal' and a database 'drupal' for your Drupal
site and load the drupal database scheme.
Any idea what I need to enter to make it work with postgres, or what I could
run manually to achieve the same effect, once logged in to postgres?
--
Regards,
Mick
pgp34gv4E4bZE.pgp
Description: PGP signature
Re: [gentoo-user] Set up drupal with postgres
On Thursday 09 August 2007, Mick [EMAIL PROTECTED] wrote
about '[gentoo-user] Set up drupal with postgres':
USE mysql;
\c postgres
INSERT INTO user (host, user, password, select_priv, insert_priv,
update_priv) VALUES ('localhost', 'drupal', PASSWORD('passwd'), 'Y',
'Y', 'Y');
CREATE USER 'drupal';
CREATE database drupal;
(unchanged)
USE drupal;
\c drupal
GRANT ALL PRIVILEGES ON drupal.* TO drupal@'%' IDENTIFIED BY 'passwd';
Probably easiest to just make the drupal user the owner of the drupal
database.
--
Boyd Stephen Smith Jr. ,= ,-_-. =.
[EMAIL PROTECTED] ((_/)o o(\_))
ICQ: 514984 YM/AIM: DaTwinkDaddy `-'(. .)`-'
http://iguanasuicide.org/ \_/
signature.asc
Description: This is a digitally signed message part.
Re: [gentoo-user] Set up drupal with postgres
On Thursday 09 August 2007 20:29, Boyd Stephen Smith Jr. wrote:
On Thursday 09 August 2007, Mick [EMAIL PROTECTED] wrote
about '[gentoo-user] Set up drupal with postgres':
USE mysql;
\c postgres
INSERT INTO user (host, user, password, select_priv, insert_priv,
update_priv) VALUES ('localhost', 'drupal', PASSWORD('passwd'), 'Y',
'Y', 'Y');
CREATE USER 'drupal';
CREATE database drupal;
(unchanged)
USE drupal;
\c drupal
GRANT ALL PRIVILEGES ON drupal.* TO drupal@'%' IDENTIFIED BY 'passwd';
Probably easiest to just make the drupal user the owner of the drupal
database.
Thank you Boyd! I'll try this out - although it seems that the default script
already created a drupal database owned by postgres. :@
Besides databases I am also a total noob with apache and related apps. Is
there a link somewhere that explains:
a) how do you create different vhosts (I only have localhost
under /var/www/locahost/).
b) how do you run/access drupal (the drupal files seem to be
under /usr/share/webapps/drupal/5.2/htdocs).
Thank you for your help. :)
--
Regards,
Mick
pgpVAda6QGOeS.pgp
Description: PGP signature
Re: [gentoo-user] Set up drupal with postgres
On Thursday 09 August 2007, Mick [EMAIL PROTECTED] wrote about 'Re: [gentoo-user] Set up drupal with postgres': On Thursday 09 August 2007 20:29, Boyd Stephen Smith Jr. wrote: On Thursday 09 August 2007, Mick [EMAIL PROTECTED] wrote GRANT ALL PRIVILEGES ON drupal.* TO drupal@'%' IDENTIFIED BY 'passwd'; Probably easiest to just make the drupal user the owner of the drupal database. Thank you Boyd! I'll try this out - although it seems that the default script already created a drupal database owned by postgres. :@ You can do something like: CREATE DATABASE 'drupal' WITH OWNER 'drupal'; a) how do you create different vhosts (I only have localhost under /var/www/locahost/). All of this a apache (or other httpd) configuration, you should be able to pattern your vhost(s) off of the default one installed by the package. b) how do you run/access drupal (the drupal files seem to be under /usr/share/webapps/drupal/5.2/htdocs). man webapp-config -- Boyd Stephen Smith Jr. ,= ,-_-. =. [EMAIL PROTECTED] ((_/)o o(\_)) ICQ: 514984 YM/AIM: DaTwinkDaddy `-'(. .)`-' http://iguanasuicide.org/ \_/ signature.asc Description: This is a digitally signed message part.
