Viewing Category : database

Post thumbnail of Installing Pylons and BlastOff - YUM alternative to easy-install
23 February 2010
Continue reading Installing Pylons and BlastOff - YUM alternative to easy-install

Installing Pylons and BlastOff - YUM alternative to easy-install

The Pylons web framework is aimed at making webapps and large programmatic website development in Python easy. Pylons combines the very best ideas from the worlds of Ruby, Python and Perl, providing a structured but extremely flexible Python web framework. BlastOff is a Pylons application template providing a working site skeleton configured with SQLAlchemy, mako, repoze.who, ToscaWidgets, TurboMail, and WebFlash.

Post thumbnail of ATI fglrx driver - fix corrupt amdpcsdb
12 February 2010
Continue reading ATI fglrx driver - fix corrupt amdpcsdb

ATI fglrx driver - fix corrupt amdpcsdb

ATI allows xorg.conf to have the normal customized settings you’re used to for X, but it relies on this little PCS database at /etc/ati/amdpcsdb for driver configuration. If you have a customized amdpcsdb, or a binary installation from your favorite package manager is screwing up your X when using the fglrx driver, try reverting back to the default ATI settings.

Post thumbnail of Securing MySQL Server is Easy
4 February 2010
Continue reading Securing MySQL Server is Easy

Securing MySQL Server is Easy

The default out-of-the-box installation should delete any additional anonymous users after installation and disallow remote logins completely, but it doesn’t. At least all you have to do is run the mysql_secure_installation script to do so.

Post thumbnail of Batch add users to the cc list for all components in the bugzilla database directly
24 November 2009
Continue reading Batch add users to the cc list for all components in the bugzilla database directly

Batch add users to the cc list for all components in the bugzilla database directly

If you want to add a user to all of the components in bugzilla, you don’t have to go through the gui. In fact, you can change just about anything in bugzilla by connecting to the database directly and modifying the tables. I find this much faster than repetitively navigating through the web front end. Connect to the database, match up user id’s to user names, figure out which components you want to modify, then update the component_cc table. Step-by-step.

Post thumbnail of YUM: Thread died in Berkeley DB library, Fatal error, run database recovery
2 November 2009
Continue reading YUM: Thread died in Berkeley DB library, Fatal error, run database recovery

YUM: Thread died in Berkeley DB library, Fatal error, run database recovery

Before I get to the problem, here’s the interesting part. If you list the files in /var/lib/rpm/ you will see the flat berkeley database files, but not all of them. And I didn’t notice there was one missing until I went to fix it. I’m not sure what caused/causes this, but I found a pretty simple solution.

Post thumbnail of How to restore a postgresql database from dumpall backup
23 October 2009
Continue reading How to restore a postgresql database from dumpall backup

How to restore a postgresql database from dumpall backup

If your dump was performed with the “–clean” option, you can skip the reinitializing of your databases to avoid duplicating data. This option, used with the “pg_dumpall” command will cause the restore to clean out all the objects in the database before performing the restore. If you didn’t include this option, then just delete the data directory and reinitialize the database as shown below.

Powered by Wordpress   |   Lunated designed by ZenVerse