<?xml version="1.0" encoding="utf-8"?><rss version="2.0" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/">
<channel>
<title>selfoss support forum - MySQL settings</title>
<link>https://forum.selfoss.aditu.de/</link>
<description>selfoss support forum</description>
<language>en</language>
<item>
<title>MySQL settings</title>
<content:encoded><![CDATA[<p><strong>Question 1</strong><br />
Is it a good idea to place the selfoss-2/ catalog in the public directory like this: /var/www/selfoss-2/ ?<br />
If so, should any measures be taken to prevent sensitive information in case, for example, the server would be misconfigured for a while so that visitors can read config.ini?</p>
<p><strong>Question 2</strong><br />
<a href="https://github.com/SSilence/selfoss/issues/723">Here</a> jitojnar says:</p>
<blockquote><p>Sometimes we forget to add the prefix when we change the code and as not many people use the db_prefix option it often goes unnoticed.</p>
</blockquote><p>
If I am not mistaken, this is true for version 2.15. Would it be possible to provide a list of places in the code where a user can fix this or should we give up security and omit the table prefix option?</p>
<p><strong>Question 3</strong><br />
What privileges should selfoss's mysql-user have?</p>
<p>---<br />
I tried to install this on Debian wheezy with apache2 php5-fpm/fastcgi and mysql 5.6 iirc. So far, I have had these issues: <a href="https://github.com/SSilence/selfoss/issues/723">723</a>, the generate password-hash doesn't work with safari (at least not with my settings) but worked with firefox (mac) and <a href="https://github.com/SSilence/selfoss/issues/656">&quot;An error occurred&quot;</a>.</p>
<p>At the moment I am at this point:<br />
05-21-16 13:51:01 Debug logged in with supplied username and password<br />
05-21-16 13:51:01 Debug logged in with supplied username and password<br />
05-21-16 13:51:01 Debug set cookie on <span style="color:#939;">mydomain.tld</span>/selfoss-2/ expiring in 2592000 seconds<br />
05-21-16 13:51:01 Debug logged in using valid session<br />
05-21-16 13:51:01 Debug Establish database connection<br />
05-21-16 13:51:01 Error PDOStatement: Table 'selfoss.version' doesn't exist</p>
<p>Of course it exists. :p<br />
Hope to get some answers so I can try again knowing a little more about what I am doing.</p>
]]></content:encoded>
<link>https://forum.selfoss.aditu.de/index.php?id=1185</link>
<guid>https://forum.selfoss.aditu.de/index.php?id=1185</guid>
<pubDate>Sat, 21 May 2016 14:18:59 +0000</pubDate>
<dc:creator>sestir</dc:creator>
</item>
</channel>
</rss>
