Problem after update - Customer company info - missing customers

[cr1zz]

Hey all,

I will try my luck here too

After I migrated and updated my OTRS (3.2.x -> 3.3.x -> 4.0.10) everything seems to work.
But know I'm missing the customers in the customer company screen.

Any help appreciated.

[crythias]

The code doesn't delete customer information. check your tables.

[cr1zz]

Hey crythias,

thanks for your answer. The tables seems to be ok (customer info equals in both systems - live/test).
Next I experienced: If I manually add a new customer via the customer company info the new record does not show up in the info screen? <-- At test system.

MySQLcheck command runs smooth without any errors.

[crythias]

Note that 4.0 thinks customers are different from customer users.

[cr1zz]

In what way the customers were changed in OTRS 4.0?

If I use the following button, there should be a new customer user at the customer information center?

[crythias]

I don't use the German interface. Note that there is an active German language forum on this site.

[cr1zz]

Yeah I know, but I don't get an answer there, so I thought someone here might help me.

[rmueller]

I have exactly the same problem. cr1zz could you find a solution?

Cheers, Reto

[crythias]

If I manually add a new customer via the customer company info the new record does not show up in the info screen? <-- At test system.

It shouldn't. It will only show if you add a new customer via the customer user info screen, and that only if the ticket has been created with the customer. If the ticket was created, then the customer user was created, click the customer button on the ticket and choose the correct customer.

Somehow you appear to be looking at the wrong customer screen, but I can't verify this and can't imagine that this is a problem with the language.

[cr1zz]

It shouldn't. It will only show if you add a new customer via the customer user info screen, and that only if the ticket has been created with the customer. If the ticket was created, then the customer user was created, click the customer button on the ticket and choose the correct customer.

Somehow you appear to be looking at the wrong customer screen, but I can't verify this and can't imagine that this is a problem with the language.

I cannot confirm this. I did this in my live system, and the new customer appears after creating him via customer company info screen (please see attachments - If you have problems with the german just ask ).

Step 1

step1.jpg

Step 2

step2.jpg

Step 3

step3.jpg

[crythias]

I really am having difficulties assisting with this. To me, it seems there is something wrong with Config.pm or that would show up in the System Logs or error logs ... "Sorry customer doesn't exist".

[cr1zz]

I really am having difficulties assisting with this. To me, it seems there is something wrong with Config.pm or that would show up in the System Logs or error logs ... "Sorry customer doesn't exist".

Config.pm was copied and rebuilded. No entry in the error log regarding this

[cr1zz]

Additional info:

Problem occurs from update 3.3.x to 4.0.x.
Before I updated from 3.2.10 to 3.3.x -> Everything was ok

Perhaps something with our unique customer_user table design?

2015-08-26 13_25_20-Microsoft Excel - ExcelFile_2015-08-26T13_24_09.xlsx.jpg

[crythias]

What is custom about your customer Config?

[cr1zz]

What is custom about your customer Config?

Sorry, but what is a customer config?

//EDIT: If you mean the table: We added 4 fields as you can see in the screenshot.

//EDIT2: Here the errors during the update to 4.0.x

scripts/DBUpdate-to-4.mysql.sql

Code: Select all

ERROR 1060 (42S21) at line 9: Duplicate column name 'disposition'
ERROR 1060 (42S21) at line 13: Duplicate column name 'disposition'
INFO: Foreign key constraint FK_ticket_valid_id_id does not exist, skipping.
INFO: Foreign key constraint FK_ticket_valid_id_id does not exist, skipping.
ERROR 1091 (42000) at line 23: Can't DROP 'valid_id'; check that column/key exists
INFO: Foreign key constraint FK_ticket_history_valid_id_id does not exist, skipping.
INFO: Foreign key constraint FK_ticket_history_valid_id_id does not exist, skipping.
ERROR 1091 (42000) at line 33: Can't DROP 'valid_id'; check that column/key exists
ERROR 1050 (42S01) at line 38: Table 'personal_services' already exists
ERROR 1091 (42000) at line 47: Can't DROP 'content_size'; check that column/key exists
ERROR 1050 (42S01) at line 51: Table 'system_maintenance' already exists
ERROR 1005 (HY000) at line 66: Can't create table 'otrs.#sql-a605_6b' (errno: 121)
ERROR 1005 (HY000) at line 67: Can't create table 'otrs.#sql-a605_6b' (errno: 121)
ERROR 1005 (HY000) at line 68: Can't create table 'otrs.#sql-a605_6b' (errno: 121)
ERROR 1005 (HY000) at line 69: Can't create table 'otrs.#sql-a605_6b' (errno: 121)
ERROR 1005 (HY000) at line 70: Can't create table 'otrs.#sql-a605_6b' (errno: 121)

DBUpdate-to-4.pl

Code: Select all

Migration started...

Step 1 of 15: Refresh configuration cache...
If you see warnings about 'Subroutine Load redefined', that's fine, no need to worry!
done.

Step 2 of 15: Check framework version... [Wed Aug 26 12:58:25 2015] DBUpdate-to-4.pl: Subroutine Load redefined at /opt/otrs/Kernel/Config/Files/ZZZAuto.pm line 7.
done.

Step 3 of 15: Migrate FontAwesome icons... [Wed Aug 26 12:58:25 2015] DBUpdate-to-4.pl: utf8 "\xF6" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 464, <$In> line 201.
[Wed Aug 26 12:58:25 2015] DBUpdate-to-4.pl: utf8 "\xF6" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 464, <$In> line 347.
[Wed Aug 26 12:58:25 2015] DBUpdate-to-4.pl: Malformed UTF-8 character (unexpected non-continuation byte 0x67, immediately after start byte 0xf6) in print at /opt/otrs/Kernel/System/SysConfig.pm line 1926.
[Wed Aug 26 12:58:25 2015] DBUpdate-to-4.pl: Code point 0x0000 is not Unicode, may not be portable at /opt/otrs/Kernel/System/SysConfig.pm line 1926.
[Wed Aug 26 12:58:25 2015] DBUpdate-to-4.pl: Malformed UTF-8 character (unexpected non-continuation byte 0x67, immediately after start byte 0xf6) in print at /opt/otrs/Kernel/System/SysConfig.pm line 1926.
[Wed Aug 26 12:58:25 2015] DBUpdate-to-4.pl: Code point 0x0000 is not Unicode, may not be portable at /opt/otrs/Kernel/System/SysConfig.pm line 1926.
[Wed Aug 26 12:58:25 2015] DBUpdate-to-4.pl: utf8 "\xF6" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 464, <$In> line 201.
[Wed Aug 26 12:58:25 2015] DBUpdate-to-4.pl: utf8 "\xF6" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 464, <$In> line 347.
[Wed Aug 26 12:58:25 2015] DBUpdate-to-4.pl: Malformed UTF-8 character (unexpected non-continuation byte 0x67, immediately after start byte 0xf6) in print at /opt/otrs/Kernel/System/SysConfig.pm line 1926.
[Wed Aug 26 12:58:25 2015] DBUpdate-to-4.pl: Code point 0x0000 is not Unicode, may not be portable at /opt/otrs/Kernel/System/SysConfig.pm line 1926.
[Wed Aug 26 12:58:25 2015] DBUpdate-to-4.pl: Malformed UTF-8 character (unexpected non-continuation byte 0x67, immediately after start byte 0xf6) in print at /opt/otrs/Kernel/System/SysConfig.pm line 1926.
[Wed Aug 26 12:58:25 2015] DBUpdate-to-4.pl: Code point 0x0000 is not Unicode, may not be portable at /opt/otrs/Kernel/System/SysConfig.pm line 1926.
[Wed Aug 26 12:58:25 2015] DBUpdate-to-4.pl: utf8 "\xF6" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 464, <$In> line 201.
[Wed Aug 26 12:58:25 2015] DBUpdate-to-4.pl: utf8 "\xF6" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 464, <$In> line 347.
[Wed Aug 26 12:58:25 2015] DBUpdate-to-4.pl: Malformed UTF-8 character (unexpected non-continuation byte 0x67, immediately after start byte 0xf6) in print at /opt/otrs/Kernel/System/SysConfig.pm line 1926.
[Wed Aug 26 12:58:25 2015] DBUpdate-to-4.pl: Code point 0x0000 is not Unicode, may not be portable at /opt/otrs/Kernel/System/SysConfig.pm line 1926.
[Wed Aug 26 12:58:25 2015] DBUpdate-to-4.pl: Malformed UTF-8 character (unexpected non-continuation byte 0x67, immediately after start byte 0xf6) in print at /opt/otrs/Kernel/System/SysConfig.pm line 1926.
[Wed Aug 26 12:58:25 2015] DBUpdate-to-4.pl: Code point 0x0000 is not Unicode, may not be portable at /opt/otrs/Kernel/System/SysConfig.pm line 1926.
[Wed Aug 26 12:58:25 2015] DBUpdate-to-4.pl: utf8 "\xF6" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 464, <$In> line 201.
[Wed Aug 26 12:58:25 2015] DBUpdate-to-4.pl: utf8 "\xF6" does not map to Unicode at /opt/otrs/Kernel/System/SysConfig.pm line 464, <$In> line 347.
[Wed Aug 26 12:58:25 2015] DBUpdate-to-4.pl: Malformed UTF-8 character (unexpected non-continuation byte 0x67, immediately after start byte 0xf6) in print at /opt/otrs/Kernel/System/SysConfig.pm line 1926.
[Wed Aug 26 12:58:25 2015] DBUpdate-to-4.pl: Code point 0x0000 is not Unicode, may not be portable at /opt/otrs/Kernel/System/SysConfig.pm line 1926.
[Wed Aug 26 12:58:25 2015] DBUpdate-to-4.pl: Malformed UTF-8 character (unexpected non-continuation byte 0x67, immediately after start byte 0xf6) in print at /opt/otrs/Kernel/System/SysConfig.pm line 1926.
[Wed Aug 26 12:58:25 2015] DBUpdate-to-4.pl: Code point 0x0000 is not Unicode, may not be portable at /opt/otrs/Kernel/System/SysConfig.pm line 1926.
done.

