2012 November

Archive for November, 2012

reload.sh: Cron Script to Reshuffle SHOUTcast Playlist

by dervish on Nov.16, 2012, under Linux, Scripts



#!/bin/sh

# Perform kill -USR1 on running sc_trans

# Use in nightly cron to reshuffle "random" playlist

# 20121116 - Jamey Hopkins

 

# Note: sc_trans accepts the following signals:

# HUP - flush logfiles (close and reopen) -- will make console logging stop

# WINCH - jump to next song

# USR1 - reload playlist off disk (will not interrupt current playing stream)

# USR2 - toggle shuffle on/off

# TERM - normal sc_trans shutdown (clean)

 

ID=`ps -ef | grep sc_trans | grep -v grep |awk '{ print $2 }'`

 

if [ "$ID" ]

then

    echo "Reloading playlist for sc_trans at $ID"

    kill -USR1 $ID

else

    echo "Did not find a running sc_trans"

fi

MySQL Logrotate Error

by dervish on Nov.06, 2012, under Debian, Linux

If you move a database to another server, you may need to reset the MySQL password for the debian-sys-maint user.

Error encountered:
/etc/cron.daily/logrotate:
error: error running shared postrotate script for ‘/var/log/mysql.log /var/log/mysql/mysql.log /var/log/mysql/mysql-slow.log ‘
run-parts: /etc/cron.daily/logrotate exited with return code 1

Fix:

Set password for debian-sys-maint user to the one contained in the /etc/mysql/debian.cnf file.

# cat /etc/mysql/debian.cnf
# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host = localhost
user = debian-sys-maint
password = xxxxxx
socket = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host = localhost
user = debian-sys-maint
password = xxxxxx
socket = /var/run/mysqld/mysqld.sock
basedir = /usr

# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> UPDATE user SET Password = PASSWORD(‘xxxxxx’) WHERE User = ‘debian-sys-maint’ && Host = ‘localhost’;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> quit;
Bye

ciphermethod.com

Archive for November, 2012

reload.sh: Cron Script to Reshuffle SHOUTcast Playlist

MySQL Logrotate Error

News:

Recent Posts

Browse by tags

Categories

Meta

Looking for something?

But Wait, There's More!

Old Stuff