# Cant access config,  500 er. active db connections looks very odd!

**URL:** <https://forum.mautic.org/t/cant-access-config-500-er-active-db-connections-looks-very-odd/3786>\
**Category:** Product Support\
**Created:** [May 16, 2016, 1:10pm UTC](https://forum.mautic.org/t/cant-access-config-500-er-active-db-connections-looks-very-odd/3786 "2016-05-16T13:10:18Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mwaura](https://avatars.discourse-cdn.com/v4/letter/m/b2d939/32.png) [@mwaura](https://forum.mautic.org/u/mwaura)\
**Post date:** [May 16, 2016, 1:10pm UTC](https://forum.mautic.org/t/cant-access-config-500-er-active-db-connections-looks-very-odd/3786/1 "2016-05-16T13:10:18Z")

</div>

Anyone able to have a look at this please, started the learning curve and now I am a bit stuck. here are the logs and sys.info and ver.  
  
1.Cant access config, just get server 500 error  
  
2.Goes wrong when monitored email setting installed. (other SMTP) ssl none,port25  
  
Pauses for ever with the status curser in perpetual motion. Only way to stop is is logging out.  
  
  
  
3. Look at the active connections on the database, looks wrong although i don’t really know why!  
  
  
  
Thanks for having a look at this  
  
  
  
mwaura  
  
  
  
  
  
Version 1.4.0.1 of Mautic  
  
  
  
System Linux [vps.home.dot.com](http://vps.home.dot.com) 2.6.32-279. el6.x86\_64 #1  
  
  
  
Server API CGI/FastCGI  
  
  
  
  
  
[16-May-2016 14:14:36 Europe/London] PHP Fatal error: require(): Failed opening required ‘/home/usr/public\_html/sub/app/cache/prod/doctrine/orm/Proxies/\_\_CG\_\_MauticCategoryBundleEntityCategory.php’ (include\_path=’.:/usr/lib/php:/usr/local/lib/php’) in /home/usr/public\_html/sub/vendor/doctrine/common/lib/Doctrine/Common/Proxy/AbstractProxyFactory.php on line 207  
  
  
  
  
  
mysqlnd  
  
enabled  
  
Version  
  
mysqlnd 5.0.11-dev - 20120503 - $Id:  
  
Compression  
  
supported  
  
core SSL  
  
supported  
  
extended SSL  
  
supported  
  
Command buffer size  
  
4096  
  
Read buffer size  
  
32768  
  
Read timeout  
  
31536000  
  
Collecting statistics  
  
Yes  
  
Collecting memory statistics  
  
No  
  
Tracing  
  
n/a  
  
Loaded plugins  
  
mysqlnd, debug\_trace, auth\_plugin\_mysql\_native\_password, auth\_plugin\_mysql\_clear\_password, auth\_plugin\_sha256\_password  
  
API Extensions  
  
mysqli, mysql, pdo\_mysql  
  
mysqlnd statistics  
  
  
  
bytes\_sent  
  
2511317  
  
bytes\_received  
  
9597465  
  
packets\_sent  
  
31168  
  
packets\_received  
  
148059  
  
protocol\_overhead\_in  
  
592236  
  
protocol\_overhead\_out  
  
124672  
  
bytes\_received\_ok\_packet  
  
0  
  
bytes\_received\_eof\_packet  
  
0  
  
bytes\_received\_rset\_header\_packet  
  
92664  
  
bytes\_received\_rset\_field\_meta\_packet  
  
0  
  
bytes\_received\_rset\_row\_packet  
  
27440  
  
bytes\_received\_prepare\_response\_packet  
  
7674836  
  
bytes\_received\_change\_user\_packet  
  
1692335  
  
packets\_sent\_command  
  
15559  
  
packets\_received\_ok  
  
0  
  
packets\_received\_eof  
  
0  
  
packets\_received\_rset\_header  
  
10296  
  
packets\_received\_rset\_field\_meta  
  
0  
  
packets\_received\_rset\_row  
  
5235  
  
packets\_received\_prepare\_response  
  
92912  
  
packets\_received\_change\_user  
  
34416  
  
result\_set\_queries  
  
5113  
  
non\_result\_set\_queries  
  
122  
  
no\_index\_used  
  
5107  
  
bad\_index\_used  
  
0  
  
slow\_queries  
  
0  
  
buffered\_sets  
  
0  
  
unbuffered\_sets  
  
0  
  
ps\_buffered\_sets  
  
5113  
  
ps\_unbuffered\_sets  
  
0  
  
flushed\_normal\_sets  
  
0  
  
flushed\_ps\_sets  
  
0  
  
ps\_prepared\_never\_executed  
  
0  
  
ps\_prepared\_once\_executed  
  
5150  
  
rows\_fetched\_from\_server\_normal  
  
0  
  
rows\_fetched\_from\_server\_ps  
  
29303  
  
rows\_buffered\_from\_client\_normal  
  
0  
  
rows\_buffered\_from\_client\_ps  
  
29303  
  
rows\_fetched\_from\_client\_normal\_buffered  
  
0  
  
rows\_fetched\_from\_client\_normal\_unbuffered  
  
0  
  
rows\_fetched\_from\_client\_ps\_buffered  
  
29303  
  
rows\_fetched\_from\_client\_ps\_unbuffered  
  
0  
  
rows\_fetched\_from\_client\_ps\_cursor  
  
0  
  
rows\_affected\_normal  
  
0  
  
rows\_affected\_ps  
  
35  
  
rows\_skipped\_normal  
  
0  
  
rows\_skipped\_ps  
  
29303  
  
copy\_on\_write\_saved  
  
260925  
  
copy\_on\_write\_performed  
  
0  
  
command\_buffer\_too\_small  
  
0  
  
connect\_success  
  
25  
  
connect\_failure  
  
0  
  
connection\_reused  
  
0  
  
reconnect  
  
0  
  
pconnect\_success  
  
25  
  
**active\_connections**  
  
**18446744073709551593**  
  
**active\_persistent\_connections**  
  
**18446744073709551593**  
  
explicit\_close  
  
24  
  
implicit\_close  
  
0  
  
disconnect\_close  
  
0  
  
in\_middle\_of\_command\_close  
  
0  
  
explicit\_free\_result  
  
5113  
  
implicit\_free\_result  
  
5150  
  
explicit\_stmt\_close  
  
0  
  
implicit\_stmt\_close  
  
5150  
  
mem\_emalloc\_count  
  
0  
  
mem\_emalloc\_amount  
  
0  
  
mem\_ecalloc\_count  
  
0  
  
mem\_ecalloc\_amount  
  
0  
  
mem\_erealloc\_count  
  
0  
  
mem\_erealloc\_amount  
  
0  
  
mem\_efree\_count  
  
0  
  
mem\_efree\_amount  
  
0  
  
mem\_malloc\_count  
  
0  
  
mem\_malloc\_amount  
  
0  
  
mem\_calloc\_count  
  
0  
  
mem\_calloc\_amount  
  
0  
  
mem\_realloc\_count  
  
0  
  
mem\_realloc\_amount  
  
0  
  
mem\_free\_count  
  
0  
  
mem\_free\_amount  
  
0  
  
mem\_estrndup\_count  
  
0  
  
mem\_strndup\_count  
  
0  
  
mem\_estndup\_count  
  
0  
  
mem\_strdup\_count  
  
0  
  
proto\_text\_fetched\_null  
  
0  
  
proto\_text\_fetched\_bit  
  
0  
  
proto\_text\_fetched\_tinyint  
  
0  
  
proto\_text\_fetched\_short  
  
0  
  
proto\_text\_fetched\_int24  
  
0  
  
proto\_text\_fetched\_int  
  
0  
  
proto\_text\_fetched\_bigint  
  
0  
  
proto\_text\_fetched\_decimal  
  
0  
  
proto\_text\_fetched\_float  
  
0  
  
proto\_text\_fetched\_double  
  
0  
  
proto\_text\_fetched\_date  
  
0  
  
proto\_text\_fetched\_year  
  
0  
  
proto\_text\_fetched\_time  
  
0  
  
proto\_text\_fetched\_datetime  
  
0  
  
proto\_text\_fetched\_timestamp  
  
0  
  
proto\_text\_fetched\_string  
  
0  
  
proto\_text\_fetched\_blob  
  
0  
  
proto\_text\_fetched\_enum  
  
0  
  
proto\_text\_fetched\_set  
  
0  
  
proto\_text\_fetched\_geometry  
  
0  
  
proto\_text\_fetched\_other  
  
0  
  
proto\_binary\_fetched\_null  
  
0  
  
proto\_binary\_fetched\_bit  
  
52554  
  
proto\_binary\_fetched\_tinyint  
  
0  
  
proto\_binary\_fetched\_short  
  
88  
  
proto\_binary\_fetched\_int24  
  
0  
  
proto\_binary\_fetched\_int  
  
0  
  
proto\_binary\_fetched\_bigint  
  
220  
  
proto\_binary\_fetched\_decimal  
  
19009  
  
proto\_binary\_fetched\_float  
  
0  
  
proto\_binary\_fetched\_double  
  
0  
  
proto\_binary\_fetched\_date  
  
0  
  
proto\_binary\_fetched\_year  
  
0  
  
proto\_binary\_fetched\_time  
  
0  
  
proto\_binary\_fetched\_datetime  
  
0  
  
proto\_binary\_fetched\_timestamp  
  
66  
  
proto\_binary\_fetched\_string  
  
0  
  
proto\_binary\_fetched\_json  
  
170636  
  
proto\_binary\_fetched\_blob  
  
18352  
  
proto\_binary\_fetched\_enum  
  
0  
  
proto\_binary\_fetched\_set  
  
0  
  
proto\_binary\_fetched\_geometry  
  
0  
  
proto\_binary\_fetched\_other  
  
0  
  
init\_command\_executed\_count  
  
0  
  
init\_command\_failed\_count  
  
0  
  
com\_quit  
  
24  
  
com\_init\_db  
  
0  
  
com\_query  
  
85  
  
com\_field\_list  
  
0  
  
com\_create\_db  
  
0  
  
com\_drop\_db  
  
0  
  
com\_refresh  
  
0  
  
com\_shutdown  
  
0  
  
com\_statistics  
  
0  
  
com\_process\_info  
  
0  
  
com\_connect  
  
0  
  
com\_process\_kill  
  
0  
  
com\_debug  
  
0  
  
com\_ping  
  
0  
  
com\_time  
  
0  
  
com\_delayed\_insert  
  
0  
  
com\_change\_user  
  
0  
  
com\_binlog\_dump  
  
0  
  
com\_table\_dump  
  
0  
  
com\_connect\_out  
  
0  
  
com\_register\_slave  
  
0  
  
com\_stmt\_prepare  
  
5150  
  
com\_stmt\_execute  
  
5150  
  
com\_stmt\_send\_long\_data  
  
0  
  
com\_stmt\_close  
  
5150  
  
com\_stmt\_reset  
  
0  
  
com\_stmt\_set\_option  
  
0  
  
com\_stmt\_fetch  
  
0  
  
com\_deamon  
  
0  
  
bytes\_received\_real\_data\_normal  
  
0  
  
bytes\_received\_real\_data\_ps  
  
1283049

---

<div class="post-metadata">

**Author:** ![mwaura](https://avatars.discourse-cdn.com/v4/letter/m/b2d939/32.png) [@mwaura](https://forum.mautic.org/u/mwaura)\
**Post date:** [May 16, 2016, 1:10pm UTC](https://forum.mautic.org/t/cant-access-config-500-er-active-db-connections-looks-very-odd/3786/2 "2016-05-16T13:10:18Z")

</div>

Anyone able to have a look at this please, started the learning curve and now I am a bit stuck. here are the logs and sys.info and ver.  
1.Cant access config, just get server 500 error  
2.Goes wrong when monitored email setting installed. (other SMTP) ssl none,port25  
Pauses for ever with the status curser in perpetual motion. Only way to stop is is logging out.

1. Look at the active connections on the database, looks wrong although i don’t really know why!

Thanks for having a look at this

mwaura

Version 1.4.0.1 of Mautic

System Linux [vps.home.dot.com](http://vps.home.dot.com) 2.6.32-279. el6.x86\_64 #1

Server API CGI/FastCGI

[16-May-2016 14:14:36 Europe/London] PHP Fatal error: require(): Failed opening required ‘/home/usr/public\_html/sub/app/cache/prod/doctrine/orm/Proxies/\_\_CG\_\_MauticCategoryBundleEntityCategory.php’ (include\_path=’.:/usr/lib/php:/usr/local/lib/php’) in /home/usr/public\_html/sub/vendor/doctrine/common/lib/Doctrine/Common/Proxy/AbstractProxyFactory.php on line 207

mysqlnd  
enabled  
Version  
mysqlnd 5.0.11-dev - 20120503 - $Id:  
Compression  
supported  
core SSL  
supported  
extended SSL  
supported  
Command buffer size  
4096  
Read buffer size  
32768  
Read timeout  
31536000  
Collecting statistics  
Yes  
Collecting memory statistics  
No  
Tracing  
n/a  
Loaded plugins  
mysqlnd, debug\_trace, auth\_plugin\_mysql\_native\_password, auth\_plugin\_mysql\_clear\_password, auth\_plugin\_sha256\_password  
API Extensions  
mysqli, mysql, pdo\_mysql  
mysqlnd statistics

bytes\_sent  
2511317  
bytes\_received  
9597465  
packets\_sent  
31168  
packets\_received  
148059  
protocol\_overhead\_in  
592236  
protocol\_overhead\_out  
124672  
bytes\_received\_ok\_packet  
0  
bytes\_received\_eof\_packet  
0  
bytes\_received\_rset\_header\_packet  
92664  
bytes\_received\_rset\_field\_meta\_packet  
0  
bytes\_received\_rset\_row\_packet  
27440  
bytes\_received\_prepare\_response\_packet  
7674836  
bytes\_received\_change\_user\_packet  
1692335  
packets\_sent\_command  
15559  
packets\_received\_ok  
0  
packets\_received\_eof  
0  
packets\_received\_rset\_header  
10296  
packets\_received\_rset\_field\_meta  
0  
packets\_received\_rset\_row  
5235  
packets\_received\_prepare\_response  
92912  
packets\_received\_change\_user  
34416  
result\_set\_queries  
5113  
non\_result\_set\_queries  
122  
no\_index\_used  
5107  
bad\_index\_used  
0  
slow\_queries  
0  
buffered\_sets  
0  
unbuffered\_sets  
0  
ps\_buffered\_sets  
5113  
ps\_unbuffered\_sets  
0  
flushed\_normal\_sets  
0  
flushed\_ps\_sets  
0  
ps\_prepared\_never\_executed  
0  
ps\_prepared\_once\_executed  
5150  
rows\_fetched\_from\_server\_normal  
0  
rows\_fetched\_from\_server\_ps  
29303  
rows\_buffered\_from\_client\_normal  
0  
rows\_buffered\_from\_client\_ps  
29303  
rows\_fetched\_from\_client\_normal\_buffered  
0  
rows\_fetched\_from\_client\_normal\_unbuffered  
0  
rows\_fetched\_from\_client\_ps\_buffered  
29303  
rows\_fetched\_from\_client\_ps\_unbuffered  
0  
rows\_fetched\_from\_client\_ps\_cursor  
0  
rows\_affected\_normal  
0  
rows\_affected\_ps  
35  
rows\_skipped\_normal  
0  
rows\_skipped\_ps  
29303  
copy\_on\_write\_saved  
260925  
copy\_on\_write\_performed  
0  
command\_buffer\_too\_small  
0  
connect\_success  
25  
connect\_failure  
0  
connection\_reused  
0  
reconnect  
0  
pconnect\_success  
25  
active\_connections  
18446744073709551593  
active\_persistent\_connections  
18446744073709551593  
explicit\_close  
24  
implicit\_close  
0  
disconnect\_close  
0  
in\_middle\_of\_command\_close  
0  
explicit\_free\_result  
5113  
implicit\_free\_result  
5150  
explicit\_stmt\_close  
0  
implicit\_stmt\_close  
5150  
mem\_emalloc\_count  
0  
mem\_emalloc\_amount  
0  
mem\_ecalloc\_count  
0  
mem\_ecalloc\_amount  
0  
mem\_erealloc\_count  
0  
mem\_erealloc\_amount  
0  
mem\_efree\_count  
0  
mem\_efree\_amount  
0  
mem\_malloc\_count  
0  
mem\_malloc\_amount  
0  
mem\_calloc\_count  
0  
mem\_calloc\_amount  
0  
mem\_realloc\_count  
0  
mem\_realloc\_amount  
0  
mem\_free\_count  
0  
mem\_free\_amount  
0  
mem\_estrndup\_count  
0  
mem\_strndup\_count  
0  
mem\_estndup\_count  
0  
mem\_strdup\_count  
0  
proto\_text\_fetched\_null  
0  
proto\_text\_fetched\_bit  
0  
proto\_text\_fetched\_tinyint  
0  
proto\_text\_fetched\_short  
0  
proto\_text\_fetched\_int24  
0  
proto\_text\_fetched\_int  
0  
proto\_text\_fetched\_bigint  
0  
proto\_text\_fetched\_decimal  
0  
proto\_text\_fetched\_float  
0  
proto\_text\_fetched\_double  
0  
proto\_text\_fetched\_date  
0  
proto\_text\_fetched\_year  
0  
proto\_text\_fetched\_time  
0  
proto\_text\_fetched\_datetime  
0  
proto\_text\_fetched\_timestamp  
0  
proto\_text\_fetched\_string  
0  
proto\_text\_fetched\_blob  
0  
proto\_text\_fetched\_enum  
0  
proto\_text\_fetched\_set  
0  
proto\_text\_fetched\_geometry  
0  
proto\_text\_fetched\_other  
0  
proto\_binary\_fetched\_null  
0  
proto\_binary\_fetched\_bit  
52554  
proto\_binary\_fetched\_tinyint  
0  
proto\_binary\_fetched\_short  
88  
proto\_binary\_fetched\_int24  
0  
proto\_binary\_fetched\_int  
0  
proto\_binary\_fetched\_bigint  
220  
proto\_binary\_fetched\_decimal  
19009  
proto\_binary\_fetched\_float  
0  
proto\_binary\_fetched\_double  
0  
proto\_binary\_fetched\_date  
0  
proto\_binary\_fetched\_year  
0  
proto\_binary\_fetched\_time  
0  
proto\_binary\_fetched\_datetime  
0  
proto\_binary\_fetched\_timestamp  
66  
proto\_binary\_fetched\_string  
0  
proto\_binary\_fetched\_json  
170636  
proto\_binary\_fetched\_blob  
18352  
proto\_binary\_fetched\_enum  
0  
proto\_binary\_fetched\_set  
0  
proto\_binary\_fetched\_geometry  
0  
proto\_binary\_fetched\_other  
0  
init\_command\_executed\_count  
0  
init\_command\_failed\_count  
0  
com\_quit  
24  
com\_init\_db  
0  
com\_query  
85  
com\_field\_list  
0  
com\_create\_db  
0  
com\_drop\_db  
0  
com\_refresh  
0  
com\_shutdown  
0  
com\_statistics  
0  
com\_process\_info  
0  
com\_connect  
0  
com\_process\_kill  
0  
com\_debug  
0  
com\_ping  
0  
com\_time  
0  
com\_delayed\_insert  
0  
com\_change\_user  
0  
com\_binlog\_dump  
0  
com\_table\_dump  
0  
com\_connect\_out  
0  
com\_register\_slave  
0  
com\_stmt\_prepare  
5150  
com\_stmt\_execute  
5150  
com\_stmt\_send\_long\_data  
0  
com\_stmt\_close  
5150  
com\_stmt\_reset  
0  
com\_stmt\_set\_option  
0  
com\_stmt\_fetch  
0  
com\_deamon  
0  
bytes\_received\_real\_data\_normal  
0  
bytes\_received\_real\_data\_ps  
1283049

---

<div class="post-metadata">

**Author:** ![escopecz](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/escopecz/32/370_2.png) [@escopecz](https://forum.mautic.org/u/escopecz)\
**Post date:** [May 17, 2016, 9:09am UTC](https://forum.mautic.org/t/cant-access-config-500-er-active-db-connections-looks-very-odd/3786/3 "2016-05-17T09:09:02Z")

</div>

Check [https://www.mautic.org/community/index.php/1496-cannot-access-the-configuration-page/0](https://www.mautic.org/community/index.php/1496-cannot-access-the-configuration-page/0)
