-
Notifications
You must be signed in to change notification settings - Fork 0
/
install.txt
109 lines (76 loc) · 4.55 KB
/
install.txt
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
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
Requirements: installed inno-thinyldap, myPBX should be active , Call-List via innovaphone reporting-app
You need access via ssh (in windows 10 (with activated WSL (windows Linux Support) : open commandshell and enter
ssh root@<Ip of LAP>
will ask for password
or with Putty dial in a ssh-Session at the <Ip of LAP>, enter username (root, if not changed) and password (iplinux, if not changed)
and a possibility to copy,edit files on the webserver (i use winscp for the most part)
add after last line to /etc/lighttpd/lighttpd.conf (winscp)
$SERVER["socket"] == ":8080" { server.document-root = "/var/www/tools" }
if you switch from force https to not force https this changes will be lost as the lighttpd.conf will be rebuild
You can enter the 3 lines afterwards again.
Or you can hack the /var/www/innovaphone/include-main.php
include the line $config .= '$SERVER["socket"] == ":8080" {server.document-root = "/var/www/tools"}';
after line 2206 so the $config contains the enhancement even when switching
make directory /var/www/tools (ssh)
--- ssh ---
mkdir /var/www/tools
service lighttpd restart
--- ssh ---
after restarting the webserver this folder can be accessed via http://<Ip of LAP>:8080
the port 8080 is an example and used here, you can use another port but have to change this in the related occurrences.
--
upload content of webserver to /var/www/tools
- **adminer.php** - tools to handle mysql-databases (replacement for phpmyadmin) just in case needed when fooling around with mysql-user settings
- **askitall.php** - script to get the phonebook as a sql insert-script
- **calllist.php** - shows call that have no names, can put the phonenumbers in the phonebook and asks more data copncerning the phonenumber
- **dbconnect.php** - mysqlconnection, put user password, tablename here
- **dbdisconnect.php** - guess what
- **defs.php** - holds preferences concerning the webserver
- **editor.php** - tool to edit mysql-tables , enhanced by a little twist get access to the phonebook-overview page
- **inputdataset.php** - script to input one dataset
- **reindex.php** - reindexing tools to reindex the phonebook-table after big changes to keep the index (addressID) small. a remnant of the record-table is still in there.
- **updatedataset.php** - script to update one dataset
- **index.html** - OverviewPage to get access to the PhonebookEditor or Call-List
so not to publish the technical userdata used in the inno-phonebook you should use a user intended for the editor-access
Create a user name addressmaster , password pw4am
use ssh
--
mysql -u root
CREATE USER 'addressmaster'@'localhost' IDENTIFIED BY 'pw4am';
GRANT ALL ON phonebook_innovaphone.address TO 'addressmaster'@'localhost';
FLUSH PRIVILEGES;
exit
--
or if you dare you can grant acces without a password. will make access to the phonebook more userfriendly
use ssh
--
mysql -u root
CREATE USER 'addresseditor'@'localhost';
GRANT ALL ON phonebook_innovaphone.address TO 'addresseditor'@'localhost';
FLUSH PRIVILEGES;
exit
--
to get access to the mysql-table you can call the editor.php with some parameters
--
if mysql is fussy (stops reacting) you can cron job a 'service mysql restart' als daily.cronjob
nano /etc/cron.daily/mysql
----this into the file---
#!/bin/sh
service mysql restart
-------------------------
Save it and 'chmod 0755 /etc/cron.daily/mysql' ensures executablility
--
http://<IP Of LAP>:8080/editor.php?username=addressmaster&select=address
will ask for a password
http://<IP Of LAP>:8080/editor.php?username=addresseditor&select=address
won't ask for a password
the index.html uses some samples to get access to the mysql-table via editor.php
the app will call the editor.php with keyboard shortcut F3 or Button, Phonebook-Overview-Page Ctrl-F3, and
a helppage F1
--
The Calllist.php can show Callnumbers of calls that have no name at the time of showing the list. It needs access to the postgres database and table innovaphone-reporting. The credentials to get access are stored in the calllist.php itself. You need to change it there if you have changed user and/or Password.
--
the App loads some access-data from the preference-file gdfm.ini located in the same folder as the app itself (make a folder where you put both in)
If the App is called by myPBX it will pull all Data (Program gdfmhelper.exe) from the actual phonebook to a local sqlite-database to get quicker access as the app shows proposals for company and firstname if arrow-down is pressed in the respective fields.
myPBX should call the APP with Parameter n:$n, N:$N, I:$I, u:$u, d:"$d", C:$c
and while a call is picked.