On 05/23/13 10:15, Damon Getsman wrote:
Hello all, and thank you for taking the time to take a look at
this issue that I am currently having. I've been a strong advocate of
OpenBSD for some time, but have only recently taken steps to start
upgrading some of my machines instead of reinstalling.
My primary server was a 4.9 installation, and it was running
apache, with PHP and MySQL integrated for the purpose of serving a
mediawiki, a gallery2 installation, and a few other utilities that I
have had up for myself and some friends. Unfortunately, ever since I've
made the leap from 4.9 to 5.0, I've been unable to get anything other
than plain HTML documents to display via apache. The server tells me
that there are either '500' server errors or with a little more detail
MediaWiki tells me "(Can't contact the database server: MySQL functions
missing, have you compiled PHP with the --with-mysql option? )".
Now according to the pkg_info listing that I have, I _believe_
that I have all of the proper packages and libraries installed, but I
guess I am mistaken as I'm still not able to serve pages up with any
sort of MySQL back end handling. Here is the output of 'pkg_info -a -m'
for anybody who cares to verify this:
BitTorrent-4.4.0p10 cooperative file distribution system implemented in
Python
ImageMagick-6.6.6.10p0 image processing tools
alacarte-0.12.4p7 easy GNOME menu editing tool
apache-httpd-2.2.15p0 apache HTTP server
apcupsd-3.14.8p2 daemon for controlling APC UPSes
archie-1.4.1 Prospero client for the archie service
bash-4.2.10 GNU Bourne Again Shell
beav-1.40.15 binary editor and viewer
bzip2-1.0.6 block-sorting file compressor, unencumbered
calc-2.11.7 C-style arbitrary precision calculator
camlimages-3.0.2p0 image manipulation functions for Objective Caml
check_bioctl-1.9 Nagios plugin to check RAID status with bioctl
check_email_delivery-0.7.0 Nagios plugin to check full email delivery loop
(SMTP
/IMAP)
check_hw_sensors-1.42 Nagios plugin to monitor sysctl hw.sensors
check_mssql_health-1.5.3 Nagios plugin to check Microsoft SQL Server
check_openbgpd-1.5 Nagios plugin to monitor OpenBGPd peers
cups-1.4.7p0 Common Unix Printing System
cups-pdf-2.5.1 PDF backend for CUPS
curl-7.21.7 get files from FTP, Gopher, HTTP or HTTPS servers
dosbox-0.74p0 x86 with DOS emulator targeted at playing games
emacs-22.3p10 GNU editor: extensible, customizable, self-documenting
fedora_base-4.0p8 Linux compatibility package based on Fedora Core 4
firefox-5.0p3 Mozilla web browser
firefox35-3.5.19p2 Mozilla web browser
ghostview-1.5p3 X11 front-end for ghostscript
git-1.7.6p0 GIT - Tree History Storage Tool
git-svn-1.7.6p0 GIT - subversion interoperability tools
git-x11-1.7.6p0 GIT - graphical tools
gnome-common-2.34.0 common automake macros for GNOME
gnome-desktop-2.32.1p4 components for the GNOME desktop
gnome-mplayer-1.0.4p1 GTK+/GNOME frontend for MPlayer
gnome-panel-2.32.1p5 GNOME panel
gnome-screensaver-2.30.2p2 screen saver and locker for GNOME
gnome-system-monitor-2.28.2p6 sytem monitor for GNOME
gnome-system-tools-2.32.0p6 sytem configuration GUI for desktops
gnuchess-5.08 chess program
gpgme-1.1.5p1 GnuPG Made Easy
gstoraster-1.03p0 filter to convert PostScript or PDF to cups raster
format
ircII-20081115p0 Internet Relay Chat client
ispell-3.2.06p6 interactive spelling checker
jove-4.16p1 Jonathan's Own Version of Emacs
kdebase-3.5.10p13 K Desktop Environment, basic applications
kermit-8.0.211 serial and network communications package
latex-mk-1.9.1p0 set of Makefile fragments to manage LaTeX documents
libpurple-2.9.0 multi-protocol instant messaging library
libreoffice-3.4.1.3p1v0 multi-platform productivity suite
mediawiki-1.15.5p3 web-based collaborative editing environment
minicom-2.2p0 MS-DOS Telix-like serial communication program
mpg123-1.13.1 fast console MPEG audio player and decoder library
mrtg-2.17.1p1 multi-router traffic grapher
mutt-1.5.21v0-sasl tty-based e-mail client, development version
mysql-server-5.1.54p9 multithreaded SQL database (server)
ncftp-3.2.3 ftp replacement with advanced user interface
nethack-3.4.3p4-qt dungeon explorin', hackin', game. Piece of cake
nmap-5.51p0 scan ports and fingerprint stack of network hosts
ntop-1.1 network usage, interface similar to top(1)
ntp-4.2.6pl2p7 Network Time Protocol reference implementation
ocaml-3.12.0p0 ML language based on complete class-based objective
system
oinkmaster-2.0p0 update your Snort rules
p7zip-9.20.1 file archiver with high compression ratio
partial-wordpress-3.0.2 standard compliant weblog
pgp-2.6.3 Pretty Good Privacy 2.6.3ia
php-5.2.17p5 server-side HTML-embedded scripting language
php-curl-5.2.17p3 curl URL library extensions for php5
php-gd-5.2.17p4 image manipulation extensions for php5
php-imap-5.2.17p3 imap, pop3 and nntp extensions for php5
php-mcrypt-5.2.17p3 mcrypt encryption/decryption extensions for php5
php-mhash-5.2.17p3 mhash extensions for php5
php-mysql-5.2.17p3 mysql database access extensions for php5
phpMyAdmin-3.4.3.2 tool to handle the administration of MySQL over the web
pico-5.04p1 UW text editor
pidgin-2.9.0-gtkspell multi-protocol instant messaging client
pkglocatedb-0.1 database of packages for use with locate(1)
pork-0.99.8.1 programmable ncurses-based AIM client
python-2.5.4p13 interpreted object-oriented programming language
python-2.6.6p0 interpreted object-oriented programming language
quirks-1.53 exceptions to pkg_add rules
rsync-3.0.8p0 mirroring/synchronization over low bandwidth links
rtorrent-0.8.6p2 ncurses BitTorrent client based on libTorrent
rxvt-2.7.10p6 color, low memory usage, xterm replacement
samba-3.5.10-cups SMB and CIFS client and server for UNIX
screen-4.0.3p2 multi-screen window manager
snort-2.8.6-mysql highly flexible sniffer/NIDS
spidermonkey-1.9.2.16p0v0 Mozilla C implementation of JavaScript
subversion-1.6.15p0-gnome_keyring subversion revision control system
texlive_base-2010p3 base binaries for TeXLive typesetting distribution
texlive_texmf-minimal-2010p1 texlive texmf for laTeX/PdfTeX
tin-1.8.3p2 threaded NNTP- and spool-based UseNet newsreader
tor-0.2.1.30p0 anonymity service using onion routing
trafshow-3.1 full screen visualization of network traffic
transmission-2.13p0 lightweight BitTorrent command line and daemon client
transmission-qt-2.13 lightweight BitTorrent client with Qt interface
unrar-4.00v0 extract, list, and test RAR archives
unzip-6.0p0 extract, list & test files in a ZIP archive
vim-7.3.154p1-gtk2 vi clone, many additional features
vlc-1.0.6p33 VideoLAN client; multimedia player
wget-1.12p1 retrieve files from the web via HTTP, HTTPS and FTP
wordpress-3.1.2p1 standard compliant weblog
xsane-0.998p1 scanner frontend for SANE
xscreensaver-5.12 screen saver and locker for the X Window System
xv-3.10ap10 X11 image display and modification tool
ytalk-3.1.1p1 enhanced talk that allows for multiple parties
zip-3.0 create/update ZIP files compatible with PKZip(tm)
Any help or pointers in the right direction that can be offered
will be very much appreciated, I really need to get my wiki back up for
some work that I need to be doing on a speech that is to be given this
weekend. Thanks guys, let me know if you need anything more, I'll do my
best to come up with whatever info, logs, or whatever you may need.
-Damon
1. Are you using the base Apache or the installed 2.2?
2. Doubt anyone is still running on 5.0 - any reason you are on an
out-of-date version? You might as well keep going until you get to 5.3
and then people will have the same set-up as you.
3. You understand chroot, etc., if applicable?
http://www.openbsd.org/faq/faq10.html#httpdchroot Depends on your
answer to 1.
4. Bump up PHP error_reporting - make sure that's telling you as much as
possible (but if thinks mysql functions are missing might not be much
more to tell you!)
Apache, PHP, MySQL definitely work on OpenBSD - I use the base Apache,
though, so not sure of the wrinkles in using the 2.2 line.
