The Rambling Chronicles: Notes

Posts Tagged ‘reference’

  1. Python DB API

    9th Mar 2010

    Useful things to remember:

    Can get python built (no compile, no need for mysql_config file shenanigans) from launchpad

    Need to create a DB cnfig object:

    config = {'host': 'localhost', 'database': 'database_name', 'user': 'root', 'password': '', 'charset': 'utf8' ,'use_unicode': True, 'get_warnings': True }

    Then connect:

    db = mysql.connector.connect(**config)

    Then you can get the “cursor” object which allows you to do things:

    cursor = db.cursor()

    Then perform whatever you want with SQL:

    cursor.execute('SELECT * FROM table')

    Get the results for your query and iterate through them:

    for row in cursor.fetchall():
	print row

    Get the ID of an insert you have just performed:

    cursor.lastrowid
    Tags: , , ,

    No Comments »

  2. Setting up a MoinMoin wiki

    22nd Jan 2009

    This is time consuming and I ultimately didn’t use the thing in the end. Not enough guidance.

    MoinMoin was supposedly an easy wiki to use. It is, sort of. This is how I set it up in the end. It’s based around the FTP install instructions, however I used my SSH access to do most of it.

    Things I had (and Didn’t)

    • SSH access
    • No access to anything other than CGI 1
    • No root access

    How I did it

    Just for reference the folder structure was:

      [wiki.site.com]
   |
   +- [HTML[
   |
   +- [cgi-bin]

    Setting up

    • Connect to the sever, use wget to fetch MoinMoin to wiki.site.com folder.
    • untar and rename to something easier.
    • Create .htaccess file in the HTML directory to enable CGI anywhere 2
    AddHandler cgi-script .cgi
 
Options +ExecCGI

    Copying folders + files

    • You need to copy three folders out of the untar’d moin directory into the wiki.site.com folder: wiki/data, wiki/underlay and MoinMoin.
      [wiki.site.com]
   |
   +- [HTML]
   |
   +- [cgi-bin]
   |
   +- [data]
   |
   +- [underlay]
   |
   +- [MoinMoin]
    • Copy the contents of the htdocs folder (cp -R moin/wiki/htdocs/* html/moin_static181) into a folder called moin_static181 in the HTML folder.
      [wiki.site.com]
   |
   +- [HTML]
   |     | 
   |     +-[moin_static181]
   |
   +- [cgi-bin]
   |
   +- [data]
   |
   +- [underlay]
   |
   +- [MoinMoin]
    • Create a folder called config and copy wikiconfig.py from moin/wiki/config/ into it.
      [wiki.site.com]
   |
   +- [HTML]
   |     | 
   |     +-[moin_static181]
   |
   +- [cgi-bin]
   |
   +- [data]
   |
   +- [underlay]
   |
   +- [MoinMoin]
   |
   +- [config]
    • Copy moin/wiki/server/moin.cgi into the HTML folder.

    Edit configs

    moin.cgi

    Three things need changing:

    1. #!/usr/bin/env python to #!/usr/bin/python
    2. uncomment # sys.path.insert(0, 'PREFIX/lib/pythonX.X/site-packages') and change it to # sys.path.insert(0, '../')
    3. find sys.path.insert(0, '/path/to/wikiconfig') and change to sys.path.insert(0, '../config')
    wikiconfig.py

    Two things to change:

    1. data_dir to data_dir = '../data/'
    2. underlay_dir to data_underlay_dir = '../underlay/'
    And that’s it!

    You will now have a functioning MoinMoin wiki.

    Playing around though I wasn’t impressed though, too much still needed to be done.
    1. FastCGI is installed, but out of my reach to configure ↩
    2. This is not the best thing to do, but saves huge problems later ↩
    Tags: , ,

    No Comments »