• Blog
  • Get Help Now!
  • Customer Portal

BlueGecko Denmark

  • Why you need us
    • Why act now
    • Why are we unique
  • What we do
    • Products Supported 24/7
      • MySQL
      • Postgres
      • SQL Server
      • Open Source
      • OS & Storage
  • How we do it
    • Consulting
    • System Monitoring
    • Security
  • Support
    • Blog
      • Oracle
      • MySQL
      • News & Events
      • Oracle Applications
      • Amazon Web Services
      • Jeremiah Wilton’s Oradeblog
      • OurSQL Community Podcast
      • Remote DBA
    • Team viewer
    • Whitepapers
  • About Us
    • Philosophy
    • The Blue Gecko Teams
    • Employment Opportunities
    • Partners
    • News
    • Press
  • Contact Us

March 28, 2008 by snovotny

Managing databases and other stuff

Databases exist to store data.  That said, a database is infrequently useful entirely on it’s own.  So, managing databases means that we’re often interacting with applications that access that data.   Some of the common applications that we work with include Oracle E-Business Suite, Tomcat, Apache and ColdFusion.

We had an entertaining problem this last week with Apache logging on a Linux server that gave our SAs fits.  The great Google search also failed to find a real solution, so I thought I could post ours here.

First, the problem.  We were seeing all the traffic in the logs originating from the same IP address. We were sure that this was not actually the case.

The ultimate cause of the problem was that the version of apr (Apache Portable Runtime) 0.9.13-1 was installed.  For some reason yum didn’t want to update it to 0.9.4-24.9. This version of apr was installed by a handrolled RPM with an older version of apr.

The solution was to force the upgrade of apr with ‘rpm -e –nodeps apr apr-util’ and ‘yum install apr apr-util’. Very strange behavior that ‘yum update apr’ wouldn’t do it.

Maybe it will help someone else.   Happy Friday.

Filed Under: MySQL Tagged With: Apache, linux, MySQL, performance tuning

Categories

  • Amazon Web Services
  • Configuration Management
  • downtime
  • Drizzle
  • ebs
  • Education
  • elastic block store
  • elastic compute cloud
  • hosting
  • hot backup
  • ignorance
  • Infrastructure
  • IOUG
  • Jeremiah Wilton's Oradeblog
  • misconception
  • misconceptions
  • Monocle
  • MySQL
  • MySQL Council
  • News & Events
  • Oracle
  • Oracle Applications
  • Oracle Data Guard
  • Oracle Database
  • Oracle Database Appliance
  • Our People
  • OurSQL Community Podcast
  • outage
  • parallel
  • performance
  • podcast
  • proof
  • Remote DBA
  • replication
  • S3
  • Security
  • SQL Server
  • System monitoring
  • Uncategorized

Contact Blue Gecko

  • This field is for validation purposes and should be left unchanged.

Get Our Newsletter

  • This field is for validation purposes and should be left unchanged.

The Fine Print

  • Privacy Policy
  • Terms of Use
  • When is remote DBA the right solution
  • What are remote DBA services
  • Get Help

Blog Categories

  • 24/7 support
  • Blue Gecko 360° Services
  • Products Supported 24/7

Virtual runs

Contact Blue Gecko

Blue Gecko A/S
Slotsgade 21
DK – 4200 Slagelse
Denmark
Phone: (DK) +45 70 60 51 20

Networks

  • Email
  • Twitter

© Blue Gecko Group