Author Topic: SOLVED: Cannot login as user admin with password admin in the frontend  (Read 6045 times)

Offline starkstrom

  • User
  • *
  • Posts: 15
    • View Profile
I have installed knowledgeroot version 0.9.9.5 under Debian Linux 7.

I am able to access both webinterfaces:

http://127.0.1.1/knowledgeroot/index.php

http://127.0.1.1/knowledgeroot/admin/

I can only login as "admin" to the admin interface. But there is no menu entry to create users or even to change the password for admin.

The mysql user is root.

Therefore I have no login for http://127.0.1.1/knowledgeroot/index.php
Trying to login as "root" and "admin" does not work.

The only menu entries in the admin web interface are:
information
configure
extensions
  import
logout

With "configure" I can edit the configuration:

change configuration

base url for knowledgeroot
baseurl = http://127.0.1.1/knowledgeroot/

enable/disable counting of content items
content.showcounter = 1

show developer toolbar
dev.toolbar = 0

enable static download links
downloads.static = 0

set from email
email.from_email = knowledgeroot@mydomain.tld

set from name
email.from_name = Knowledgeroot

enable email notification
email.notification = 0

set recipients
email.recipients = 

set smtp host
email.smtp_host = 

enable to use smtp instead of mail
email.smtp_mode = 0

set password for authentification
email.smtp_password = gmr

set port of host
email.smtp_port = 25

set username for authentification
email.smtp_username = gmr

enable html mails
email.type = html

choose fckeditor or tinymce
htmleditor.editor = fckeditor

set height of fckeditor
htmleditor.fckeditor.height = 450

set default lang in default fckeditor
htmleditor.fckeditor.langdefault = en

enable autodetection of language in fckeditor
htmleditor.fckeditor.langdetect = false

choose skin in fckeditor
htmleditor.fckeditor.skin = default

choose toolbar in fckeditor
htmleditor.fckeditor.toolbar = Default

set widht of fckeditor
htmleditor.fckeditor.width = 600

set cols for textarea in tinymce
htmleditor.tinymce.cols = 75

set rows for textarea in tinymce
htmleditor.tinymce.rows = 20

enable rte editor
htmleditor.use = 1

set charset
knowledgeroot.charset = UTF-8

enable collapse content
knowledgeroot.collapsecontent = yes

set id of default page
knowledgeroot.defaultpage = 

set theme in knowledgeroot
knowledgeroot.default_theme = green

set default language
knowledgeroot.language = en

show language dropdown
knowledgeroot.language_dropdown = 0

set maxfilesize for uploads
knowledgeroot.maxfilesize = 5242880

set recusriv delete, 2 - only admins; 1 - all users with login, 0 - all users
knowledgeroot.recursivdelete = 2

show lastupdate of content
knowledgeroot.showlastupdated = yes

show knowledgeroot logo instead of texttitle
knowledgeroot.showlogo = 0

show title of contents
knowledgeroot.showtitle = yes

set title for knowledgeroot
knowledgeroot.title = Knowledgeroot

set upload folder
knowledgeroot.uploadfolder = uploads/

set upload server path
knowledgeroot.uploadserverpath = auto

setting login delay
login.delay = 30

setting max login
login.max = 50

use ajax menu
menu.ajax = yes

enable/disable context menus
menu.context = 1

enable/disable a default layout of the tree
menu.defaultlayout = 0

serialized array with default layout of tree - should not be edit
menu.defaultlayoutarray = 

enable/disable drag and drop in tree
menu.dragdrop = 1

enable/disable edit of tooltiptext of tree element
menu.edittooltiptext = 0

expand menu at default
menu.expandall = 1

enable self order of tree elements
menu.order.self = 0

enable/disable counting of tree items
menu.showcounter = 1

show sourceforge logo
menu.showsourceforgelogo = 0

set menu type
menu.type = static

set rights to edit the alias
pagealias.rights = 2

enable of using static links
pagealias.static = 0

enable pagealias
pagealias.use = 1

check browser of session
session.checkBrowser = 0

check ip of session
session.checkIP = 0

enable handling of sessin
session.handle = 0

lifetime of session in minutes
session.lifetime = 60

allow only cookie sessions
session.onlyCookies = 0

knowledgeroot version - do not edit! - it only shows the database version of knowledgeroot
version = 0.9.9.5

I am using the following browsers all with the same result:

Firefox 28.0
Opera 12.16 Build 1860

Can anyone help ?
« Last Edit: July 20, 2014, 07:15:09 PM by starkstrom »

Offline admin

  • Administrator
  • User
  • *****
  • Posts: 688
    • View Profile
    • http://www.lordlamer.de
Re: Cannot create new users in knowledgeroot
« Reply #1 on: July 19, 2014, 08:35:17 PM »
Hi,

i believe that you cannot create admin users in the admin interface.
But the default login for the frontend is
user: admin
password: admin

You could also take a look here:
http://trac.knowledgeroot.org/cgi-bin/trac.cgi/wiki/release0995

Hope this helps.
Frank

Offline starkstrom

  • User
  • *
  • Posts: 15
    • View Profile
Re: Cannot create new users in knowledgeroot
« Reply #2 on: July 19, 2014, 09:52:22 PM »
Sorry, I cannot login to the front end at http://127.0.1.1/knowledgeroot/index.php at all.

User admin and password admin does only work for the login to the admin interface, but not to the frontend.

Its getting frustrating.

Offline starkstrom

  • User
  • *
  • Posts: 15
    • View Profile
Re: Cannot create new users in knowledgeroot
« Reply #3 on: July 20, 2014, 07:44:34 AM »
I am now going to delete my installation of knowledgeroot and re-install it from scratch:

