Custom Query (196 matches)

We relatively often hit the cap on number of database connections. We should set max_user_connections (​http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_max_user_connections; ​http://dev.mysql.com/doc/refman/5.0/en/user-resources.html) in addition to max_connections (​http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_max_connections). Hopefully, this will mean that a single runaway account doesn't block other users from accessing sql.mit.edu.

This was previously brought up on -c scripts -i 2129340 on Sept. 26, 2012.

When Apache is truly systemd'ified, we will be able to add the following:

For OpenAFS:

[Unit]
Before=httpd.service
[Install]
WantedBy=httpd.service

For Cron (needs a new patch):

[Unit]
Before=httpd.service
[Install]
WantedBy=httpd.service

Though, honestly, it may make more sense to roll our own Systemd service for afsagent.

This doesn't work right now because Apache is still SysV.

(Imported from ​help.mit.edu #397407.)

jceggles:

I exported my TechTime? calendar as an iCal and uploaded it to PHP iCalender and the events are 4 hours off. I've been looking online and don't see a fix for this. Since the Oracle calendar is in wide use here, I figure somebody is doing this.

geofft:

Hm, a 4-hour time discrepancy sounds rather like PHP iCalendar not knowing about your time zone - and indeed, the standard config file defaults to GMT.

If you edit the file "config.inc.php" in your install directory, you will see a line about one screen down with the text:

$timezone = '';

Change this line to read:

$timezone = 'US/Eastern';

This should introduce the proper 4-hour time difference from GMT. Let us know if iCalendar continues to give you problems.