New installation of OctoberCMS can't find database

[Morsusy2k]

• OctoberCMS Build: 446
• PHP Version: 7.2.10
• Database Engine: Mysql (WAMP)
• Plugins Installed: None

Description:

Investigating the issue from before I have decided to try a clean install of OctoberCMS which throws an error. Installation ignores the database name I specified during the installation and searches for "database" database.

Error log:

.============================ POST REQUEST ==========================.
[2019/01/11 12:05:50] Postback payload: Array
(
    [step] => createAdmin
    [meta] => Array
        (
            [core] => Array
                (
                    [hash] => d1028fbd034b2639b0d2ca0869002836
                    [build] => 446
                    [uhash] => b4b79ec07b137e6c84605ac76f616781
                )

        )
    [db_type] => mysql
    [db_host] => localhost
    [db_port] => 
    [db_name] => test2
    [db_user] => test2
    [db_pass] => *******
    [admin_first_name] => Admin
    [admin_last_name] => Person
    [admin_email] => *******@*****.com
    [admin_login] => admin
    [admin_password] => *******
    [admin_confirm_password] => *******
    [backend_uri] => /backend
    [encryption_code] => *******
    [file_mask] => 777
    [folder_mask] => 777
    [handler] => onInstallStep
)
[2019/01/11 12:05:50] Install step: createAdmin
[2019/01/11 12:05:50] Handler error (onInstallStep): SQLSTATE[HY000] [1049] Unknown database 'database' (SQL: select * from information_schema.tables where table_schema = database and table_name = migrations)
[2019/01/11 12:05:50] Trace log:
#0 C:\wamp64\www\test\vendor\laravel\framework\src\Illuminate\Database\Connection.php(624): Illuminate\Database\Connection->runQueryCallback('select * from i...', Array, Object(Closure))
#1 C:\wamp64\www\test\vendor\laravel\framework\src\Illuminate\Database\Connection.php(333): Illuminate\Database\Connection->run('select * from i...', Array, Object(Closure))
#2 C:\wamp64\www\test\vendor\laravel\framework\src\Illuminate\Database\Schema\MySqlBuilder.php(18): Illuminate\Database\Connection->select('select * from i...', Array)
#3 C:\wamp64\www\test\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(221): Illuminate\Database\Schema\MySqlBuilder->hasTable('migrations')
#4 C:\wamp64\www\test\modules\system\classes\UpdateManager.php(135): Illuminate\Support\Facades\Facade::__callStatic('hasTable', Array)
#5 C:\wamp64\www\test\install_files\php\Installer.php(525): System\Classes\UpdateManager->update()
#6 C:\wamp64\www\test\install_files\php\Installer.php(382): Installer->createAdminAccount()
#7 C:\wamp64\www\test\install_files\php\Installer.php(48): Installer->onInstallStep()
#8 C:\wamp64\www\test\install_files\php\boot.php(91): Installer->__construct()
#9 C:\wamp64\www\test\install.php(1): include('C:\\wamp64\\www\\t...')
#10 {main}

Steps To Reproduce:

• Download fresh copy of OctoberCMS
• Setup environment (vhost and hosts)
• Run the installation
• Fill the required data

Will try again using composer and let you know the results.

[w20k]

@Morsusy2k, could you past your configs? Those that you use during installation?

[w20k]

@Morsusy2k, have you got this working? If - not, past your initial configs. Or try to use composer setup.

[Morsusy2k]

@w20k Just installed it via composer and it works fine what is weird about it the past bug with new administrators not seeing pages in BE is gone too. What is up with that..?

The problem here must be my environment, I use WAMP. Will try another installation via wizard tomorrow to confirm. Thank you for support ;)

[w20k]

@Morsusy2k, you're welcome 😉After confirmation if everything is fine, close this ticket! Thanks!

[timj-code]

Hi, I have the same error exactly, the same error message in exactly the same way. my environment is Ubuntu 16.04 + php7.0 + Mysql, php and mysql were installed from ubuntu repository. I found there are bunch of php files in the install-master/config folder, don't know which one would be the related, I just paste the database.php here:

