corbetto

Members
 View Profile  See their activity

  • Posts

    7

  • Joined

  • Last visited

 Content Type 

Posts posted by corbetto

    [Support] Akaunting

    in Docker Containers

    Posted

    On 6/21/2022 at 6:19 PM, Chiacomo said:

    Hi,

     

    i have the same problem. I didn't use akaunting for 2 weeks. Yesterday i wanted to use it. I tried to login and but the login site didn't load.

    This was in the log files and the container stopped:

     

     Some options are missing and --no-interaction is present. Please run the following command for more information :
    ❌ php artisan help install
    ❌ Missing options are : db-port

     

    After editing the settings of the container and set setup to false, i restartet the container. I entered my credentials at the login screen but nothing

    happens.

     

    Now i have a big problem to get it work again. I only have backups fom the database. I don*t no what happend. I think the problem comes from an

    update because i see the login screen in a new design.

     

    Please help me because i am in big trouble.

     

    When i use this line in the container:

    php artisan install --db-host "ip_of_dbhost" --db-port "port_number_of_db" --db-name "db_name_here" --db-username "db_username_here" --db-password "db_password_here" --company-name "company_name" --company-email "company@mail" --admin-email "email@mail" --admin-password "password_here" --locale "en-US"

     

    with my values, it connects to the database and after a few seconds this error came:


    In Connection.php line 742:
                                                                                                       
      SQLSTATE[HY000]: General error: 1005 Can't create table `akaunting`.`2gl_media` (errno: 121 "Du  
      plicate key on write or update") (SQL: alter table `2gl_media` add constraint `original_media_i  
      d` foreign key (`original_media_id`) references `2gl_media` (`id`) on delete set null)           
                                                                                                       

    In Connection.php line 527:
                                                                                                       
      SQLSTATE[HY000]: General error: 1005 Can't create table `akaunting`.`2gl_media` (errno: 121 "Du  
      plicate key on write or update")   

     

     

    Best Regards

    Im in the exact same boat, if you find out anything please share!

    [Support] Akaunting

    in Docker Containers

    Posted

    I did make some further progress by adding the SeverName line to my local server ip with port for akaunting in the apache.conf file within the console - this stopped the fully qual'd domain name error. But i still cannot get pass the login, allthough the logs say that its POST ing 

    [Support] Akaunting

    in Docker Containers

    Posted

    1 minute ago, Danuel said:

     

     

    if you open akaunting console and type  "service apache2 restart" still not working ?

     

    Yup still not working, it shuts down container then this appears in log:

    Module rewrite already enabled
    AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.18.0.6. Set the 'ServerName' directive globally to suppress this message
    AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.18.0.6. Set the 'ServerName' directive globally to suppress this message
    [Sun Jun 19 19:31:27.215839 2022] [mpm_prefork:notice] [pid 1] AH00163: Apache/2.4.53 (Debian) PHP/8.1.7 configured -- resuming normal operations
    [Sun Jun 19 19:31:27.215879 2022] [core:notice] [pid 1] AH00094: Command line: 'apache2 -D FOREGROUND'

    [Support] Akaunting

    in Docker Containers

    Posted

    Still having issues not been able to login now getting this error output any help please!!!

    Enabling module rewrite.
    To activate the new configuration, you need to run:
    service apache2 restart
    AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.18.0.6. Set the 'ServerName' directive globally to suppress this message
    AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.18.0.6. Set the 'ServerName' directive globally to suppress this message
    [Sun Jun 19 19:13:43.286237 2022] [mpm_prefork:notice] [pid 1] AH00163: Apache/2.4.53 (Debian) PHP/8.1.7 configured -- resuming normal operations
    [Sun Jun 19 19:13:43.286280 2022] [core:notice] [pid 1] AH00094: Command line: 'apache2 -D FOREGROUND'
    172.18.0.1 - - [19/Jun/2022:19:13:51 +1200] "GET / HTTP/1.1" 302 1624 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.123.123.115 Safari/537.36"

    [Support] Akaunting

    in Docker Containers

    Posted

    Just updated to the latest version and get constantly stuck on login - just hangs when i press login. Only thing that looks out of order in the log is this:

    [2022-06-09 09:25:31] production.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'accounting.ak_users' doesn't exist (SQL: select * from `ak_users` where `email` = [email protected] and `ak_users`.`deleted_at` is null limit 1) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'accounting.ak_users' doesn't exist (SQL: select * from `ak_users` where `email` = [email protected] and `ak_users`.`deleted_at` is null limit 1) at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:742)