/Guides/FreeBSD/Databases/

General Information

If you are a point-and-click kind of person and have to manage one or more MySQL servers, you may find this web-based utility to be a goldmine.

Requirements

1. Local root access on the box or be able to su to root.
   
2. A SSH client such as puTTy or SecureCRT (if you aren't on the box).
   
3. Your favorite text editor (I prefer nano).

Installation

Installation is straight forward.  Either download the source from http://www.phpmyadmin.net/ or install it from your favorite package manager.  I will be installing it on FreeBSD using the ports tree.  If you grabbed the source, just extract it to whichever directory you want it to be accessed from the web.  If you install it via ports or packages, it will get installed in /usr/local/www/phpMyAdmin.

# #	cd /usr/ports/databases/phpmyadmin make install clean

Configuration

The configuration of the newer versions (2.7.x and above) can be done by pointing your browser to http://mydomain.com/phpMyAdmin/scripts/setup.php or whatever virtualhost you are using.  Now, what we effectively want to accomplish is populating /usr/local/www/phpMyAdmin/config.inc.php with the proper settings that you want.  Once you loaded the setup script in your browser, run through all of the setup options configuring what you need.  A quick and dirty setup includes adding the server you are connecting to with cookie authentication.  Now there are a couple of ways to save this configuration.

Method One

Once you click 'Add' click 'Display' and copy all of the php text, open a ssh connection to your phpMyAdmin server and paste it into /usr/local/www/phpMyAdmin/config.inc.php.

Method Two

Click 'Add' as above, but this time you want to make the config.inc.php file writable by the web server so you can save your configuration from the web interface.

Note:  This method is the least secure because anybody could change your config file, so use with caution.

# #	cd /usr/local/www/phpMyAdmin chmod g+w config.inc.php

Make your changes in the setup page and then click 'Save' to save to the writable config file.

Now point your browser to your phpMyAdmin site and log in using your MySQL credentials.  Enjoy.

Author: Jon LaBass
jon at bsdguides dot org

I get errors...

*** Error code 1

Stop in /usr/ports/print/pdflib.
*** Error code 1

Stop in /usr/ports/print/pdflib.
*** Error code 1

Stop in /usr/ports/databases/phpmyadmin.


Any ideas?

What are the last few lines posted just before that first Error code 1?  Usually it will be a little helpful as to why print/pdflib isn't compiling.

Hi, this is what I got, any idea?
The following line has been added to your /usr/local/etc/php/extensions.ini
configuration file to automatically load the installed extension:

extension=openssl.so

****************************************************************************
===>   Returning to build of phpMyAdmin-2.7.0.2
===>   phpMyAdmin-2.7.0.2 depends on file: /usr/local/lib/php/20020429/pdf.so - not found
===>    Verifying install for /usr/local/lib/php/20020429/pdf.so in /usr/ports/print/pecl-pdflib
===>  Vulnerability check disabled, database not found
=> pdflib-2.0.4.tgz doesn't seem to exist in /usr/ports/distfiles/PECL.
=> Attempting to fetch from http://pecl.php.net/get/.
pdflib-2.0.4.tgz                              100% of   35 kB   89 kBps
===>  Extracting for pecl-pdflib-2.0.4
=> MD5 Checksum OK for PECL/pdflib-2.0.4.tgz.
=> SHA256 Checksum OK for PECL/pdflib-2.0.4.tgz.
===>  Patching for pecl-pdflib-2.0.4
===>   pecl-pdflib-2.0.4 depends on file: /usr/local/include/php/main/php.h - found
===>   pecl-pdflib-2.0.4 depends on executable: phpize - found
===>   pecl-pdflib-2.0.4 depends on file: /usr/local/lib/php/20020429/gd.so - found
===>   pecl-pdflib-2.0.4 depends on file: /usr/local/bin/autoconf259 - found
===>   pecl-pdflib-2.0.4 depends on shared library: pdf.7 - not found
===>    Verifying install for pdf.7 in /usr/ports/print/pdflib
===>  Vulnerability check disabled, database not found
=> PDFlib-Lite-6.0.3.tar.gz doesn't seem to exist in /usr/ports/distfiles/.
=> Attempting to fetch from http://pdflib.com/products/pdflib/download/603src/.
fetch: http://pdflib.com/products/pdflib/download/603src/PDFlib-Lite-6.0.3.tar.gz: Not Found
=> Attempting to fetch from ftp://ftp.FreeBSD.org/pub/FreeBSD/ports/distfiles/.
fetch: ftp://ftp.FreeBSD.org/pub/FreeBSD/ports/distfiles/PDFlib-Lite-6.0.3.tar.gz: File unavailable (e.g., file not found, no access)
=> Couldn't fetch it - please try to retrieve this
=> port manually into /usr/ports/distfiles/ and try again.
*** Error code 1

Stop in /usr/ports/print/pdflib.
*** Error code 1

Stop in /usr/ports/print/pecl-pdflib.
*** Error code 1

Stop in /usr/ports/databases/phpmyadmin.
*** Error code 1

Stop in /usr/ports/databases/phpmyadmin.

This must be the same problem Melvinchi was having.  The issue is that PDFlib-Lite-6.0.3.tar.gz is not found at either of those URLs and thus fails.  A quick google found a copy at http://www.pdflib.com/fileadmin/pdflib/products/pdflib/download/603src/PDFlib-Lite-6.0.3.tar.gz which you can place inside /usr/ports/distfiles.  Once it's copied there (the tar.gz - not extracted) you can try installing phpmyadmin again.

Jon,

Thanks for the quick response! I followed your instruction, it works!
Thanks,

TA