Post ubuntu installation with LAMP default databases are not being created

[Neha Deo]

Milestone: Cosmic Daily
Product: Ubuntu Server amd64
Test case: Install (LAMP) in Ubuntu Server amd64 in Cosmic Daily (archived)

Description:
After Installing Ubuntu server amd64 with LAMP the default list of databases is not as expected.

ProblemType: Bug
DistroRelease: Ubuntu 18.10
Package: debian-installer (not installed)
ProcVersionSignature: Ubuntu 4.15.0-29.31-generic 4.15.18
Uname: Linux 4.15.0-29-generic x86_64
ApportVersion: 2.20.10-0ubuntu7
Architecture: amd64
Date: Fri Jul 27 09:36:29 2018
InstallationDate: Installed on 2018-07-26 (0 days ago)
InstallationMedia: Ubuntu-Server 18.10 "Cosmic Cuttlefish" - Alpha amd64 (20180726)
Lsusb:
 Bus 001 Device 001: ID 1d6b:0002 Linux Foundation 2.0 root hub
 Bus 002 Device 003: ID 0e0f:0002 VMware, Inc. Virtual USB Hub
 Bus 002 Device 002: ID 0e0f:0003 VMware, Inc. Virtual Mouse
 Bus 002 Device 001: ID 1d6b:0001 Linux Foundation 1.1 root hub
MachineType: VMware, Inc. VMware Virtual Platform
MemoryUsage:
 total used free shared buff/cache available
 Mem: 2160688 428972 1160024 2464 571692 1564824
 Swap: 969960 0 969960
ProcKernelCmdLine: BOOT_IMAGE=/boot/vmlinuz-4.15.0-29-generic root=UUID=d59e1db3-b3b7-4027-bd96-a9dd5c3d50c5 ro
SourcePackage: debian-installer
UpgradeStatus: No upgrade log present (probably fresh install)
dmi.bios.date: 07/02/2015
dmi.bios.vendor: Phoenix Technologies LTD
dmi.bios.version: 6.00
dmi.board.name: 440BX Desktop Reference Platform
dmi.board.vendor: Intel Corporation
dmi.board.version: None
dmi.chassis.asset.tag: No Asset Tag
dmi.chassis.type: 1
dmi.chassis.vendor: No Enclosure
dmi.chassis.version: N/A
dmi.modalias: dmi:bvnPhoenixTechnologiesLTD:bvr6.00:bd07/02/2015:svnVMware,Inc.:pnVMwareVirtualPlatform:pvrNone:rvnIntelCorporation:rn440BXDesktopReferencePlatform:rvrNone:cvnNoEnclosure:ct1:cvrN/A:
dmi.product.name: VMware Virtual Platform
dmi.product.version: None
dmi.sys.vendor: VMware, Inc.

[Ubuntu QA Website (ubuntuqa)]

This bug has been reported on the Ubuntu ISO testing tracker.

A list of all reports related to this bug can be found here:
http://iso.qa.ubuntu.com/qatracker/reports/bugs/1783931

[Brian Murray (brian-murray)]

This has to do with the mysql package not debian-installer.

[Andreas Hasenack (ahasenack)]

This is comparing the new output to the one from the test: https://pastebin.ubuntu.com/p/r4Ts5RwJj6/

The "test" database is gone, and there is a new "sys" db. The list of users is different too.

@racb, is it ok to update the test case with the new output, or is something indeed wrong?

[Andreas Hasenack (ahasenack)]

This is the current test: http://iso.qa.ubuntu.com/qatracker/milestones/390/builds/177932/testcases/1404/results

[Lars Tangvald (lars-tangvald)]

Hi,

This is expected, yes, and was changed from 5.6 to 5.7.

Test schema was removed because it was a potential security issue (https://blogs.oracle.com/jsmyth/the-test-database-and-security)

More can be seen about the sys schema here https://dev.mysql.com/doc/refman/5.7/en/sys-schema.html

[Christian Ehrhardt  (paelzer)]

@Powersj - given that this is "as intended" should we adapt the test to no more be a false positive in the future?
Actually where exactly would we edit the content of http://iso.qa.ubuntu.com/qatracker/testcases/1404/info ?

[Joshua Powers (powersj)]

This repo:

     bzr branch lp:ubuntu-manual-tests

Edit 'ubuntu-manual-tests/testcases/image/1404_Install (LAMP)'

This file:
https://bazaar.launchpad.net/~ubuntu-testcase/ubuntu-manual-tests/trunk/view/head:/testcases/image/1404_Install%20%28LAMP%29

[Joshua Powers (powersj)]

Adding ubuntu-manual-tests and marking invalid for mysql.

[Robie Basak (racb)]

Andreas' output for Cosmic in https://pastebin.ubuntu.com/p/r4Ts5RwJj6/ looks correct to me, so I think the right fix is to update the test case with the actual output Andreas found.