linux » Karl Katzke | PHP, Puppies, and other Geekery

Entries in the ' linux ' category

Written May 29, 2008 in howto, sysadmin

1 Comment

I forgot to mention something in yesterday’s post about configuring Postfix with Dovecot and turning on smtp authentication.

When you’re configuring Squirrelmail, you need to make sure that it does smtp authentication. It doesn’t seem that the version that comes with any way to that that *I* could easily find. …

CentOS, Postfix, Dovecot, Spamassassin, Postfixadmin, and Squirrelmail

Written May 27, 2008 in centos, howto, linux, mysql, sysadmin

What a mouthful. Like most other americans who live on a budget, I’m taking a “staycation” this weekend. What better thing to do than to get my mail server migrated to my new VPS? Well, first, I suppose, I should get the mail server all working on the new VPS…

In CentOS, the default Postfix package doesn’t have MySQL support built in. If you’ve got the priorities plugin installed, you’re either going to need to disable it or otherwise work around it so that you get the one from the centosplus repo. Other than that, it’s been made about as easy as it can be… just keep in mind as you’re reading this tutorial that I really loathe administering mail servers and consider it to be a quite onerous chore that’s been made even more onerous by spammers and hackers and script kiddies and what have you.

You’ll need to install: yum install gcc postfix clamav mysql-server mysql-devel spamassassin
dovecot php php-mbstring php-mysql rpm-build. There’s no RPM for Postfixadmin, but it’s available from the project’s site on Sourceforge.

And now the fun begins. This howto assumes that you have a decent level of knowledge and skill setting up services that run on Linux.

Maatkit - MySQL Replication Tools

Written May 27, 2008 in mysql, sysadmin

Post a Comment

Been doing a lot of work with MySQL Replication recently. We’re exploring a solution for our needs, which are mostly HA issues. Maatkit has a bunch of scripts that make replication easier to troubleshoot or fix, or make loading large datasets easier, or … well, go read the …

MySQL Cluster / Carrier Grade Edition

Written May 12, 2008 in mysql, opensuse

Post a Comment

There aren’t any binaries for MySQL Carrier Grade Edition, which includes the NDB Cluster engine, enabling highly available MySQL services. If you’re using OpenSUSE, you can get an older edition (MySQL 5.1.24) from the Build Service … or the most recent Carrier Grade Edition, 6.2 and 6.3, from the MySQL …

Reading List: MySQL Replication, DRBD, Clustering, Etc.

Written April 20, 2008 in howto, mysql, reading list, sysadmin

Post a Comment

UPDATED: MySQL To Reserve New Features for Paying Customers

Written April 18, 2008 in linux, mysql, webdev

Post a Comment

Some updates: Matthew Aslett, Marten Micoks on jcole.us: [ 1 ] Slashdot: [ 1, 2 ], Lukas Smith’s reaction.

Well, I guess it’s time to learn Postgres again. Sun Microsystems bought MySQL AB (The makers of the MySQL Database) in February, and now they’ve announced that …

Why You Install OMSA…

Written April 16, 2008 in linux, sysadmin

Post a Comment

We’ve had problems recently with our Dell 1650s at work. After five or six years of steady service, in the past three weeks we’ve had two bad fans on two separate machines, another machine has a voltage wobbly on it’s drive backplane, and another one failed with a rather dramatic …

JIRA Standalone - Major Vulnerability

Written March 3, 2008 in linux, sysadmin

2 Comments

JIRA Standalone runs, by default, as the user that starts the process on Linux. Running tomcat as root is generally a Bad Idea. Therefore, if you run JIRA as a service by adding a script under /etc/init.d and calling /etc/init.d/jira start … it’ll be running as root.

I opened a ticket with JIRA support several weeks ago pointing this out, and the only result has been adding one line of documentation that tells you how to add a user. This is not the best solution. Their solution would create a privileged user with a shell — you want to avoid this. Also, they don’t say anything about running JIRA as a service under init.d.

After the fold, there’s my init.d script for OpenSUSE 10.3. Gotta love JIRA, it’s more flexible than any other project management tool out there, but Atlassian apparently is not a company with a great deal of understanding of Linux.

MySQL and Threading vs. Context Switching

Written February 21, 2008 in linux, mysql, sysadmin

Post a Comment

Is your MySQL server running multiple processes with each running a single thread? Read this: Enabling Threading in MySQL. Ran into this on someone else’s legacy server today.

Today’s Reading List

Written February 1, 2008 in reading list, sysadmin

Post a Comment

(Since this started out as a log for me to keep track of what my brain actually needs to be doing, and y’all just started reading it by accident, I’m gonna take my blog back for me for a sec.)

Reading I need to do over the weekend: