1 Topic by niv

  • niv
  • Guest

Topic: SQLite connection settings

Hi,

A similar problem was discussed here: http://ochiba.x-maru.org/support/viewtopic.php?id=14, but I wasn't able to find a solid solution for my problem.

I'm trying to setup ochiba with SQLite. I created a blank database located at "~/public_html/tmp/ochiba.db". I followed the instructions on the site for setting up PEAR::DB as well as PEAR::HTML_TEMPLATE_IT.

However, every time I run install.php I get this message:

Checking for convert (/usr/bin/convert) ... OK

Checking for identify (/usr/bin/identify) ... OK

Checking permissions on /mnt/volume01/chris/public_html/ochiba/img ... OK

Checking permissions on /mnt/volume01/chris/public_html/ochiba/thumbs ... OK

Checking permissions on /tmp/ochiba-cache ...OK

Checking for HTML_Template_IT ...OK

Checking for PEAR::DB ...OK

Checking for database definition ... OK

Checking for database connection ... FAILED - please check connection settings (sqlite:////mnt/volume01/chris/public_html/tmp/ochiba.db)


This is most likely an easy fix, but no matter how I change the sqlite://// DSN it keeps on giving me the same message.

Thanks,

niv

Quote Post 1

2 Reply by h3

  • h3
  • Administrator
  • Offline
  • Registered: 2005-04-05
  • Posts: 181

Re: SQLite connection settings

Could you try the little test/debug script in post#6  of that thread? It'll give a more informative error message (obviously, changing the connect string to yours).

Quote Post 2

3 Reply by niv

  • niv
  • Guest

Re: SQLite connection settings

When I tried that I got this message:

[DB Error: extension not found] ** sqlite://///mnt/volume01/chris/public_html/ochiba/ochiba.db

Quote Post 3

4 Reply by h3

  • h3
  • Administrator
  • Offline
  • Registered: 2005-04-05
  • Posts: 181

Re: SQLite connection settings

Oh, it sounds like your host does not have the sqlite extension, or may be using a newer version of PHP (specifically version 5) which does sqlite differently. Can you set up a script that just does "phpversion()" and then let me know the version it is and anything that mentions "sqlite" ?

Quote Post 4

5 Reply by niv

  • niv
  • Guest

Re: SQLite connection settings

Yeah, that was the problem.

Kind of weird, since the sqlite3 command is still there when I access my space from the command-line.

If you're interested, you can view the phpinfo page here:

http://www.music.mcgill.ca/~chris/ochiba/test.php

I tried to set it up using SQLite because I'm a complete noob when it comes to databases and it seemed like the most straightforward option.

Would you recommend any of the other databases that my host supports? Would you be able to give me any tips on how to set them up?

Thanks for your help,

niv

Quote Post 5

6 Reply by h3

  • h3
  • Administrator
  • Offline
  • Registered: 2005-04-05
  • Posts: 181

Re: SQLite connection settings

Hmm, actually it looks like you're in luck as your host apparently has Postgres support, so ochiba will function the same. Unlike sqlite you need a database created for you, a database username, and a database password, and only your support/sysadmin can provide those, but once you have all three of those, you can plug them into your connect string - examples of the postgres form are in conf.php.

Quote Post 6

7 Reply by niv

  • niv
  • Guest

Re: SQLite connection settings

Cool, actually that helps a lot! :D

Hopefully my sysadmin won't have a problem with that, I've made requests like that before and he seemed okay with them.

Thanks for all your help! Looking forward to using your software!

niv

Quote Post 7