sqlite issue?


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers sqlite issue?
# 1  
Old 07-23-2004
sqlite issue?

i'm on freebsd 5.2.1, and from a fresh installation i've used pkg_add for the latest ported version of apache, as well as installing php 5. supposedly php5 comes with native support for sqlite (in the binary package), and this is what i added.

i am trying to install a site engine (the 'gyrator' engine, from http://www.gyrate.org) and am encountering an annoying issue. there is an sqlite database setup script, and running it via the php results in the script dying after attempting to write to the sqlite database (though it can recognize and play with the database file without issues).

i was under the impression that this is a permissions issue, but chmod 777 on the directories and files in question squashed that suspician.

if anybody is interested in looking at the gyrator engine, or whatever, let me know and i'll post more information (if it's necessary).
 
Login or Register to Ask a Question

Previous Thread | Next Thread

8 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Manipulating UNIX and sqlite db

Hi there, I have multiple rows of data. For example: S/N | Name| Age I would like to store them into sqlite database after doing some grepping in CSV and output them into console/html format. Will it be possible? (1 Reply)
Discussion started by: alvinoo
1 Replies

2. Shell Programming and Scripting

Using sqlite query to build script...

Okay, so this one is a bit above my knowledge level so I'm hoping for some pointers. Here's the scenario: I have a backup system on my network that makes single file images of the machines it's backing up and uses an sqlite database to keep track of everything. As is pretty typical with... (2 Replies)
Discussion started by: NyxPDX
2 Replies

3. UNIX and Linux Applications

ruby/SQLite database interface

Hello, I'm not sure this is quite the right place, but there do seem to be allot of posts with folks using ruby to play nicely with databases so I thought I would give it a go. I am starting a long process of developing a database application bases on SQLite and ruby. This will run on various... (1 Reply)
Discussion started by: LMHmedchem
1 Replies

4. Shell Programming and Scripting

[ask]sqlite with shell script

hlow all i have file like this : BDG0100.2011091620162100CF5341.DAT BDG0100.2011091720175500CF5342.DAT BDG0100.2011091820192900CF5343.DAT BDG0100.2011091920210600CF5344.DAT but now i want make file like this 20110916.DAT 20110919.DAT 20110918.DAT 20110919.DAT so what i can do that... (3 Replies)
Discussion started by: zvtral
3 Replies

5. Linux

Using squid_db_auth to authenticate squid users against SQLite

Hi guys, Can we use squid_db_auth to authenticate squid users against SQLite database? I googled but all configurations are in MySQL. (0 Replies)
Discussion started by: majid.merkava
0 Replies

6. Shell Programming and Scripting

hell and sqlite

Hi everyone, I have a requirement that requires me to fill an sqlite database with 100,000 entries (no duplicates). I will start out by giving the command that will insert the values necessary to populate the database: # sqlite /var/local/database/dblist "insert into list... (2 Replies)
Discussion started by: ogoy
2 Replies

7. Shell Programming and Scripting

Perl - SQLite question

Hello All, I am trying to write a Perl script that is using 'SQLite' as the application needs a very light weight Database. I wanted to know how to catch exceptions when I run queries in SQLite. Without this the Perl script comes to a halt everytime an exception occurs. Please help. Regards,... (4 Replies)
Discussion started by: garric
4 Replies

8. HP-UX

sqlite database in HP-UX vs Linux

Hi everybody, We have a cgi application which accesses sqlite database. It works fine in Linux environment but the same code doesn't enter data into the database when done in HP-UX environment. Should the codes vary depending on whether it is Linux or HP-UX. Regards Ruma (1 Reply)
Discussion started by: perlprg
1 Replies
Login or Register to Ask a Question
App::Info::RDBMS::SQLite(3pm)				User Contributed Perl Documentation			     App::Info::RDBMS::SQLite(3pm)

NAME
App::Info::RDBMS::SQLite - Information about SQLite SYNOPSIS
use App::Info::RDBMS::SQLite; my $sqlite = App::Info::RDBMS::SQLite->new; if ($sqlite->installed) { print "App name: ", $sqlite->name, " "; print "Version: ", $sqlite->version, " "; print "Bin dir: ", $sqlite->bin_dir, " "; } else { print "SQLite is not installed. :-( "; } DESCRIPTION
App::Info::RDBMS::SQLite supplies information about the SQLite application installed on the local system. It implements all of the methods defined by App::Info::RDBMS. Methods that trigger events will trigger them only the first time they're called (See App::Info for documentation on handling events). To start over (after, say, someone has installed SQLite) construct a new App::Info::RDBMS::SQLite object to aggregate new meta data. Some of the methods trigger the same events. This is due to cross-calling of shared subroutines. However, any one event should be triggered no more than once. For example, although the info event "Executing `pg_config --version`" is documented for the methods "name()", "version()", "major_version()", "minor_version()", and "patch_version()", rest assured that it will only be triggered once, by whichever of those four methods is called first. INTERFACE
Constructor new my $sqlite = App::Info::RDBMS::SQLite->new(@params); Returns an App::Info::RDBMS::SQLite object. See App::Info for a complete description of argument parameters. When it called, "new()" searches the directories returned by search_bin_dirs for an executable with a name returned by "search_exe_names". If found, it will be called by the object methods below to gather the data necessary for each. If it cannot be found, then "new()" will attempt to load DBD::SQLite or DBD::SQLite2. These DBI drivers have SQLite embedded in them but do not install the application. If these fail, then SQLite is assumed not to be installed, and each of the object methods will return "undef". Events: info Looking for SQLite. confirm Path to SQLite executable? unknown Path to SQLite executable? Class Method key_name my $key_name = App::Info::RDBMS::SQLite->key_name; Returns the unique key name that describes this class. The value returned is the string "SQLite". Object Methods installed print "SQLite is ", ($sqlite->installed ? '' : 'not '), "installed. "; Returns true if SQLite is installed, and false if it is not. App::Info::RDBMS::SQLite determines whether SQLite is installed based on the presence or absence of the sqlite3 or sqlite application on the file system as found when "new()" constructed the object. If SQLite does not appear to be installed, then all of the other object methods will return empty values. name my $name = $sqlite->name; Returns the name of the application. App::Info::RDBMS::SQLite simply returns the value returned by "key_name" if SQLite is installed, and "undef" if it is not installed. version my $version = $sqlite->version; Returns the SQLite version number. App::Info::RDBMS::SQLite parses the version number from the system call "`sqlite -version`" or retrieves it from DBD::SQLite. Events: info Executing `sqlite -version` error Failed to find SQLite version with `sqlite -version` Failed to retrieve SQLite version from DBD::SQLite Unable to parse name from string Unable to parse version from string Failed to parse SQLite version parts from string unknown Enter a valid SQLite version number major version my $major_version = $sqlite->major_version; Returns the SQLite major version number. App::Info::RDBMS::SQLite parses the version number from the system call "`sqlite -version`" or retrieves it from DBD::SQLite. For example, if "version()" returns "3.0.8", then this method returns "3". Events: info Executing `sqlite -version` error Failed to find SQLite version with `sqlite -version` Failed to retrieve SQLite version from DBD::SQLite Unable to parse name from string Unable to parse version from string Failed to parse SQLite version parts from string unknown Enter a valid SQLite version number minor version my $minor_version = $sqlite->minor_version; Returns the SQLite minor version number. App::Info::RDBMS::SQLite parses the version number from the system call "`sqlite -version`" or retrieves it from DBD::SQLite. For example, if "version()" returns "3.0.8", then this method returns "0". Events: info Executing `sqlite -version` error Failed to find SQLite version with `sqlite -version` Failed to retrieve SQLite version from DBD::SQLite Unable to parse name from string Unable to parse version from string Failed to parse SQLite version parts from string unknown Enter a valid SQLite version number patch version my $patch_version = $sqlite->patch_version; Returns the SQLite patch version number. App::Info::RDBMS::SQLite parses the version number from the system call "`sqlite -version`" or retrieves it from DBD::SQLite. For example, if "version()" returns "3.0.8", then this method returns "8". Events: info Executing `sqlite -version` error Failed to find SQLite version with `sqlite -version` Failed to retrieve SQLite version from DBD::SQLite Unable to parse name from string Unable to parse version from string Failed to parse SQLite version parts from string unknown Enter a valid SQLite version number executable my $executable = $sqlite->executable; Returns the path to the SQLite executable, usually sqlite3 or sqlite, which will be defined by one of the names returned by"search_exe_names()". The executable is searched for in "new()", so there are no events for this method. bin_dir my $bin_dir = $sqlite->bin_dir; Returns the SQLite binary directory path. App::Info::RDBMS::SQLite simply retrieves it as the directory part of the path to the SQLite executable. lib_dir my $lib_dir = $expat->lib_dir; Returns the directory path in which an SQLite library was found. The directory path will be one of the values returned by "search_lib_dirs()", where a file with a name as returned by "search_lib_names()" was found. No search is performed if SQLite is not installed or if only DBD::SQLite is installed. Events: info Searching for shared object library directory error Cannot find shared object library directory unknown Enter a valid Expat shared object library directory so_lib_dir my $so_lib_dir = $expat->so_lib_dir; Returns the directory path in which an SQLite shared object library was found. The directory path will be one of the values returned by "search_lib_dirs()", where a file with a name as returned by "search_so_lib_names()" was found. No search is performed if SQLite is not installed or if only DBD::SQLite is installed. Events: info Searching for shared object library directory error Cannot find shared object library directory unknown Enter a valid Expat shared object library directory inc_dir my $inc_dir = $sqlite->inc_dir; Returns the directory path in which an SQLite include file was found. The directory path will be one of the values returned by "search_inc_dirs()", where a file with a name as returned by "search_inc_names()" was found. No search is performed if SQLite is not installed or if only DBD::SQLite is installed. Events: info Searching for include directory error Cannot find include directory unknown Enter a valid SQLite include directory home_url my $home_url = $pg->home_url; Returns the PostgreSQL home page URL. download_url my $download_url = $pg->download_url; Returns the PostgreSQL download URL. search_exe_names my @search_exe_names = $sqlite->search_exe_names; Returns a list of possible names for the SQLite executable. The names are sqlite3 and sqlite by default (sqlite3.exe and sqlite.exe on Win32). search_bin_dirs my @search_bin_dirs = $sqlite->search_bin_dirs; Returns a list of possible directories in which to search an executable. Used by the "new()" constructor to find an executable to execute and collect application info. The found directory will also be returned by the "bin_dir" method. search_lib_names my @seach_lib_names = $self->search_lib_nams Returns a list of possible names for library files. Used by "lib_dir()" to search for library files. By default, the list is: libsqlite3.a libsqlite3.la libsqlite3.so libsqlite3.so.0 libsqlite3.so.0.0.1 libsqlite3.dylib libsqlite3.0.dylib libsqlite3.0.0.1.dylib libsqlite.a libsqlite.la libsqlite.so libsqlite.so.0 libsqlite.so.0.0.1 libsqlite.dylib libsqlite.0.dylib libsqlite.0.0.1.dylib search_so_lib_names my @seach_so_lib_names = $self->search_so_lib_nams Returns a list of possible names for shared object library files. Used by "so_lib_dir()" to search for library files. By default, the list is: libsqlite3.so libsqlite3.so.0 libsqlite3.so.0.0.1 libsqlite3.dylib libsqlite3.0.dylib libsqlite3.0.0.1.dylib libsqlite.so libsqlite.so.0 libsqlite.so.0.0.1 libsqlite.dylib libsqlite.0.dylib libsqlite.0.0.1.dylib search_lib_dirs my @search_lib_dirs = $sqlite->search_lib_dirs; Returns a list of possible directories in which to search for libraries. By default, it returns all of the paths in the "libsdirs" and "loclibpth" attributes defined by the Perl Config module -- plus /sw/lib (in support of all you Fink users out there). search_inc_names my @search_inc_names = $sqlite->search_inc_names; Returns a list of include file names to search for. Used by "inc_dir()" to search for an include file. By default, the names are sqlite3.h and sqlite.h. search_inc_dirs my @search_inc_dirs = $sqlite->search_inc_dirs; Returns a list of possible directories in which to search for include files. Used by "inc_dir()" to search for an include file. By default, the directories are: /usr/local/include /usr/include /sw/include BUGS
Please send bug reports to <bug-app-info@rt.cpan.org> or file them at <http://rt.cpan.org/NoAuth/Bugs.html?Dist=App-Info>. AUTHOR
David Wheeler <david@justatheory.com> SEE ALSO
App::Info documents the event handling interface. App::Info::RDBMS is the App::Info::RDBMS parent class from which App::Info::RDBMS::SQLite inherits. DBD::SQLite is the DBI driver for connecting to SQLite databases. <http://www.sqlite.org/> is the SQLite home page. COPYRIGHT AND LICENSE
Copyright (c) 2004-2008, David Wheeler. Some Rights Reserved. This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.10.1 2011-03-15 App::Info::RDBMS::SQLite(3pm)