Step 4 of 15: Migrate ProcessManagement EntityIDs...
 Process EntityIDs Migration Reference
  PROCESS:

  ACTIVITY:

  ACTIVITY DIALOG:

  TRANSITION:

  TRANSITION ACTION:


done.

Step 5 of 15: Migrate ProcessManagement Dynamic Field Types... done.

Step 6 of 15: Migrate ACLs stored in the DB... done.

Step 7 of 15: Set service notifications... done.

Step 8 of 15: Migrate Settings... done.

Step 9 of 15: Uninstall Merged Feature Add-Ons... ERROR: OTRS-DBUpdate-to-4.pl-31 Perl: 5.20.2 OS: linux Time: Wed Aug 26 12:58:26 2015

 Message: No such file: /opt/otrs/Kernel/Config/Files/Support.xml!

 Traceback (45865):
   Module: Kernel::System::Package::_FileRemove Line: 3412
   Module: Kernel::System::Package::PackageUninstall Line: 1162
   Module: main::_UninstallMergedFeatureAddOns Line: 1523
   Module: scripts/DBUpdate-to-4.pl Line: 176

ERROR: OTRS-DBUpdate-to-4.pl-31 Perl: 5.20.2 OS: linux Time: Wed Aug 26 12:58:26 2015

 Message: No such file: /opt/otrs/Kernel/Language/de_Support.pm!

 Traceback (45865):
   Module: Kernel::System::Package::_FileRemove Line: 3412
   Module: Kernel::System::Package::PackageUninstall Line: 1162
   Module: main::_UninstallMergedFeatureAddOns Line: 1523
   Module: scripts/DBUpdate-to-4.pl Line: 176

ERROR: OTRS-DBUpdate-to-4.pl-31 Perl: 5.20.2 OS: linux Time: Wed Aug 26 12:58:26 2015

 Message: No such file: /opt/otrs/Kernel/Language/es_MX_Support.pm!

 Traceback (45865):
   Module: Kernel::System::Package::_FileRemove Line: 3412
   Module: Kernel::System::Package::PackageUninstall Line: 1162
   Module: main::_UninstallMergedFeatureAddOns Line: 1523
   Module: scripts/DBUpdate-to-4.pl Line: 176

ERROR: OTRS-DBUpdate-to-4.pl-31 Perl: 5.20.2 OS: linux Time: Wed Aug 26 12:58:26 2015

 Message: No such file: /opt/otrs/Kernel/Modules/AdminSupport.pm!

 Traceback (45865):
   Module: Kernel::System::Package::_FileRemove Line: 3412
   Module: Kernel::System::Package::PackageUninstall Line: 1162
   Module: main::_UninstallMergedFeatureAddOns Line: 1523
   Module: scripts/DBUpdate-to-4.pl Line: 176

