May
01
2008

phpMyAdmin Installation, openSUSE 10.2

I installed the phpmyadmin package the other day using YaST and need to document some things:

  • Configuration area (config.inc.php file) ends up in /srv/www/htdocs/phpMyAdmin along with the rest of the installation.
  • Decided to use “cookie based authentication”; don’t think I need to remember the password.
  • The advanced features were turned on in config.sample.inc.php, but the YaST installer doesn’t load the schema required for this into the mySQL database (maybe it’s not possible unless done during mySQL installation). This resulted in endless error messages of “Table ‘phpmyadmin.pma_bookmark’ doesn’t exist”.
  • Learned that I needed to run create_tables.sql, which was not included in the openSUSE package. I downloaded it from the phpMyAdmin site, created user “pma”, defined corresponding controluser and controlpass entries in the config file. create_tables finally ran successfully and the bookmarks error messages went away.
  • Stopped annoying half-hour auto-logout with: $cfg[‘LoginCookieValidity’] = 3600 * 8;

posted in opensuse, SUSE, SysAdmin, YaST by Bozzie

 
Powered by Wordpress and MySQL. Theme by openark.org