Gavin,
I ran into this (or something of the ilk) — I understood a fix was in
the works.
Firstly,
grep MYSQL_PW /var/svc/log/system-zoneinit\:default.log
Should help you find what the password is now.
Secondly, as you see from this redacted working example that you may
need use internal_metadata:
{
"brand": "joyent",
"image_uuid": "c95ba4f2-8546-11e4-97b5-0b9bb0bc4227",
"alias": "rails",
"hostname": "rails",
"max_physical_memory": 2048,
"quota": 200,
"resolvers": ["8.8.8.8", "8.8.4.4"],
"customer_metadata":{"mysql_pw":"********"},
"internal_metadata":{"mysql_pw":"*******"},
"nics": [
{
"nic_tag": "external",
"ip": "172.16.1.28",
"netmask": "255.255.255.0",
"gateway": "172.16.1.1"
}
]
}
Thank You,
Will
On 5/7/15 3:39 AM, Gavin Ang wrote:
Hi,
I’m trying to work with the Joyent SmartOS image that comes bundled
with Mysql Cluster. Firstly trying to get the basic mysqld working, I
could start mysql, but then couldn’t log in.
According to the documentation, I need to set the password while
provisioning, so I have included this in the json:
"customer_metadata": {
"mysql_password": "xxxxxx"
},
Which I verified using vmadm get $uuid
But when I login to the instance and try to access mysql using
[root@e3f9cb38-6af7-4f1d-b719-c414ebedb0b0 ~]# mysql -uroot
-p$(mdata-get mysql_pw)
No metadata for 'mysql_pw'
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES)
How can I get round this. Can’t even stop the DB now.
Thanks,
Gavin
*smartos-discuss* | Archives
<https://www.listbox.com/member/archive/184463/=now>
<https://www.listbox.com/member/archive/rss/184463/26368559-ba231e1c>
| Modify
<https://www.listbox.com/member/?&;>
Your Subscription [Powered by Listbox] <http://www.listbox.com>
-------------------------------------------
smartos-discuss
Archives: https://www.listbox.com/member/archive/184463/=now
RSS Feed: https://www.listbox.com/member/archive/rss/184463/25769125-55cfbc00
Modify Your Subscription:
https://www.listbox.com/member/?member_id=25769125&id_secret=25769125-7688e9fb
Powered by Listbox: http://www.listbox.com