<?php

return [

    /*
    |--------------------------------------------------------------------------
    | PDO Fetch Style
    |--------------------------------------------------------------------------
    |
    | By default, database results will be returned as instances of the PHP
    | stdClass object; however, you may desire to retrieve records in an
    | array format for simplicity. Here you can tweak the fetch style.
    |
    */

    'fetch' => PDO::FETCH_CLASS,

    /*
    |--------------------------------------------------------------------------
    | Default Database Connection Name
    |--------------------------------------------------------------------------
    |
    | Here you may specify which of the database connections below you wish
    | to use as your default connection for all database work. Of course
    | you may use many connections at once using the Database library.
    |
    */

    'default' => 'mysql',

    /*
    |--------------------------------------------------------------------------
    | Database Connections
    |--------------------------------------------------------------------------
    |
    | Here are each of the database connections setup for your application.
    | Of course, examples of configuring each database platform that is
    | supported by Laravel is shown below to make development simple.
    |
    |
    | All database work in Laravel is done through the PHP PDO facilities
    | so make sure you have the driver for your particular database of
    | choice installed on your machine before you begin development.
    |
    */

    'connections' => [

        'sqlite' => [
            'driver'   => 'sqlite',
            'database' => 'storage/database.sqlite',
            'prefix'   => '',
        ],

        'mysql' => [
            'driver'    => 'mysql',
            'host'      => 'localhost',
            'port'      => 3306,
            'database'  => 'oct_db',
            'username'  => 'october',
            'password'  => '',
            'charset'   => 'utf8mb4',
            'collation' => 'utf8mb4_unicode_ci',
            'prefix'    => '',
        ],

        'pgsql' => [
            'driver'   => 'pgsql',
            'host'     => 'localhost',
            'port'     => 5432,
            'database' => 'database',
            'username' => 'root',
            'password' => '',
            'charset'  => 'utf8',
            'prefix'   => '',
            'schema'   => 'public',
        ],

        'sqlsrv' => [
            'driver'   => 'sqlsrv',
            'host'     => 'localhost',
            'port'     => 1433,
            'database' => 'database',
            'username' => 'root',
            'password' => '',
            'prefix'   => '',
        ],

    ],

    /*
    |--------------------------------------------------------------------------
    | Migration Repository Table
    |--------------------------------------------------------------------------
    |
    | This table keeps track of all the migrations that have already run for
    | your application. Using this information, we can determine which of
    | the migrations on disk have not actually be run in the databases.
    |
    */

    'migrations' => 'migrations',

    /*
    |--------------------------------------------------------------------------
    | Redis Databases
    |--------------------------------------------------------------------------
    |
    | Redis is an open source, fast, and advanced key-value store that also
    | provides a richer set of commands than a typical key-value systems
    | such as APC or Memcached. Laravel makes it easy to dig right in.
    |
    */

    'redis' => [

        'cluster' => false,

        'default' => [
            'host'     => '127.0.0.1',
            'password' => null,
            'port'     => 6379,
            'database' => 0,
        ],

    ],
];

[evici]

Same issue on different environments (apache, nginx, mamp, wamp). Command-line installation fails with same error even database name was entered different it still does not pickup and keeps default value of "database" during installation.

[LucasZdv]

Hello, in the latest versions added to be able to install October.Drivers and RainLab.Builder. The error is if you want to install any of these plugins, because the October database has not yet been installed. If you omit the installation of these plugins, the installation runs correctly.

Here I send a sample of the behavior.

Installation by command-line:

demo@server:~/apps/demo$ curl https://octobercms.com/api/installer |php
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100  280k    0  280k    0     0   164k      0 --:--:--  0:00:01 --:--:--  164k
All settings correct for installing OctoberCMS
Downloading OctoberCMS...

