issue after installing Mariadb Enterprise edition

Thu May 26 12:43:58 UTC 2016

Hi

Thanks for earlier  information. I have below issue : 

1)
After Installing Mariadb Enterprise edition on to power 8 machine from 
charm store, I am trying to install any layer charm from charm store on 
the same machine as I have dependency with mariadb, I am getting error 
:Failed to fetch 
http://ftp.osuosl.org/pub/mariadb/repo/10.0/ubuntu/dists/trusty/InRelease 
Unable to find expected entry 'main/binary-ppc64el/Packages' in Release 
file (Wrong sources.list entry or malformed file)

2)After I got the above error I tried to follow the steps given in link: 
http://bazaar.launchpad.net/~dbart/charms/trusty/mariadb/trunk/view/head:/README.md#L24 
 and used the mariadb code from lp:~dbart/charms/trusty/mariadb/trunk  or 
directly deploying from charm store, I am getting token error KeyError: 
'token , I have taken token from https://mariadb.com/my_portal

Attached log for 

Please help me in fixing above issue 

Rajith

IBM AIX Certified, OCPCertified
____________________________________

Cell- 9901966577
Email: rajith.pv at in.ibm.com

From:   Daniel Bartholomew <dbart at mariadb.com>
To:     Kevin Monroe <kevin.monroe at canonical.com>
Cc:     Rajith P Venkata/India/IBM at IBMIN, juju <juju at lists.ubuntu.com>, 
Mark Shuttleworth <mark at ubuntu.com>
Date:   25-05-16 04:09 AM
Subject:        Re: information needed for Mariadb Enterprise edition

On Thu, May 19, 2016 at 7:46 PM, Kevin Monroe
<kevin.monroe at canonical.com> wrote:
> I recently took a look at the mariadb charm on ppc64le and ran across 
some
> interesting bits.  I'm looping in the charm maintainer (dbart) for extra
> insights.
>
> First, MariaDB has both enterprise and community versions available for 
this
> charm to deploy.  Rajith, as you saw in the readme, you should be able 
to
> obtain credentials from the MariaDB Portal
> (https://mariadb.com/user/login?destination=my_portal/download
>
> ).  However, there was a recent change in the package signing key [0] 
that
> may affect installation.  Daniel, are these "enterprise.yaml" creation
> instructions in the charm readme still valid?:
>
> 
http://bazaar.launchpad.net/~charmers/charms/trusty/mariadb/trunk/view/head:/README.md#L46

>

No. Those are old instructions. I submitted an updated version of the
charm way back in November, but it looks like it never made it into
the charm store. As a first step, the version of the charm currently
in my repo (revision 28) should immediately be pushed to the charm
store: lp:~dbart/charms/trusty/mariadb/trunk

The correct readme is here:

http://bazaar.launchpad.net/~dbart/charms/trusty/mariadb/trunk/view/head:/README.md#L24

...but the instructions there won't work unless the charm in the store
is updated.

> Second, line 382 of Rajith's log (http://paste.ubuntu.com/16514402/) 
shows that if the configured repo is ignored, the charm will continue to
> install mariadb-[server|client] from the trusty archives.  This will put
> mariadb-5.x on the unit, which may or may not be intended.  Perhaps the
> charm should warn the user if mariadb is installed from a location other
> than the configured repo?

A warning is something that could be added. In the log the configured
repo is ignored because it is trying to use the MariaDB repositories
(not the MariaDB Enterprise repositories). Only the MariaDB Enterprise
repositories have packages for the POWER8 architecture.

> Third, I was able to reproduce the behavior seen in Rajith's log where
> mariadb did not start successfully.  I think the default dataset-size
> configuration is too aggressive in some scenarios.  I've opened a bug 
[1] to
> track this.

It could be that the version of MariaDB in the Ubuntu repositories is
what is at fault here. It's the older 5.5 version, whereas the MariaDB
Enterprise version is 10.0. That said, I can definitely make the
change to the default config in the charm.

> Rajith, I know you specifically asked about the enterprise edition, and
> hopefully Daniel will be able to assist there.  That said, I have 
verified
> the community edition works when deploying from the charm store to a 
ppc64le
> container.  Let me know if I can be of any help to get that running in 
your
> environment.
>
> [0] https://jira.mariadb.org/browse/MDEV-9781

This MDEV is a red herring. It has no bearing on MariaDB Enterprise
and only affects MariaDB for Xenial and Debian Sid.

> [1] https://bugs.launchpad.net/charms/+source/mariadb/+bug/1583834

As mentioned above, assuming the default mem config is to blame, this
bug is simple to solve. I'll add the fix to the current update I'm
working on.

And speaking of updates, I'm working on an updated version of the
charm that installs the latest MariaDB from the community
repositories, including for POWER8, and only attempts to install
MariaDB Enterprise if the enterprise.yaml file is in place and called
during the deploy step.

Thanks.

> On Thu, May 19, 2016 at 8:01 AM, Mark Shuttleworth <mark at ubuntu.com> 
wrote:
>>
>>
>> Looks like MariaDB have an enterprise version which requires you to 
agree
>> to their terms and download the software from them using a private 
password
>> dedicated to you.
>>
>> This might be related to specific config settings (i.e. if you've told 
the
>> charm to use an enterprise version) or it may just be the default 
behaviour
>> of that charm.
>>
>> We are working towards a simpler mechanism to handle this sort of use
>> case, will ask that MariaDB try that instead.
>>
>> Mark
>>
>>
>> On 19/05/16 03:10, Rajith P Venkata wrote:
>>
>> Hi
>> I am installing Mariadb Enterprise edition by following below steps 
from
>> charm store, I am getting hook fail error,
>>
>>
>> Obtain a username/password from the MariaDB Portal and you will then 
have
>> access to the MariaDB Enterprise repository.
>> Next create a file called enterprise.yaml with the following contents,
>> replacing username:password with your actual username and password:
>>         mariadb:
>>           enterprise-eula: true
>>           key: 0xd324876ebe6a595f
>>           source: "deb 
https://username:password@code.mariadb.com/mariadb-enterprise/10.0/repo/ubuntu 
trusty main"

>> Lastly, deploy MariaDB as normal but with the addition of the yaml file
>>         juju deploy --config ./enterprise.yaml mariadb
>>
>>
>>  please let me know steps for getting username and password .  Is 
username
>> and password same as site username and password.

-- 
Daniel Bartholomew, MariaDB Release Manager
MariaDB | http://mariadb.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.ubuntu.com/archives/juju/attachments/20160526/e1396adf/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: unit-mariadb-0.log
Type: application/octet-stream
Size: 35098 bytes
Desc: not available
URL: <https://lists.ubuntu.com/archives/juju/attachments/20160526/e1396adf/attachment.obj>