(adding @users back, please keep the list in your replies) So, with the persistent template, you need a Persistent Volume so the created MySQL pod has a place to store database files. See [1] for an overview, there's also a link in there for e.g. NFS. For MySQL persistent template [2] the minimum required capacity is 512 MiB. This could probably be even lower for some small deployments and you can set the $VOLUME_CAPACITY when instantiating the persistent template. When creating a PV, you must make sure the specified capacity is 512 MiB or higher.
[1] https://docs.openshift.org/latest/architecture/additional_concepts/storage.html [2] https://github.com/openshift/origin/blob/master/examples/db-templates/mysql-persistent-template.json#L187 On Thu, Jan 14, 2016 at 3:40 PM, Candide Kemmler <[email protected]> wrote: > I instantiated the plugin from the web UI. > > Sorry I killed that one. Trying the persistent one, here's what I get: > > 3:35:48 PMmysql-1-q1cm3PodFailedSyncError syncing pod, skipping: failed > to instantiate volume plugin for mysql-data: The claim mysql is not yet > bound to a volume (7 times in the last 52 seconds)3:35:48 PMmysql-1-q1cm3 > PodFailedMountUnable to mount volumes for pod "mysql-1-q1cm3_test": > failed to instantiate volume plugin for mysql-data: The claim mysql is not > yet bound to a volume (7 times in the last 52 seconds) > This is for the new one: > > # pods mysql-1-080py, container mysql > MYSQL_USER=intrinsic > MYSQL_PASSWORD=intrinsic > MYSQL_DATABASE=intrinsic > > OK great thanks! > > So my problem now is to get pesistence to work for mysql. > > On 14 Jan 2016, at 15:35, Martin Nagy <[email protected]> wrote: > > Well, they should be autofilled if you used the persistent/ephemeral > template. Let's see the environment: > oc env pod/mysql-1-0kkx6 --list > > Also, how did you instantiate the template? What command did you run? > > On Thu, Jan 14, 2016 at 3:30 PM, Candide Kemmler <[email protected]> > wrote: > >> OK thanks. Here's what it says: >> >> mbcandide:~ candide$ oc logs -p mysql-1-0kkx6 >> You must either specify the following environment variables: >> MYSQL_USER (regex: '^[a-zA-Z0-9_]+$') >> MYSQL_PASSWORD (regex: '^[a-zA-Z0-9_~!@#$%^&*()-=<>,.?;:|]+$') >> MYSQL_DATABASE (regex: '^[a-zA-Z0-9_]+$') >> Or the following environment variable: >> MYSQL_ROOT_PASSWORD (regex: '^[a-zA-Z0-9_~!@#$%^&*()-=<>,.?;:|]+$') >> Or both. >> Optional Settings: >> MYSQL_LOWER_CASE_TABLE_NAMES (default: 0) >> MYSQL_MAX_CONNECTIONS (default: 151) >> MYSQL_FT_MIN_WORD_LEN (default: 4) >> MYSQL_FT_MAX_WORD_LEN (default: 20) >> MYSQL_AIO (default: 1) >> >> I'm pretty sure I specified all the required parameters >> user: root >> password: letmein >> database: intrinsic >> >> On 14 Jan 2016, at 15:18, Martin Nagy <[email protected]> wrote: >> >> Hi, >> something is likely wrong with the MySQL since it is restarting. Can you >> show us your logs from the container? You can get logs from the last >> container by 'oc logs -p mysql-1-0kkx6' >> >> On Thu, Jan 14, 2016 at 3:03 PM, Candide Kemmler <[email protected] >> > wrote: >> >>> Hi, >>> >>> I created my own cluster using ansible (full install log here >>> <https://www.evernote.com/l/ACjvdVhtZ_pAZaJAtgVQJPn51-hS8huMVaI>). >>> Everything seems to be working fine except I can't seem to launch a mysql >>> server. I tried both mysql-persistent and -ephemeral. In both cases I will >>> end up having one pod showing and "flashing" from blue to orange and >>> vice-versa. >>> >>> Here's the log from my latest attempt at installing mysql-ephemeral on >>> my test environment. Is there a way that I can access more verbose logs? >>> This isn't nearly enough to understand a malfunction like this. >>> >>> Candide >>> >>> TimeNameKindReasonMessage3:01:19 PMmysql-1-0kkx6PodBackoffBack-off >>> restarting failed docker container (17 times in the last 3 minutes, 20 >>> seconds)3:00:59 PMmysql-1-0kkx6PodPulledContainer image " >>> docker.io/centos/mysql-56-centos7@sha256:6d8562ea408b2f674b735b4e78550934b26c4913bb2e61757aa749008cee0cb8" >>> already present on machine (6 times in the last 3 minutes, 16 >>> seconds)3:00:59 >>> PMmysql-1-0kkx6PodStartedStarted with docker id 692e580331fe3:00:59 PM >>> mysql-1-0kkx6PodCreatedCreated with docker id 692e580331fe2:59:29 PM >>> mysql-1-0kkx6PodStartedStarted with docker id 2a3db4ea71a52:59:29 PM >>> mysql-1-0kkx6PodCreatedCreated with docker id 2a3db4ea71a52:58:39 PM >>> mysql-1-0kkx6PodCreatedCreated with docker id 97173a0da91c2:58:39 PM >>> mysql-1-0kkx6PodStartedStarted with docker id 97173a0da91c2:58:09 PM >>> mysql-1-0kkx6PodStartedStarted with docker id 9a8fac130fe62:58:09 PM >>> mysql-1-0kkx6PodCreatedCreated with docker id 9a8fac130fe62:57:50 PM >>> mysql-1-0kkx6PodStartedStarted with docker id 0874ac6c4ae62:57:50 PM >>> mysql-1-0kkx6PodCreatedCreated with docker id 0874ac6c4ae62:57:49 PM >>> mysql-1-deployPodFailedSyncError syncing pod, skipping: failed to >>> delete containers ([exit status 1])2:57:49 PMmysql-1-deployPodKillingKilling >>> with docker id b410bb3266f32:57:44 PMmysql-1-0kkx6PodStartedStarted >>> with docker id 24df27c8eda02:57:44 PMmysql-1-0kkx6PodCreatedCreated >>> with docker id 24df27c8eda02:57:43 PMmysql-1-0kkx6PodScheduledSuccessfully >>> assigned mysql-1-0kkx6 to apps.intrinsic.world2:57:43 PMmysql-1 >>> ReplicationControllerSuccessfulCreateCreated pod: mysql-1-0kkx62:57:43 >>> PMmysql-1-0kkx6PodStartedStarted with docker id 75267e329dac2:57:43 PM >>> mysql-1-0kkx6PodCreatedCreated with docker id 75267e329dac2:57:42 PM >>> mysql-1-0kkx6PodPulledContainer image "openshift/origin-pod:v1.1.0.1" >>> already present on machine2:57:41 PMmysql-1ReplicationController >>> FailedUpdateError updating deployment test/mysql-1 status to Pending2:57:41 >>> PMmysql-1-deployPodStartedStarted with docker id cd9b442846842:57:41 PM >>> mysql-1-deployPodScheduledSuccessfully assigned mysql-1-deploy to >>> apps.intrinsic.world2:57:41 PMmysql-1-deployPodCreatedCreated with >>> docker id cd9b442846842:57:40 PMmysql-1-deployPodPulledContainer image >>> "openshift/origin-deployer:v1.1.0.1" already present on machine2:57:40 >>> PMmysql-1-deployPodStartedStarted with docker id b410bb3266f32:57:40 PM >>> mysql-1-deployPodCreatedCreated with docker id b410bb3266f32:57:39 PM >>> mysql-1-deployPodPulledContainer image "openshift/origin-pod:v1.1.0.1" >>> already present on machine >>> >>> >>> _______________________________________________ >>> users mailing list >>> [email protected] >>> http://lists.openshift.redhat.com/openshiftmm/listinfo/users >>> >>> >> >> > >
_______________________________________________ users mailing list [email protected] http://lists.openshift.redhat.com/openshiftmm/listinfo/users
