SME8.0 QA

Version 8.0 testing

This document lists tests that we need to do to get version 8.0 closer to a final release. It's an attempt to invite as many testers as possible and to coordinate our testing work.

The document should be used as Work In Progress so please feel free to add additional test scenarios and comments

All tests here should be based on the currently available version 8.0 beta 4 (09/2009). (+ updates available in yum possibly including enablerepo=smeupdates-testing ?)

In general

• check the related logfile(s) for each test
• don't hesitate to raise a bug if there is an issue or something suspicious but check the Bugtracker before whether this might already be reported
• A list of currently reported bugs for SME 8.0 is here: bugzilla matrix

Test guidelines

The purpose of the page is mostly to verify features are working, you can list a bug number if you like but we don't intend to duplicate the tracking provided by bugzilla:

Executive Summary

In general almost everything works as well as in SME 7

Obvious bugs are

USB Backup, backup code needs tweaking before USB Disks can be mounted

...

Verification

Create a test environment, either virtually or with spare hardware. Install the latest release, add some test users/ibays/domains/websites, send some internal e-mails, copy some files to/from ibays, perform a backup and restore. Perform as many functions that you can based on your knowledge and test environment abilities. Play. :)

The scenario's should be as complex as needed, but also as simple as possible, testing one unique feature where possible.

For instance creating an ibay could mean something like this, perhaps even incomplete as I am doing this from the top of my head:

• log in in server-manager
• create ibay
• test for directory created (-f /home/e-smith/ibays/ibayname)
• check for account (ibayname) created
• check for group (ibayname) created
• anaylze log for errors/exceptions

but also (and that is the most work mostly) test exceptions (names too long, starting with a number, containing a _, as well as all other exceptions):

• log in in server-manager
• create ibay with invalid name
• check the error in the server-manager screen
• check no account (ibayname) is created
• check no group (ibayname) is created
• check that the error is present in the log file

Header codes

Check one feature at a time and add comments. We will use a shorthand in the header line so we can check progress quickly

• header x - unchecked
• header ? - questions, or more to do
• header bug - there is a bug
• header - blank means the section has passed

Installation

Installation types

Different installation scenarios re. software RAID, LVM and NOSPARE usage, etc.

to check: /var/log/messages; server-console, item 5; cat /proc/mdstat (which is the same as server-console, item 5;)

• RAID1 nolvm spares=2 - Pass

Comments:

• RAID1 "nolvm" - Pass

Comments: Installation was RAID1, nolvm with one physical disk only; adding second disk still to be tested

• RAID5 (with lvm) spares=0 - Pass

Comments:

• RAID5 nolvm spares=2 - Pass

Comments:

• RAID6 (with lvm) spare=1 multipart - Pass

Comments:

• RAIDx "nolvm"

Comments:

Upgrading x

Upgrade from older versions ?

to check: /var/log/messages

From 7.4

CD upgrade from a clean SME7.4 installation to SME8b4.

The message as below in /var/log/messages can be safely ignored, see: bugzilla:5486:

 Sep 24 00:22:18 sme74clean mysql.init: ERROR 1060 (42S21) at line 75: Duplicate column name 'File_priv'
 Sep 24 00:22:18 sme74clean mysql.init: ERROR 1060 (42S21) at line 81: Duplicate column name 'Grant_priv'
 Sep 24 00:22:18 sme74clean mysql.init: ERROR 1060 (42S21) at line 82: Duplicate column name 'Grant_priv'
 Sep 24 00:22:18 sme74clean mysql.init: ERROR 1060 (42S21) at line 83: Duplicate column name 'Grant_priv'
 Sep 24 00:22:18 sme74clean mysql.init: ERROR 1060 (42S21) at line 94: Duplicate column name 'ssl_type'
 Sep 24 00:22:18 sme74clean mysql.init: ERROR 1061 (42000) at line 105: Duplicate key name 'Grantor'
 Sep 24 00:22:19 sme74clean mysql.init: ERROR 1054 (42S22) at line 131: Unknown column 'Type' in 'columns_priv'
 Sep 24 00:22:19 sme74clean mysql.init: ERROR 1060 (42S21) at line 153: Duplicate column name 'type'
 Sep 24 00:22:19 sme74clean mysql.init: ERROR 1060 (42S21) at line 163: Duplicate column name 'Show_db_priv'
 Sep 24 00:22:19 sme74clean mysql.init: ERROR 1060 (42S21) at line 180: Duplicate column name 'max_questions'
 Sep 24 00:22:19 sme74clean mysql.init: ERROR 1060 (42S21) at line 190: Duplicate column name 'Create_tmp_table_priv'
 Sep 24 00:22:19 sme74clean mysql.init: ERROR 1060 (42S21) at line 193: Duplicate column name 'Create_tmp_table_priv'
 Sep 24 00:22:20 sme74clean mysql.init: ERROR 1054 (42S22) at line 282: Unknown column 'Create_view_priv' in 'where clause'
 Sep 24 00:22:22 sme74clean mysql.init: ERROR 1054 (42S22) at line 317: Unknown column 'Create_routine_priv' in 'where clause'
 Sep 24 00:22:24 sme74clean mysql.init: ERROR 1054 (42S22) at line 366: Unknown column 'Create_user_priv' in 'where clause'
 Sep 24 00:22:25 sme74clean mysql.init: ERROR 1060 (42S21) at line 386: Duplicate column name 'Routine_type'

