Custom Query (196 matches)

The sql.mit.edu servers currently have old_passwords=1 set in the mysqld configuration for compatibility with MySQL 3.x and 4.x clients. The ​MySQL native driver in PHP 5.3 only knows how to deal with ​new-style passwords; this will probably bite us hard when we move to PHP 5.3 as part of upgrading to Fedora 13.

We'll need to either figure out if we can do the backward-compatible but insecure hack of making PHP clients able to use old-style passwords (disable the native driver? patch it?), or if we can drop support for MySQL clients that don't support new-style passwords, i.e., 4.0.x and below.

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

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.