ERROR: OTRS-DBUpdate-to-4.pl-31 Perl: 5.20.2 OS: linux Time: Wed Aug 26 12:58:26 2015

 Message: No such file: /opt/otrs/Kernel/Output/HTML/Standard/AdminSupport.dtl!

 Traceback (45865):
   Module: Kernel::System::Package::_FileRemove Line: 3412
   Module: Kernel::System::Package::PackageUninstall Line: 1162
   Module: main::_UninstallMergedFeatureAddOns Line: 1523
   Module: scripts/DBUpdate-to-4.pl Line: 176

ERROR: OTRS-DBUpdate-to-4.pl-31 Perl: 5.20.2 OS: linux Time: Wed Aug 26 12:58:26 2015

 Message: No such file: /opt/otrs/Kernel/Output/HTML/Standard/AdminSupportLicenseText.dtl!

 Traceback (45865):
   Module: Kernel::System::Package::_FileRemove Line: 3412
   Module: Kernel::System::Package::PackageUninstall Line: 1162
   Module: main::_UninstallMergedFeatureAddOns Line: 1523
   Module: scripts/DBUpdate-to-4.pl Line: 176

ERROR: OTRS-DBUpdate-to-4.pl-31 Perl: 5.20.2 OS: linux Time: Wed Aug 26 12:58:26 2015

 Message: No such file: /opt/otrs/Kernel/System/Support.pm!

 Traceback (45865):
   Module: Kernel::System::Package::_FileRemove Line: 3412
   Module: Kernel::System::Package::PackageUninstall Line: 1162
   Module: main::_UninstallMergedFeatureAddOns Line: 1523
   Module: scripts/DBUpdate-to-4.pl Line: 176

ERROR: OTRS-DBUpdate-to-4.pl-31 Perl: 5.20.2 OS: linux Time: Wed Aug 26 12:58:26 2015

 Message: No such file: /opt/otrs/Kernel/System/Support/Database.pm!

 Traceback (45865):
   Module: Kernel::System::Package::_FileRemove Line: 3412
   Module: Kernel::System::Package::PackageUninstall Line: 1162
   Module: main::_UninstallMergedFeatureAddOns Line: 1523
   Module: scripts/DBUpdate-to-4.pl Line: 176

ERROR: OTRS-DBUpdate-to-4.pl-31 Perl: 5.20.2 OS: linux Time: Wed Aug 26 12:58:26 2015

 Message: No such file: /opt/otrs/Kernel/System/Support/OS.pm!

 Traceback (45865):
   Module: Kernel::System::Package::_FileRemove Line: 3412
   Module: Kernel::System::Package::PackageUninstall Line: 1162
   Module: main::_UninstallMergedFeatureAddOns Line: 1523
   Module: scripts/DBUpdate-to-4.pl Line: 176

ERROR: OTRS-DBUpdate-to-4.pl-31 Perl: 5.20.2 OS: linux Time: Wed Aug 26 12:58:26 2015

 Message: No such file: /opt/otrs/Kernel/System/Support/OTRS.pm!

 Traceback (45865):
   Module: Kernel::System::Package::_FileRemove Line: 3412
   Module: Kernel::System::Package::PackageUninstall Line: 1162
   Module: main::_UninstallMergedFeatureAddOns Line: 1523
   Module: scripts/DBUpdate-to-4.pl Line: 176

ERROR: OTRS-DBUpdate-to-4.pl-31 Perl: 5.20.2 OS: linux Time: Wed Aug 26 12:58:26 2015

 Message: No such file: /opt/otrs/Kernel/System/Support/Webserver/IIS.pm!

 Traceback (45865):
   Module: Kernel::System::Package::_FileRemove Line: 3412
   Module: Kernel::System::Package::PackageUninstall Line: 1162
   Module: main::_UninstallMergedFeatureAddOns Line: 1523
   Module: scripts/DBUpdate-to-4.pl Line: 176

