Obsolete Releases > SME 8.x Contribs

owncloud contrib mysql issue

(1/3) > >>

ghorst352:
I have tried getting the owncloud contrib to work however I cannot get past the following mysql commands:

myUser="put owncloud-admin usernamehere"
myPass="put password here"
mysql --execute="create database owncloud"
mysql --execute="grant all privileges on owncloud.* to $myUser@localhost identified by $myPass"
mysql --execute="flush privileges"

When I try to execute the 4th line "mysql --execute="grant all privileges on owncloud.* to $myUser@localhost identified by $myPass" I get the following error message:

ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0wncl0ud4m32' at line 1

I am using SME Version 8.0 and followed the documentation word for word so I don't know what I am missing here?

Reference: http://wiki.contribs.org/OwnCloud

Stefano:
login as root

then

--- Code: ---mysql

--- End code ---

now you have a prompt like

--- Code: ---mysql>

--- End code ---

execute following commands

verify there's a owncloud db with

--- Code: ---show databases;

--- End code ---

if it does not exist then

--- Code: ---create database owncloud;

--- End code ---

finally

--- Code: ---grant all privileges on owncloud.* to myUser@localhost identified by $myPass;
flush privileges;

--- End code ---

note the ";" at the end of each row

HTH

ghorst352:
Stefano,

I did exactly as you presented and got the following error message:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '$myPass' at line 1

Stefano:
ahem..

you must declare both username and password , don't use variables

i.e., for example

--- Code: ---grant all privileges on owncloud.* to stefano@localhost identified by stefanoverylongpassword;

--- End code ---

remember to replace stefano and stefanoverylongpassword with your values :-)

ghorst352:
Stefano,

I get the same error message??



mysql> grant all privileges on owncloud.* to ocadmin@localhost identified by D1x134dm1n;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'D1x134dm1n' at line 1

I even deleted the database and tried again.  This is frustrating.

Navigation

[0] Message Index

[#] Next page