Forum

(2/2) QueryException & (1/2) PDOException

Posted in CategoryInstallation & Update
  • Gabriel Guitart    ( User ) 1 year ago

    I get this error all the time or something like that.
    I have been using php 5.6.4 and 7.1


    Database, user name etc is fine and all the php modules specified in the documentaion are also ok according to the php.info on my server.


    Database is partially created, many tables are missing. If I don't delete the database and I keep installing, the installation adds more tables ... a few more every installation.


     


    This is the error:


    (1/2) PDOException


    SQLSTATE[HY000] [1045] Access denied for user 'bderpuser'@'localhost' (using password: YES)


    in Connector.php (line 68)


    at PDO->__construct('mysql:host=localhost;port=3306;dbname=bderp', 'bderpuser', 'xxxxxxxB_PASSWORD=', array(0, 2, 0, false, false))


    in Connector.php (line 68)


    at Connector->createPdoConnection('mysql:host=localhost;port=3306;dbname=bderp', 'bderpuser', 'xxxxxxDB_PASSWORD=', array(0, 2, 0, false, false))


    in Connector.php (line 45)


    etc etc.


     


    QueryException


    SQLSTATE[HY000] [1045] Access denied for user 'bderpuser'@'localhost' (using password: YES) (SQL: insert into `zyc_companies` (`domain`, `updated_at`, `created_at`) values (, 2018-02-01 09:12:18, 2018-02-01 09:12:18))


    in Connection.php (line 647)


    at Connection->runQueryCallback('insert into `zyc_companies` (`domain`, `updated_at`, `created_at`) values (?, ?, ?)', array('', '2018-02-01 09:12:18', '2018-02-01 09:12:18'), object(Closure))


    in Connection.php (line 607)


    at Connection->run('insert into `zyc_companies` (`domain`, `updated_at`, `created_at`) values (?, ?, ?)', array('', '2018-02-01 09:12:18', '2018-02-01 09:12:18'), object(Closure))


     


    in Connection.php (line 450)


     


    etc etc.


     


     

  • Gabriel Guitart    ( User ) 1 year ago

    Ok. Sorry. Solved ( somehow )


    If mysql user uses a "$" symbol in the password the installation process crashes.


    I had to add an unsecure password to the user, and the installation process could finish

  • Sebastian Di Luise    ( User ) 1 year ago

    Hi Gabriel,


    Strange! I have just added a $ symbol in the middle of mysql user password for Akaunting and it works.  Maybe its only in installation process, can you post back trying to change the password now that you have it installed?


     

  • Sebastian Di Luise    ( User ) 1 year ago

    Can confirm... if yous password has for ie $ as a character in the password... you cant end the installation.  Just choose alphanumeric password for now and you can end the install right.  If you broke the install in the middle, you have to delete the database and the .env file in your install dir to start again right.

  • Denis Duliçi    ( Admin ) 1 year ago

    Guys, can you please try the following version of Akaunting: https://akaunting.com/download.php?version=1.1.6

  • Sebastian Di Luise    ( User ) 1 year ago

    Yup, just test 1.1.6, same problem.  Here a pastebin with the error, it happens after clicking "next"in Step 3/3 : Company and Admin Details, from installation.


    Then seems to create 39 tables in the database (compared with the 42 tables from a good install), and leaves the .env (so if you try again it wont start the wizard). 


    Database code is latin1_swedish_ci, tables codes are utf8mb4_unicode_ci, if it helps...


    https://pastebin.com/tg9NgpYm


    (if you need askme to start a github issue, if it is an issue :-p)

  • Denis Duliçi    ( Admin ) 1 year ago

    The code at pastebin says that your password is "Akaunting9". And the same code says that "akaunting_user" doesn't have access rights so it seems you're having an issue with MySQL permissions.

  • Sebastian Di Luise    ( User ) 1 year ago

    Nop, the password there is Akaunting$900, see that it cuts for some reason.  The user is right because it's the same I have working on the good installation.  Just have changed the pass for the test.  Try yourself to be sure.

  • Denis Duliçi    ( Admin ) 1 year ago

    This has been fixed in Akaunting 1.1.12 version released today.

Please login or register to leave a response.