search

snipe / snipe-it

A free open source IT asset/license management system
https://snipeitapp.com
GNU Affero General Public License v3.0
10.97k stars 3.16k forks source link

Ldap sync is only working when Debug mode is True, The moment I turn it false it stops responding #10335

Open Pkumar22in opened 2 years ago

Pkumar22in commented 2 years ago

Debug mode

Describe the bug

Ldap synch is only working when Debug mode is True, The moment I turn it false it stops responding. Snipe-IT version v5.3.2 build 6508 (g7ce5993f5) Software License AGPL3 PHP Version 7.4.25 Laravel Version 6.20.29

I have total 7 instance of SnipeIT running with latest and n-1 versions and managing more than 50k assets, out of 7 only 1 is miss behaving.

Reproduction steps

  1. Debug if set to "false"
  2. Hit "Test LDAP Sync" button
  3. we get "500 Server Error. Please check your server logs for more information." Some time you credentials are not correct.
  4. Set Debug to to "True"
  5. Hit "Test LDAP Sync" button
  6. We get success with 10 records as sample.

Please note: during this entire process no setting other than debug was changed. same Login creds in both cases. ...

Expected behavior

expected behaviour is to get sucess message for ldap test synch and 10 records even when debug is set to "False"

Screenshots

Screenshot 2021-11-19 at 11 26 29 AM

Snipe-IT Version

v5.3.2 build 6508 (g7ce5993f5)

Operating System

ubuntu

Web Server

Apache

PHP Version

7.4.25 Laravel Version 6.20.29

Operating System

Mac windows

Browser

Chrome, safari

Version

No response

Device

No response

Operating System

No response

Browser

No response

Version

No response

Error messages

When Turned on every thing works like a clock work, hence don't have any error message with debug turned on.

Additional context

No response

welcome[bot] commented 2 years ago

👋 Thanks for opening your first issue here! If you're reporting a 🐞 bug, please make sure you include steps to reproduce it. We get a lot of issues on this repo, so please be patient and we will get back to you as soon as we can.

uberbrady commented 2 years ago

What a weird problem! What do you see in storage/logs/laravel.log when debug is turned off? If it's 500'ing, there should be some kind of error in there.

Pkumar22in commented 2 years ago

Hi,

Thanks for responding back to me.

error I am getting in laravel.log is as below.

[2021-11-18 01:54:09] production.ERROR: SQLSTATE[HY000] [2002] Connection refused (SQL: select from users where username = TLA10226 and users.deleted_at is null limit 1) {"exception":"[object] (Illuminate\Database\QueryException(code: 2002): SQLSTATE[HY000] [2002] Connection refused (SQL: select from users where username = TLA10226 and users.deleted_at is null limit 1) at /var/www/assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Connection.php:669 http://assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Connection.php:669)[stacktrace]

0 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Connection.php(743): Illuminate\Database\Connection->runQueryCallback()

1 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Connection.php(723): Illuminate\Database\Connection->tryAgainIfCausedByLostConnection()

2 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Connection.php(632): Illuminate\Database\Connection->handleQueryException()

3 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Connection.php(338): Illuminate\Database\Connection->run()

4 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2159): Illuminate\Database\Connection->select()

5 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2147): Illuminate\Database\Query\Builder->runSelect()

6 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2619): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()

7 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2148): Illuminate\Database\Query\Builder->onceWithColumns()

8 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(546): Illuminate\Database\Query\Builder->get()

9 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(530): Illuminate\Database\Eloquent\Builder->getModels()

10 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(143): Illuminate\Database\Eloquent\Builder->get()

11 /var/www/assets.ekoexcel.org.ng/app/Console/Commands/LdapSync.php(194):

Illuminate\Database\Eloquent\Builder->first()

12 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Console\Commands\LdapSync->handle()

13 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Container/Util.php(37): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()

14 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()

15 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()

16 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Container/Container.php(590): Illuminate\Container\BoundMethod::call()

17 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Console/Command.php(134): Illuminate\Container\Container->call()

18 /var/www/

assets.ekoexcel.org.ng/vendor/symfony/console/Command/Command.php(255): Illuminate\Console\Command->execute()

19 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\Component\Console\Command\Command->run()

20 /var/www/

assets.ekoexcel.org.ng/vendor/symfony/console/Application.php(1009): Illuminate\Console\Command->run()

21 /var/www/

assets.ekoexcel.org.ng/vendor/symfony/console/Application.php(273): Symfony\Component\Console\Application->doRunCommand()

22 /var/www/

assets.ekoexcel.org.ng/vendor/symfony/console/Application.php(149): Symfony\Component\Console\Application->doRun()

23 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Console/Application.php(93): Symfony\Component\Console\Application->run()

24 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(131): Illuminate\Console\Application->run()

25 /var/www/assets.ekoexcel.org.ng/artisan(35):

Illuminate\Foundation\Console\Kernel->handle()

26 {main}

[previous exception] [object] (Doctrine\DBAL\Driver\PDO\Exception(code: 2002): SQLSTATE[HY000] [2002] Connection refused at /var/www/assets.ekoexcel.org.ng/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18 http://assets.ekoexcel.org.ng/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18) [stacktrace]

0 /var/www/

assets.ekoexcel.org.ng/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(43): Doctrine\DBAL\Driver\PDO\Exception::new()

1 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(67): Doctrine\DBAL\Driver\PDOConnection->__construct()

2 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(100): Illuminate\Database\Connectors\Connector->createPdoConnection()

3 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(50): Illuminate\Database\Connectors\Connector->tryAgainIfCausedByLostConnection()

4 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(24): Illuminate\Database\Connectors\Connector->createConnection()

5 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php(182): Illuminate\Database\Connectors\MySqlConnector->connect()

6 [internal function]:

Illuminate\Database\Connectors\ConnectionFactory->Illuminate\Database\Connectors\{closure}()

7 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Connection.php(924): call_user_func()

8 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Connection.php(959): Illuminate\Database\Connection->getPdo()

9 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Connection.php(404): Illuminate\Database\Connection->getReadPdo()

10 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Connection.php(330): Illuminate\Database\Connection->getPdoForSelect()

11 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Connection.php(662): Illuminate\Database\Connection->Illuminate\Database\{closure}()

12 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Connection.php(743): Illuminate\Database\Connection->runQueryCallback()

13 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Connection.php(723): Illuminate\Database\Connection->tryAgainIfCausedByLostConnection()

14 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Connection.php(632): Illuminate\Database\Connection->handleQueryException()

15 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Connection.php(338): Illuminate\Database\Connection->run()

16 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2159): Illuminate\Database\Connection->select()

17 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2147): Illuminate\Database\Query\Builder->runSelect()

18 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2619): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()

19 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2148): Illuminate\Database\Query\Builder->onceWithColumns()

20 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(546): Illuminate\Database\Query\Builder->get()

21 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(530): Illuminate\Database\Eloquent\Builder->getModels()

22 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(143): Illuminate\Database\Eloquent\Builder->get()

23 /var/www/assets.ekoexcel.org.ng/app/Console/Commands/LdapSync.php(194):

Illuminate\Database\Eloquent\Builder->first()

24 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Console\Commands\LdapSync->handle()

25 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Container/Util.php(37): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()

26 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()

27 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()

28 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Container/Container.php(590): Illuminate\Container\BoundMethod::call()

29 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Console/Command.php(134): Illuminate\Container\Container->call()

30 /var/www/

assets.ekoexcel.org.ng/vendor/symfony/console/Command/Command.php(255): Illuminate\Console\Command->execute()

31 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\Component\Console\Command\Command->run()

32 /var/www/

assets.ekoexcel.org.ng/vendor/symfony/console/Application.php(1009): Illuminate\Console\Command->run()

33 /var/www/

assets.ekoexcel.org.ng/vendor/symfony/console/Application.php(273): Symfony\Component\Console\Application->doRunCommand()

34 /var/www/

assets.ekoexcel.org.ng/vendor/symfony/console/Application.php(149): Symfony\Component\Console\Application->doRun()

35 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Console/Application.php(93): Symfony\Component\Console\Application->run()

36 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(131): Illuminate\Console\Application->run()

37 /var/www/assets.ekoexcel.org.ng/artisan(35):

Illuminate\Foundation\Console\Kernel->handle()

38 {main}

[previous exception] [object] (PDOException(code: 2002): SQLSTATE[HY000] [2002] Connection refused at /var/www/assets.ekoexcel.org.ng/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:39 http://assets.ekoexcel.org.ng/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:39)[stacktrace]

0 /var/www/

assets.ekoexcel.org.ng/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(39): PDO->__construct()

1 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(67): Doctrine\DBAL\Driver\PDOConnection->__construct()

2 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(100): Illuminate\Database\Connectors\Connector->createPdoConnection()

3 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(50): Illuminate\Database\Connectors\Connector->tryAgainIfCausedByLostConnection()

4 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(24): Illuminate\Database\Connectors\Connector->createConnection()

5 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php(182): Illuminate\Database\Connectors\MySqlConnector->connect()

6 [internal function]:

Illuminate\Database\Connectors\ConnectionFactory->Illuminate\Database\Connectors\{closure}()

7 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Connection.php(924): call_user_func()

8 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Connection.php(959): Illuminate\Database\Connection->getPdo()

9 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Connection.php(404): Illuminate\Database\Connection->getReadPdo()

10 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Connection.php(330): Illuminate\Database\Connection->getPdoForSelect()

11 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Connection.php(662): Illuminate\Database\Connection->Illuminate\Database\{closure}()

12 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Connection.php(743): Illuminate\Database\Connection->runQueryCallback()

13 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Connection.php(723): Illuminate\Database\Connection->tryAgainIfCausedByLostConnection()

14 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Connection.php(632): Illuminate\Database\Connection->handleQueryException()

15 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Connection.php(338): Illuminate\Database\Connection->run()

16 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2159): Illuminate\Database\Connection->select()

17 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2147): Illuminate\Database\Query\Builder->runSelect()

18 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2619): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()

19 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2148): Illuminate\Database\Query\Builder->onceWithColumns()

20 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(546): Illuminate\Database\Query\Builder->get()

21 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(530): Illuminate\Database\Eloquent\Builder->getModels()

22 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(143): Illuminate\Database\Eloquent\Builder->get()

23 /var/www/assets.ekoexcel.org.ng/app/Console/Commands/LdapSync.php(194):

Illuminate\Database\Eloquent\Builder->first()

24 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Console\Commands\LdapSync->handle()

25 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Container/Util.php(37): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()

26 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()

27 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()

28 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Container/Container.php(590): Illuminate\Container\BoundMethod::call()

29 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Console/Command.php(134): Illuminate\Container\Container->call()

30 /var/www/

assets.ekoexcel.org.ng/vendor/symfony/console/Command/Command.php(255): Illuminate\Console\Command->execute()

31 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\Component\Console\Command\Command->run()

32 /var/www/

assets.ekoexcel.org.ng/vendor/symfony/console/Application.php(1009): Illuminate\Console\Command->run()

33 /var/www/

assets.ekoexcel.org.ng/vendor/symfony/console/Application.php(273): Symfony\Component\Console\Application->doRunCommand()

34 /var/www/

assets.ekoexcel.org.ng/vendor/symfony/console/Application.php(149): Symfony\Component\Console\Application->doRun()

35 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Console/Application.php(93): Symfony\Component\Console\Application->run()

36 /var/www/

assets.ekoexcel.org.ng/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(131): Illuminate\Console\Application->run()

37 /var/www/assets.ekoexcel.org.ng/artisan(35):

Illuminate\Foundation\Console\Kernel->handle()

38 {main}

"}

--

Regards

Prem Kumar Tewari Associate Director, IT Operations Mob : +91.8800.816.082 Skype: premkrtewari [image: NewGlobe] https://newglobe.education/ Website https://newglobe.education/ | LinkedIn https://www.linkedin.com/company/newglobe

On Sat, 20 Nov 2021 at 03:46, Brady Wetherington @.***> wrote:

What a weird problem! What do you see in storage/logs/laravel.log when debug is turned off? If it's 500'ing, there should be some kind of error in there.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/snipe/snipe-it/issues/10335#issuecomment-974508793, or unsubscribe https://github.com/notifications/unsubscribe-auth/AWONTYS37RILK4GGL5W2SQDUM3EE5ANCNFSM5ILLE2OQ . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

snipe commented 2 years ago

production.ERROR: SQLSTATE[HY000] [2002] Connection refused (SQL: select * from users where username = TLA10226 and users.deleted_at is null limit 1) {"exception":"[object]

Thanks for that stack trace - that's helpful! But that means your database can't connect. That has nothing to do with our software. :(

Pkumar22in commented 2 years ago

Hi,

Thanks for pointing it out, but I still wonder how come everything works perfectly fine when Debug = True?

Same database starts responding.

--

Regards

Prem Kumar Tewari Associate Director, IT Operations Mob : +91.8800.816.082 Skype: premkrtewari [image: NewGlobe] https://newglobe.education/ Website https://newglobe.education/ | LinkedIn https://www.linkedin.com/company/newglobe

On Tue, 23 Nov 2021 at 00:12, snipe @.***> wrote:

production.ERROR: SQLSTATE[HY000] [2002] Connection refused (SQL: select * from users where username = TLA10226 and users.deleted_at is null limit 1) {"exception":"[object]

Thanks for that stack trace - that's helpful! But that means your database can't connect. That has nothing to do with our software. :(

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/snipe/snipe-it/issues/10335#issuecomment-975815034, or unsubscribe https://github.com/notifications/unsubscribe-auth/AWONTYWMBOVPNYMK5JX3DUTUNKFKXANCNFSM5ILLE2OQ . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

-- *Disclaimer: *This message, and any files transmitted with it, contains confidential information and is intended only for the individual or entity named. If you are not the intended recipient, please notify the sender immediately by e-mail and delete this e-mail from your system. If you are not the intended recipient, any disclosure, copying, distribution or action taken or omitted to be taken in reliance on this e-mail, is prohibited and may be unlawful. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version of the contents.

Pkumar22in commented 2 years ago

Hi,

There is one more finding, if I reduce the scope of synch by adding sub OU to synch configuration then again synch works fine but not for larger OU.

Any ideas?

--

Regards

Prem Kumar Tewari Associate Director, IT Operations Mob : +91.8800.816.082 Skype: premkrtewari [image: NewGlobe] https://newglobe.education/ Website https://newglobe.education/ | LinkedIn https://www.linkedin.com/company/newglobe

On Tue, 23 Nov 2021 at 10:45, Prem Tewari @.***> wrote:

Hi,

Thanks for pointing it out, but I still wonder how come everything works perfectly fine when Debug = True?

Same database starts responding.

--

Regards

Prem Kumar Tewari Associate Director, IT Operations Mob : +91.8800.816.082 Skype: premkrtewari [image: NewGlobe] https://newglobe.education/ Website https://newglobe.education/ | LinkedIn https://www.linkedin.com/company/newglobe

On Tue, 23 Nov 2021 at 00:12, snipe @.***> wrote:

production.ERROR: SQLSTATE[HY000] [2002] Connection refused (SQL: select

  • from users where username = TLA10226 and users.deleted_at is null limit 1) {"exception":"[object]

Thanks for that stack trace - that's helpful! But that means your database can't connect. That has nothing to do with our software. :(

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/snipe/snipe-it/issues/10335#issuecomment-975815034, or unsubscribe https://github.com/notifications/unsubscribe-auth/AWONTYWMBOVPNYMK5JX3DUTUNKFKXANCNFSM5ILLE2OQ . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

-- *Disclaimer: *This message, and any files transmitted with it, contains confidential information and is intended only for the individual or entity named. If you are not the intended recipient, please notify the sender immediately by e-mail and delete this e-mail from your system. If you are not the intended recipient, any disclosure, copying, distribution or action taken or omitted to be taken in reliance on this e-mail, is prohibited and may be unlawful. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version of the contents.

Pkumar22in commented 2 years ago

Hi,

I am checking again for your help to understand challenges with Ldap Synch in case of larger OU. In the current case smaller OU with 1k to 2k are getting synched easily but a OU with 15k users is not synching at all, and I get 500 error while doing the test from the front end.

--

Regards

Prem Kumar Tewari Associate Director, IT Operations Mob : +91.8800.816.082 Skype: premkrtewari [image: NewGlobe] https://newglobe.education/ Website https://newglobe.education/ | LinkedIn https://www.linkedin.com/company/newglobe

On Wed, 24 Nov 2021 at 10:31, Prem Tewari @.***> wrote:

Hi,

There is one more finding, if I reduce the scope of synch by adding sub OU to synch configuration then again synch works fine but not for larger OU.

Any ideas?

--

Regards

Prem Kumar Tewari Associate Director, IT Operations Mob : +91.8800.816.082 Skype: premkrtewari [image: NewGlobe] https://newglobe.education/ Website https://newglobe.education/ | LinkedIn https://www.linkedin.com/company/newglobe

On Tue, 23 Nov 2021 at 10:45, Prem Tewari @.***> wrote:

Hi,

Thanks for pointing it out, but I still wonder how come everything works perfectly fine when Debug = True?

Same database starts responding.

--

Regards

Prem Kumar Tewari Associate Director, IT Operations Mob : +91.8800.816.082 Skype: premkrtewari [image: NewGlobe] https://newglobe.education/ Website https://newglobe.education/ | LinkedIn https://www.linkedin.com/company/newglobe

On Tue, 23 Nov 2021 at 00:12, snipe @.***> wrote:

production.ERROR: SQLSTATE[HY000] [2002] Connection refused (SQL: select

  • from users where username = TLA10226 and users.deleted_at is null limit 1) {"exception":"[object]

Thanks for that stack trace - that's helpful! But that means your database can't connect. That has nothing to do with our software. :(

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/snipe/snipe-it/issues/10335#issuecomment-975815034, or unsubscribe https://github.com/notifications/unsubscribe-auth/AWONTYWMBOVPNYMK5JX3DUTUNKFKXANCNFSM5ILLE2OQ . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

uberbrady commented 2 years ago

You can set LDAP_MEM_LIM in your .env file, which can be like 1G or 2G - the default being 500M. There's also an LDAP_TIME_LIM which is a number of seconds - the default is 600 (10 minutes) but for a larger directory (especially for the initial sync) you'll need more time.

Pkumar22in commented 2 years ago

Hi,

I did make changes as per your instructions, but somehow that as well didn't, the moment we run the test CPU utilisation goes 100%.

--

Regards

Prem Kumar Tewari Associate Director, IT Operations Mob : +91.8800.816.082 Skype: premkrtewari [image: NewGlobe] https://newglobe.education/ Website https://newglobe.education/ | LinkedIn https://www.linkedin.com/company/newglobe

On Sat, 11 Dec 2021 at 04:57, Brady Wetherington @.***> wrote:

You can set LDAP_MEM_LIM in your .env file, which can be like 1G or 2G - the default being 500M. There's also an LDAP_TIME_LIM which is a number of seconds - the default is 600 (10 minutes) but for a larger directory (especially for the initial sync) you'll need more time.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/snipe/snipe-it/issues/10335#issuecomment-991371479, or unsubscribe https://github.com/notifications/unsubscribe-auth/AWONTYTA43MLPRLZCPC5YYLUQKEH5ANCNFSM5ILLE2OQ . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.