Mautic Community Forums

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

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

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

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