Koozali.org: home of the SME Server
Obsolete Releases => SME 8.x Contribs => Topic started by: ghorst352 on January 28, 2013, 05:43:01 PM
-
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
-
login as root
then
mysql
now you have a prompt like
mysql>
execute following commands
verify there's a owncloud db with
show databases;
if it does not exist then
create database owncloud;
finally
grant all privileges on owncloud.* to myUser@localhost identified by $myPass;
flush privileges;
note the ";" at the end of each row
HTH
-
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
-
ahem..
you must declare both username and password , don't use variables
i.e., for example
grant all privileges on owncloud.* to stefano@localhost identified by stefanoverylongpassword;
remember to replace stefano and stefanoverylongpassword with your values :-)
-
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.
-
doh, my bad
password must be enclosed into single quotes '
just tried.. sorry..
-
Holy Geez, finally. Thanks. :grin:
So I guess I also need to initiate a bug for documentation?
-
I think so
-
Stefano,
I still have not got this to work as I have apparently another issue:
Whenever I browse to http://192.168.1.10/owncloud/ I see the directory structure of the html folder? If I try http://192.168.1.10/owncloud/index.php then I get the following error message "You don't have permission to access /owncloud/index.php on this server."
According to the documentation I am suppose to Browse to http://yourserver/owncloud and follow install script. ???
-
Here are my errors in httpd error log so I guess I need to look at the config.
[Mon Jan 28 13:46:05 2013] [error] [client 192.168.1.28] client denied by server configuration: /home/e-smith/files/ibays/owncloud/html/public.php
[Mon Jan 28 13:46:05 2013] [error] [client 192.168.1.28] client denied by server configuration: /home/e-smith/files/ibays/owncloud/html/cron.php
[Mon Jan 28 13:46:05 2013] [error] [client 192.168.1.28] client denied by server configuration: /home/e-smith/files/ibays/owncloud/html/remote.php
[Mon Jan 28 13:46:05 2013] [error] [client 192.168.1.28] client denied by server configuration: /home/e-smith/files/ibays/owncloud/html/index.php
[Mon Jan 28 13:46:05 2013] [error] [client 192.168.1.28] client denied by server configuration: /home/e-smith/files/ibays/owncloud/html/status.php
[Mon Jan 28 13:46:13 2013] [error] [client 192.168.1.28] client denied by server configuration: /home/e-smith/files/ibays/owncloud/html/index.php
[Mon Jan 28 13:46:15 2013] [error] [client 192.168.1.28] client denied by server configuration: /home/e-smith/files/ibays/owncloud/html/index.php
[Mon Jan 28 13:46:16 2013] [error] [client 192.168.1.28] client denied by server configuration: /home/e-smith/files/ibays/owncloud/html/index.php
[Mon Jan 28 13:46:19 2013] [error] [client 192.168.1.28] client denied by server configuration: /home/e-smith/files/ibays/owncloud/html/index.php
[Mon Jan 28 13:46:27 2013] [error] [client 192.168.1.28] client denied by server configuration: /home/e-smith/files/ibays/owncloud/html/index.php
[Mon Jan 28 13:46:32 2013] [error] [client 192.168.1.28] client denied by server configuration: /home/e-smith/files/ibays/owncloud/html/public.php
[Mon Jan 28 13:46:32 2013] [error] [client 192.168.1.28] client denied by server configuration: /home/e-smith/files/ibays/owncloud/html/cron.php
[Mon Jan 28 13:46:32 2013] [error] [client 192.168.1.28] client denied by server configuration: /home/e-smith/files/ibays/owncloud/html/remote.php
[Mon Jan 28 13:46:32 2013] [error] [client 192.168.1.28] client denied by server configuration: /home/e-smith/files/ibays/owncloud/html/index.php
[Mon Jan 28 13:46:32 2013] [error] [client 192.168.1.28] client denied by server configuration: /home/e-smith/files/ibays/owncloud/html/status.php
[Mon Jan 28 13:48:29 2013] [error] [client 192.168.1.28] client denied by server configuration: /home/e-smith/files/ibays/owncloud/html/index.php
-
bhay3s: one problem -> one topic, thank you