Skip to content
This repository was archived by the owner on Oct 7, 2020. It is now read-only.
This repository was archived by the owner on Oct 7, 2020. It is now read-only.

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

Description

@kcleung

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?

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions