System auto kills the session and user is redirected to the login page, the duration is not fixed. Sometimes it happens ASAP sometimes it takes hours, pls help.
Steps to reproduce
Install owncloud server 10.0.8
Connect owncloud server using this login URL
It will automatically logout for no reason, after the connection with owncloud (10.0.8).
Expected behaviour
Owncloud
Actual behaviour
Owncloud gets logged out automatically in the middle if the session. Timing is not specific, as session logout happens at any point of time.
Server configuration
Operating system: Ubuntu 16.04.5 LTS
Web server: Apache/2.4.18
**Database:**MySql 5.7
**PHP version:**Php 7.0
**ownCloud version:**10.0.08
Updated from an older ownCloud or fresh install: Fresh Install
Where did you install ownCloud from: official site of Owncloud
Signing status (ownCloud 9.0 and above):
Login as admin user into your ownCloud and access
http://example.com/index.php/settings/integrity/failed
paste the results into https://gist.github.com/ and puth the link here.
<script src="https://gist.github.com/bhaskar3110/d246c4bf7d27063ffb1c5a369f1a0f86.js"></script>
https://gist.github.com/bhaskar3110/d246c4bf7d27063ffb1c5a369f1a0f86
**The content of config/config.php:**
<?php
$CONFIG = array (
'memcache.local' => '\\OC\\Memcache\\APCu',
'memcache.locking' => '\\OC\\Memcache\\Redis',
'redis' =>
array (
'host' => 'localhost',
'port' => 6379,
),
'instanceid' => '************',
'passwordsalt' => '**********************',
'secret' => '***********************************',
'trusted_domains' =>
array (
0 => 'localhost',
1 => 'local_IPaddress',
2 => 'sample.com',
),
'datadirectory' => '/var/www/html/owncloud/data',
'overwrite.cli.url' => 'https://sample.com/owncloud/index.php',
'dbtype' => 'mysql',
'version' => '10.0.8.5',
'dbname' => 'owncloud',
'dbhost' => 'localhost',
'dbtableprefix' => 'oc_',
'mysql.utf8mb4' => true,
'dbuser' => '********',
'dbpassword' => '********',
'logtimezone' => 'UTC',
'installed' => true,
'mail_domain' => 'sample.com',
'mail_from_address' => 'created_user',
'mail_smtpmode' => 'smtp',
'mail_smtphost' => 'maildomain.com',
'mail_smtpport' => 'portno',
'ldapIgnoreNamingRules' => false,
'loglevel' => 0,
'enable_certificate_management' => true,
'debug' => false,
'session_lifetime' => 60 * 60 * 24,
'onlyoffice' =>
array (
'verify_peer_off' => true,
),
);
*ATTENTION:* Do not post your config.php file in public as is. Please use one of the above
methods whenever possible. Both, the generated reports from the web-ui and from occ config:list
consistently remove sensitive data. You still may want to review the report before sending.
If done manually then it is critical for your own privacy to dilligently
remove *all* host names, passwords, usernames, salts and other credentials before posting.
You should assume that attackers find such information and will use them against your systems.
List of activated apps:
#0 /var/www/html/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(429): OC\DB\Connection->connect()
#1 /var/www/html/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(389): Doctrine\DBAL\Connection->getDatabasePlatformVersion()
#2 /var/www/html/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(328): Doctrine\DBAL\Connection->detectDatabasePlatform()
#3 /var/www/html/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(623): Doctrine\DBAL\Connection->getDatabasePlatform()
#4 /var/www/html/owncloud/lib/private/DB/Connection.php(145): Doctrine\DBAL\Connection->setTransactionIsolation(2)
#5 /var/www/html/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/DriverManager.php(172): OC\DB\Connection->__construct(Array, Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Configuration), Object(Doctrine\Common\EventManager))
#6 /var/www/html/owncloud/lib/private/DB/ConnectionFactory.php(145): Doctrine\DBAL\DriverManager::getConnection(Array, Object(Doctrine\DBAL\Configuration), Object(Doctrine\Common\EventManager))
#7 /var/www/html/owncloud/lib/private/Server.php(521): OC\DB\ConnectionFactory->getConnection(‘mysql’, Array)
#8 /var/www/html/owncloud/lib/composer/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC{closure}(Object(OC\Server))
#9 /var/www/html/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(111): Pimple\Container->offsetGet(‘DatabaseConnect…’)
#10 /var/www/html/owncloud/lib/private/ServerContainer.php(87): OC\AppFramework\Utility\SimpleContainer->query(‘DatabaseConnect…’)
#11 /var/www/html/owncloud/lib/private/Server.php(1192): OC\ServerContainer->query(‘DatabaseConnect…’)
#12 /var/www/html/owncloud/lib/private/Server.php(398): OC\Server->getDatabaseConnection()
#13 /var/www/html/owncloud/lib/composer/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC{closure}(Object(OC\Server))
#14 /var/www/html/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(111): Pimple\Container->offsetGet(‘AppConfig’)
#15 /var/www/html/owncloud/lib/private/ServerContainer.php(87): OC\AppFramework\Utility\SimpleContainer->query(‘AppConfig’)
#16 /var/www/html/owncloud/lib/private/Server.php(1121): OC\ServerContainer->query(‘AppConfig’)
#17 /var/www/html/owncloud/lib/private/Server.php(575): OC\Server->getAppConfig()
#18 /var/www/html/owncloud/lib/composer/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC{closure}(Object(OC\Server))
#19 /var/www/html/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(111): Pimple\Container->offsetGet(‘AppManager’)
#20 /var/www/html/owncloud/lib/private/ServerContainer.php(87): OC\AppFramework\Utility\SimpleContainer->query(‘AppManager’)
#21 /var/www/html/owncloud/lib/private/Server.php(1391): OC\ServerContainer->query(‘AppManager’)
#22 /var/www/html/owncloud/lib/private/legacy/app.php(346): OC\Server->getAppManager()
#23 /var/www/html/owncloud/lib/private/legacy/app.php(110): OC_App::getEnabledApps()
#24 /var/www/html/owncloud/lib/base.php(579): OC_App::loadApps(Array)
#25 /var/www/html/owncloud/lib/base.php(997): OC::init()
#26 /var/www/html/owncloud/console.php(64): require_once(’/var/www/html/o…’)
#27 /var/www/html/owncloud/occ(11): require_once(’/var/www/html/o…’)
#28 {main}PHP Fatal error: Uncaught Doctrine\DBAL\DBALException: Failed to connect to the database: An exception occured in driver: could not find driver in /var/www/html/owncloud/lib/private/DB/Connection.php:62
Stack trace:
#0 /var/www/html/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(429): OC\DB\Connection->connect()
#1 /var/www/html/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(389): Doctrine\DBAL\Connection->getDatabasePlatformVersion()
#2 /var/www/html/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(328): Doctrine\DBAL\Connection->detectDatabasePlatform()
#3 /var/www/html/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(623): Doctrine\DBAL\Connection->getDatabasePlatform()
#4 /var/www/html/owncloud/lib/private/DB/Connection.php(145): Doctrine\DBAL\Connection->setTransactionIsolation(2)
#5 /var/www/html/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/DriverManager.php(172): OC\DB\Connection->__construct(Array, Object(Doctrine\DBAL\Driver\ in /var/www/html/owncloud/lib/private/DB/Connection.php on line 62
**Are you using external storage, if yes which one: NO
Are you using encryption: No
Are you using an external user-backend, if yes which one: LDAP
mysql> SELECT * FROM `oc_appconfig` WHERE `appid` = 'user_ldap';
+-----------+--------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| appid | configkey | configvalue |
+-----------+--------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| user_ldap | enabled | yes |
| user_ldap | installed_version | 0.11.0 |
| user_ldap | s01has_memberof_filter_support | |
| user_ldap | s01home_folder_naming_rule | |
| user_ldap | s01last_jpegPhoto_lookup | 0 |
| user_ldap | s01ldap_agent_password | ******** |
| user_ldap | s01ldap_attributes_for_group_search | |
| user_ldap | s01ldap_attributes_for_user_search | |
| user_ldap | s01ldap_backup_host | |
| user_ldap | s01ldap_backup_port | |
| user_ldap | s01ldap_base | dc=com |
| user_ldap | s01ldap_base_groups | dc=com |
| user_ldap | s01ldap_base_users | dc=com |
| user_ldap | s01ldap_cache_ttl | 600 |
| user_ldap | s01ldap_configuration_active | 1 |
| user_ldap | s01ldap_display_name | displayname |
| user_ldap | s01ldap_dn | uid=zimbra,cn=admins,cn=zimbra |
| user_ldap | s01ldap_dynamic_group_member_url | |
| user_ldap | s01ldap_email_attr | mail |
| user_ldap | s01ldap_experienced_admin | 1 |
| user_ldap | s01ldap_expert_username_attr | |
| user_ldap | s01ldap_expert_uuid_group_attr | |
| user_ldap | s01ldap_expert_uuid_user_attr | entryuuid |
| user_ldap | s01ldap_group_display_name | cn |
| user_ldap | s01ldap_group_filter | (|(cn=Bdmanage)(cn=Brand Connect)(cn=Content Audio)(cn=Content Graphics)(cn=Content Planning)(cn=Content Writer)(cn=IMI Alerts)(cn=MobileBusiness)(cn=Online_QC)(cn=Staff)(cn=Tech Team)(cn=Test)(cn=content.editors)(cn=dth.animator)(cn=operations)(cn=shemaroopackshots)) |
| user_ldap | s01ldap_group_filter_mode | 0 |
| user_ldap | s01ldap_group_member_assoc_attribute | memberUid |
| user_ldap | s01ldap_groupfilter_groups | Bdmanage
Brand Connect
Content Audio
Content Graphics
Content Planning
Content Writer
IMI Alerts
MobileBusiness
Online_QC
Staff
Tech Team
Test
content.editors
dth.animator
operations
shemaroopackshots |
| user_ldap | s01ldap_groupfilter_objectclass | |
| user_ldap | s01ldap_host | Domainname.com |
| user_ldap | s01ldap_login_filter | (&(|(objectclass=organizationalPerson)(objectclass=zimbraAccount))(|(uid=%uid)(|(mailPrimaryAddress=%uid)(mail=%uid))(|(mail=%uid)(objectClass=%uid)(userPassword=%uid)))) |
| user_ldap | s01ldap_login_filter_mode | 0 |
| user_ldap | s01ldap_loginfilter_attributes | mail
objectClass
userPassword |
| user_ldap | s01ldap_loginfilter_email | 1 |
| user_ldap | s01ldap_loginfilter_username | 1 |
| user_ldap | s01ldap_nested_groups | 0 |
| user_ldap | s01ldap_override_main_server | |
| user_ldap | s01ldap_paging_size | 500 |
| user_ldap | s01ldap_port | 389 |
| user_ldap | s01ldap_quota_attr | |
| user_ldap | s01ldap_quota_def | |
| user_ldap | s01ldap_tls | 0 |
| user_ldap | s01ldap_turn_off_cert_check | 0 |
| user_ldap | s01ldap_user_display_name_2 | |
| user_ldap | s01ldap_user_filter_mode | 0 |
| user_ldap | s01ldap_userfilter_groups | |
| user_ldap | s01ldap_userfilter_objectclass | organizationalPerson
***** |
| user_ldap | s01ldap_userlist_filter | (|(objectclass=organizationalPerson)(objectclass=zimbraAccount)) |
| user_ldap | s01use_memberof_to_detect_membership | 1 |
| user_ldap | signed | true |
| user_ldap | types | authentication |
+-----------+--------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
51 rows in set (0.00 sec)
### Client configuration
**Browser: chrome , Mozilla, IE .
**Operating system: Windows 10.
### Logs
#### ownCloud log (data/owncloud.log)