OctoberCMS successfully installed to: /srv/users/demo/apps/demo
demo@server:~/apps/demo$ php artisan october:install
.====================================================================.

 .d8888b.   .o8888b.   db  .d8888b.  d8888b. d88888b d8888b.  .d888b. 
.8P    Y8. d8P    Y8   88 .8P    Y8. 88  `8D 88'     88  `8D .8P , Y8.
88      88 8P      oooo88 88      88 88oooY' 88oooo  88oobY' 88  |  88
88      88 8b      ~~~~88 88      88 88~~~b. 88~~~~  88`8b   88  |/ 88
`8b    d8' Y8b    d8   88 `8b    d8' 88   8D 88.     88 `88. `8b | d8'
 `Y8888P'   `Y8888P'   YP  `Y8888P'  Y8888P' Y88888P 88   YD  `Y888P' 

`=========================== INSTALLATION ==========================='

 Database type:
  [0] MySQL
  [1] Postgres
  [2] SQLite
  [3] SQL Server
 > 0

 MySQL Host [localhost]:
 > 

 MySQL Port [3306]:
 > 

 Database Name [database]:
 > test

 MySQL Login [root]:
 > 181aed9f69d5

 MySQL Password []:
 > 90dd2d097de9106e

Enter a new value, or press ENTER for the default

 First Name [Admin]:
 > Lucas   

 Last Name [Person]:
 > Zamora

 Email Address [admin@domain.tld]:
 > lucaszdv@gmail.com

 Admin Login [admin]:
 > admin

 Admin Password [admin]:
 > admin

 Is the information correct? (yes/no) [yes]:
 > yes

 Application URL [http://localhost]:
 > 

 Configure advanced options? (yes/no) [no]:
 > yes

Enter a new value of 32 characters, or press ENTER to use the generated key

 Application key [Qno3yDoBELYdaCzriZ7d4rYIsit6MK2Y]:
 > 

Application key [Qno3yDoBELYdaCzriZ7d4rYIsit6MK2Y] set successfully.

 Backend URL [backend]:
 > 

 File Permission Mask [777]:
 > 0755

 Folder Permission Mask [777]:
 > 0755

 Enable Debug Mode? (yes/no) [yes]:
 > 

 Install the October.Drivers plugin? (yes/no) [no]:
 > yes

Installing plugin October.Drivers

  [Illuminate\Database\QueryException]                                                                                                                                  
  SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO) (SQL: select * from `system_parameters` where `namespace` = system and `group`  
   = project and `item` = id limit 1)                                                                                                                                   

  [Doctrine\DBAL\Driver\PDOException]                                                    
  SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO)  

  [PDOException]                                                                         
  SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO)

[jalu14]

+1 No matter the password, the user or the database url being specified, it will always use localhost root and no password.

Been trying to install on web and by command line, same result.

[w20k]

Have you tested connection via Tinker?

[joaocosta-azores]

I'm having same problem installing via command line with composer.

Running Ubuntu 16.04.6 LTS with php 7.3.3.

Steps to reproduce:

• composer create-project october/October October;
• php artisan october:env;
• update .env file with APP_ENV=dev where I've set my database.php inside config/dev folder;
• composer update;

I keep getting the same message even when I run php artisan october:util set build:

No database detected - skipping setting the build number.

I've also tried running October:up and I get:

[Illuminate\Database\QueryException]
could not find driver (SQL: select * from information_schema.tables where table_schema = fruter and table_name = migrations)

[Doctrine\DBAL\Driver\PDOException]
could not find driver

[PDOException]
could not find driver

[LukeTowers]

What's your database config @jonnydevv?

[joaocosta-azores]

My database config:

    'fetch' => PDO::FETCH_CLASS,
    'default' => env('DB_CONNECTION', 'mysql'),
    'connections' => [
        'sqlite' => [
            'driver'   => 'sqlite',
            'database' => env('DB_DATABASE', 'storage/database.sqlite'),
            'prefix'   => '',
        ],
        'mysql' => [
            'driver'    => 'mysql',
            'host' => env('DB_HOST', '127.0.0.1'),
            'port' => env('DB_PORT', 3306),
            'database' => env('DB_DATABASE', 'fruter'),
            'username' => env('DB_USERNAME', 'root'),
            'password' => env('DB_PASSWORD', ''),
            'charset'   => 'utf8mb4',
            'collation' => 'utf8mb4_unicode_ci',
            'prefix'    => '',
        ],
        'pgsql' => [
            'driver'   => 'pgsql',
            'host' => env('DB_HOST', 'localhost'),
            'port' => env('DB_PORT', 5432),
            'database' => env('DB_DATABASE', 'database'),
            'username' => env('DB_USERNAME', ''),
            'password' => env('DB_PASSWORD', ''),
            'charset'  => 'utf8',
            'prefix'   => '',
            'schema'   => 'public',
        ],
        'sqlsrv' => [
            'driver'   => 'sqlsrv',
            'host' => env('DB_HOST', 'localhost'),
            'port' => env('DB_PORT', 5432),
            'database' => env('DB_DATABASE', 'database'),
            'username' => env('DB_USERNAME', ''),
            'password' => env('DB_PASSWORD', ''),
            'prefix'   => '',
        ],
    ],
    'migrations' => 'migrations',
    'redis' => [
        'cluster' => false,
        'default' => [
            'host' => env('REDIS_HOST', '127.0.0.1'),
            'password' => env('REDIS_PASSWORD', ''),
            'port' => env('REDIS_PORT', 6379),
            'database' => 0,
        ],
    ],

[LukeTowers]

What about your .env file?

[joaocosta-azores]

My .env file:

APP_ENV=dev

[joaocosta-azores]

I've changed php version from7.3.3 to7.2.16 and now it works.

Steps i use to install with php7.2:

• run composer create-project october/october october
• run php artisan october:env, update database settings and .env
• run php artisan october:up
• run php artisan october:util set build

*** October sets build: 447

Ping? Pong! Ping? Pong!

I guess october isn't compatible with php7.3, because I'v tried downgrading until v1.0.444. Hope it helps

[w20k]

@jonnydevv I've tried with PHP 7.3.2 via composer. Had no issues there.

[joaocosta-azores]

@jonnydevv I've tried with PHP 7.3.2 via composer. Had no issues there.

Could you reply your steps? Because I've tried with the steps I showned before without success, always getting same message:

No database detected - skipping setting the build number.

[w20k]

I mainly use best practices gist form @LukeTowers -> https://gist.github.com/LukeTowers/9100845ba50bd53d957da822d06f3b56#file-setupproject-sh

[joaocosta-azores]

I was able to install in php 7.3.3. Made a new box and no problems with installation following the steps I've showned before:

run composer create-project october/october october run php artisan october:env, update database settings and .env run php artisan october:up run php artisan october:util set build

[tobias-kuendig]

I just had the same problem using the installation wizard.

After the installation, the database.php config is the stock one and the migrations did not run. Everything without the slightest trace of an error message.

Edit: Found the issue. I'm using laravel-valet that automatically detects what CMS is installed in a directory and then starts to redirect all requests to index.php instead of install.php as soon as the installer has extracted the sources zip.

[LukeTowers]

@tobias-kuendig could you make an issue in their repo for that?

[tobias-kuendig]

I feel like this is a "wont fix" kind of issue. laravel-valet needs some tweaking to even work with October and it literally changes the server config during the install based on the files that exist in the directory.

[LukeTowers]

I'm not sure I understand. Valet is actively changing October's core files during installation? Why on earth would they do that?

[tobias-kuendig]

:grin: No...

Valet uses "Drivers" to detect what App/CMS is served: https://laravel.com/docs/5.8/valet#custom-valet-drivers

The drivers check if certain files exist (app or wp-admin folders) and then redirect everything to public/index.php or index.php or whatever the app requires.

While running the install wizard, no app is detected. But as soon as the installer unzips October's source the Valet October driver kicks in and redirects everything to index.php since it detected an October installation. This breaks the installer since it needs to make multiple AJAX requests to install.php.

That's why downloading and extracting works, but all steps afterwards fail.

The only bug I see is that the AJAX requests don't seem to care about invalid responses (October's demo theme index instead of {"success": true} in this case) and just move on without an error message.

[LukeTowers]

@tobias-kuendig then we can make a change to the OctoberCMS driver for Valet. Do you know where that lives? We could also make a change to the installer to detect the failure of AJAX requests.

[tobias-kuendig]

October currently is suppored via the BasicValetDriver (looks for a index.php). We would have to break it out into it's own Driver to make a change. I don't see this getting merged. The only working solution that comes to mind would be to not redirect as long as there is an install.php file present.

We have to keep in mind that this check will be executed for every single request that is handled via the valet driver so I'm not sure if it's worth it.

Having a proper error returned would already make things a lot more clearer.

[LukeTowers]

@tobias-kuendig they already have drivers for a lot of other platforms. If we couple it with better error messages and https://github.com/octobercms/october/issues/4274 I don't see why it wouldn't be accepted.

[charles-tainui]

hi all, if this this may help any Googlers who reach this page : i had the same issue with "db_host => localhost" setting to "127.0.0.1" solved it !

[github-actions[bot]]

This issue will be closed and archived in 3 days, as there has been no activity in the last 30 days. If this issue is still relevant or you would like to see action on it, please respond and we will get the ball rolling.

[RLJMedia]

I am having this problem with the root user.

[w20k]

And logs @RLJMedia? I had this issue once, but for me, it was a simple fix changing from localhost to 127.0.0.1

[RLJMedia]

I had just tried you idea to replace localhost with 127.0.0.1 and same results. My install log

[2019/10/09 05:41:34] Install step: setupConfig
[2019/10/09 05:41:34] Handler error (onInstallStep): SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from `system_settings` where `item` = janvince_smallextensions_settings limit 1)
[2019/10/09 05:41:34] Trace log:
#0 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(624): Illuminate\Database\Connection->runQueryCallback('select * from `...', Array, Object(Closure))
#1 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(333): Illuminate\Database\Connection->run('select * from `...', Array, Object(Closure))
#2 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1719): Illuminate\Database\Connection->select('select * from `...', Array, true)
#3 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1704): Illuminate\Database\Query\Builder->runSelect()
#4 /var/www/html/vendor/october/rain/src/Database/QueryBuilder.php(216): Illuminate\Database\Query\Builder->get(Array)
#5 /var/www/html/vendor/laravel/framework/src/Illuminate/Cache/Repository.php(323): October\Rain\Database\QueryBuilder->October\Rain\Database\{closure}()
#6 /var/www/html/vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php(304): Illuminate\Cache\Repository->remember('system::setting...', 1440, Object(Closure))
#7 /var/www/html/vendor/october/rain/src/Database/QueryBuilder.php(158): Illuminate\Cache\CacheManager->__call('remember', Array)
#8 /var/www/html/vendor/october/rain/src/Database/QueryBuilder.php(121): October\Rain\Database\QueryBuilder->getCached(Array)
#9 /var/www/html/vendor/october/rain/src/Database/QueryBuilder.php(92): October\Rain\Database\QueryBuilder->getDuplicateCached(Array)
#10 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(481): October\Rain\Database\QueryBuilder->get(Array)
#11 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(465): Illuminate\Database\Eloquent\Builder->getModels(Array)
#12 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(77): Illuminate\Database\Eloquent\Builder->get(Array)
#13 /var/www/html/modules/system/behaviors/SettingsModel.php(114): Illuminate\Database\Eloquent\Builder->first()
#14 /var/www/html/modules/system/behaviors/SettingsModel.php(76): System\Behaviors\SettingsModel->getSettingsRecord()
#15 /var/www/html/modules/system/behaviors/SettingsModel.php(135): System\Behaviors\SettingsModel->instance()
#16 [internal function]: System\Behaviors\SettingsModel->get('static_pages_me...')
#17 /var/www/html/vendor/october/rain/src/Extension/ExtendableTrait.php(409): call_user_func_array(Array, Array)
#18 /var/www/html/vendor/october/rain/src/Database/Model.php(635): October\Rain\Database\Model->extendableCall('get', Array)
#19 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1489): October\Rain\Database\Model->__call('get', Array)
#20 /var/www/html/plugins/janvince/smallextensions/Plugin.php(597): Illuminate\Database\Eloquent\Model::__callStatic('get', Array)
#21 /var/www/html/modules/system/classes/PluginManager.php(293): JanVince\SmallExtensions\Plugin->boot()
#22 /var/www/html/modules/system/classes/PluginManager.php(275): System\Classes\PluginManager->bootPlugin(Object(JanVince\SmallExtensions\Plugin))
#23 /var/www/html/modules/system/ServiceProvider.php(96): System\Classes\PluginManager->bootAll()
#24 [internal function]: System\ServiceProvider->boot()
#25 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(29): call_user_func_array(Array, Array)
#26 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(87): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#27 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(31): Illuminate\Container\BoundMethod::callBoundMethod(Object(October\Rain\Foundation\Application), Array, Object(Closure))
#28 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(549): Illuminate\Container\BoundMethod::call(Object(October\Rain\Foundation\Application), Array, Array, NULL)
#29 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(792): Illuminate\Container\Container->call(Array)
#30 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(775): Illuminate\Foundation\Application->bootProvider(Object(System\ServiceProvider))
#31 [internal function]: Illuminate\Foundation\Application->Illuminate\Foundation\{closure}(Object(System\ServiceProvider), 24)
#32 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(776): array_walk(Array, Object(Closure))
#33 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/BootProviders.php(17): Illuminate\Foundation\Application->boot()
#34 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(213): Illuminate\Foundation\Bootstrap\BootProviders->bootstrap(Object(October\Rain\Foundation\Application))
#35 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(296): Illuminate\Foundation\Application->bootstrapWith(Array)
#36 /var/www/html/install_files/php/Installer.php(677): Illuminate\Foundation\Console\Kernel->bootstrap()
#37 /var/www/html/install_files/php/Installer.php(408): Installer->bootFramework()
#38 /var/www/html/install_files/php/Installer.php(378): Installer->buildConfigFile()
#39 /var/www/html/install_files/php/Installer.php(48): Installer->onInstallStep()
#40 /var/www/html/install_files/php/boot.php(91): Installer->__construct()
#41 /var/www/html/install.php(1): include('/var/www/html/i...')
#42 {main}