/root/upgrade.log :

• For db4 error(22): bugzilla:5489
• For No module mptscsi found: bugzilla:5490
• For PHP Warning: PHP Startup: Unable to load dynamic library: bugzilla:5491

 Upgrading openldap-servers-2.3.43-3.el5.i386
 rpmdb: Program version 4.2 doesn't match environment version
 error: db4 error(22) from dbenv->open: Invalid argument
 error: cannot open Packages index using db3 - Invalid argument (22)
 error: cannot open Packages database in /var/lib/rpm
 warning: /etc/openldap/slapd.conf created as /etc/openldap/slapd.conf.rpmnew
 Upgrading m2crypto-0.16-6.el5.3.i386
 
 Upgrading kernel-PAE-2.6.18-128.1.14.el5.i686
 WARNING: No module mptscsi found for kernel 2.6.18-128.1.14.el5PAE, continuing anyway
 
 PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/domxml.so' - /usr/lib/php/modules/domxml.so: cannot open shared object file: No such file or directory in Unknown on line 0
 Upgrading php-pear-DB-1.7.13-1.el5.centos.noarch
 PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/domxml.so' - /usr/lib/php/modules/domxml.so: cannot open shared object file: No such file or directory in Unknown on line 0
 Upgrading php-pear-HTTP-1.4.0-7.el5.noarch
 PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/domxml.so' - /usr/lib/php/modules/domxml.so: cannot open shared object file: No such file or directory in Unknown on line 0
 Upgrading php-pear-File-1.2.2-1.el5.centos.noarch
 PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/domxml.so' - /usr/lib/php/modules/domxml.so: cannot open shared object file: No such file or directory in Unknown on line 0
 Upgrading php-pear-Date-1.4.7-2.el5.centos.noarch
 PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/domxml.so' - /usr/lib/php/modules/domxml.so: cannot open shared object file: No such file or directory in Unknown on line 0
 Upgrading php-pear-Net-URL-1.0.15-1.el5.centos.noarch
 PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/domxml.so' - /usr/lib/php/modules/domxml.so: cannot open shared object file: No such file or directory in Unknown on line 0
 Upgrading php-pear-HTTP-Request-1.4.2-1.el5.centos.noarch
 PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/domxml.so' - /usr/lib/php/modules/domxml.so: cannot open shared object file: No such file or directory in Unknown on line 0
 Upgrading php-pear-Cache-1.5.5-0.1.RC4.fc6.1.noarch
 PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/domxml.so' - /usr/lib/php/modules/domxml.so: cannot open shared object file: No such file or directory in Unknown on line 0
 Upgrading php-pear-Net-FTP-1.3.4-1.el5.noarch
 PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/domxml.so' - /usr/lib/php/modules/domxml.so: cannot open shared object file: No such file or directory in Unknown on line 0
 Upgrading php-pear-MDB2-2.4.1-2.el5.centos.noarch
 PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/domxml.so' - /usr/lib/php/modules/domxml.so: cannot open shared object file: No such file or directory in Unknown on line 0
 Upgrading php-pear-Log-1.9.13-1.el5.centos.noarch
 PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/domxml.so' - /usr/lib/php/modules/domxml.so: cannot open shared object file: No such file or directory in Unknown on line 0
 Upgrading php-pear-Mail-Mime-1.4.0-1.el5.centos.noarch
 PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/domxml.so' - /usr/lib/php/modules/domxml.so: cannot open shared object file: No such file or directory in Unknown on line 0
 Upgrading php-pear-Net-DIME-1.0.1-1.el5.noarch
 PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/domxml.so' - /usr/lib/php/modules/domxml.so: cannot open shared object file: No such file or directory in Unknown on line 0
 Upgrading php-pear-XML-Util-1.1.4-3.el5.noarch
 PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/domxml.so' - /usr/lib/php/modules/domxml.so: cannot open shared object file: No such file or directory in Unknown on line 0
 Upgrading php-pear-XML-Parser-1.2.8-1.el5.noarch
 PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/domxml.so' - /usr/lib/php/modules/domxml.so: cannot open shared object file: No such file or directory in Unknown on line 0
 Upgrading php-pear-XML-Serializer-0.18.0-3.el5.noarch
 PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/domxml.so' - /usr/lib/php/modules/domxml.so: cannot open shared object file: No such file or directory in Unknown on line 0
 Upgrading php-pear-Auth-SASL-1.0.2-4.el5.centos.noarch
 PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/domxml.so' - /usr/lib/php/modules/domxml.so: cannot open shared object file: No such file or directory in Unknown on line 0
 Upgrading php-pear-Net-SMTP-1.2.10-1.el5.centos.noarch
 PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/domxml.so' - /usr/lib/php/modules/domxml.so: cannot open shared object file: No such file or directory in Unknown on line 0
 Upgrading php-pear-Mail-1.1.14-1.el5.centos.noarch
 PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/domxml.so' - /usr/lib/php/modules/domxml.so: cannot open shared object file: No such file or directory in Unknown on line 0
 Upgrading php-pear-SOAP-0.11.0-2.el5.noarch
 PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/domxml.so' - /usr/lib/php/modules/domxml.so: cannot open shared object file: No such file or directory in Unknown on line 0
 Upgrading php-pear-Services-Weather-1.4.2-1.fc6.noarch
 PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/domxml.so' - /usr/lib/php/modules/domxml.so: cannot open shared object file: No such file or directory in Unknown on line 0
 
 pgrading kernel-2.6.18-128.1.14.el5.i686
 WARNING: No module mptscsi found for kernel 2.6.18-128.1.14.el5, continuing anyway

