CONTENTS #contents ---- Lastmodified &lastmod; ---- *owncloud [#fd22db71] **portinstall www/owncloud [#qfa28bae] => Attempting to fetch http://distcache.FreeBSD.org/ports-distfiles/trousers-0.3.14.tar.gz fetch: http://distcache.FreeBSD.org/ports-distfiles/trousers-0.3.14.tar.gz: Internal Server Error => Couldn't fetch it - please try to retrieve this => port manually into /usr/ports/distfiles/ and try again. *** Error code 1 Stop. make: stopped in /usr/ports/www/owncloud ** Command failed [exit code 1]: /usr/bin/script -qa /tmp/portinstall20170902-35526-tpgf1y env make ** Fix the problem and try again. ** Listing the failed packages (-:ignored / *:skipped / !:failed) ! www/owncloud (fetch error) ** # pkg install owncloud [#p45292f6] Please note that everything has been installed in /usr/local/www/owncloud. You will probably want to add an alias to your httpd.conf file, something like this: Alias /owncloud /usr/local/www/owncloud AcceptPathInfo On <Directory /usr/local/www/owncloud> AllowOverride All Require all granted </Directory> And restart Apache. ** Setup [#yf5ec0df] ***root% mysql_secure_installation [#s66927a6] root% mysql -u root -p mysql> CREATE DATABASE owncloud DEFAULT CHARACTER SET utf8; Query OK, 1 row affected (0.00 sec) Error while trying to create admin user: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [2002] Connection refused Error while trying to create admin user: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: hostname nor servname provided, or not known Error while trying to create admin user: An exception occurred while executing 'INSERT INTO `oc_migrations` (`app`,`version`) SELECT ?,? FROM `oc_migrations` WHERE `app` = ? AND `version` = ? HAVING COUNT(*) = 0' with params ["core", 20170101215145, "core", 20170101215145]: SQLSTATE[HY000]: General error: 1665 Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED. ---- Total access &counter(total);:本日 &counter(today);:昨日 &counter(yesterday); #counter([total|today|yesterday]);