[w20k]

@RLJMedia could you describe how you do it? Your steps? It seems like it hasn't changed to 127.0.0.1 -> Access denied for user 'root'@'localhost'

[RLJMedia]

Here is the the details with the 127.0.0.1: I tried again and same result when I connect my project ID. Everything looks cool than, boom!

SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * fromsystem_settingswhereitem= janvince_smallextensions_settings limit 1) My install log:

============================ POST REQUEST ==========================.
[2019/10/09 05:51:51] Postback payload: Array
(
    [step] => setupConfig
    [meta] => Array
        (
            [core] => Array
                (
                    [hash] => 462e49f2d6d2896abb56874dbdb64aee
                    [build] => 458
                    [uhash] => 7ecf00bd75e60458191bfcdc43dc14e5
                )

        )

    [db_type] => mysql
    [db_host] => 127.0.0.1
    [db_port] => 3306
    [db_name] => dev_bdesign_do
    [db_user] => dev_bdesign_user
    [db_pass] => *******
    [admin_first_name] => R
    [admin_last_name] => LJr
    [admin_email] => *******@*****.com
    [admin_login] => Bcreature
    [admin_password] => *******
    [admin_confirm_password] => *******
    [backend_uri] => /backend
    [encryption_code] => *******
    [file_mask] => 777
    [folder_mask] => 777
    [handler] => onInstallStep
)

