<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
ah. you have no write permissions to these folders.<br>
create db in /home/nemo/.local/share/Sockona<br>
or /home/nemo/.config/Stockona<br>
<br>
<div class="moz-cite-prefix">On 12.11.2013 14:25, Stockona wrote:<br>
</div>
<blockquote
cite="mid:1384244746.5867.YahooMailNeo@web120302.mail.ne1.yahoo.com"
type="cite">
<div style="color:#000; background-color:#fff; font-family:times
new roman, new york, times, serif;font-size:12pt">I have QT +=
sql in my pro.<br>
DB path= "/usr/share/Stockona/.stockona_db" <br>
By the way, db.lastError().text() and type() gave me:<br>
"Error: DB failed to open, "out of memory Error opening
database" errorType= 1"<br>
<br>
The path I got when deployed as binary was:<br>
DB path= "/opt/sdk/Stockona/usr/share/Stockona/.stockona_db" <br>
Database file can be created as expected with this
configuration.<br>
<br>
Thanks,<br>
William<br>
<div><br>
</div>
<div style="font-family: times new roman, new york, times,
serif; font-size: 12pt;">
<div style="font-family: times new roman, new york, times,
serif; font-size: 12pt;">
<div dir="ltr">
<hr size="1"> <font size="2" face="Arial"> <b><span
style="font-weight:bold;">From:</span></b> Andrey
Kozhevnikov <a class="moz-txt-link-rfc2396E" href="mailto:coderusinbox@gmail.com"><coderusinbox@gmail.com></a><br>
<b><span style="font-weight: bold;">To:</span></b>
<a class="moz-txt-link-abbreviated" href="mailto:devel@lists.sailfishos.org">devel@lists.sailfishos.org</a> <br>
<b><span style="font-weight: bold;">Sent:</span></b>
Tuesday, November 12, 2013 12:14 AM<br>
<b><span style="font-weight: bold;">Subject:</span></b>
Re: [SailfishDevel] QSqlDatabase cannot create db file
when deployed as rpm package<br>
</font> </div>
<div class="y_msg_container"><br>
<div id="yiv9671822156">
<div> have you added sql to your project CONFIG?<br
clear="none">
<br clear="none">
and what is resulting dbPath value?<br clear="none">
<br clear="none">
<div class="yiv9671822156yqt6888396067"
id="yiv9671822156yqt95203">
<div class="yiv9671822156moz-cite-prefix">On
12.11.2013 14:12, Stockona wrote:<br clear="none">
</div>
<blockquote type="cite">
<div
style="color:#000;background-color:#fff;font-family:times
new roman, new york, times,
serif;font-size:12pt;">
<div><span>Source code:</span></div>
<div style="color:rgb(0, 0,
0);font-size:16px;font-family:times new roman,
new york, times,
serif;background-color:transparent;font-style:normal;"><br
clear="none">
</div>
<div style="color:rgb(0, 0,
0);font-size:16px;font-family:times new roman,
new york, times,
serif;background-color:transparent;font-style:normal;"><span
style="color:#c0c0c0;"> </span><span
style="color:#800080;"><span
style="color:#000080;">Q_DECL_EXPORT</span><span
style="color:#c0c0c0;"> </span><span
style="color:#808000;">int</span><span
style="color:#c0c0c0;"> </span><span
style="color:#000000;">main</span><span
style="color:#000000;">(</span><span
style="color:#808000;">int</span><span
style="color:#c0c0c0;"> </span><span
style="color:#000000;">argc</span><span
style="color:#000000;">,</span><span
style="color:#c0c0c0;"> </span><span
style="color:#808000;">char</span><span
style="color:#c0c0c0;"> </span><span
style="color:#000000;">*</span><span
style="color:#000000;">argv</span><span
style="color:#000000;">[]) {</span> </span></div>
<pre style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px;"><span class="yiv9671822156tab"> </span>...
</pre>
<div style="color:rgb(0, 0,
0);font-size:16px;font-family:times new roman,
new york, times,
serif;background-color:transparent;font-style:normal;"><span
style="color:#800080;"><span
class="yiv9671822156tab"> </span>FileHandler</span><span
style="color:#c0c0c0;"> </span><span
style="color:#000000;">*</span><span
style="color:#000000;">fileHandler</span><span
style="color:#c0c0c0;"> </span><span
style="color:#000000;">=</span><span
style="color:#c0c0c0;"> </span><span
style="color:#808000;">new</span><span
style="color:#c0c0c0;"> </span><span
style="color:#800080;">FileHandler</span><span
style="color:#000000;">();</span> </div>
<pre style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px;"><span style="color:#c0c0c0;"> </span><span style="color:#000000;"> view</span><span style="color:#000000;">-></span><span style="color:#000000;">rootContext</span><span style="color:#000000;">()-></span><span style="color:#000000;">setContextProperty</span><span style="color:#000000;">(</span><span style="color:#008000;">"fileHandler"</span><span style="color:#000000;">,</span><span style="color:#c0c0c0;"> </span><span style="color:#000000;">fileHandler</span><span style="color:#000000;">);</span></pre>
<pre style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px;"> ...
</pre>
<div style="color:rgb(0, 0,
0);font-size:16px;font-family:times new roman,
new york, times,
serif;background-color:transparent;font-style:normal;">}<br
clear="none">
<span></span></div>
<div style="color:rgb(0, 0,
0);font-size:16px;font-family:times new roman,
new york, times,
serif;background-color:transparent;font-style:normal;"><br
clear="none">
<span style="color:#800080;">FileHandler</span><span
style="color:#000000;">::</span><span
style="color:#000000;">FileHandler</span><span
style="color:#000000;">(</span><span
style="color:#800080;">QObject</span><span
style="color:#c0c0c0;"> </span><span
style="color:#000000;">*</span><span
style="color:#000000;">parent</span><span
style="color:#000000;">)</span><span
style="color:#c0c0c0;"> </span><span
style="color:#000000;">:</span><span
style="color:#c0c0c0;"><span
style="font-family:monospace;"> </span></span><span
style="color:#800080;">QObject</span><span
style="color:#000000;">(</span><span
style="color:#000000;">parent</span><span
style="color:#000000;">)</span><span
style="color:#000000;"> {</span></div>
<div style="color:rgb(192, 192,
192);font-size:16px;font-family:monospace;background-color:transparent;font-style:normal;"><span
style="color:rgb(0, 0, 0);"><span
style="font-family:times new roman, new
york, times, serif;"> ...</span></span><br
clear="none">
</div>
<pre style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px;"><span style="color:#c0c0c0;"> // /usr/share/Stockona/
</span><span style="color:#800080;"> QString</span><span style="color:#c0c0c0;"> </span><span style="color:#000000;">dbPath</span><span style="color:#c0c0c0;"> </span><span style="color:#000000;">=</span><span style="color:#c0c0c0;"> </span><span style="color:#000000;"></span><span style="color:#800080;">QString</span><span style="color:#000000;">(</span><span style="color:#000080;">DEPLOYMENT_PATH</span><span style="color:#000000;">);</span><span style="color:#000000;"></span>
<span style="color:#c0c0c0;"> </span><span style="color:#000000;">dbPath</span><span style="color:#000000;">.</span><span style="color:#000000;">append</span><span style="color:#000000;">(</span><span style="color:#008000;">".stockona_db"</span><span style="color:#000000;">);</span>
<span style="color:#c0c0c0;"> </span><span style="color:#000080;">qDebug</span><span style="color:#000000;">()</span><span style="color:#c0c0c0;"> </span><span style="color:#000000;"><<</span><span style="color:#c0c0c0;"> </span><span style="color:#008000;">"DB</span><span style="color:#c0c0c0;"> </span><span style="color:#008000;">path="</span><span style="color:#c0c0c0;"> </span><span style="color:#000000;"><<</span><span style="color:#c0c0c0;"> </span><span style="color:#000000;">dbPath</span><span style="color:#000000;">;</span>
<span style="color:#c0c0c0;">
</span><span style="color:#c0c0c0;"> </span><span style="color:#800080;">QSqlDatabase</span><span style="color:#c0c0c0;"> </span><span style="color:#000000;">db</span><span style="color:#c0c0c0;"> </span><span style="color:#000000;">=</span><span style="color:#c0c0c0;"> </span><span style="color:#800080;">QSqlDatabase</span><span style="color:#000000;">::</span><span style="color:#000000;">addDatabase</span><span style="color:#000000;">(</span><span style="color:#008000;">"QSQLITE"</span><span style="color:#000000;">);</span>
<span style="color:#c0c0c0;"> </span><span style="color:#000000;">db</span><span style="color:#000000;">.</span><span style="color:#000000;">setDatabaseName</span><span style="color:#000000;">(</span><span style="color:#000000;">dbPath</span><span style="color:#000000;">);<span class="yiv9671822156tab">
<span class="yiv9671822156tab"><span class="yiv9671822156tab"> </span></span>// Cannot open database when deployed as rpm</span>
</span><span class="yiv9671822156tab"> </span><span style="color:#c0c0c0;"></span><span style="color:#808000;">bool</span><span style="color:#c0c0c0;"> </span><span style="color:#000000;">ok</span><span style="color:#c0c0c0;"> </span><span style="color:#000000;">=</span><span style="color:#c0c0c0;"> </span><span style="color:#000000;">db</span><span style="color:#000000;">.</span><span style="color:#000000;">open</span><span style="color:#000000;">();</span>
...
}
</pre>
<div><br clear="none">
</div>
<div style="font-family:times new roman, new
york, times, serif;font-size:12pt;">
<div style="font-family:times new roman, new
york, times, serif;font-size:12pt;">
<div dir="ltr">
<hr size="1"> <font size="2" face="Arial">
<b><span style="font-weight:bold;">From:</span></b>
Andrey Kozhevnikov <a
moz-do-not-send="true" rel="nofollow"
shape="rect"
class="yiv9671822156moz-txt-link-rfc2396E"
ymailto="mailto:coderusinbox@gmail.com" target="_blank"
href="mailto:coderusinbox@gmail.com"><coderusinbox@gmail.com></a><br
clear="none">
<b><span style="font-weight:bold;">To:</span></b>
<a moz-do-not-send="true" rel="nofollow"
shape="rect"
class="yiv9671822156moz-txt-link-abbreviated"
ymailto="mailto:devel@lists.sailfishos.org" target="_blank"
href="mailto:devel@lists.sailfishos.org">devel@lists.sailfishos.org</a>
<br clear="none">
<b><span style="font-weight:bold;">Sent:</span></b>
Monday, November 11, 2013 11:32 PM<br
clear="none">
<b><span style="font-weight:bold;">Subject:</span></b>
Re: [SailfishDevel] QSqlDatabase cannot
create db file when deployed as rpm
package<br clear="none">
</font> </div>
<div class="yiv9671822156y_msg_container"><br
clear="none">
<div id="yiv9671822156">
<div> My project working with QSQLITE
local database, and everything good :)<br
clear="none">
<br clear="none">
Share your code and we can found
issues.<br clear="none">
<br clear="none">
<div
class="yiv9671822156yqt9414099898"
id="yiv9671822156yqt61773">
<div
class="yiv9671822156moz-cite-prefix">On
12.11.2013 02:35, Stockona wrote:<br
clear="none">
</div>
<blockquote type="cite">
<div
style="color:#000;background-color:#fff;font-family:times
new roman, new york, times,
serif;font-size:12pt;">When I
switched to "Deploy by copying
binary", the database is created
and connected correctly.
<div>Changing the deployment to
rpm package the same code just
failed with database error
message "out of memory Error
opening database."</div>
<div><br clear="none">
</div>
<div style="color:rgb(0, 0,
0);font-size:16px;font-family:times
new roman, new york, times,
serif;background-color:transparent;font-style:normal;">I
checked in Emulator terminal
and the database file was not
created at all. Is this a
permission issue? How do I
work around this?</div>
<div style="color:rgb(0, 0,
0);font-size:16px;font-family:times
new roman, new york, times,
serif;background-color:transparent;font-style:normal;">Thanks
in advance!<br clear="none">
</div>
<div style="color:rgb(0, 0,
0);font-size:16px;font-family:times
new roman, new york, times,
serif;background-color:transparent;font-style:normal;"><br
clear="none">
</div>
</div>
<br clear="none">
<fieldset
class="yiv9671822156mimeAttachmentHeader"></fieldset>
<br clear="none">
<pre>_______________________________________________
SailfishOS.org Devel mailing list</pre>
</blockquote>
</div>
<br clear="none">
</div>
</div>
<br clear="none">
<div class="yiv9671822156yqt9414099898"
id="yiv9671822156yqt85380">_______________________________________________<br
clear="none">
SailfishOS.org Devel mailing list</div>
<br clear="none">
<br clear="none">
</div>
</div>
</div>
</div>
<br clear="none">
<fieldset
class="yiv9671822156mimeAttachmentHeader"></fieldset>
<br clear="none">
<pre>_______________________________________________
SailfishOS.org Devel mailing list</pre>
</blockquote>
</div>
<br clear="none">
</div>
</div>
<br>
<div class="yqt6888396067" id="yqt46759">_______________________________________________<br
clear="none">
SailfishOS.org Devel mailing list</div>
<br>
<br>
</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
SailfishOS.org Devel mailing list</pre>
</blockquote>
<br>
</body>
</html>