KETSE / casebox

Casebox: Secure all your information and team communication in one place
https://www.casebox.org
215 stars 120 forks source link

bin/install.php have problems setting up database on ubuntu 18.04 #82

Open kcleung opened 5 years ago

kcleung commented 5 years ago

On an Ubuntu 18.04 VM, I have followed instructions at:

https://www.casebox.org/dev/install/

except that I have to replace the user "apache" with "www-data" for ubuntu.

I changed into /var/www/casebox, and run:

sudo php bin/install.php

Mysql refuses access to the database:

vagrant@ubuntu1804:/var/www/casebox$ sudo php bin/install.php Config file doesnt exist Specify apache user (default "apache"): Specify prefix used for database names, solr core and log files (default "cb"): Specify database configuration: db host (default "127.0.0.1"): db port (default "3306"): db user (default "local"): db password: privileged db user (default "root"): privileged db user's password: PHP Warning: mysqli::__construct(): (HY000/1698): Access denied for user 'root'@'localhost' in /var/www/casebox/httpsdocs/lib/install_functions.php on line 415 Specify database configuration: db host (default "127.0.0.1"):

I didn't fiddle with the mysql installation. Also, I verified that the user root does not need a password for mysql login:

vagrant@ubuntu1804:/var/www/casebox/bin$ sudo mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 14 Server version: 5.7.23-0ubuntu0.18.04.1 (Ubuntu)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

So how can I get the script to work on ubuntu?

bertver commented 5 years ago

Dear KC Leung,

could you kindly identify yourself?

HURIDOCS can only provide advice and support to human rights organisations.

Best regards

Bert Verstappen

On Sun, 30 Sep 2018 at 00:57, kcleung notifications@github.com wrote:

On an Ubuntu 18.04 VM, I have followed instructions at:

https://www.casebox.org/dev/install/

except that I have to replace the user "apache" with "www-data" for ubuntu.

I changed into /var/www/casebox, and run:

sudo php bin/install.php

Mysql refuses access to the database:

vagrant@ubuntu1804:/var/www/casebox$ sudo php bin/install.php Config file doesnt exist Specify apache user (default "apache"): Specify prefix used for database names, solr core and log files (default "cb"): Specify database configuration: db host (default "127.0.0.1"): db port (default "3306"): db user (default "local"): db password: privileged db user (default "root"): privileged db user's password: PHP Warning: mysqli::__construct(): (HY000/1698): Access denied for user 'root'@'localhost' in /var/www/casebox/httpsdocs/lib/install_functions.php on line 415 Specify database configuration: db host (default "127.0.0.1"):

I didn't fiddle with the mysql installation. Also, I verified that the user root does not need a password for mysql login:

vagrant@ubuntu1804:/var/www/casebox/bin$ sudo mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 14 Server version: 5.7.23-0ubuntu0.18.04.1 (Ubuntu)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

So how can I get the script to work on ubuntu?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/KETSE/casebox/issues/82, or mute the thread https://github.com/notifications/unsubscribe-auth/AKyYwPNoeNLiIxqY0QOTDPsADTa04xgGks5uf_rCgaJpZM4XAuFY .

-- Bert Verstappen Senior Documentalist https://www.huridocs.org/ Geneva Office 3 rue de Varembé CH-1202 Geneva +41 22 755 5252 <%41%22%755%5252> Skype: berthuridocs | PGP: 8FA6A3BBCB81CBB0 https://pgp.mit.edu/pks/lookup?op=get&search=0x8FA6A3BBCB81CBB0 website http://huridocs.org | facebook http://facebook.com/huridocs | twitter http://twitter.com/huridocs | linkedin https://www.linkedin.com/company/huridocs | newsletter http://eepurl.com/raFyP

kcleung commented 5 years ago

I am for a community law centre. I tried to send you a PM but can't find a way to do so under github

bertver commented 5 years ago

Hello again,

My direct e-mail is info@huridocs.org

We can only provide limited support in setting up Casebox.

Best wishes,

Bert Verstappen

On Thu, 4 Oct 2018 at 23:14, kcleung notifications@github.com wrote:

I am for a community law centre. I tried to send you a PM but can't find a way to do so under github

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/KETSE/casebox/issues/82#issuecomment-427171516, or mute the thread https://github.com/notifications/unsubscribe-auth/AKyYwJQNI9lF9LWDXuVGPOASBv7RVoQ6ks5uhnoagaJpZM4XAuFY .

-- Bert Verstappen Senior Documentalist https://www.huridocs.org/ Geneva Office 3 rue de Varembé CH-1202 Geneva +41 22 755 5252 <%41%22%755%5252> Skype: berthuridocs | PGP: 8FA6A3BBCB81CBB0 https://pgp.mit.edu/pks/lookup?op=get&search=0x8FA6A3BBCB81CBB0 website http://huridocs.org | facebook http://facebook.com/huridocs | twitter http://twitter.com/huridocs | linkedin https://www.linkedin.com/company/huridocs | newsletter http://eepurl.com/raFyP