ERROR: OTRS-DBUpdate-to-4.pl-31 Perl: 5.20.2 OS: linux Time: Wed Aug 26 12:58:26 2015

 Message: No such file: /opt/otrs/Kernel/System/Support/Webserver/Apache.pm!

 Traceback (45865):
   Module: Kernel::System::Package::_FileRemove Line: 3412
   Module: Kernel::System::Package::PackageUninstall Line: 1162
   Module: main::_UninstallMergedFeatureAddOns Line: 1523
   Module: scripts/DBUpdate-to-4.pl Line: 176

ERROR: OTRS-DBUpdate-to-4.pl-31 Perl: 5.20.2 OS: linux Time: Wed Aug 26 12:58:26 2015

 Message: No such file: /opt/otrs/Kernel/System/Support/Database/oracle.pm!

 Traceback (45865):
   Module: Kernel::System::Package::_FileRemove Line: 3412
   Module: Kernel::System::Package::PackageUninstall Line: 1162
   Module: main::_UninstallMergedFeatureAddOns Line: 1523
   Module: scripts/DBUpdate-to-4.pl Line: 176

ERROR: OTRS-DBUpdate-to-4.pl-31 Perl: 5.20.2 OS: linux Time: Wed Aug 26 12:58:26 2015

 Message: No such file: /opt/otrs/Kernel/System/Support/Database/mssql.pm!

 Traceback (45865):
   Module: Kernel::System::Package::_FileRemove Line: 3412
   Module: Kernel::System::Package::PackageUninstall Line: 1162
   Module: main::_UninstallMergedFeatureAddOns Line: 1523
   Module: scripts/DBUpdate-to-4.pl Line: 176

ERROR: OTRS-DBUpdate-to-4.pl-31 Perl: 5.20.2 OS: linux Time: Wed Aug 26 12:58:26 2015

 Message: No such file: /opt/otrs/Kernel/System/Support/Database/postgresql.pm!

 Traceback (45865):
   Module: Kernel::System::Package::_FileRemove Line: 3412
   Module: Kernel::System::Package::PackageUninstall Line: 1162
   Module: main::_UninstallMergedFeatureAddOns Line: 1523
   Module: scripts/DBUpdate-to-4.pl Line: 176

ERROR: OTRS-DBUpdate-to-4.pl-31 Perl: 5.20.2 OS: linux Time: Wed Aug 26 12:58:26 2015

 Message: No such file: /opt/otrs/Kernel/System/Support/Database/mysql.pm!

 Traceback (45865):
   Module: Kernel::System::Package::_FileRemove Line: 3412
   Module: Kernel::System::Package::PackageUninstall Line: 1162
   Module: main::_UninstallMergedFeatureAddOns Line: 1523
   Module: scripts/DBUpdate-to-4.pl Line: 176

ERROR: OTRS-DBUpdate-to-4.pl-31 Perl: 5.20.2 OS: linux Time: Wed Aug 26 12:58:26 2015

 Message: No such file: /opt/otrs/Kernel/System/Support/Webserver.pm!

 Traceback (45865):
   Module: Kernel::System::Package::_FileRemove Line: 3412
   Module: Kernel::System::Package::PackageUninstall Line: 1162
   Module: main::_UninstallMergedFeatureAddOns Line: 1523
   Module: scripts/DBUpdate-to-4.pl Line: 176

ERROR: OTRS-DBUpdate-to-4.pl-31 Perl: 5.20.2 OS: linux Time: Wed Aug 26 12:58:26 2015

 Message: No such file: /opt/otrs/Kernel/cpan-lib/Archive/Tar/Constant.pm!

 Traceback (45865):
   Module: Kernel::System::Package::_FileRemove Line: 3412
   Module: Kernel::System::Package::PackageUninstall Line: 1162
   Module: main::_UninstallMergedFeatureAddOns Line: 1523
   Module: scripts/DBUpdate-to-4.pl Line: 176

ERROR: OTRS-DBUpdate-to-4.pl-31 Perl: 5.20.2 OS: linux Time: Wed Aug 26 12:58:26 2015

 Message: No such file: /opt/otrs/Kernel/cpan-lib/Archive/Tar/File.pm!

 Traceback (45865):
   Module: Kernel::System::Package::_FileRemove Line: 3412
   Module: Kernel::System::Package::PackageUninstall Line: 1162
   Module: main::_UninstallMergedFeatureAddOns Line: 1523
   Module: scripts/DBUpdate-to-4.pl Line: 176