neupc:~# aptitude
(Lese Datenbank ... 254086 Dateien und Verzeichnisse sind derzeit installiert.)
Entfernen von knowledgeroot ...
Entfernen von fckeditor ...
Entfernen von php-htmlpurifier ...
Entfernen von php-gettext ...
Entfernen von libphp-phpmailer ...
Entfernen von php5 ...
Entfernen von libapache2-mod-php5 ...
Module php5 disabled.
To activate the new configuration, you need to run:
  service apache2 restart
Entfernen von libjs-scriptaculous ...
Entfernen von libjs-prototype ...
Entfernen von php-xml-htmlsax3 ...
Entfernen von php-pear ...
Entfernen von php5-mysql ...
Entfernen von php5-cli ...
Entfernen von libonig2 ...
Entfernen von libqdbm14 ...
Entfernen von php5-common ...
Entfernen von tinymce ...
Trigger für man-db werden verarbeitet ...
Drücken Sie zum Fortsetzen die Eingabetaste.

neupc:~# aptitude show knowledgeroot
Paket: knowledgeroot                           
Zustand: nicht installiert
Version: 0.9.9.5-6
Priorität: optional
Bereich: web
Verwalter: Frank Habermann <lordlamer@lordlamer.de>
Architektur: all
Unkomprimierte Größe: 1.696 k
Hängt ab von: apache2 | httpd, php5, php5-mysql | php5-pgsql, libphp-phpmailer, php-xml-htmlsax3, fckeditor, libjs-scriptaculous,
               libjs-prototype, tinymce, php-gettext, php-htmlpurifier
Schlägt vor: mysql-server | postgresql-8.2 | postgresql-8.1
Beschreibung: Webbasiertes Wissenbasissystem
 Dies ist ein Wissensbasissystem, das Sie Ihren Inhalt in einer Baumstruktur unterbringen lässt. Es ist ein kleines bisschen wie ein Wiki,
 aber es ist kein Wiki! Sie müssen keine Wiki-Syntax lernen. Sie können einen »Rich Text«-Editor (FCKEditor oder TinyMCE) verwenden, um den
 Inhalt zu schreiben.

So now knowledgeroot is not installed anymore.

The next thing is to drop the mysql database ELEKTRO which had been created for knowledgeroot:

neupc:~# mysql --user=root --password=root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 37
Server version: 5.5.37-0+wheezy1 (Debian)

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> drop database ELEKTRO;
Query OK, 3 rows affected (0.10 sec)

mysql> use ELEKTRO
ERROR 1049 (42000): Unknown database 'ELEKTRO'
mysql> quit
Bye

The next step will be to re-install knowledgeroot. See next post.
« Last Edit: July 20, 2014, 07:49:09 AM by starkstrom »

Offline starkstrom

  • User
  • *
  • Posts: 15
    • View Profile
Re: Cannot create new users in knowledgeroot
« Reply #4 on: July 20, 2014, 08:12:53 AM »
This step shows my re-install of knowledgeroot in detail:

neupc:~# aptitude
Vormals nicht ausgewähltes Paket php5-common wird gewählt.
(Lese Datenbank ... 251562 Dateien und Verzeichnisse sind derzeit installiert.)
Entpacken von php5-common (aus .../php5-common_5.4.4-14+deb7u11_i386.deb) ...
Vormals nicht ausgewähltes Paket libonig2 wird gewählt.
Entpacken von libonig2 (aus .../libonig2_5.9.1-1_i386.deb) ...
Vormals nicht ausgewähltes Paket libqdbm14 wird gewählt.
Entpacken von libqdbm14 (aus .../libqdbm14_1.8.78-2_i386.deb) ...
Vormals nicht ausgewähltes Paket php5-cli wird gewählt.
Entpacken von php5-cli (aus .../php5-cli_5.4.4-14+deb7u11_i386.deb) ...
Vormals nicht ausgewähltes Paket libapache2-mod-php5 wird gewählt.
Entpacken von libapache2-mod-php5 (aus .../libapache2-mod-php5_5.4.4-14+deb7u11_i386.deb) ...
Vormals nicht ausgewähltes Paket php5-mysql wird gewählt.
Entpacken von php5-mysql (aus .../php5-mysql_5.4.4-14+deb7u11_i386.deb) ...
Vormals nicht ausgewähltes Paket fckeditor wird gewählt.
Entpacken von fckeditor (aus .../fckeditor_1%3a2.6.6-3_all.deb) ...
Vormals nicht ausgewähltes Paket php5 wird gewählt.
Entpacken von php5 (aus .../php5_5.4.4-14+deb7u11_all.deb) ...
Vormals nicht ausgewähltes Paket libphp-phpmailer wird gewählt.
Entpacken von libphp-phpmailer (aus .../libphp-phpmailer_5.1-1_all.deb) ...
Vormals nicht ausgewähltes Paket php-pear wird gewählt.
Entpacken von php-pear (aus .../php-pear_5.4.4-14+deb7u11_all.deb) ...
Vormals nicht ausgewähltes Paket php-xml-htmlsax3 wird gewählt.
Entpacken von php-xml-htmlsax3 (aus .../php-xml-htmlsax3_3.0.0+cvs01112007-2_all.deb) ...
Vormals nicht ausgewähltes Paket libjs-prototype wird gewählt.
Entpacken von libjs-prototype (aus .../libjs-prototype_1.7.0-2_all.deb) ...
Vormals nicht ausgewähltes Paket libjs-scriptaculous wird gewählt.
Entpacken von libjs-scriptaculous (aus .../libjs-scriptaculous_1.9.0-2_all.deb) ...
Vormals nicht ausgewähltes Paket tinymce wird gewählt.
Entpacken von tinymce (aus .../tinymce_3.4.8+dfsg0-1_all.deb) ...
Vormals nicht ausgewähltes Paket php-gettext wird gewählt.
Entpacken von php-gettext (aus .../php-gettext_1.0.11-1_all.deb) ...
Vormals nicht ausgewähltes Paket php-htmlpurifier wird gewählt.
Entpacken von php-htmlpurifier (aus .../php-htmlpurifier_4.4.0+dfsg1-1_all.deb) ...
Vormals nicht ausgewähltes Paket knowledgeroot wird gewählt.
Entpacken von knowledgeroot (aus .../knowledgeroot_0.9.9.5-6_all.deb) ...
Trigger für man-db werden verarbeitet ...
php5-common (5.4.4-14+deb7u11) wird eingerichtet ...
libonig2 (5.9.1-1) wird eingerichtet ...
libqdbm14 (1.8.78-2) wird eingerichtet ...
php5-cli (5.4.4-14+deb7u11) wird eingerichtet ...
update-alternatives: /usr/bin/php5 wird verwendet, um /usr/bin/php (php) im Auto-Modus bereitzustellen
libapache2-mod-php5 (5.4.4-14+deb7u11) wird eingerichtet ...
[....] Reloading web server config: apache2apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1 for ServerName
. ok
php5-mysql (5.4.4-14+deb7u11) wird eingerichtet ...
fckeditor (1:2.6.6-3) wird eingerichtet ...
php5 (5.4.4-14+deb7u11) wird eingerichtet ...
libphp-phpmailer (5.1-1) wird eingerichtet ...
php-pear (5.4.4-14+deb7u11) wird eingerichtet ...
php-xml-htmlsax3 (3.0.0+cvs01112007-2) wird eingerichtet ...
libjs-prototype (1.7.0-2) wird eingerichtet ...
libjs-scriptaculous (1.9.0-2) wird eingerichtet ...
tinymce (3.4.8+dfsg0-1) wird eingerichtet ...
php-gettext (1.0.11-1) wird eingerichtet ...
php-htmlpurifier (4.4.0+dfsg1-1) wird eingerichtet ...
Trigger für libapache2-mod-php5 werden verarbeitet ...
[....] Reloading web server config: apache2apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1 for ServerName
. ok
knowledgeroot (0.9.9.5-6) wird eingerichtet ...
Drücken Sie zum Fortsetzen die Eingabetaste.

