tag:piggydb.net,2009:db-20110814170804990:tag-162014-02-19T22:12:34.892+00:00Piggydb Documents - FAQPiggydbtag:piggydb.net,2009:db-20110814170804990.fragment-762014-02-19T22:12:34.892+00:002014-02-19T22:12:34.892+00:00How can I reset owner's password?
<div class="paragraph">
To reset owner's password, you need to access the database directly and execute a query as follows:
</div>
<div class="paragraph">
(here I suppose you use the standalone package)
</div>
<div class="paragraph">
1) Stop the piggydb server if running
</div>
<div class="paragraph">
2) Open the terminal or console and move to the root directory of your piggydb installment
</div>
<div class="paragraph">
3) Open the database shell by executing:
</div>
<pre>
$ java -cp webapp/WEB-INF/lib/h2-*.jar org.h2.tools.Shell
</pre>
<div class="paragraph">
You will be asked a few parameters, so input the followings:
</div>
<pre>
URL: jdbc:h2:~/piggydb/piggydb (the default database location)
User: sa
Password: <empty> (just hit the Enter)
</pre>
<div class="paragraph">
4) Execute a query to clear owner's password:
</div>
<pre>
sql> delete from global_setting where setting_name = 'owner.password';
</pre>
<div class="paragraph">
5) Close the shell with 'quit' and restart your piggydb server
</div>
<div class="paragraph">
You should be able to log in with the default password owner/owner
</div>
ownertag:piggydb.net,2009:db-20110814170804990.fragment-642011-09-15T20:40:48.266+00:002011-09-15T20:40:48.266+00:00How to embed images into the content of a knowledge fragment?
<div class="paragraph">
There are two ways to embed images. One is to write image URLs in content, which must start with "http" (<a class="url-link" href="file:">file:</a> is not allowed by the browsers because of a security reason). The other is to register image files as <a href="http://piggydb.jp/en/fragment.htm?id=43">file fragments</a> (there's the text/file switch in the fragment editor) and embed them with the wiki formatting:
</div>
<pre>
fragment:<another-fragment-number>:embed
</pre>
<div class="paragraph">
Please refer to the Wiki Markup Help which can be opened via the help button [?] in the editor menu.
</div>
ownertag:piggydb.net,2009:db-20110814170804990.fragment-632011-09-15T20:33:18.206+00:002011-09-15T20:33:18.206+00:00How to install multiple Piggydbs on the same computer?
<div class="paragraph">
The <a class="quick-viewable" data-id="12" href="http://piggydb.jp/en/fragment.htm?id=12">Standalone Package</a> doesn't support multiple databases. So you need to set up a <a href="http://tomcat.apache.org/">Tomcat</a> server (or other servlet containers) on your environment, to which you can deploy multiple <a class="quick-viewable" data-id="14" href="http://piggydb.jp/en/fragment.htm?id=14">War Package</a>s. A database will be created for each deployment(installment) of the War Package.
</div>
<div class="paragraph">
Apache Tomcat - <a class="url-link" href="http://tomcat.apache.org/">http://tomcat.apache.org/</a>
</div>
<div class="paragraph">
To deploy a war file, just copy it to the <i>webapps</i> directory under the Tomcat home directory. You might want to change the name of the deployed war file corresponding to your purpose. The name will be used for the URL to access the application and the database file names (<a class="quick-viewable" data-id="16" href="http://piggydb.jp/en/fragment.htm?id=16">#16</a>).
</div>
owner