1 Reply by lostwf

(5 replies, posted in Report Bugs here)

Hi

Why are you dropping my company data that is defined as company 0_?

DROP TABLE IF EXISTS `0_security_roles`;

CREATE TABLE `0_security_roles` (

Thanks
Wayne

Go to forum: Report Bugs here

2 Reply by lostwf

(5 replies, posted in Report Bugs here)

hi

I used the "5 Digit American coa with education Data"

Thanks

Go to forum: Report Bugs here

3 Topic by lostwf

(5 replies, posted in Report Bugs here)

Hi

After some troubleshooting I found that the 1_security_roles table was blank and I copied all the contents from 0_security_roles to 1_security_roles

INSERT INTO 1_security_roles
SELECT *
FROM 0_security_roles

I am able to login to the second company(us 5 with educational data)

I am not sure if this is kept in the company script or in FA

thanks
Wayne

Go to forum: Report Bugs here

4 Reply by lostwf

(10 replies, posted in Report Bugs here)

Thanks it is working

Go to forum: Report Bugs here

5 Topic by lostwf

(10 replies, posted in Report Bugs here)

Hi

Completed a new install of 2.4.6

I have tried all the suggestions in
https://frontaccounting.com/punbb/viewtopic.php?id=6833
https://frontaccounting.com/punbb/viewtopic.php?id=5724
https://frontaccounting.com/punbb/viewtopic.php?id=7195

None of them have worked

Below is my installation

PHP version >=5.0.0     Required     7.0.33-0+deb9u3     Ok
PHP MySQL extension     Required     Yes     Ok
Server system     Info     Linux     Ok
Database auth file     Required     ../config_db.php     Ok
Main config file     Required     ../config.php     Ok
Company subdirectories consistency     Required     ../company/0/*
../company/0/*/images
../company/0/*/pdf_files
../company/0/*/backup
../company/0/*/js_cache     Ok
Language configuration consistency     Required         Ok
Temporary directory     Required     ../tmp     Ok
Session save path     Info     /var/lib/php/sessions     Ok
Extensions system     Required     ../installed_extensions.php
../company/0/*/installed_extensions.php
../modules
../modules/_cache
../themes
../sql
OpenSSL PHP extension     Ok


http://anonymous:password@repo.frontaccounting.eu/2.4/ does not work and
repo.frontaccounting.eu redirects to frontaccounting.com


Any other suggestions?

Thanks
Wayne

Go to forum: Report Bugs here

6 Reply by lostwf

(8 replies, posted in Setup)

Hi

It was the same database, the admin user record was created, the security roles were not created for the second company

Go to forum: Setup

7 Reply by lostwf

(8 replies, posted in Setup)

Hi apmuthu

After some troubleshooting I found that the 1_security_roles table was blank and I copied all the contents from 0_security_roles to 1_security_roles

INSERT INTO 1_security_roles
SELECT *
FROM 0_security_roles

I am able to login to the second company

thanks
Wayne

Go to forum: Setup

8 Reply by lostwf

(8 replies, posted in Setup)

Users table in CSV format

"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"

Go to forum: Setup

9 Reply by lostwf

(8 replies, posted in Setup)

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

Go to forum: Setup

10 Topic by lostwf

(8 replies, posted in Setup)

hi All

I have created a new company, my first company works correctly and I can logon to the first company(0). The default "password" does not work for my new company. I get the following errors
"Incorrect Password
The user and password combination is not valid for the system.
If you are not an authorized user, please contact your system administrator to obtain an account to enable you to use the system."


I have checked the users table and the md5 has is 5f4dcc3b5aa765d61d8327deb882cf99, I have enabled the debug and the sql statements in the footer and I have not been able to get any more details. I have also copied the md5 has from company 0 to company 1 and the company 0 password does not work either

Any suggestions?


Diagnostics attached

Test     Test type     Value     Comments
MySQL version >=4.1     Required     10.3.7-MariaDB     Ok
PHP version >=5.0.0     Required     5.6.39     Ok
Http server type     Info     Apache/2.2.34 (Unix) mod_fastcgi/mod_fastcgi-SNAP-0910052141     Ok
Server system     Info     Linux     Ok
Browser type     Info     Mozilla/5.0 (Windows NT 10.0; WOW64; rv:60.0) Gecko/20100101 Firefox/60.0     Ok
Native gettext     Optional     Yes     Ok
Debugging mode     Info     Yes     Ok
Error logging     Recommended     ../tmp/errors.log     Ok
Current database version     Required     2.4.1     Ok
Company subdirectories consistency     Required     ../company/0/*
../company/0/*/images
../company/0/*/pdf_files
../company/0/*/backup
../company/0/*/js_cache     Ok
Language configuration consistency     Required     en_AU
en_US
en_ZA     Missing system locale: en_AU.iso-8859-1
Missing system locale: en_US.iso-8859-1
Missing system locale: en_ZA.iso-8859-1
Temporary directory     Required     ../tmp     Ok
Session save path     Info     /var/services/tmp     Ok

Go to forum: Setup