473,399 Members | 2,858 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,399 software developers and data experts.

Setting up php5/sqlite3 with apache2

I have been trying to set of php5 with sqlite3 support on my ubuntu machine with no results till now. I installed all the required packages specifically the php-sqlite package and it has installed the sqlite library. My php is working fine and my phpinfo() shows that pdo_sqlite() is enabled. Nevertheless i an unable to open and PDO conenction to a database.

[PHP]$dbh= new PDO('sqlite:sample.db');[/PHP]

is giving me
Expand|Select|Wrap|Line Numbers
  1. Error!: SQLSTATE[HY000] [14] unable to open database file
Overall none of the sqlite functions are working. Please help me to set up sqlite3 support properly in php!

thanks.
Aug 13 '07 #1
1 3334
pbmods
5,821 Expert 4TB
Heya, Digital. Welcome to TSDN!

Does Apache have read/write permissions in the directory in which you're trying to create the SQLite database?
Aug 13 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: michael newport | last post by:
I did the following as instructed in the docs. (see below) everything seemed to install ok and I started apache with no complaints, but, 1)I do not see a process for apache using ps -ef 2) In...
1
by: FL | last post by:
Hi, I'm tring to *test* php5 beta2 as module with Apache 2.0.48 and win2k (I know, I'm nuts :o) First, there is no php5apache2.dll in the beta2 package but a php4apache2.dll (php.net doc...
6
by: somaBoy MX | last post by:
I'm configuring PHP5 on my WinXP pro machine as an Apache2 handler. However when I start apache I get system errormessages like "PHP Shutdown: Unable to load dynamic library...
12
by: Chung Leong | last post by:
I've been trying to set up a LAMP server for experimental purpose. Our production environment is WAMP (Windows Apache2 MSSQL PHP) but out of curiosity I would like to see if we can operate our...
0
by: Jason Morehouse | last post by:
Hello, Just wondering if anyone is using the apache worker module with php? I've complied php5 with zend threadsafe support, and apache2 with the MPM worker module on a Linux box. Everything...
0
by: furious_radish | last post by:
I have been trying to use php5's xml support. My OS is Ubuntu 5.10 I am running apache2 with php5, no problems there. I installed the php5-xsl package but when I use any xsl related functions...
0
by: TheClair | last post by:
Hi, I'm trying to install php5 as a shared module for Apache 2 (on SuSe 10.0). When I compile I don't get libphp5.so. I don't know why, I'm not getting any errors, there are a few warnings, but...
3
by: brundlefly76 | last post by:
I am using the apache-perl webserver in Feisty (an Apache 1.3 with mod_perl enabled), which works fine, but I cannot figure out how to install php5 into this webserver as well. Here's some stuff...
12
by: Alan M Dunsmuir | last post by:
After having worked with Apache/MySQL/PHP for a year or so under Linux I need, purely for convenience, to set up a parallel platform under Windows. Unfortunately, since I last did this (using...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.