<div dir="ltr"><div name="div[0]" style="color:rgb(0,0,0);font-family:Arial;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:pre-wrap;word-spacing:0px">
<span id="Dst[0][0:6:0:5]">Andreas, thanks for the explanation about the Berkeley Database. </span><span></span><span></span><span id="Dst[0][70:80:57:63]">However</span><span>,</span><span> </span><span id="Dst[0][83:84:66:71]">I have</span><span> </span><span id="Dst[0][86:94:73:76]">made</span><span> </span><span id="Dst[0][96:101:78:84]">several</span><span> </span><span id="Dst[0][103:109:86:92]">changes</span><span> </span><span id="Dst[0][111:112:94:95]">of</span><span> </span><span id="Dst[0][114:125:97:107]">permissions</span><span> </span><span id="Dst[0][127:127:109:111]">and</span><span> </span><span id="Dst[0][129:139:113:117]">owner</span><span> </span><span id="Dst[0][141:142:119:120]">of</span><span> </span><span id="Dst[0][144:146:122:124]">the</span><span> </span><span id="Dst[0][148:155:126:130]">files</span><span> </span><span id="Dst[0][157:166:132:139]">produced</span><span> </span><span id="Dst[0][168:170:141:142]">by</span><span> </span><span id="Dst[0][172:184:144:156]">mapcache_seed</span><span>,</span><span> </span><span id="Dst[0][187:187:159:161]" class="">and</span><span> </span><span id="Dst[0][194:203:163:163]">I</span><span> </span><span id="Dst[0][189:192:165:169]">still</span><span> </span><span id="Dst[0][194:203:171:173]">get</span><span> </span><span id="Dst[0][205:206:175:177]">the</span><span> </span><span id="Dst[0][208:212:179:182]">same</span><span> </span><span id="Dst[0][214:218:184:188]">error</span><span> </span><span id="Dst[0][220:221:190:191]">on</span><span> </span><span id="Dst[0][223:224:193:195]">the</span><span> </span><span id="Dst[0][234:243:197:206]">OpenLayers</span><span> </span><span id="Dst[0][226:229:208:211]">demo</span><span>.</span></div>
<br style="color:rgb(0,0,0);font-family:Arial;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:pre-wrap;word-spacing:0px">
<div name="div[1]" style="color:rgb(0,0,0);font-family:Arial;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:pre-wrap;word-spacing:0px">
<span id="Dst[1][3:4:0:0]">I</span><span> </span><span id="Dst[1][0:1:2:6]">don't</span><span> </span><span id="Dst[1][3:4:8:11]">know</span><span> </span><span id="Dst[1][6:7:13:14]">if</span><span> </span><span id="Dst[1][9:12:16:22]">others</span><span> </span><span id="Dst[1][14:20:24:27]">users</span><span> </span><span id="Dst[1][25:30:29:31]">have had</span><span> </span><span id="Dst[1][32:33:33:35]">the</span><span> </span><span id="Dst[1][35:39:37:40]" class="">same</span><span> </span><span id="Dst[1][41:45:42:46]" class="">error</span><span> </span><span id="Dst[1][47:49:48:51]">with</span><span> </span><span id="Dst[1][51:58:53:60]" class="">Mapcache</span><span> </span><span id="Dst[1][60:60:62:64]" class="">and</span><span> </span><span id="Dst[1][77:84:66:73]">Berkeley</span><span> Databases </span><span id="Dst[1][86:87:75:76]">in</span><span> </span><span id="Dst[1][89:94:78:83]">Ubuntu</span><span> </span><span id="Dst[1][96:101:85:90]" class="">Server</span><span>.</span></div>
<br style="color:rgb(0,0,0);font-family:Arial;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:pre-wrap;word-spacing:0px">
<div name="div[2]" style="color:rgb(0,0,0);font-family:Arial;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:pre-wrap;word-spacing:0px">
<span id="Dst[2][0:6:0:5]" class="">Thanks</span><span> </span><span id="Dst[2][8:17:7:11]" class="">again</span><span>,</span></div><br style="color:rgb(0,0,0);font-family:Arial;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:pre-wrap;word-spacing:0px">
<div name="div[3]" style="color:rgb(0,0,0);font-family:Arial;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:pre-wrap;word-spacing:0px">
<span id="Dst[3][0:5:0:5]">Samuel</span><span>.</span></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">2014/1/23 Eichner, Andreas - SID-NLKM <span dir="ltr"><<a href="mailto:Andreas.Eichner@sid.sachsen.de" target="_blank">Andreas.Eichner@sid.sachsen.de</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">> Thanks Andreas for your response. I changed all the permissions to<br>
> read, write and the owner, after restarting apache, it fails<br>
> displaying tiles in the demo and report the same error:<br>
><br>
> "failed to aquire connection to bdb backend: unknown error"<br>
><br>
> I followed the instructions to check the database created with db_sql<br>
> according to [1] but I get the same error:<br>
><br>
> > db5.1_sql ortofoto.db<br>
><br>
> "ortoforo.db: multiple databases specified but not supported by file"<br>
> "Error: file is encrypted or is not a database"<br>
><br>
> I have little knowledge of this type of database, but I would to<br>
> evaluate the loading speed of tiles.<br>
<br>
</div>It seems there is a misunderstanding of the usage of Berkley DB. BDB is a library implementing a key/value store and is quite flexible in what can be used as key and value.<br>
And that's the way MapCache uses it. The key is a string representing tileset, zoomlevel and any used dimension but at least (x, y) and the value is the image BLOB. So there will be a single BDB cache stored in a directory (because BDB uses multiple files) for all tilesets configured to use this cache.<br>
The error message you got is a mixed result of BDB (1st: "multiple ...") and SQLite (2nd: "file is encrypted..."). This is a new feature since Oracle Berkeley DB 11g. It combines the flexibility of the SQLite database engine with the strengths of the BDB used as storage backend. See [1] for more info on that.<br>
Although both use-cases use BDB as backend they are in fact completely different and cannot be mixed together. So you cannot use dbsql to inspect the tilecache. You have to use mapcache_seed to manipulate it (seed/reseed, clean).<br>
<br>
HTH<br>
<br>
[1] <a href="http://www.oracle.com/technetwork/database/berkeleydb/overview/sql-160887.html" target="_blank">http://www.oracle.com/technetwork/database/berkeleydb/overview/sql-160887.html</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>---<div> .~.<div> / v \</div><div> // \\</div><div> /( )\</div><div> ^`~'^</div></div>
</div>