ERROR: OTRS-DBUpdate-to-4.pl-31 Perl: 5.20.2 OS: linux Time: Wed Aug 26 12:58:26 2015

 Message: No such file: /opt/otrs/Kernel/cpan-lib/Archive/Tar.pm!

 Traceback (45865):
   Module: Kernel::System::Package::_FileRemove Line: 3412
   Module: Kernel::System::Package::PackageUninstall Line: 1162
   Module: main::_UninstallMergedFeatureAddOns Line: 1523
   Module: scripts/DBUpdate-to-4.pl Line: 176

Notice: Backup for changed file: /opt/otrs/Kernel/cpan-lib/Linux/Distribution.pm.backup
ERROR: OTRS-DBUpdate-to-4.pl-31 Perl: 5.20.2 OS: linux Time: Wed Aug 26 12:58:26 2015

 Message: Can't remove file /opt/otrs/Kernel/cpan-lib/Linux/Distribution.pm, because it a framework file and no other one exists!

 Traceback (45865):
   Module: Kernel::System::Package::_FileRemove Line: 3435
   Module: Kernel::System::Package::PackageUninstall Line: 1162
   Module: main::_UninstallMergedFeatureAddOns Line: 1523
   Module: scripts/DBUpdate-to-4.pl Line: 176

ERROR: OTRS-DBUpdate-to-4.pl-31 Perl: 5.20.2 OS: linux Time: Wed Aug 26 12:58:26 2015

 Message: No such file: /opt/otrs/var/httpd/htdocs/skins/Agent/default/css/Support.Default.css!

 Traceback (45865):
   Module: Kernel::System::Package::_FileRemove Line: 3412
   Module: Kernel::System::Package::PackageUninstall Line: 1162
   Module: main::_UninstallMergedFeatureAddOns Line: 1523
   Module: scripts/DBUpdate-to-4.pl Line: 176

Notice: DROP TABLE IF EXISTS support_bench_test
done.

Step 10 of 15: Migrate SysConfig settings from DT to Template::Toolkit... done.

Step 11 of 15: Migrate Dynamic Field links from DT to Template::Toolkit... done.

Step 12 of 15: Migrate Generic Agent Process Management Dynamic Fields ... done.

Step 13 of 15: Migrate Notification (Event) Process Management Dynamic Fields ... done.

Step 14 of 15: Clean up the cache... done.

Step 15 of 15: Refresh configuration cache another time...
If you see warnings about 'Subroutine Load redefined', that's fine, no need to worry!
done.

Migration completed!

Is there something that would indicate my problem?

[crythias]

multiple issues I can't diagnose here. Some look like duplicate run of update. Some look like bad entries.

This is beyond the scope of what can be determined on a free forum.

[cr1zz]

Ok, for testing purposes I created a new test server with a blank 3.2.10 otrs and did the upgrading like on my other test system (3.2.10 -> 3.3.14 -> 4.0.11).

I created 2 customers and 2 customer-users. After the upgrade to 4.0.11 again all customers are missing in the customer infor screen?!

What am I doing wrong?

[rmueller]

Probably I do have a different issue.

In the customer information center - customer users does work with users and componies stored in the internal or external database but it does not work if the users are stored in an ldap directory. Do I have to configure something in the Config.pm or does it not work with an ldap backend?

Thanks for your support.

Cheers,
Reto

[crythias]

Do I have to configure something in the Config.pm or does it not work with an ldap backend

This is important information that was glossed over during this conversation. It was assumed that customers were sourced from the database ... probably because you modified the database.

So, no, customers don't sync from LDAP to the database. The information is queried from the source on demand. Which means that if it's not working, you were using a third party ldap source util, perhaps, that doesn't seem to work in 4.0.

[cr1zz]

Do I have to configure something in the Config.pm or does it not work with an ldap backend

This is important information that was glossed over during this conversation. It was assumed that customers were sourced from the database ... probably because you modified the database.

So, no, customers don't sync from LDAP to the database. The information is queried from the source on demand. Which means that if it's not working, you were using a third party ldap source util, perhaps, that doesn't seem to work in 4.0.

Here are 2 different cases My database is the integrated one...