neupc:~# aptitude show knowledgeroot
Paket: knowledgeroot                           
Zustand: Installiert
Automatisch installiert: nein
Version: 0.9.9.5-6
Priorität: optional
Bereich: web
Verwalter: Frank Habermann <lordlamer@lordlamer.de>
Architektur: all
Unkomprimierte Größe: 1.696 k
Hängt ab von: apache2 | httpd, php5, php5-mysql | php5-pgsql, libphp-phpmailer, php-xml-htmlsax3, fckeditor, libjs-scriptaculous,
               libjs-prototype, tinymce, php-gettext, php-htmlpurifier
Schlägt vor: mysql-server | postgresql-8.2 | postgresql-8.1
Beschreibung: Webbasiertes Wissenbasissystem
 Dies ist ein Wissensbasissystem, das Sie Ihren Inhalt in einer Baumstruktur unterbringen lässt. Es ist ein kleines bisschen wie ein Wiki,
 aber es ist kein Wiki! Sie müssen keine Wiki-Syntax lernen. Sie können einen »Rich Text«-Editor (FCKEditor oder TinyMCE) verwenden, um den
 Inhalt zu schreiben.

"Zustand: installiert" means that the package is now installed.

My next step is to install knowledgeroot via web interface:

http://127.0.1.1/knowledgeroot/install.php

These are my inputs on this web interface:

Type of database:  MySQL
                                  ( I did NOT choose "MySQL (mysqli)"; I dont know the difference to just "MySQL")

For the rest please look at my screenshots below.
« Last Edit: July 20, 2014, 08:21:31 AM by starkstrom »

Offline starkstrom

  • User
  • *
  • Posts: 15
    • View Profile
Re: Cannot create new users in knowledgeroot
« Reply #5 on: July 20, 2014, 08:15:08 AM »
One of the screenshots is unreadable.

Here are the two missing screenshots.

Offline starkstrom

  • User
  • *
  • Posts: 15
    • View Profile
Re: Cannot create new users in knowledgeroot
« Reply #6 on: July 20, 2014, 08:20:35 AM »
And:

neupc:/etc/knowledgeroot# ls
admin_config.inc.php  admin_config.inc.php.dist  config.inc.php  config.inc.php.dist
neupc:/etc/knowledgeroot#
neupc:/etc/knowledgeroot#
neupc:/etc/knowledgeroot# cat admin_config.inc.php
<?php

   $ADMIN_CONFIG['loginhash'] = "b4b8daf4b8ea9d39568719e1e320076f";

?>
neupc:/etc/knowledgeroot#
neupc:/etc/knowledgeroot# cat config.inc.php
<?php

   $CONFIG['db']['type'] = "mysql";


   $CONFIG['db']['host'] = "127.0.0.1";

   $CONFIG['db']['user'] = "root";

   $CONFIG['db']['pass'] = "root";

   $CONFIG['db']['database'] = "ELEKTRO";

   $CONFIG['db']['schema'] = "";

   $CONFIG['db']['encoding'] = "";

?>


neupc:/usr/share/knowledgeroot# diff install.php install.php_sicher
neupc:/usr/share/knowledgeroot# diff update.php update.php_sicher
neupc:/usr/share/knowledgeroot# rm install.php update.php
neupc:/usr/share/knowledgeroot# pwd
/usr/share/knowledgeroot

