mysql database table crash and recovery

There was a power outage yesterday at the studio, and the UPS also tripped. PB reports:
The phplist mailist list server gave the error message

> Message:
> Database error 144 while doing query Table './path/to/tablename' is marked as crashed and last (automatic?) repair failed
>
>
> Currently running the repair on the table tablename​ as suggested here:
>
> http://stackoverflow.com/questions/8843776/mysql-table-is-marked-as-crashed-and-last-automatic-repair-failed
>
> cd /var/lib/mysql/path/to/relevant/db
> myisamchk -r tablename.MYI
>
> ​looks like its going to take a long time.....​


and later,

Recovery successful.

​This was done by stopping mysql database:

service mysql stop​

myisamchk -r tablename.MYI

- recovering (with sort) MyISAM-table 'tablename.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
Data records: 119477877

service mysql start

testing schedule page and audio search page accessibility with screen reader software

We got a report that the audio search results were not accessible with JAWS 14.137 screen reader software. The google chrome accessibility page lists JAWS and NVDA. Downloaded and tested both. Found JAWS 14.0 working perfectly fine with our audio search page, with Firefox and Chrome. Also with IE8 (on my machine which has Win XP, highest version of Internet Explorer is IE8). Also fine on NVDA, which is free, as against JAWS which is $1000. Probably reasons, some of which I also faced:

1. Opening the page in a new tab instead of a new window causes problems. Open all pages in new windows instead.

2. Using old version of browser may cause issues on radiosai.org - upgrade to latest version of browser.
 

Google Apps Education edition

I had a query asked of me, whether the Google apps for a domain was the "Free edition" or the "Education Edition". Also about the number of users allowed for Edu edition. Here was my reply.

Google apps Education edition allows unlimited users for educational institutions, and 3000 users for other non-profit institutions.
https://productforums.google.com/forum/#!topic/apps/fptTBRXfGPM

You can check which edition you have - Education edition or not - by seeing how much space each user gets. According to this page,
https://support.google.com/a/answer/175121?hl=en
Education edition users get 30 GB, Free edition users get 15 GB.

This is seen at the bottom of your inbox, "Using 4.13 GB of your 15 GB" or "Using 4.13 GB of your 30 GB" or something like that.

source timeout on icecast

On May 21, we had changed the source timeout property on icecast from 10 to 40 seconds hoping to reduce the number of times the server dropped connection. This strategy suggested by PB seems to have worked, since then the connection has not dropped even once when I was operating the live broadcast. Edited  icecast_all.xml  and  icecast_tel_live.xml  and made the source timeout 40 sec. The original suggestion was as below.

changing default browser font for other languages

Using this post as a guide, changed the default font for Malayalam on Firefox to Rachana, which is more readable.

Tools -> Options -> Content tab -> Advanced button in default fonts -> Fonts for: chose Malayalam in the drop-down list, and changed the options other than Proportional to Rachana.

recordings with M-Audio MobilePre

As noted in an earlier post, the M-Audio MobilePre is an el-cheapo USB preamp interface. But I had to rely on that for some trial recordings.

Using a Maxim mic, laptop sound card noise floor is around -50 dB

M-Audio MobilePre with Maxim mic noise floor is around -60 dB

Using dynamic mic - Ahuja ASM-780XLR - results were similar.

Nose floor rises to -40 dB when capture slider increased to 80%.

The XLR input on the MobilePre seems to be defective - S/N almost unity! -18 dB of noise

"NEW" label on schedule page

As requested, PB has added the "NEW" label on our schedule page for "Concert" category also. He had to modify the csv generation local code as well as the schedule page code for this.

brief outage

There was a brief outage of radiosai services. The issue was with Cloudflare dns returning SERVFAIL for our domains. Conversation with Cloudflare: