-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathum_databases.html
58 lines (50 loc) · 3.57 KB
/
um_databases.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
<!DOCTYPE html>
<html>
<head>
<title>skarphed - Documentation</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link href="static/logo_32.png" rel="icon" type="image/png">
<link href="static/mainsite.css" rel="stylesheet" type="text/css">
</head>
<body>
<div id="body_overlay" >
<header>
<div id="headercontent">
<a class="bclink" href="http://skarphed.org">
<img src="static/logo_32.png" alt="skarphed" style="float:left; margin-right: 10px;"></a>
<a class="bclink" href="index.html">Documentation
</a>
<a class="bclink" href="user_man.html">
→ Users Manual
</a>
<a class="bclink" href="um_databases.html">
→ Databases
</a>
</div>
</header>
<div id="space_content">
<span class="headerlink_nohover"><h2> Databases </h2></span>
<h3> Step 1: Installing the server </h3>
<p>
Skarphed uses the <a href="http://www.firebirdsql.org">Firebird RDBMS</a> as it's database management system. Therefore you have to set up at least one Firebird-server in your setup.
It is up to you which operating system you run your Firebird-server on, it just has to offer a SSH-Server at <b>TCP-port 22</b>, the database connection at <b>TCP-port 3050</b> (which is firebirds default port) and must be a running a Firebird version 2.5 or greater.
On Debian (tested on squeeze) for example you install a Firebird-server simply by executing these commands:<br>
<code>
user@skarphed-db:~$ sudo apt-get install firebird2.5-super<br>
user@skarphed-db:~$ sudo dpkg-reconfigure firebird2.5-super<br>
user@skarphed-db:~$ sudo /etc/init.d/firebird2.5-super restart
</code><br>
The second command will ask if the Firebird-server should be started by default. Answer this question with yes. Further it will ask you for a SYSDBA-password. SYSDBA is the equivalent of a root-user in UNIX-environments. <b>Choose a strong password</b> and keep it until the next step.
</p>
<h3> Step 2: Register the database in <em>skarphed-admin</em></h3>
<p>
If you haven't already done it, please register the machine you just installed Firebird on as a <a href="um_servers.html">server</a> in <em>skarphed-admin</em>. Now you do a right mouseclick on this server and click <em>Register Database</em>. You will now see a Dialog in the working area that asks you for a Firebird-database-user and a password.
Please enter "SYSDBA" and the password you chose for the User in the last step. Finish by clicking <em>OK</em>.
</p>
</div>
<footer id="space_footer"></p><a href="../imprint.html">Imprint / Impressum</a></p>
<a rel="license" href="http://creativecommons.org/licenses/by-sa/3.0/"><img alt="Creative Commons License" style="border-width:0" src="http://i.creativecommons.org/l/by-sa/3.0/88x31.png" /></a><br />This work is licensed under a <a rel="license" href="http://creativecommons.org/licenses/by-sa/3.0/">Creative Commons Attribution-ShareAlike 3.0 Unported License</a>.
</footer>
</div>
</body>
</html>