We have a multiuser Machform PHP application running on a Redhat 7 Linux server with Apache webserver and MariaDB database. In a specific form after page 3, accessing this URI: confirm.php?id=NNNNNNNN&mf_page_from=3 where NNNNNNNN is the id number of the form, The following error message appears: SQL: [671] select A.element_id, A.option_id, (select if(B.element_matrix_parent_id=0,A.option, (select C.`option` from…
I have two different Linux servers, and wanted to test if one where faster than the other. I used mysqlslap together with the “time” command in a bash shell. # time mysqlslap –user=root –password=$(cat /root/mysql) –host=localhost concurrency=50 –iterations=100 –number-int-cols=5 –number-char-cols=20 –auto-generate-sql –verbose In this way I could get out different values from the server which…
We have a Linux server (Redhat Enterprise 6) running a multi-site installation of Mediawiki. In total, we have today 120 unique wiki’s, each having its one Postgresql 9.1 database. Suddenly the server stopped responding. In Apache webserver, the total number concurrent apache processes went up to Apache’s max-client setting in httpd.conf, and people couldn’t log…
We have a Postgresql server open to many different people at our organization. In order to add a ldap authentication you can add these 3 lines to your current pg_hba.conf file: host all username 127.0.0.1/32 ldap ldapserver=”ourserver.uib.no” ldapbasedn=”ou=people,dc=uib,dc=no” host all username 129.177.XXX.YYY/32 ldap ldapserver=”ourserver.uib.no” ldapbasedn=”ou=people,dc=uib,dc=no” local all username ldap ldapserver=”ourserver.uib.no” ldapbasedn=”ou=people,dc=uib,dc=no”…
I upgraded our Open Journal Systems from 2.2.2 to 2.4.2 and afterwards we saw the email logs were gone. This was related to: http://pkp.sfu.ca/support/forum/viewtopic.php?f=8&t=9140 My solution was this: Established a new Postgresql server in a virtual enviroment (vmware, test-machine), and import the old and the new (upgraded) database. # Log in to Prod server ssh…
I tried to upgrade Moodle 2.2.1 to 2.6.2+ and got this error message: Default exception handler: DDL sql execution error Debug: Data truncated for column ‘institution’ at row 999 ALTER TABLE mdl_user MODIFY COLUMN institution VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ” after phone2 Error code: ddlexecuteerror The solution was to run…
We wrote an improved postgresql dump bash script for Postgresql version 9.1. This one will save each dump file with the name: database_name_DAYNAME.sql.bz2 In this way, we would only have 7 backups at any time, because each file will be overwritten after seven days. Since our backup system (TSM) saves 7 versions of each file,…