Console ?

• cosmetic bug 3561

briefly displays 'Could not open pci table...'

Check Status

Pass - the server displays 'This sever has been running for ...'

Configure Server ?

basic configuration works, eg NIC's, password, host and domain names

DHCP server

• test IP allocation - Pass

for predefined MAC addresses (= 'static' IP allocation)

for dynamic IPs

Server-gateway

• Pass

Comments: Running as gateway behind broadband router with static IP for several weeks; all sorts of incoming connections tested (email, ssh, webmail, server-manager access) successfully, also outgoing traffic from various PCs (Windows, Linux) on LAN

Server-only

Comments:

Comments: Both scenarios tested

Test internet

• Pass - Prompt displays, then 'The test was successful...'

Reboot

• Pass for each of

reboot

reconfigure

shutdown

Raid

• pass

console, option 5, displays correctly for single disk

displays correctly for various RAID scenarios, all those combinations which we tested under SME8.0_QA#Installation_types

another disk added to a one disk system, open console, option 5, prompted to add drive, drive added, option 5 states all drives in clean state.

Access Server Manger

• Pass - server-manager displays and navigation works

View Support

• Pass, The GPL text displays

Backup to USB -bug

see bug 4809

console restore fixed,

console backup to do

server-manager backup to usb still to do

Server Manager ?

Collaboration ?

Users

• create new user account - PASS
• reset user password - Pass

Comments: server-manager message OK, eventlog check OK

• lock/unlock account - Pass

Comments: both activities checked; server-manager messages OK, eventlog check OK

• add/remove user to different groups - Pass

Comments: added user to various other groups and later removed from all of these groups

• delete user account - Pass
• re create deleted user account - PASS
• reset user password user account - Pass

Groups

Add, modify and remove groups - PASS

Quotas

