ha! but as shown above it no longer seems to do it anymore or i would not be having all this trouble.
the database is obviously not being created.
i am creating the database as root and have also tried as theowner of the domain - makes no difference the database is not crreated.
i have wasted all weekend on this and the client will expect it running tomorrow - so a transfer to a new VM is getting to be the only solution