[2019/10/09 05:51:51] Install step: setupConfig
[2019/10/09 05:51:51] Handler error (onInstallStep): SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from `system_settings` where `item` = janvince_smallextensions_settings limit 1)
[2019/10/09 05:51:51] Trace log:
#0 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(624): Illuminate\Database\Connection->runQueryCallback('select * from `...', Array, Object(Closure))
#1 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(333): Illuminate\Database\Connection->run('select * from `...', Array, Object(Closure))
#2 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1719): Illuminate\Database\Connection->select('select * from `...', Array, true)
#3 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1704): Illuminate\Database\Query\Builder->runSelect()
#4 /var/www/html/vendor/october/rain/src/Database/QueryBuilder.php(216): Illuminate\Database\Query\Builder->get(Array)
#5 /var/www/html/vendor/laravel/framework/src/Illuminate/Cache/Repository.php(323): October\Rain\Database\QueryBuilder->October\Rain\Database\{closure}()
#6 /var/www/html/vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php(304): Illuminate\Cache\Repository->remember('system::setting...', 1440, Object(Closure))
#7 /var/www/html/vendor/october/rain/src/Database/QueryBuilder.php(158): Illuminate\Cache\CacheManager->__call('remember', Array)
#8 /var/www/html/vendor/october/rain/src/Database/QueryBuilder.php(121): October\Rain\Database\QueryBuilder->getCached(Array)
#9 /var/www/html/vendor/october/rain/src/Database/QueryBuilder.php(92): October\Rain\Database\QueryBuilder->getDuplicateCached(Array)
#10 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(481): October\Rain\Database\QueryBuilder->get(Array)
#11 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(465): Illuminate\Database\Eloquent\Builder->getModels(Array)
#12 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(77): Illuminate\Database\Eloquent\Builder->get(Array)
#13 /var/www/html/modules/system/behaviors/SettingsModel.php(114): Illuminate\Database\Eloquent\Builder->first()
#14 /var/www/html/modules/system/behaviors/SettingsModel.php(76): System\Behaviors\SettingsModel->getSettingsRecord()
#15 /var/www/html/modules/system/behaviors/SettingsModel.php(135): System\Behaviors\SettingsModel->instance()
#16 [internal function]: System\Behaviors\SettingsModel->get('static_pages_me...')
#17 /var/www/html/vendor/october/rain/src/Extension/ExtendableTrait.php(409): call_user_func_array(Array, Array)
#18 /var/www/html/vendor/october/rain/src/Database/Model.php(635): October\Rain\Database\Model->extendableCall('get', Array)
#19 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1489): October\Rain\Database\Model->__call('get', Array)
#20 /var/www/html/plugins/janvince/smallextensions/Plugin.php(597): Illuminate\Database\Eloquent\Model::__callStatic('get', Array)
#21 /var/www/html/modules/system/classes/PluginManager.php(293): JanVince\SmallExtensions\Plugin->boot()
#22 /var/www/html/modules/system/classes/PluginManager.php(275): System\Classes\PluginManager->bootPlugin(Object(JanVince\SmallExtensions\Plugin))
#23 /var/www/html/modules/system/ServiceProvider.php(96): System\Classes\PluginManager->bootAll()
#24 [internal function]: System\ServiceProvider->boot()
#25 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(29): call_user_func_array(Array, Array)
#26 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(87): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#27 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(31): Illuminate\Container\BoundMethod::callBoundMethod(Object(October\Rain\Foundation\Application), Array, Object(Closure))
#28 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(549): Illuminate\Container\BoundMethod::call(Object(October\Rain\Foundation\Application), Array, Array, NULL)
#29 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(792): Illuminate\Container\Container->call(Array)
#30 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(775): Illuminate\Foundation\Application->bootProvider(Object(System\ServiceProvider))
#31 [internal function]: Illuminate\Foundation\Application->Illuminate\Foundation\{closure}(Object(System\ServiceProvider), 24)
#32 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(776): array_walk(Array, Object(Closure))
#33 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/BootProviders.php(17): Illuminate\Foundation\Application->boot()
#34 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(213): Illuminate\Foundation\Bootstrap\BootProviders->bootstrap(Object(October\Rain\Foundation\Application))
#35 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(296): Illuminate\Foundation\Application->bootstrapWith(Array)
#36 /var/www/html/install_files/php/Installer.php(677): Illuminate\Foundation\Console\Kernel->bootstrap()
#37 /var/www/html/install_files/php/Installer.php(408): Installer->bootFramework()
#38 /var/www/html/install_files/php/Installer.php(378): Installer->buildConfigFile()
#39 /var/www/html/install_files/php/Installer.php(48): Installer->onInstallStep()
#40 /var/www/html/install_files/php/boot.php(91): Installer->__construct()
#41 /var/www/html/install.php(1): include('/var/www/html/i...')
#42 {main}