• Setting quota (soft:10MB / hard: 20MB) and going over hard limit works: -PASS

 # dd if=/dev/zero of=/mnt/user-a/user-a_21MB bs=22020096 count=1
 1+0 records in
 1+0 records out
 dd: closing output file `/mnt/user-a/user-a_21MB': No space left on device

• Setting quota (soft:20MB / hard: 40MB) and going over soft limit works: -PASS

 To: User B <user-b@testdomain.lan>
 From: "Automated quota report" <do-not-reply@testdomain.lan>
 Subject: You have exceeded your disk quota
 
 Your current disk usage: 21.08 Mb
 Your maximum usage: 40.00 Mb
 Warnings start at: 20.00 Mb
 Grace period ends: Fri Oct  2 09:06:22 2009
 System name: sme8b4clean

Pseudonyms

• Pass

created a pseudonym jane to sent to usera

created a pseudonym jane@test.org to userb

sent mail to both which was received as expected

Information Bays x

User access via file sharing

basic smb file access working as expected. Permissions checked (smb) with several groups, users and all permission-combinations

Public access via web ?

• Primary website access tested form public Internet. If not configured, the default (".. under construction ..") works.
• Ibay accessible for http(s) from outside network without password - PASS
• Ibay accessible for http(s) from outside network with a password -NEEDS TESTING
• Ibay accessible for http(s) from local network without password and outside network with a pass -NEEDS TESTING

Local access via web

• Primary website accessible for http(s) from the local network -PASS

• Ibay not accessible for http(s) from local network when set to 'No Access' -PASS
• Ibay accessible for http(s) from local network without password -PASS
• Ibay accessible for http(s) from local network with a password -PASS

/var/log/httpd/error_log (Bug #5492):

 [Thu Sep 24 22:45:56 2009] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
 [Thu Sep 24 22:45:56 2009] [warn] RSA server certificate CommonName (CN) `sme8b4clean.testdomain.lan' does NOT match server name!?

Local access via ftp

• Primary & ibay not accessible when ftp set to 'No Access' -PASS
• Primary ibay accessible anonymous for download, not upload -PASS
• Ibay (no password required) accessible anonymous without password for download, not upload -PASS
• Ibay (password required) accessible anonymous only with password for download, not upload -PASS

• User homedir accessible with username+pass for download and upload -PASS
• Ibay accessible with username+pass for download and upload (with ibay permissions correctly set) -PASS
• Ibay accessible with username+pass for download and not upload (with ibay permissions correctly set) -PASS
• Ibay not accessible with username+pass (with ibay permissions correctly set) -PASS

Dynamic content ?

• PHP scripts in Primary ibay are interpreted and displayed -PASS
• PHP scripts in ibay are/not interpreted and displayed when dynamic content is enabled/disabled -PASS

• CGI scripts (cgi-bin) -NEEDS TESTING

Administration x

Backup and restore x

Backup x

to desktop

a server with a small amount of data created a smeserver.tgz correctly

to workstation

• pass - tested a set of three to a cifs share

to usb disk -bug

bug 4809

Restore x

from desktop (console) -bug

Restoring from desktop via the console gives an: "No removable media or device found"
Possibly related to: Bug #4809 ??

from workstation

• pass - tested a set of three to a cifs share, with verification

View log files

view log files works, including filtering and highlighting

download logfile works

Mail log files

local mail delivery is reported

external mail delivery is tested (ongoing use for a 'production' home server) and email logs are OK

Reboot and shutdown

• Pass for each of

reboot

reconfigure

shutdown

Security x

Remote access x

VPN / PPTP

• Pass

Set a number of PPTP clients in server manager and test remote access (repeatedly)

SSH

• Pass - remote access from local network on port other than 22
• External user/password access denied (port 22 and other) when set to 'No access' or 'Local network' --PASS
• External user/password access allowed (port 22 and other) when set to 'Entire internet' --PASS
• External user/password access denied (port 22 and other) for root when 'allow administrative commandline' to 'No' --PASS
• External user/password access allowed (port 22 and other) for user (if configured) when 'administrative commandline' to 'No' --PASS
• External user/password access denied (port 22 and other) when 'allow standard password' set to 'No' -PASS
• External certificate access denied (port 22 and other) for root when 'administrative commandline' to 'No' and 'allow standard password' set to 'No' -PASS
• External certificate access allowed (port 22 and other) for root when 'administrative commandline' to 'Yes' and 'allow standard password' set to 'No' -PASS
• External certificate access allowed (port 22 and other) for user (if configured) when 'administrative commandline' to 'No' and 'allow standard password' set to 'No' -PASS
• External certificate access allowed (port 22 and other) for user (if configured) when 'administrative commandline' to 'Yes' and 'allow standard password' set to 'No' -PASS

FTP

• Ftp access allowed for Primary, ibays and users when access set to 'Allowe access ...' -PASS
• Ftp access refused for Primary, ibays and users when access set to 'No Access' -PASS

Port forwarding

server gateway - PASS

Tested successfully with port 3389 (RDP) to WIndows terminal server on LAN

server only - pass

