Password not working for new company(1)

Comments below
"Logout
Clear browser cache
Close all instances of the browser
Login"

For the first item, I tried connecting using a different computer and browser that has not connected to FrontAcc before and it resulted in the same issue

"List the contents of the users table."

id    user_id    password    real_name    role_id    phone    email    language    date_format    date_sep    tho_sep    dec_sep    theme    page_size    prices_dec    qty_dec    rates_dec    percent_dec    show_gl    show_codes    show_hints    last_visit_date    query_size    graphic_links    pos    print_profile    rep_popup    sticky_doc_date    startup_tab    transaction_days    save_report_selections    use_date_picker    def_print_destination    def_print_orientation    inactive   
1    admin    5f4dcc3b5aa765d61d8327deb882cf99    Administrator    2        adm@adm.com    en_US    1    0    0    0    default    Letter    2    2    4    1    1    0    0    2009-06-24 20:28:10    10    1    1        1    0    orders    30    0    1    0    0    0   
2    demouser    5f4dcc3b5aa765d61d8327deb882cf99    Demo User    2       
    NULL
    en_US    1    0    0    0    default    Letter    2    2    4    1    1    0    0    2009-06-24 17:39:42    10    1    1        1    0    orders    30    0    1    0    0    0   

"Check if the IP Hijack code is causing issues with your PHP version." I don't understand how to do this I could not find anything useful on Google, can you please point me in the correct direction?

"Your diagnostics are for company 0 - list it for the company 1 or whichever failed. " Can only provide diagnostics for Company 0, I cannot logon to company 1 to provide you with the diagnostics for company 1.

Thanks you very much for your reply
Wayne

The users db seems okay.

Even though you could not log into the company 1, the errors would still be available in the tmp/*.logs files as well as the apache error logs at /var/log/....

The key error that appears is the lack of the en_AU locale from:
"Missing system locale: en_AU.iso-8859-1"
that the chart wants.

On a fresh install of FA 2.4.6+ Git Master code base, create company 0 and company 1 using the en_US-new and demo sql files as the chart of accounts.

Set the default "C" or en_US language locales to start with - do not make any changes for the Australian locale now.

Now see if you can login to both companies.

If all goes well, then install the en_AU locale in the server OS and then reboot the server for good measure and try with en_AU chart of accounts drawn from the FA24extensions repo - the official chart may not have been updated as yet.

The IP Hijacking code is listed in the wiki and referred to in a few posts in the forum but that addresses a connectivity recognition issue that may mostly not be directly relevant here.

The use of the bleeding edge MariaDB may have issues with FA's use of zero dates where strict date mode may need to be switched off. Assume you are using Ubuntu 18.04.

You used the same database for the second company. Wonder how the admin user record did not get created in it's users table.