[RLJMedia]

I also get this when I use this command.

[w20k]

Few things to try out @RLJMedia:

• mysql -u root -p || sudo mysql -u root -p (can you connect directly?) Or this might be your issue: https://askubuntu.com/a/763359
• php artisan cache:clear (might help 😄)
• Also, check your password for MySQL, old versions doesn't support # or few other special symbols
• Wild shoot here, maybe you have .env?

[RLJMedia]

1. I am able to login as " mysql -u root -p || sudo mysql -u root -p"

2. When I use this command, I get this result with out sudo and with sudo.

3. I reinstalled mysql from scratch and removed any # from my password:

4. Wild shoot here, maybe you have .env? ( I assume .env is related to docker files. I am not using docker.

Do you think it is because I used this command to secure the database: ?

sudo mysql_secure_installation

Maybe I have to allow remote root login? not sure at this point what is possible to get my project from OctoberCMS to work.

Thank you for your time in helping me.

I am not giving up!

[Samuell1]

Did you changed your database settings in config? @RLJMedia

[RLJMedia]

What database settings in config are you referring to? do you mean mysql database config?

[Samuell1]

@RLJMedia in config/database.php

[RLJMedia]

I did check that file and added the details manually. The install did not complete. However, when I enter this information, It has led me to do a sql dump by importing a working install of OctoberCMS from a 16.04 LTS box and the import of the database failed. I kinda now see issues with the MYSQL import. An error comes up in PHPMyadmin exactly as this article describes.

https://stackoverflow.com/questions/48001569/phpmyadmin-count-parameter-must-be-an-array-or-an-object-that-implements-co

I followed the instructions and the error persists.

I will continuing to figure this out.

[RLJMedia]

I have fixed the import error in MSQL using this technique below.

https://devanswers.co/problem-php-7-2-phpmyadmin-warning-in-librariessql-count/

Now when I manually configure the config/database.php

The new error is this:

[w20k]

@RLJMedia great news, have you tried installing from scratch? I'm guessing you're trying to add plugins or go for install using projectId. There is a bug in installer, that's why mainly you'd use composer install or from scratch. It doesn't support plugins with dependency.

[RLJMedia]

Hi just tried it from scratch and I have success.

I do not have a domain name pointed to the site and only using a test ip address

Example dummy ip http://33.72.101.133/

Default apache page show up now

the backed does not work as well http://33.72.101.133/backend

[RLJMedia]

I fixed the dummy ip by removing the index.html file so the index.php loads and the site is up.

Now, the only issue is the backend is not working with the ip address Not working http://33.72.101.133/backend

Almost working. Once I get to the backend I should be golden!

[w20k]

Just double-check your apache configs and .htacess, and you should be good ;) https://octobercms.com/docs/setup/configuration#apache-configuration https://github.com/octobercms/october/blob/master/.htaccess - if it's there ))

[RLJMedia]

Thank you , Thank you , Thank you!!!!!!!!!

I looks and feels so good!!!

I appreciate everyones help on this install.

[w20k]

@RLJMedia - have fun ;) Will be closing this ticket! You could use slack channel (https://octobercms.com/support) for tips&tricks, also https://octobertricks.com