Installation Owncloud 9.1.0 impossible

expert
9.1.x
help
#1

I tried to install owncloud 9.1.0 on my FreeBSD 9.2 RELEASE server. I installed apache 2.4 with php 5.6.

Steps to reproduce
1. I untar the owncloud-9.1.0.tar.bz2 file in my web directory
2. I create the user owncloud in database with
CREATE USER 'owncloud'@'localhost' IDENTIFIED BY 'mot_de_passe';
3. I create the owncloud database with
CREATE DATABASE owncloud;
4. I give the privilege to the user owncloud with
GRANT ALL on owncloud.* TO 'owncloud'@'localhost';
5. Then, with my web browser, I see the installation owncloud page on "http://IP_du_serveur/owncloud"
6. I fil the data ("Créer un compte admnistrateur", ... with using a mysql database)
7. I clic on "Terminer Installation"
8. I wait 2 minutes and then nothing... (the database is created with all tables and admin user)
9. I try to reload the "http://IP_du_serveur/owncloud" but it's seems the installation not working.

Expected behaviour
Normally, I'll see the owncloud interface

Actual behaviour
I see the installation page

Server configuration
Operating system: FreeBSD 9.2
Web server: apache 2.4.10
Database: MySQL 5.6.22
PHP version: 5.6.4
ownCloud version (see ownCloud admin page): 9.1.0
Updated from an older ownCloud or fresh install: Fresh install
ownCloud log (data/owncloud.log, see https://central.owncloud.org/t/how-to-find-webserver-or-oc-logfile-enable-php-logfile/808):

{"reqId":"+OJEiCwjCwzTze4SqmmH","remoteAddr":"192.168.0.50","app":"PHP","message":"Module 'posix' already loaded at Unknown#0","level":3,"time":"2016-07-23T07:26:02+00:00","method":"GET","url":"\/owncloud\/index.php","user":"--"}
{"reqId":"eZ7JD81jL8NPPK+o27XW","remoteAddr":"192.168.0.50","app":"mysql.setup","message":"Specific user creation failed: An exception occurred while executing 'SELECT user FROM mysql.user WHERE user=?' with params [\"oc_root\"]:\n\nSQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user 'owncloud'@'localhost' for table 'user'","level":3,"time":"2016-07-23T07:26:49+00:00","method":"POST","url":"\/owncloud\/index.php","user":"--"}
{"reqId":"eZ7JD81jL8NPPK+o27XW","remoteAddr":"192.168.0.50","app":"mysql.setup","message":"Database creation failed: An exception occurred while executing 'GRANT ALL PRIVILEGES ON `owncloud` . * TO 'owncloud'':\n\nSQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user 'owncloud'@'localhost' to database 'owncloud'","level":3,"time":"2016-07-23T07:26:49+00:00","method":"POST","url":"\/owncloud\/index.php","user":"--"}

Sorry to my very bad english,
Thanks to your help...

Trouble while installing OwnCloud 9 on Centos
#2

Instead of creating a user and database user before running the setup try to specify the root user of your database. ownCloud will create a database and a less privileged user for you.

#3

I test this...
In field "Créer un compte administrateur", I type root and a new password (this user is to owncloud not to mysql)
In field "Stockage & Base de données",
field "Repertoire de données" -> /www/owncloud/data (I don't understand why it necessary because I use mysql database ??)
field "configurer la base de donnée" -> "MySQL/MariaDB"
field "Utilisateur de la base de donnée" -> "root" (the user root of the mysql database)
field "Mot de passe de la base de donnée" -> "the database root pass"
field "Nom de la base de donnée" -> "owncloud"
field "localhost" -> "localhost"

With this configuration, it's the same ... no install return to the installation page.
with error message : 

Error while trying to create admin user: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES)
#4

Can you login to mysql with other webapplication such as phpmyadmin? Or on the terminal
mysql -u root -p
The root password of the mysql-database can be different from the root password on the system.

#5

I can login to mysql by phpmyadmin with the root user of mysql, what would you want I do with this connection ?
The two password I used are not the same. I used for example the "" to the user root of owncloud and "" to the user root of mysql.

thanks to help me...I really want to use owncloud...

#6

Great, so you php with mysql works and you know the right password :wink:

If you have access via phpmyadmin, can you delete previously installed owncloud database and owncloud-users? This could perhaps block the installation process.
When you give the root-credentials of the database, the installation process will itself create a database, a database user and fix all permissions for this new database user.

The data-folder is actually needed where all the files are stored. The database is only used for a file-index (and other data) but not for the files themselves.

#7

I do. So in phpmyadmin, no database "owncloud" and no user "oc_*", just the root user of mysql.

when i try to install with "http://192.168.0.240/owncloud/index.php", and this parameter :

I have the same result : 

La page 192.168.0.240 ne fonctionne pas
192.168.0.240 n'a envoyé aucune donnée.
ERR_EMPTY_RESPONSE

But, the database "owncloud" is create and two users "oc_root" (one for all client and one for just localhost) too.

When I try to reload "http://192.168.0.240/owncloud/index.php", I have the installation page ...

#8

And you get again the same errors in your logfiles?
Other strategy could be: use phpmyadmin to create a new user, create a database and grant all permissions to this new user (don't forget to flush privileges). In the setup-page for owncloud, give the new user-credentials for the database and the database name.

Or: try the command line: https://doc.owncloud.org/server/9.1/admin_manual/configuration_server/occ_command.html?highlight=occ#command-line-installation-label

Regarding your data folder:

Your webserver probably hasn't the permission to create this folder. It is normally /var/www/owncloud/data.

#9

I have this : 

{"reqId":"SijWOXjrevD4+8Uk0YXm","remoteAddr":"192.168.0.50","app":"PHP","message":"Module 'posix' already loaded at Unknown#0","level":3,"time":"2016-07-23T09:54:15+00:00","method":"POST","url":"\/owncloud\/index.php\/heartbeat","user":"--"}
{"reqId":"u+m9gtXq+mDD4Dj2ZQmF","remoteAddr":"192.168.0.50","app":"PHP","message":"Module 'posix' already loaded at Unknown#0","level":3,"time":"2016-07-23T10:09:16+00:00","method":"POST","url":"\/owncloud\/index.php\/heartbeat","user":"--"}

I try :
In PhpMyAdmin : 

CREATE USER 'owncloud'@'localhost' IDENTIFIED BY 'mot_de_passe';
CREATE DATABASE owncloud;
GRANT ALL PRIVILEGES on owncloud.* TO 'owncloud'@'localhost';
FLUSH PRIVILEGES;

I removed the /www/owncloud and untar the owncloud-9.1.0.tar.bz2 file in /www to have now a clean extract of owncloud without install.

Then I reload "http://192.168.0.240/owncloud/index.php" and I fill with :
* Créer un compte admnistrateur : "root" / "rootowncloud"
* Repertoire des données : "/www/owncloud/data"
* Configurer la base de données : "MySQL/MariaDB"
* Utilisateur de la base de donnée : "owncloud"
* Mot de passe de la base de donnée : "mot_de_passe"
* Nom de la base de donnée : "owncloud"
* localhost : "localhost"

The database "owncloud" is create and one user "owncloud" is create but no "oc_root" as the before install with root (mysql) install. The user "oc_root" is necessary ?

I have this log : 

{"reqId":"n6tWr\/xUIG1vgikxoRjJ","remoteAddr":"192.168.0.50","app":"mysql.setup","message":"Specific user creation failed: An exception occurred while executing 'SELECT user FROM mysql.user WHERE user=?' with params [\"oc_root\"]:\n\nSQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user 'owncloud'@'localhost' for table 'user'","level":3,"time":"2016-07-23T11:20:47+00:00","method":"POST","url":"\/owncloud\/index.php","user":"--"}
{"reqId":"n6tWr\/xUIG1vgikxoRjJ","remoteAddr":"192.168.0.50","app":"mysql.setup","message":"Database creation failed: An exception occurred while executing 'GRANT ALL PRIVILEGES ON `owncloud` . * TO 'owncloud'':\n\nSQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user 'owncloud'@'localhost' to database 'owncloud'","level":3,"time":"2016-07-23T11:20:47+00:00","method":"POST","url":"\/owncloud\/index.php","user":"--"}

For the /www/owncloud/data permissions (my user apache is www) : 

drwxr-xr-x   3 www  www    512 23 jul 13:21 data/

No problem access because the user www write in log file : 

# ls-al /www/owncloud/data
-rw-r--r--  1 www  www  284 23 jul 13:20 .htaccess
-rw-r--r--  1 www  www    0 23 jul 13:20 index.html
-rw-r-----  1 www  www  910 23 jul 13:20 owncloud.log
drwxr-xr-x  3 www  www  512 23 jul 13:21 root/

An other idea ?

purhaps, the config.php which help you : 

<?php
$CONFIG = array (
  'instanceid' => 'oc8wcgtlz4jc',
  'passwordsalt' => 'DsAir++B6UbWrb3L+RBU/goCE9Ty4t',
  'secret' => 'vEdqLlbE0hcyhXRDdOUJbWwjTrgOTtaXHVUZG6a5FDQqL99D',
  'trusted_domains' =>
  array (
    0 => '192.168.0.240',
  ),
  'datadirectory' => '/www/owncloud/data',
  'overwrite.cli.url' => 'http://192.168.0.240/owncloud',
  'dbtype' => 'mysql',
  'version' => '9.1.0.15',
  'dbname' => 'owncloud',
  'dbhost' => 'localhost',
  'dbtableprefix' => 'oc_',
  'dbuser' => 'owncloud',
  'dbpassword' => 'mot_de_passe',
);

If I delete the 'dbtableprefix' value to put it ''. Is there a chance to install ?

#10

Are you sure that your owncloud is not already working? A complete config/config.php normally indicates that it has been installed (verify in the database if tables were created).

No matter what username you give, it tries to create a new user (in case you gave an admin user). Therefore, such messages are expected when the user has been created for owncloud manually.

#11

I clean all previous installation (/www/owncloud folder and owncloud databse and users)

I try to install owncloud with command line : 

/www/owncloud # sudo -u www php occ maintenance:install --database "mysql" --database-name "owncloud"  --database-user "root" --database-pass "pass_root" --admin-user "admin" --admin-pass "pass_admin"

And this is the reply : 

PHP Warning:  Module 'posix' already loaded in Unknown on line 0
The process control (PCNTL) extensions are required in case you want to interrupt long running commands - see http://php.net/manual/en/book.pcntl.php
ownCloud is not installed - only a limited number of commands are available
Segmentation fault

the /www/owncloud/data/owncloud/log file is empty

In the database, the owncloud database is create and two user "oc_admin" (one in localhost and one to all client). In the owncloud.oc_users, I've admin user created.

For me the install is finish so why I've the install page when I access "http://192.168.0.240/owncloud" ?
Normally, I should see the interface of owncloud...

I think one thing ... Can there be a timeout blocking the install process owncloud ( in php or apache) ?

#12

PCNTL is not a hard requirement (but you it can be useful for command-line use: https://doc.owncloud.org/server/9.1/admin_manual/installation/source_installation.html#prerequisites). On command line you don't have timeouts and the first setup process should be quite fast.

Segmentation fault doesn't sound good and code normally shouldn't create that. Not sure if it is the code or some configuration error in php. I hope some developer can help you out here: @PVince81 @DeepDiver1975

#13

seg faults are always bad. Any further log entries in the Apache error log after the seg fault?

#14

After a cleaning install (remove folder and database), and after an install by command line as my previous post, I've this in http-error.log : 

[Mon Jul 25 12:40:17.454475 2016] [mpm_prefork:notice] [pid 64411] AH00169: caught SIGTERM, shutting down
PHP Warning:  Module 'posix' already loaded in Unknown on line 0
[Mon Jul 25 12:40:17.589321 2016] [mpm_prefork:notice] [pid 73660] AH00163: Apache/2.4.10 (FreeBSD) PHP/5.6.4 configured -- resuming normal operations
[Mon Jul 25 12:40:17.589398 2016] [core:notice] [pid 73660] AH00094: Command line: '/usr/local/sbin/httpd -D SSL -D NOHTTPACCEPT'
#15

Still seg faulting?

Please fix your php.ini - I have seen seg faults due to double registered modules

#16

After fix php.ini, I've in /var/log/httpd-error.log : 

[Mon Jul 25 21:23:46.634455 2016] [mpm_prefork:notice] [pid 73660] AH00169: caught SIGTERM, shutting down
[Mon Jul 25 21:23:46.769368 2016] [mpm_prefork:notice] [pid 75147] AH00163: Apache/2.4.10 (FreeBSD) PHP/5.6.4 configured -- resuming normal operations
[Mon Jul 25 21:23:46.769449 2016] [core:notice] [pid 75147] AH00094: Command line: '/usr/local/sbin/httpd -D SSL -D NOHTTPACCEPT'

And always Seg fault...

#17

Try to update your PHP and your operating system to a recent one (PHP 5.6.4 is a way too outdated, 5.6.24 is current on this branch):

Whatever the problem is, it probably does not lie with Owncloud as a script should in no circumstance cause an interpreter to segfault. The problem most likely lies with either your specific PHP version or an extension you have installed, you could try to get a backtrace or a core dump to find out exactly where it segfaults.

Have you considered moving to PHP7? It is 'the future', after all. It is maturing rapidly and works well on older hardware.

http://owncloud.10557.n7.nabble.com/php-fpm-hanging-segfault-SIGSEGV-CPUs-100-tp17535p17536.html

The user there solved such an issue with segmentation faults by updating some operating system components:

http://owncloud.10557.n7.nabble.com/php-fpm-hanging-segfault-SIGSEGV-CPUs-100-tp17535p17546.html

#18

For your initial issue:

i've just stumbled over the following fix:

Seems that message is just misleading.

#19

Don't know if this will help you, but this is how I do it in the ownCloud VM install script: https://github.com/enoch85/ownCloud-VM/blob/master/production/owncloud_install_production.sh#L259-L278

#20

following the instructions on this page: https://doc.owncloud.org/desktop/2.1/building.html#mac-os-x
I don't understand what the last step is for Mac OS X. I completed the first six steps with brew and everything seemed to go smoothly. I installed the package software, I have a folder called "owncloud" with 25 items in it. I feel like I'm SO close but can't complete the process. I don't understand what the last step is saying to do from the 'build directory'? what is this? and what install directory?