Offline starkstrom

  • User
  • *
  • Posts: 15
    • View Profile
Re: Cannot create new users in knowledgeroot
« Reply #7 on: July 20, 2014, 08:26:40 AM »
The result is:

I can login as user root in: http://127.0.1.1/knowledgeroot/admin/

But I have no login for: http://127.0.1.1/knowledgeroot/

The default login as user admin with password admin does not work at all.

If I try then I get a little message:  You have entered the wrong user or password!

Did I make anything wrong at installation ?

Offline starkstrom

  • User
  • *
  • Posts: 15
    • View Profile
Re: Cannot create new users in knowledgeroot
« Reply #8 on: July 20, 2014, 08:29:07 AM »
In the mysql database we have now:

neupc:/usr/share/knowledgeroot# mysql --user=root --password=root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 56
Server version: 5.5.37-0+wheezy1 (Debian)

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use ELEKTRO;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+-------------------+
| Tables_in_ELEKTRO |
+-------------------+
| extensions        |
| settings          |
| users_login       |
+-------------------+
3 rows in set (0.00 sec)


My database is of version:

neupc:/usr/share/knowledgeroot# mysql --version
mysql  Ver 14.14 Distrib 5.5.37, for debian-linux-gnu (i686) using readline 6.2

More details in the mysql database ELEKTRO:

mysql> describe extensions;
+---------+--------------+------+-----+---------+----------------+
| Field   | Type         | Null | Key | Default | Extra          |
+---------+--------------+------+-----+---------+----------------+
| id      | int(11)      | NO   | PRI | NULL    | auto_increment |
| keyname | varchar(255) | NO   |     | NULL    |                |
| active  | int(11)      | NO   | MUL | NULL    |                |
| admin   | int(11)      | NO   |     | 0       |                |
| version | varchar(30)  | NO   |     |         |                |
+---------+--------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)

mysql> describe settings;
+-------------+--------------+------+-----+---------+----------------+
| Field       | Type         | Null | Key | Default | Extra          |
+-------------+--------------+------+-----+---------+----------------+
| id          | int(11)      | NO   | PRI | NULL    | auto_increment |
| name        | varchar(255) | NO   | UNI | NULL    |                |
| value       | text         | NO   |     | NULL    |                |
| description | varchar(255) | NO   |     |         |                |
| selection   | varchar(255) | NO   |     |         |                |
+-------------+--------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)

mysql> describe users_login;
+-------------+------------------+------+-----+---------+-------+
| Field       | Type             | Null | Key | Default | Extra |
+-------------+------------------+------+-----+---------+-------+
| usersid     | int(10) unsigned | NO   | PRI | 0       |       |
| login_trial | int(10) unsigned | NO   |     | 0       |       |
| lasttrydate | int(11) unsigned | NO   |     | 0       |       |
| session_id  | varchar(100)     | NO   |     |         |       |
+-------------+------------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

mysql> select * from extensions;
+----+-----------------+--------+-------+---------+
| id | keyname         | active | admin | version |
+----+-----------------+--------+-------+---------+
|  1 | admin_extension |      1 |     1 |         |
|  2 | admin_info      |      1 |     1 |         |
|  3 | admin_config    |      1 |     1 |         |
|  4 | fckeditor       |      1 |     0 |         |
|  5 | tinymce         |      0 |     0 |         |
+----+-----------------+--------+-------+---------+
5 rows in set (0.00 sec)

mysql> select * from users_login;
Empty set (0.00 sec)

mysql> select * from settings;
+----+----------------------------------+---------------------------------+--------------------------------------------------------------------------------------------+-----------+
| id | name                             | value                           | description                                                                                | selection |
+----+----------------------------------+---------------------------------+--------------------------------------------------------------------------------------------+-----------+
|  1 | login.delay                      | 30                              | setting login delay                                                                        |           |
|  2 | login.max                        | 50                              | setting max login                                                                          |           |
|  3 | knowledgeroot.charset            | UTF-8                           | set charset                                                                                |           |
|  4 | knowledgeroot.language           | en                              | set default language                                                                       |           |
|  5 | knowledgeroot.language_dropdown  | 0                               | show language dropdown                                                                     |           |
|  6 | htmleditor.use                   | 1                               | enable rte editor                                                                          |           |
|  7 | htmleditor.editor                | fckeditor                       | choose fckeditor or tinymce                                                                |           |
|  8 | htmleditor.tinymce.cols          | 75                              | set cols for textarea in tinymce                                                           |           |
|  9 | htmleditor.tinymce.rows          | 20                              | set rows for textarea in tinymce                                                           |           |
| 10 | htmleditor.fckeditor.width       | 600                             | set widht of fckeditor                                                                     |           |
| 11 | htmleditor.fckeditor.height      | 450                             | set height of fckeditor                                                                    |           |
| 12 | htmleditor.fckeditor.langdefault | en                              | set default lang in default fckeditor                                                      |           |
| 13 | htmleditor.fckeditor.langdetect  | false                           | enable autodetection of language in fckeditor                                              |           |
| 14 | htmleditor.fckeditor.toolbar     | Default                         | choose toolbar in fckeditor                                                                |           |
| 15 | htmleditor.fckeditor.skin        | default                         | choose skin in fckeditor                                                                   |           |
| 16 | knowledgeroot.title              | Knowledgeroot                   | set title for knowledgeroot                                                                |           |
| 17 | menu.expandall                   | 1                               | expand menu at default                                                                     |           |
| 18 | menu.type                        | static                          | set menu type                                                                              |           |
| 19 | menu.ajax                        | yes                             | use ajax menu                                                                              |           |
| 20 | knowledgeroot.default_theme      | green                           | set theme in knowledgeroot                                                                 |           |
| 21 | knowledgeroot.showtitle          | yes                             | show title of contents                                                                     |           |
| 22 | knowledgeroot.collapsecontent    | yes                             | enable collapse content                                                                    |           |
| 23 | knowledgeroot.showlastupdated    | yes                             | show lastupdate of content                                                                 |           |
| 24 | knowledgeroot.uploadfolder       | uploads/                        | set upload folder                                                                          |           |
| 25 | knowledgeroot.uploadserverpath   | auto                            | set upload server path                                                                     |           |
| 26 | knowledgeroot.defaultpage        |                                 | set id of default page                                                                     |           |
| 27 | knowledgeroot.recursivdelete     | 2                               | set recusriv delete, 2 - only admins; 1 - all users with login, 0 - all users              |           |
| 28 | email.notification               | 0                               | enable email notification                                                                  |           |
| 29 | email.recipients                 |                                 | set recipients                                                                             |           |
| 30 | email.type                       | html                            | enable html mails                                                                          |           |
| 31 | email.from_name                  | Knowledgeroot                   | set from name                                                                              |           |
| 32 | email.from_email                 | knowledgeroot@mydomain.tld      | set from email                                                                             |           |
| 33 | email.smtp_mode                  | 0                               | enable to use smtp instead of mail                                                         |           |
| 34 | email.smtp_host                  |                                 | set smtp host                                                                              |           |
| 35 | email.smtp_port                  | 25                              | set port of host                                                                           |           |
| 36 | email.smtp_username              |                                 | set username for authentification                                                          |           |
| 37 | email.smtp_password              |                                 | set password for authentification                                                          |           |
| 38 | dev.toolbar                      | 0                               | show developer toolbar                                                                     |           |
| 39 | pagealias.use                    | 1                               | enable pagealias                                                                           |           |
| 40 | pagealias.rights                 | 2                               | set rights to edit the alias                                                               |           |
| 41 | pagealias.static                 | 0                               | enable of using static links                                                               |           |
| 42 | knowledgeroot.maxfilesize        | 5242880                         | set maxfilesize for uploads                                                                |           |
| 43 | downloads.static                 | 0                               | enable static download links                                                               |           |
| 44 | menu.order.self                  | 0                               | enable self order of tree elements                                                         |           |
| 45 | menu.context                     | 1                               | enable/disable context menus                                                               |           |
| 46 | menu.dragdrop                    | 1                               | enable/disable drag and drop in tree                                                       |           |
| 47 | menu.edittooltiptext             | 0                               | enable/disable edit of tooltiptext of tree element                                         |           |
| 48 | session.handle                   | 0                               | enable handling of sessin                                                                  |           |
| 49 | session.lifetime                 | 60                              | lifetime of session in minutes                                                             |           |
| 50 | session.checkIP                  | 0                               | check ip of session                                                                        |           |
| 51 | session.checkBrowser             | 0                               | check browser of session                                                                   |           |
| 52 | session.onlyCookies              | 0                               | allow only cookie sessions                                                                 |           |
| 53 | menu.showcounter                 | 1                               | enable/disable counting of tree items                                                      |           |
| 54 | content.showcounter              | 1                               | enable/disable counting of content items                                                   |           |
| 55 | menu.defaultlayout               | 0                               | enable/disable a default layout of the tree                                                |           |
| 56 | menu.defaultlayoutarray          |                                 | serialized array with default layout of tree - should not be edit                          |           |
| 57 | menu.showsourceforgelogo         | 0                               | show sourceforge logo                                                                      |           |
| 58 | knowledgeroot.showlogo           | 0                               | show knowledgeroot logo instead of texttitle                                               |           |
| 59 | version                          | 0.9.9.5                         | knowledgeroot version - do not edit! - it only shows the database version of knowledgeroot |           |
| 60 | baseurl                          | http://127.0.1.1/knowledgeroot/ | base url for knowledgeroot                                                                 |           |
+----+----------------------------------+---------------------------------+--------------------------------------------------------------------------------------------+-----------+
60 rows in set (0.00 sec)
« Last Edit: July 20, 2014, 08:38:55 AM by starkstrom »

Offline starkstrom

  • User
  • *
  • Posts: 15
    • View Profile
Re: Cannot create new users in knowledgeroot
« Reply #9 on: July 20, 2014, 08:44:31 AM »
Interesting is:

http://trac.knowledgeroot.org/cgi-bin/trac.cgi/wiki/faq

It says that there must be an USERS table within the database which is missing in my case.

If I would guess then I think that I have to manually create that table in MySQL and populate it with one row for the user admin.

But I need details for this to do.

Offline starkstrom

  • User
  • *
  • Posts: 15
    • View Profile
Re: Cannot create new users in knowledgeroot
« Reply #10 on: July 20, 2014, 09:20:19 AM »
Last but not least, I have done:

http://127.0.1.1/knowledgeroot/update.php

with the result:

Congratulation you have updated Knowledgeroot successfully!

But I am still not able to login as admin in http://127.0.1.1/knowledgeroot/index.php

Offline starkstrom

  • User
  • *
  • Posts: 15
    • View Profile
Re: Cannot create new users in knowledgeroot
« Reply #11 on: July 20, 2014, 09:34:11 AM »
In the internet I found the information that the mysql database should indeed contain more tables:

MySQL> use knowledgeroot

MySQL>show tables;
+-------------------------+
| Tables_in_knowledgeroot |
+-------------------------+
| access                  |
| content                 |
| content_open            |
| extensions              |
| files                   |
| groups                  |
| settings                |
| tree                    |
| user_group              |
| users                   |
| users_login             |
+-------------------------+