"This server is currently in serveronly mode and portforwarding is not possible."

Proxy settings ?

Web

net access via the squid proxy works

net access is disabled via squid proxy if disabled

Configuration ?

Software Installer

Updates

updates via the panel work

the updates available warning displays

Settings

Settings can be changed

Installing additional software works

Installing:
 wvdial               i386         1.54.0-5.2.2.1            base         131 k
Installing for dependencies:
 libwvstreams         i386         4.2.2-2.1                 base         657 k

and Removing

Removing:
 wvdial          i386          1.54.0-5.2.2.1          installed          264 k

Date and time

'Set Date and Time' manually works

'Configure Network Time Server' works, if you enter a valid time server

[a blank value for the time server reverts to manual date and time]

Workgroup ?

Domain controller

• PDC - setup Primary Domain Controller - Pass

Steps:

• join PC to domain (as user 'admin') and test domain user logon on that PC - Pass
• join (another) PC to domain (as a different user from group 'Domain Admins', NOT user admin) - Pass

Comments: The user 'michael' is part of that group:

db accounts show domain-admin-group 
domain-admin-group=group
   Description=Domain Admins
   Gid=5010
   Members=admin,michael
   Uid=5010

Comments: Here is a log extract from /var/log/messages for the latest join:

Aug 30 07:04:52 mdo002sv esmith::event[20711]: Running event handler: /etc/e-smith/events/machine-account-create/S10create-machine-account 
Aug 30 07:04:52 mdo002sv /etc/e-smith/events/machine-account-create/S10create-machine-account[20712]: /home/e-smith/db/accounts: OLD twt042lt$ (undefined) 
Aug 30 07:04:52 mdo002sv /etc/e-smith/events/machine-account-create/S10create-machine-account[20712]: /home/e-smith/db/accounts: NEW twt042lt$=machine 
Aug 30 07:04:52 mdo002sv esmith::event[20711]: create-machine-account twt042lt$: Creating Unix user and group  
Aug 30 07:04:52 mdo002sv esmith::event[20711]: create-machine-account twt042lt$: Locking account  
Aug 30 07:04:52 mdo002sv esmith::event[20711]: Locking password for user twt042lt$.  
Aug 30 07:04:52 mdo002sv esmith::event[20711]: passwd: Success  
Aug 30 07:04:52 mdo002sv esmith::event[20711]: S10create-machine-account=action|Event|machine-account-create|Action|S10create-machine-account|Start|1251572692 236608|End|1251572692 708624|Elapsed|0.472016 

• domain user password change via Ctrl-Alt-Del - Partially

Comments: Several combinations tested, incl. invalid combinations (e.g. password too short); successfully changed; case sensitivity tested; testing was done with the following setting in place:

db configuration show passwordstrength
passwordstrength=configuration
   Admin=none
   Ibays=none
   Users=none

Might need more testing with better password strength.

• Workgroup server ?

Comments:

Directory

Directory (LDAP) access - PASS

Test access from various email clients, list client, platform, Operating system, local and or external

- webmail (list address book contents via string like "mich" shows all Michael(s)) - PASS - Thunderbird LDAP test on local network - PASS

Printers

Attached/created LTP,USB and network printer; Printing test page:

• USB printer -PASS
• LTP printer -PASS
• Network printer -PASS

Hostnames

set a hostname to a remote server works

set a hostname to self works

set hostname for other host on the local network - passed (tested with several other hosts)

Domains ?

2nd domain added, web and email works

DNS options to be tested

Email ?

Access ?

• webmail works

• pop3(s)

Comments:

• imap(s) - Pass

Comments: Intensive, ongoing testing with imap & imaps access from LAN PCs and external

to check: /var/log/pop3(s)/current; /var/log/imap(s)/current

Antivirus

• Clam/email integration - Pass

to check: /var/log/qmail/current; /var/log/spamd/current; /var/log/qpsmtpd/current; /var/log/clamd/current; /var/log/clamd/smeserver-clamscan.log; email headers

Comments: Server runs in a semi production state - as a home server with various email accounts for family members (static IP, registered domain name). Have done regular checks for quite some time and there is nothing unusual or unexpected in all email logs. Incl. email header checks for spam recognition and filtering.

• regular Clam scans - Pass

enable regular scanning in server-manager and check results (email to admin)

Comments: Runs weekly without problems, emails to admin working.

Review

Basic server information is displayed

Miscellaneous

Support

The GPL text is displayed

Starter Website

Site created after entering text as prompted