Forum

Ask, reply and learn. Join the community of Akaunting.

New Discussion

Problem installing fresh new 1.2 'forge'@'localhost' user

Sebastian Di Luise   ( User )

Commented 5 years ago

Just downloaded 1.2, trying to fresh new install, after clicking install button gives whoops... seems a forge@localhost user got left in some php?


 


Thanks



































(3/3) QueryException


SQLSTATE[HY000] [1045] Access denied for user 'forge'@'localhost' (using password: NO) (SQL: insert into `ak_companies` (`domain`, `updated_at`, `created_at`) values (, 2018-05-03 15:28:43, 2018-05-03 15:28:43))


in Connection.php line 647
at Connection->runQueryCallback('insert into `ak_companies` (`domain`, `updated_at`, `created_at`) values (?, ?, ?)', array('', '2018-05-03 15:28:43', '2018-05-03 15:28:43'), object(Closure))in Connection.php line 607
at Connection->run('insert into `ak_companies` (`domain`, `updated_at`, `created_at`) values (?, ?, ?)', array('', '2018-05-03 15:28:43', '2018-05-03 15:28:43'), object(Closure))in Connection.php line 450
at Connection->statement('insert into `ak_companies` (`domain`, `updated_at`, `created_at`) values (?, ?, ?)', array('', '2018-05-03 15:28:43', '2018-05-03 15:28:43'))in Connection.php line 404
at Connection->insert('insert into `ak_companies` (`domain`, `updated_at`, `created_at`) values (?, ?, ?)', array('', '2018-05-03 15:28:43', '2018-05-03 15:28:43'))in Processor.php line 32
at Processor->processInsertGetId(object(Builder), 'insert into `ak_companies` (`domain`, `updated_at`, `created_at`) values (?, ?, ?)', array('', '2018-05-03 15:28:43', '2018-05-03 15:28:43'), 'id')in Builder.php line 2133
at Builder->insertGetId(array('', '2018-05-03 15:28:43', '2018-05-03 15:28:43'), 'id')in Builder.php line 1251
at Builder->__call('insertGetId', array(array('domain' => '', 'updated_at' => '2018-05-03 15:28:43', 'created_at' => '2018-05-03 15:28:43'), 'id'))in Model.php line 688

 

Denis Dulici   ( Admin )

Commented 5 years ago

I just tried and it worked fine. Make sure you're file/folder permissions allow the system to rename .env.example file.

Sebastian Di Luise   ( User )

Commented 5 years ago

Thanks Denis, just checked! no file/folder permission problem (i think)


Have you noticed the "Access denied for user 'forge'@'localhost'" I have no user forge@ on mysql server, that users seems to be 'hardcoded', is it possible? do you use that user on your testings/develp server?

Denis Dulici   ( Admin )

Commented 5 years ago

No, that is used by Laravel when it's not able to read the .env file:


https://github.com/akaunting/akaunting/blob/master/config/database.php#L46

Sebastian Di Luise   ( User )

Commented 5 years ago

OK, hope its only my installation, will try to solve it my side.


Strange that inside akaunting install dir (/var/www/html/akaunting/) I ran:


sudo -u www-data touch test.txt


And the file is created with www-data user (the same user apache runs in ubuntu 16.04)


And outside (/var/www/html/) where www-data has no write permission it wont let create, permission denied: sudo -u www-data touch ../test.test

Please login or register to leave a response.

Showing 1 to 5 of 5 discussions