Attachment 5634 Details for Bug 14614 – Drupal testing procedure

Drupal testing procedure

drupal procedure (text/plain), 3.63 KB, created by olivier charles on 2014-11-23 18:36:29 CET

(hide)

Description:

Filename:

MIME Type:

Creator: olivier charles

Created: 2014-11-23 18:36:29 CET

Size: 3.63 KB

patch

obsolete

>
>Full drupal test procedure with 3 database types (Mysql, Postgresql, SQlite)
>
>On current package :
>------------------
>
>- drupal-7.32-1.mga4.noarch
>- drupal-mysql-7.32-1.mga4.noarch
>- drupal-postgresql-7.32-1.mga4.noarch
>- drupal-sqlite-7.32-1.mga4.noarch
>
>
>Test with mysql :
>- - - - - - - -
>
>$ mysql -u root -p
>MariaDB [(none)]> create database drupaltest;
>MariaDB [(none)]> create user 'drupaluser'@'localhost' identified by 'password';
>MariaDB [(none)]> grant all on drupaltest.* to 'drupaluser'@'localhost';
>MariaDB [(none)]> exit;
>
># cd /usr/share/drupal
># cp sites/default/default.settings.php sites/default/settings.php
># chmod a+w sites/default/settings.php
># chmod a+w sites/default
>
>
>Browse to http://localhost/drupal 
>When setting drupal, check mysql database type.
>Set up database using database name, user and password previously set.
>
>When warned, change permissions on sites/default and sites/default/settings.php :
># chmod 644 sites/default/settings.php
># cd sites
># chmod 755 default
>
>In drupal menu, browse to Reports/status report, it will tell you if there is any issue.
>Create a new site, add content, edit content, upload image in article, install a module, change appearance, log out, log in, etc.
>
>Update to testing packages :
>--------------------------
>drupal-7.34-1.mga4
>drupal-mysql-7.34-1.mga4
>drupal-postgresql-7.34-1.mga4
>drupal-sqlite-7.34-1.mga4
>
>Test with mysql :
>- - - - - - - -
>
># systemctl restart mysqld
># systemctl restart httpd
>
>Browse to http://localhost/drupal
>
>You should find the site previously set. Make some alterations (edit, delete articles, etc.). Log out and close window.
>
>$ mysql -p
>MariaDB [(none)]> drop user 'drupaluser'@'localhost';
>MariaDB [(none)]> drop database drupaltest;
>MariaDB [(none)]> exit;
>
>Reproduce the previous procedure with mysql done with current package.
>
>When finished close window.
>
>Drop database and user :
>
>$ mysql -p
>MariaDB [(none)]> drop user 'drupaluser'@'localhost';
>MariaDB [(none)]> drop database drupaltest;
>MariaDB [(none)]> exit;
>
>
>Test with postgresql :
>- - - - - - - - - - 
>
>Check version of lib64pq was installed with drupal.
>Install matching postgresql-server (eg : postgresql9.3-server)
>
># service postgresql start
>
>Create a postgreql database :
># su - postgres
>[postgres@localhost ~]$ createuser --pwprompt --encrypted --no-adduser drupaluser
>Enter password for new role: 
>Enter it again: 
>[postgres@localhost ~]$ createdb --encoding=UNICODE --template=template0 --owner=drupaluser drupaltest
>[postgres@localhost ~]$ exit
>logout
>[root@localhost sites]#
>
>
># cd /usr/share/drupal
># cp sites/default/default.settings.php sites/default/settings.php
># chmod a+w sites/default/settings.php
># chmod a+w sites/default
>
>Browse to http://localhost/drupal
>When setting drupal, check postgresql database type.
>
>When done, change permissions on sites/default and sites/default/settings.php :
># chmod 644 sites/default/settings.php
># cd sites
># chmod 755 default
>
>Browse to Reports/status report in Drupal menu to see if there is any problem.
>Set up a test site.
>
>When done, drop database and user :
># su - postgres
>[postgres@localhost ~]$ dropdb drupaltest
>[postgres@localhost ~]$ dropuser drupaluser
>[postgres@localhost ~]$ exit
>logout
>
>Test with sqlite :
>- - - - - - - - -
>
># cd /usr/share/drupal
># cp sites/default/default.settings.php sites/default/settings.php
># chmod a+w sites/default/settings.php
># chmod a+w sites/default
>
>When setting drupal, check SQlite database type.
>
>When done, change permissions on sites/default and sites/default/settings.php :
># chmod 644 sites/default/settings.php
># cd sites
># chmod 755 default
>
>Browse to Reports/status report in Drupal menu to see if there is any problem.
>Set up a test site.

