[DBD-SQLite] problems using sqlite with mod_perl in apache

Mike Campbell mike.campbell at oracle.com
Wed Dec 2 14:43:05 GMT 2009


VGhhbmtzIGV2ZXJ5b25lIGZvciB0aGUgaGVscC4gSSBoYXZlIGhhZCBzb21lIHN1Y2Nlc3MuIEkg
bW92ZWQgdGhlIApzY3JpcHQgb3ZlciB0byB0aGUgY2dpLWJpbiBkaXJlY3RvcnkgYW5kIGl0IG5v
dyB3b3JrcyB3aGVuIGFjY2Vzc2VkIHZpYSAKdGhlIGJyb3dzZXIuIFNvIGl0IHNlZW1zIHRoYXQg
dGhlIHByb2JsZW0gaXMgcmVsYXRlZCB0byBtb2RfcGVybC4gVGhlIApiZWxvdyBpbmZvIGlzIHdo
ZW4gdHJ5aW5nIHRvIHJ1biB3aXRoIG1vZF9wZXJsLiBJIGFtIG5vdCBzdXJlIGlmIGl0IGlzIAp3
b3J0aCBwdXJzdWluZyBzaW5jZSBpdCB3b3JrcyBhcyBhIGNnaSBzY3JpcHQgdGhvdWdoLiBJZiBh
bnlvbmUgaGFzIGFueSAKaWRlYXMgaXQgd291bGQgYmUgYXBwcmVjaWF0ZWQgdGhvdWdoLgoKQm90
aCB0aGUgbW9kX3BlcmwgYW5kIHNoZWxsIHNjcmlwdCByZXR1cm5zIHRoZSBmb2xsb3dpbmc6Cgpw
ZXJsIHZlcnNpb24gNS4wMDgwMDgKREJJIHZlcnNpb24gMS42MDkKCkFwYWNoZSB2ZXJzaW9uIDIu
Mi4zClJlZGhhdCB2ZXJzaW9uIDUKCkkgdG9vayBEYXJyZW4ncyBhZHZpY2UgYW5kIG1vZGlmaWVk
IHRoZSBjb2RlIGFzIHNob3duIGJlbG93LiBJIGFsc28gdG9vayAKb3V0IHRoZSBjcmVhdGUgdGFi
bGUgYW5kIGluc2VydCBzdGF0ZW1lbnRzIGFuZCBhbSBqdXN0IHRlc3RpbmcgdGhlIApwcmVwYXJl
IHN0YXRlbWVudC4gVGhlIGRhdGFiYXNlIGlzIGNyZWF0ZWQgYnkgcnVubmluZyB0aGUgc2hlbGwg
c2NyaXB0IAp0byBjcmVhdGUgdGhlIHRhYmxlIGFuZCBpbnNlcnQgbXkgMSByb3cuIFRoaXMgaXMg
dGhlIGN1cnJlbnQgY29kZToKCiMhL3Vzci9iaW4vcGVybCAtdwp1c2UgREJEOjpTUUxpdGU7Cgpw
cmludCAiQ29udGVudC10eXBlOiB0ZXh0L2h0bWxcbiI7CnByaW50ICJQcmFnbWE6IG5vLWNhY2hl
XG4iOwpwcmludCAiQ2FjaGUtY29udHJvbDogbm8tY2FjaGVcbiI7CnByaW50ICJFeHBpcmVzOiBN
b24sIDA2IE1heSAxOTcwIDA0OjAwOjAwIEdNVFxuIjsKcHJpbnQgIlxuPGJvZHk+IjsKCkRCSS0+
dHJhY2UoNCwgIi90bXAvZGJpdHJhY2UudHh0Iik7CiRkYiA9IERCSS0+Y29ubmVjdCgiZGJpOlNR
TGl0ZTpkYm5hbWU9L3RtcC90ZXN0LmRiIiwgIiIsICIiLAogICAgICAgICAgICAgICAgICAgeyBS
YWlzZUVycm9yID0+IDEgfSk7CiRkYi0+dHJhY2UoNCwgIi90bXAvZGJkdHJhY2UudHh0Iik7CiRz
dGggPSAkZGItPnByZXBhcmUoInNlbGVjdCBjMSBmcm9tIHh5eiIpOwokc3RoLT5leGVjdXRlKCk7
CndoaWxlKCAkaHJlZiA9ICRzdGgtPmZldGNocm93X2hhc2hyZWYgKSB7CiAgIHByaW50ICQkaHJl
ZnsiYzEifSAuICJcbiI7Cn0KJHN0aC0+ZmluaXNoOwokZGItPmRpc2Nvbm5lY3Q7CgpwcmludCAi
PC9ib2R5PiI7CgpJIG5vIGxvbmdlciBnZXQgdGhlIGVycm9yIHByaW50ZWQgdG8gdGhlIGJyb3dz
ZXIgYnV0IG5vdyB0aGUgZXJyb3IgaXMgCnJlZGlyZWN0ZWQgaW50byB0aGUgd2Vic2VydmVyIGxv
ZyBmaWxlLiBVc2luZyB0aGUgYWJvdmUgSSBnZXQgdGhpcyBpbiAKdGhlIGVycm9yX2xvZzoKCkRC
RDo6U1FMaXRlOjpkYiBwcmVwYXJlIGZhaWxlZDogbm90IGFuIGVycm9yIGF0IAovaG9tZS9vcmFj
bGUvYnVncHVzaC9hYmMucGwgbGluZSAxNi4KW1dlZCBEZWMgMDIgMDg6MDY6MjkgMjAwOV0gW2Vy
cm9yXSBEQkQ6OlNRTGl0ZTo6ZGIgcHJlcGFyZSBmYWlsZWQ6IG5vdCAKYW4gZXJyb3IgYXQgL2hv
bWUvb3JhY2xlL2J1Z3B1c2gvYWJjLnBsIGxpbmUgMTYuXG4KCkkgYWxzbyB0b29rIEFkYW0ncyBh
ZHZpY2UgYW5kIHR1cm5lZCBvbiBEQkQgYW5kIERCSSB0cmFjaW5nIGFzIHNob3duIGluIAp0aGUg
YWJvdmUgZXhhbXBsZS4gVGhlIERCSSB0cmFjZSBmaWxlIGRpZCBub3QgaGF2ZSBtdWNoIGJ1dCB0
aGUgREJEIAp0cmFjZSBmaWxlIHNob3dzIHRoaXM6Cgo8LSB0cmFjZT0gNCBhdCAvaG9tZS9vcmFj
bGUvYnVncHVzaC9hYmMucGwgbGluZSAxMyB2aWEgIGF0IAovdXNyL2xpYi9wZXJsNS92ZW5kb3Jf
cGVybC81LjguOC9pMzg2LWxpbnV4LXRocmVhZC1tdWx0aS9Nb2RQZXJsL1JlZ2lzdHJ5Q29va2Vy
LnBtIApsaW5lIDIwNAogICAgIC0+IHByZXBhcmUgZm9yIERCRDo6U1FMaXRlOjpkYiAoREJJOjpk
Yj1IQVNIKDB4OWU0MTUyNCl+MHg5ZTQxNGU4IAonc2VsZWN0IGMxIGZyb20geHl6JykgdGhyIzlh
YmUwNDAKc3FsaXRlIHRyYWNlOiBwcmVwYXJlIHN0YXRlbWVudDogc2VsZWN0IGMxIGZyb20geHl6
IGF0IGRiZGltcC5jIGxpbmUgNDIzCnNxbGl0ZSBlcnJvciAyMSByZWNvcmRlZDogbm90IGFuIGVy
cm9yIGF0IGRiZGltcC5jIGxpbmUgNDMzCjw+IERFU1RST1koREJJOjpzdD1IQVNIKDB4OWRhZTU2
YykpIGlnbm9yZWQgZm9yIG91dGVyIGhhbmRsZSAoaW5uZXIgCkRCSTo6c3Q9SEFTSCgweDllNDE0
YTApIGhhcyByZWYgY250IDEpCiAgICAgLT4gREVTVFJPWSBmb3IgREJEOjpTUUxpdGU6OnN0IChE
Qkk6OnN0PUhBU0goMHg5ZTQxNGEwKX5JTk5FUikgCnRociM5YWJlMDQwCiAgICAgICAgRVJST1I6
ICcyMScgJ25vdCBhbiBlcnJvcicgKGVyciMxKQo8LSBERVNUUk9ZPSB1bmRlZiBhdCAvaG9tZS9v
cmFjbGUvYnVncHVzaC9hYmMucGwgbGluZSAxNCB2aWEgIGF0IAovaG9tZS9vcmFjbGUvYnVncHVz
aC9hYmMucGwgbGluZSAxNAogICAgIGRiaWhfY2xlYXJjb20gMHg5ZTQxNGEwIChjb20gMHg5ZDI4
YzkwLCB0eXBlIDMpIGRvbmUuCgogICAgICEhIEVSUk9SOiAnMjEnICdub3QgYW4gZXJyb3InIChl
cnIjMCkKPC0gcHJlcGFyZT0gdW5kZWYgYXQgL2hvbWUvb3JhY2xlL2J1Z3B1c2gvYWJjLnBsIGxp
bmUgMTQgdmlhICBhdCAKL3Vzci9saWIvcGVybDUvdmVuZG9yX3BlcmwvNS44LjgvaTM4Ni1saW51
eC10aHJlYWQtbXVsdGkvTW9kUGVybC9SZWdpc3RyeUNvb2tlci5wbSAKbGluZSAyMDQKCkl0IGFw
cGVhcnMgdGhhdCB0aGUgcHJlcGFyZSBpcyByZXR1cm5pbmcgYSBzcWxpdGUgZXJyb3IgMjEKT24g
MTIvMS8yMDA5IDEwOjI3IFBNLCBEYXJyZW4gRHVuY2FuIHdyb3RlOgo+IE1pa2UgQ2FtcGJlbGwg
d3JvdGU6Cj4+IE9rIGhlcmUgaXMgd2hhdCBJIGdldC4KPj4KPj4gVGVzdCB1c2luZyBEQkQ6OlNR
TGl0ZSAoc2FtZSBvdXRwdXQgd2hlbiB1c2VkIGNvbW1hbmQtbGluZSBhbmQgdmlhIAo+PiB3ZWJw
YWdlKQo+PiA9PT09PT09PT09PT09PT09PT09PT0KPj4gdGhlIFNRTGl0ZSB2MyBpcyAxLjI3Cj4+
Cj4+IFRlc3QgdXNpbmcgREJEOjpTUUxpdGUyIChzYW1lIG91dHB1dCB3aGVuIHVzZWQgY29tbWFu
ZC1saW5lIGFuZCB2aWEgCj4+IHdlYnBhZ2UpCj4+IHRoZSBTUUxpdGUgdjIgaXMgMC4zMwo+IDxz
bmlwPgo+Cj4gQXQgZmlyc3QgZ2xhbmNlIHlvdSBzZWVtIHRvIGJlIGRvaW5nIHRoaW5ncyBhZGVx
dWF0ZWx5IGluIHlvdXIgY29kZSAKPiBzYW1wbGVzLgo+Cj4gSG93ZXZlciwgeW91ciBjb2RlIGxv
b2tzIHZlcnkgb2xkLWZhc2hpb25lZCwgbWF5YmUgYmVjYXVzZSB5b3UgYmFzZWQgCj4gaXQgb24g
b2xkIGNvZGUgeW91IHNhdyBzb21ld2hlcmUsIGFuZCBtYWtpbmcgaXQgaW50byBtb3JlIG1vZGVy
biBQZXJsIAo+IGNhbiBwcm9iYWJseSBoZWxwLgo+Cj4gRm9yIHN0YXJ0ZXJzLCB3aGVuIHlvdSBh
cmUgdXNpbmcgREJJLCAqYWx3YXlzKiBjb25maWd1cmUgaXQgdG8gdGhyb3cgCj4gZXhjZXB0aW9u
cyBvbiBlcnJvcnMgcmF0aGVyIHRoYW4ganVzdCByZXR1cm4gbm90aGluZy4KPgo+IEluc3RlYWQg
b2YgdGhpczoKPgo+ICRkYiA9IERCSS0+Y29ubmVjdCgiZGJpOlNRTGl0ZTpkYm5hbWU9L3RtcC9i
dWdwdXNoLmRiIiwgIiIsICIiKQo+ICAgICAgIHx8IGRpZSggJERCSTo6ZXJyc3RyIC4gIlxuIiAp
Owo+Cj4gLi4uIGRvIHRoaXM6Cj4KPiAkZGIgPSBEQkktPmNvbm5lY3QoImRiaTpTUUxpdGU6ZGJu
YW1lPS90bXAvYnVncHVzaC5kYiIsICIiLCAiIiwKPiAgICAgICAgIHsgUmFpc2VFcnJvciA9PiAx
IH0pOwo+Cj4gVGhhdCBhbG9uZSBzaG91bGQgZ28gZnVydGhlciB0b3dhcmRzIHlvdSBnZXR0aW5n
IHVzZWZ1bCBlcnJvciBtZXNzYWdlcyAKPiB3aGVuIHlvdSBzaG91bGQgYmUuCj4KPiBBbHNvIHlv
dSBjYW4gcmVtb3ZlIGFsbCB5b3VyIHRlc3RzIGxpa2UgImlmKCEgZGVmaW5lZCgkc3RoKSB8fCAh
IAo+ICgkc3RoKSkiIG9yICJpZiAoISBkZWZpbmVkKCAkcmMgKSApIi4KPgo+IFdoZW4gREJJIGlz
IHNldCB0byB0aHJvdyBleGNlcHRpb25zLCB5b3UgY2FuIGp1c3QgY29kZSBhcyBpZiBlYWNoIHN0
ZXAgCj4gd2lsbCB3b3JrIGFuZCB5b3UgZG9uJ3QgbmVlZCB0byB0ZXN0LCBzaW5jZSB0aGUgcHJv
Z3JhbSBzaG91bGQgZGllIGJ5IAo+IGl0c2VsZiBpZiBzb21ldGhpbmcgZ29lcyB3cm9uZy4KPgo+
IEluc3RlYWQsIHlvdSBqdXN0IGRvIHRlc3RzIHdoZW4geW91IHdhbnQgdGhlIHByb2dyYW0gdG8g
bm90IGRpZSBidXQgCj4gcmF0aGVyIGJlIG1vcmUgZ3JhY2VmdWwgd2hlbiBzb21ldGhpbmcgZ29l
cyB3cm9uZywgYW5kIHRoZW4geW91IGRvIGl0IAo+IGJ5IHNldHRpbmcgdXAgYW4gZXhjZXB0aW9u
IGhhbmRsZXIgKGFuICJldmFsIiBibG9jayksIGJ1dCB3ZSBkb24ndCAKPiBuZWVkIHRvIGdldCBp
bnRvIHRoYXQgbm93Lgo+Cj4gU28gdHJ5IG1ha2luZyB0aG9zZSBjaGFuZ2VzIGFuZCBzZWUgd2hh
dCBlZmZlY3QgaXMgaGFzLgo+Cj4gSSdtIG5vdCBpbW1lZGlhdGVseSBpbiB0aGUgcG9zaXRpb24g
dG8gcnVuIHlvdXIgY29kZSBteXNlbGYsIG5vdCAKPiBoYXZpbmcgbW9kX3BlcmwgaW5zdGFsbGVk
Lgo+Cj4gSXQgd291bGQgYmUgaGVscGZ1bCBpZiB5b3UgY291bGQgcHJvdmlkZSBtb3JlIGluZm9y
bWF0aW9uIG9uIHlvdXIgc2V0dXAuCj4KPiBXaGF0IHZlcnNpb25zIG9mIFBlcmwgYW5kIERCSSBh
cmUgeW91IHVzaW5nLCB0byBzdGFydCB3aXRoLgo+Cj4gVG8gZmluZCBvdXQsIHlvdSBjYW4gdXNl
IGNvZGUgbGlrZSB0aGlzOgo+Cj4gICBteSAkcGVybHZlcnMgPSAkWzsKPgo+ICAgdXNlIERCSTsK
PiAgIG15ICRkYml2ZXJzID0gJERCSTo6VkVSU0lPTjsKPgo+IFJ1biB0aGF0IG9uIGJvdGggY29t
bWFuZC1saW5lIGFuZCBtb2QtcGVybCBhcyB1c3VhbC4KPgo+IEFsc28geW91ciB2ZXJzaW9ucyBv
ZiBBcGFjaGUgYW5kIG1vZF9wZXJsIGFyZSB1c2VmdWwgdG8ga25vdy4KPgo+IEFsc28gdHJ5IHJ1
bm5pbmcgeW91ciBjb2RlIHVuZGVyIEZhc3RDR0ksIG9yIENHSSwgcmF0aGVyIHRoYW4gbW9kX3Bl
cmwgCj4gYW5kIHNlZSBpZiB0aGF0IGhhcyBhbnkgZWZmZWN0IG9uIHRoZSByZXN1bHQuICBJbmNs
dWRlIHRoZSB0ZXN0cyBmb3IgCj4gd2hhdCBEQkQ6OlNRTGl0ZS9ldGMgdmVyc2lvbiBpcyBydW5u
aW5nIGlmIG5lY2Vzc2FyeS4KPgo+IE1heWJlIHNvbWVvbmUgZWxzZSBvbiB0aGlzIGxpc3QgaGFz
IGlkZWFzPwo+Cj4gLS0gRGFycmVuIER1bmNhbgo+CgotLSAKCk1pa2UgQ2FtcGJlbGwgfCBQcmlu
Y2lwYWwgU3VwcG9ydCBFbmdpbmVlciB8IDQwNy40NTguMjMxMwpPcmFjbGUgU3VwcG9ydCBTZXJ2
aWNlcwo3NDUzIFRHIExlZSBCbHZkLiB8IE9ybGFuZG8sIEZMIDMyODIyCi0tLS0tLS0tLS0tLS0t
IG5leHQgcGFydCAtLS0tLS0tLS0tLS0tLQpBbiBIVE1MIGF0dGFjaG1lbnQgd2FzIHNjcnViYmVk
Li4uClVSTDogaHR0cDovL2xpc3RzLnNjc3lzLmNvLnVrL3BpcGVybWFpbC9kYmQtc3FsaXRlL2F0
dGFjaG1lbnRzLzIwMDkxMjAyLzEzMTZjMDU5L2F0dGFjaG1lbnQuaHRtCg==


More information about the DBD-SQLite mailing list