Offline starkstrom

  • User
  • *
  • Posts: 15
    • View Profile
Re: Cannot create new users in knowledgeroot
« Reply #12 on: July 20, 2014, 11:35:01 AM »
THE ISSUE IS SOLVED !!!

I had just to execute this sql script in the ELEKTRO mysql database:

CREATE TABLE `content` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) default NULL,
  `belongs_to` int(11) NOT NULL default '0',
  `content` mediumtext NOT NULL,
  `type` varchar(255) NOT NULL default 'text',
  `sorting` int(11) NOT NULL default '0',
  `owner` int(11) NOT NULL default '0',
  `lastupdatedby` int(11) NOT NULL default '0',
  `lastupdated` timestamp NOT NULL,
  `group` int(11) NOT NULL default '0',
  `userrights` int(11) NOT NULL default '0',
  `grouprights` int(11) NOT NULL default '0',
  `otherrights` int(11) NOT NULL default '0',
  `deleted` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `belongs_to` (`belongs_to`),
  KEY `owner` (`owner`),
  KEY `group` (`group`),
  KEY `userrights` (`userrights`),
  KEY `grouprights` (`grouprights`),
  KEY `otherrights` (`otherrights`),
  KEY `deleted` (`deleted`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `content_open` (
  `id` int(11) NOT NULL auto_increment,
  `contentid` int(11) NOT NULL default '0',
  `userid`varchar(32) NOT NULL default '',
  `opened` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `contentid` (`contentid`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `files` (
  `id` int(11) NOT NULL auto_increment,
  `belongs_to` int(11) default NULL,
  `file` longblob,
  `filename` varchar(255) default NULL,
  `filesize` int(11) default NULL,
  `filetype` varchar(255) default 'application/octet-stream',
  `owner` int(11) NOT NULL default '0',
  `date` timestamp NOT NULL,
  `deleted` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `belongs_to` (`belongs_to`),
  KEY `deleted` (`deleted`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `groups` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `enabled` int(1) NOT NULL default '0',
  `deleted` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `deleted` (`deleted`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `tree` (
  `id` int(11) NOT NULL auto_increment,
  `belongs_to` int(11) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `alias` varchar(255) NOT NULL default '',
  `contentcollapsed` int(1) NOT NULL default '0',
  `owner` int(11) NOT NULL default '0',
  `group` int(11) NOT NULL default '0',
  `userrights` int(11) NOT NULL default '0',
  `grouprights` int(11) NOT NULL default '0',
  `otherrights` int(11) NOT NULL default '0',
  `subinheritrights` int(1) NOT NULL default '0',
  `subinheritrightseditable` int(1) NOT NULL default '0',
  `subinheritrightsdisable` int(1) NOT NULL default '0',
  `subinheritowner` int(11) NOT NULL default '0',
  `subinheritgroup` int(11) NOT NULL default '0',
  `subinherituserrights` int(11) NOT NULL default '0',
  `subinheritgrouprights` int(11) NOT NULL default '0',
  `subinheritotherrights` int(11) NOT NULL default '0',
  `deleted` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `belongs_to` (`belongs_to`),
  KEY `owner` (`owner`),
  KEY `group` (`group`),
  KEY `userrights` (`userrights`),
  KEY `grouprights` (`grouprights`),
  KEY `otherrights` (`otherrights`),
  KEY `deleted` (`deleted`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `user_group` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(11) NOT NULL default '0',
  `groupid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `userid` (`userid`),
  KEY `groupid` (`groupid`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `password` varchar(32) NOT NULL default '',
  `theme` varchar(255) NOT NULL default '',
  `language` varchar(255) NOT NULL default '',
  `enabled` int(1) NOT NULL default '0',
  `defaultgroup` int(11) NOT NULL default '0',
  `defaultrights` int(3) NOT NULL default '0',
  `admin` int(1) NOT NULL default '0',
  `rightedit` int(1) NOT NULL default '0',
  `treecache` text NOT NULL,
  `deleted` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `password` (`password`),
  KEY `deleted` (`deleted`)
) ENGINE=MyISAM AUTO_INCREMENT=3 ;

INSERT INTO `users` ( `id` , `name` , `password` , `enabled` , `defaultgroup` , `defaultrights` , `admin` , `rightedit` , `treecache` )
VALUES (
'1', 'admin', '21232f297a57a5a743894a0e4a801fc3', '1', '1', '210', '1', '1', ''
);

INSERT INTO `groups` ( `id` , `name` , `enabled` )
VALUES (
'1', 'admin', '1'
);

INSERT INTO `groups` ( `id` , `name` , `enabled` )
VALUES (
'2', 'users', '1'
);

# Enable extensions
INSERT INTO `extensions` (`keyname`, `active`, `admin`) VALUES ('admin_extension', 1, 1);
INSERT INTO `extensions` (`keyname`, `active`, `admin`) VALUES ('admin_info', 1, 1);
# INSERT INTO `extensions` (`keyname`, `active`, `admin`) VALUES ('admin_install', 1, 1);
# INSERT INTO `extensions` (`keyname`, `active`, `admin`) VALUES ('admin_update', 1, 1);
INSERT INTO `extensions` (`keyname`, `active`, `admin`) VALUES ('admin_config', 1, 1);

Now I am able to login as user admin with password admin in the frontend.

Offline starkstrom

  • User
  • *
  • Posts: 15
    • View Profile
Re: Cannot create new users in knowledgeroot
« Reply #13 on: July 20, 2014, 07:14:31 PM »
To get knowledgeroot completely running I had to drop all the tables in the mysql database ELEKTRO again and
had to run this script to create the tables properly:

CREATE TABLE `access` (
        `id` int(11) NOT NULL auto_increment,
        `table_name` varchar(255) NOT NULL DEFAULT '',
        `belongs_to` int(11) NOT NULL DEFAULT 0,
        `owner_group` varchar(5) NOT NULL DEFAULT '',
        `owner_group_id` int(11) NOT NULL DEFAULT 0,
        `rights` int(11) NOT NULL DEFAULT 0,
   PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `content` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) default NULL,
  `belongs_to` int(11) NOT NULL default '0',
  `content` mediumtext NOT NULL,
  `type` varchar(255) NOT NULL default 'text',
  `sorting` int(11) NOT NULL default '0',
  `owner` int(11) NOT NULL default '0',
  `createdate` datetime NOT NULL default '0000-00-00 00:00:00',
  `lastupdatedby` int(11) NOT NULL default '0',
  `lastupdated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `group` int(11) NOT NULL default '0',
  `userrights` int(11) NOT NULL default '0',
  `grouprights` int(11) NOT NULL default '0',
  `otherrights` int(11) NOT NULL default '0',
  `deleted` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `belongs_to` (`belongs_to`),
  KEY `owner` (`owner`),
  KEY `group` (`group`),
  KEY `userrights` (`userrights`),
  KEY `grouprights` (`grouprights`),
  KEY `otherrights` (`otherrights`),
  KEY `deleted` (`deleted`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `content_open` (
  `id` int(11) NOT NULL auto_increment,
  `contentid` int(11) NOT NULL default '0',
  `userid`varchar(32) NOT NULL default '',
  `opened` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `contentid` (`contentid`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `files` (
  `id` int(11) NOT NULL auto_increment,
  `belongs_to` int(11) default NULL,
  `file` longblob,
  `filename` varchar(255) default NULL,
  `filesize` int(11) default NULL,
  `filetype` varchar(255) default 'application/octet-stream',
  `owner` int(11) NOT NULL default '0',
  `date` timestamp NOT NULL,
  `counter` int(11) NOT NULL default '0',
  `deleted` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `belongs_to` (`belongs_to`),
  KEY `deleted` (`deleted`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `groups` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `enabled` int(1) NOT NULL default '0',
  `deleted` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `deleted` (`deleted`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `tree` (
  `id` int(11) NOT NULL auto_increment,
  `belongs_to` int(11) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `tooltip` varchar(255) NOT NULL default '',
  `icon` varchar(255) NOT NULL default '',
  `alias` varchar(255) NOT NULL default '',
  `contentcollapsed` int(1) NOT NULL default '0',
  `defaultcontentposition` int(1) NOT NULL default '0',
  `owner` int(11) NOT NULL default '0',
  `group` int(11) NOT NULL default '0',
  `userrights` int(11) NOT NULL default '0',
  `grouprights` int(11) NOT NULL default '0',
  `otherrights` int(11) NOT NULL default '0',
  `subinheritrights` int(1) NOT NULL default '0',
  `subinheritrightseditable` int(1) NOT NULL default '0',
  `subinheritrightsdisable` int(1) NOT NULL default '0',
  `subinheritowner` int(11) NOT NULL default '0',
  `subinheritgroup` int(11) NOT NULL default '0',
  `subinherituserrights` int(11) NOT NULL default '0',
  `subinheritgrouprights` int(11) NOT NULL default '0',
  `subinheritotherrights` int(11) NOT NULL default '0',
  `symlink` int(11) NOT NULL default '0',
  `sorting` int(11) NOT NULL default '0',
  `deleted` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `belongs_to` (`belongs_to`),
  KEY `owner` (`owner`),
  KEY `group` (`group`),
  KEY `userrights` (`userrights`),
  KEY `grouprights` (`grouprights`),
  KEY `otherrights` (`otherrights`),
  KEY `deleted` (`deleted`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `user_group` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(11) NOT NULL default '0',
  `groupid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `userid` (`userid`),
  KEY `groupid` (`groupid`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `password` varchar(32) NOT NULL default '',
  `theme` varchar(255) NOT NULL default '',
  `language` varchar(255) NOT NULL default '',
  `enabled` int(1) NOT NULL default '0',
  `defaultgroup` int(11) NOT NULL default '0',
  `defaultrights` int(3) NOT NULL default '0',
  `admin` int(1) NOT NULL default '0',
  `rightedit` int(1) NOT NULL default '0',
  `treecache` text NOT NULL,
  `deleted` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `password` (`password`),
  KEY `deleted` (`deleted`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `extensions` (
`id` INT NOT NULL AUTO_INCREMENT ,
`keyname` VARCHAR( 255 ) NOT NULL ,
`active` INT NOT NULL ,
`admin` INT NOT NULL DEFAULT '0',
`version` VARCHAR(30) NOT NULL DEFAULT '',
PRIMARY KEY ( `id` ),
KEY `active` (`active`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `settings` (
`id` INT NOT NULL AUTO_INCREMENT ,
`name` VARCHAR( 255 ) NOT NULL ,
`value` text NOT NULL ,
`description` VARCHAR( 255) NOT NULL DEFAULT '',
`selection` VARCHAR(255) NOT NULL DEFAULT '',
PRIMARY KEY ( `id` ) ,
UNIQUE (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `users_login` (
  `usersid` int(10) unsigned NOT NULL default '0',
  `login_trial` int(10) unsigned NOT NULL default '0',
  `lasttrydate` int(11) unsigned NOT NULL default '0',
  `session_id` varchar(100) NOT NULL default '',
  UNIQUE KEY `usersid` (`usersid`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

INSERT INTO `users` ( `id` , `name` , `password` , `enabled` , `defaultgroup` , `defaultrights` , `admin` , `rightedit` , `treecache` )
VALUES (
'1', 'admin', '21232f297a57a5a743894a0e4a801fc3', '1', '1', '210', '1', '1', ''
);

INSERT INTO `groups` ( `id` , `name` , `enabled` )
VALUES (
'1', 'admin', '1'
);

INSERT INTO `groups` ( `id` , `name` , `enabled` )
VALUES (
'2', 'users', '1'
);

# Enable extensions
INSERT INTO `extensions` (`keyname`, `active`, `admin`) VALUES ('admin_extension', 1, 1);
INSERT INTO `extensions` (`keyname`, `active`, `admin`) VALUES ('admin_info', 1, 1);
# INSERT INTO `extensions` (`keyname`, `active`, `admin`) VALUES ('admin_install', 1, 1);
# INSERT INTO `extensions` (`keyname`, `active`, `admin`) VALUES ('admin_update', 1, 1);
INSERT INTO `extensions` (`keyname`, `active`, `admin`) VALUES ('admin_config', 1, 1);
INSERT INTO `extensions` (`keyname`, `active`, `admin`) VALUES ('dojorte', 1, 0);
INSERT INTO `extensions` (`keyname`, `active`, `admin`) VALUES ('admin_recover', 1, 1);

# insert default settings
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('login.delay', '30', 'setting login delay', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('login.max', '50', 'setting max login', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('knowledgeroot.charset', 'UTF-8', 'set charset', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('knowledgeroot.language', 'en', 'set default language', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('knowledgeroot.language_dropdown', '0', 'show language dropdown', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('htmleditor.use', '1', 'enable rte editor', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('htmleditor.editor', 'fckeditor', 'choose fckeditor or tinymce', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('htmleditor.tinymce.cols', '75' , 'set cols for textarea in tinymce', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('htmleditor.tinymce.rows', '20', 'set rows for textarea in tinymce', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('htmleditor.fckeditor.width', '600', 'set widht of fckeditor', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('htmleditor.fckeditor.height', '450', 'set height of fckeditor', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('htmleditor.fckeditor.langdefault', 'en', 'set default lang in default fckeditor', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('htmleditor.fckeditor.langdetect', 'false', 'enable autodetection of language in fckeditor', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('htmleditor.fckeditor.toolbar', 'Default', 'choose toolbar in fckeditor', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('htmleditor.fckeditor.skin', 'default', 'choose skin in fckeditor', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('knowledgeroot.title', 'Knowledgeroot', 'set title for knowledgeroot', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('menu.expandall', '1', 'expand menu at default', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('menu.type', 'static', 'set menu type', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('menu.ajax', 'yes', 'use ajax menu', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('knowledgeroot.default_theme', 'green', 'set theme in knowledgeroot', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('knowledgeroot.showtitle', 'yes', 'show title of contents', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('knowledgeroot.collapsecontent', 'yes', 'enable collapse content', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('knowledgeroot.showlastupdated', 'yes', 'show lastupdate of content', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('knowledgeroot.uploadfolder', 'uploads/', 'set upload folder', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('knowledgeroot.uploadserverpath', 'auto', 'set upload server path', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('knowledgeroot.defaultpage', '', 'set id of default page', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('knowledgeroot.recursivdelete', '2', 'set recusriv delete, 2 - only admins; 1 - all users with login, 0 - all users', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('email.notification', '0', 'enable email notification', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('email.recipients', '', 'set recipients', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('email.type', 'html', 'enable html mails', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('email.from_name', 'Knowledgeroot', 'set from name', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('email.from_email', 'knowledgeroot@mydomain.tld', 'set from email', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('email.smtp_mode', '0', 'enable to use smtp instead of mail', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('email.smtp_host', '', 'set smtp host', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('email.smtp_port', '25', 'set port of host', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('email.smtp_username', '', 'set username for authentification', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('email.smtp_password', '', 'set password for authentification', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('dev.toolbar', '0', 'show developer toolbar', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('pagealias.use', '1', 'enable pagealias', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('pagealias.rights', '2', 'set rights to edit the alias', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('pagealias.static', '0', 'enable of using static links', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('knowledgeroot.maxfilesize', '5242880', 'set maxfilesize for uploads', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('downloads.static', '0', 'enable static download links', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('menu.order.self', '0', 'enable self order of tree elements', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('menu.context', '1', 'enable/disable context menus', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('menu.symlink', '0', 'enable/disable symlink menus', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('menu.dragdrop', '1', 'enable/disable drag and drop in tree', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('menu.edittooltiptext', '0', 'enable/disable edit of tooltiptext of tree element', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('session.handle', '0', 'enable handling of sessin', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('session.lifetime', '60', 'lifetime of session in minutes', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('session.checkIP', '0', 'check ip of session', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('session.checkBrowser', '0', 'check browser of session', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('session.onlyCookies', '0', 'allow only cookie sessions', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('menu.showcounter', '1', 'enable/disable counting of tree items', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('content.showcounter', '1', 'enable/disable counting of content items', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('menu.defaultlayout', '0', 'enable/disable a default layout of the tree', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('menu.defaultlayoutarray', '', 'serialized array with default layout of tree - should not be edit', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('menu.showsourceforgelogo', '0', 'show sourceforge logo', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('knowledgeroot.showlogo', '0', 'show knowledgeroot logo instead of texttitle', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('version', '0.9.9', 'knowledgeroot version - do not edit! - it only shows the database version of knowledgeroot', '');
INSERT INTO `settings` (`name`, `value`, `description`, `selection`) VALUES ('baseurl', '', 'base url for knowledgeroot', '');

The original installation routine obviously did only create the tables partially.