Full drupal test procedure with 3 database types (Mysql, Postgresql, SQlite)

On current package :
------------------

- drupal-7.32-1.mga4.noarch
- drupal-mysql-7.32-1.mga4.noarch
- drupal-postgresql-7.32-1.mga4.noarch
- drupal-sqlite-7.32-1.mga4.noarch


Test with mysql :
- - - - - - - -

$ mysql -u root -p
MariaDB [(none)]> create database drupaltest;
MariaDB [(none)]> create user 'drupaluser'@'localhost' identified by 'password';
MariaDB [(none)]> grant all on drupaltest.* to 'drupaluser'@'localhost';
MariaDB [(none)]> exit;

# cd /usr/share/drupal
# cp sites/default/default.settings.php sites/default/settings.php
# chmod a+w sites/default/settings.php
# chmod a+w sites/default


Browse to http://localhost/drupal 
When setting drupal, check mysql database type.
Set up database using database name, user and password previously set.

When warned, change permissions on sites/default and sites/default/settings.php :
# chmod 644 sites/default/settings.php
# cd sites
# chmod 755 default

In drupal menu, browse to Reports/status report, it will tell you if there is any issue.
Create a new site, add content, edit content, upload image in article, install a module, change appearance, log out, log in, etc.

Update to testing packages :
--------------------------
drupal-7.34-1.mga4
drupal-mysql-7.34-1.mga4
drupal-postgresql-7.34-1.mga4
drupal-sqlite-7.34-1.mga4

Test with mysql :
- - - - - - - -

# systemctl restart mysqld
# systemctl restart httpd

Browse to http://localhost/drupal

You should find the site previously set. Make some alterations (edit, delete articles, etc.). Log out and close window.

$ mysql -p
MariaDB [(none)]> drop user 'drupaluser'@'localhost';
MariaDB [(none)]> drop database drupaltest;
MariaDB [(none)]> exit;

Reproduce the previous procedure with mysql done with current package.

When finished close window.

Drop database and user :

$ mysql -p
MariaDB [(none)]> drop user 'drupaluser'@'localhost';
MariaDB [(none)]> drop database drupaltest;
MariaDB [(none)]> exit;


Test with postgresql :
- - - - - - - - - - 

Check version of lib64pq was installed with drupal.
Install matching postgresql-server (eg : postgresql9.3-server)

# service postgresql start

Create a postgreql database :
# su - postgres
[postgres@localhost ~]$ createuser --pwprompt --encrypted --no-adduser drupaluser
Enter password for new role: 
Enter it again: 
[postgres@localhost ~]$ createdb --encoding=UNICODE --template=template0 --owner=drupaluser drupaltest
[postgres@localhost ~]$ exit
logout
[root@localhost sites]#


# cd /usr/share/drupal
# cp sites/default/default.settings.php sites/default/settings.php
# chmod a+w sites/default/settings.php
# chmod a+w sites/default

Browse to http://localhost/drupal
When setting drupal, check postgresql database type.

When done, change permissions on sites/default and sites/default/settings.php :
# chmod 644 sites/default/settings.php
# cd sites
# chmod 755 default

Browse to Reports/status report in Drupal menu to see if there is any problem.
Set up a test site.

When done, drop database and user :
# su - postgres
[postgres@localhost ~]$ dropdb drupaltest
[postgres@localhost ~]$ dropuser drupaluser
[postgres@localhost ~]$ exit
logout

Test with sqlite :
- - - - - - - - -

# cd /usr/share/drupal
# cp sites/default/default.settings.php sites/default/settings.php
# chmod a+w sites/default/settings.php
# chmod a+w sites/default

When setting drupal, check SQlite database type.

When done, change permissions on sites/default and sites/default/settings.php :
# chmod 644 sites/default/settings.php
# cd sites
# chmod 755 default

Browse to Reports/status report in Drupal menu to see if there is any problem.
Set up a test site.

Actions: View

Attachments on bug 14614: 5634