I got some info before it worked. Thanks a lot for the help. I'll work on restoring the database and probably securing the connections.
address@hidden:~> /sbin/route -n
Kernel IP routing table
Destination Gateway Genmask Flags Metric Ref Use Iface
0.0.0.0 192.168.1.1 0.0.0.0 UG 0 0 0 eth0
192.168.1.0 0.0.0.0 255.255.255.0 U 0 0 0 eth0
address@hidden:~> nmap localhost
Starting Nmap 6.47 ( http://nmap.org ) at 2017-08-04 10:49 GMT
Nmap scan report for localhost (127.0.0.1)
Host is up (0.00027s latency).
Not shown: 995 closed ports
PORT STATE SERVICE
22/tcp open ssh
25/tcp open smtp
631/tcp open ipp
5432/tcp open postgresql
8000/tcp open http-alt
Nmap done: 1 IP address (1 host up) scanned in 0.05 seconds
address@hidden:~> netstat -tln
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:631 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:5432 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:8000 0.0.0.0:* LISTEN
tcp 0 0 :::1716 :::* LISTEN
tcp 0 0 :::22 :::* LISTEN
tcp 0 0 ::1:631 :::* LISTEN
tcp 0 0 ::1:5432 :::* LISTEN
tcp 0 0 ::1:25 :::* LISTEN
address@hidden:~> netstat -tupan | grep 8000
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
tcp 0 0 127.0.0.1:8000 0.0.0.0:* LISTEN -
tcp 0 0 127.0.0.1:8000 127.0.0.1:36746 TIME_WAIT -
linux-k0ot:/home/gnuhealth # lsof -i:8000
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
trytond 960 tryton 5u IPv4 21826 0t0 TCP localhost:irdmi (LISTEN)
linux-k0ot:/home/gnuhealth # ifconfig
eth0 Link encap:Ethernet HWaddr 00:23:AE:B2:66:4A
inet addr:192.168.1.64 Bcast:192.168.1.255 Mask:255.255.255.0
inet6 addr: fe80::223:aeff:feb2:664a/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:62896 errors:0 dropped:2373 overruns:0 frame:0
TX packets:29040 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:28329756 (27.0 Mb) TX bytes:3170249 (3.0 Mb)
Interrupt:21 Memory:f7ae0000-f7b00000
lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
inet6 addr: ::1/128 Scope:Host
UP LOOPBACK RUNNING MTU:65536 Metric:1
RX packets:7330 errors:0 dropped:0 overruns:0 frame:0
TX packets:7330 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1
RX bytes:1120550 (1.0 Mb) TX bytes:1120550 (1.0 Mb)
linux-k0ot:/home/gnuhealth # netstat -tupan | grep 8000
tcp 0 0 127.0.0.1:8000 0.0.0.0:* LISTEN 960/python3
linux-k0ot:/home/gnuhealth # netstat -tupan
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 1817/sshd
tcp 0 0 127.0.0.1:631 0.0.0.0:* LISTEN 1779/cupsd
tcp 0 0 127.0.0.1:5432 0.0.0.0:* LISTEN 1825/postgres
tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN 1902/master
tcp 0 0 127.0.0.1:8000 0.0.0.0:* LISTEN 960/python3
tcp 0 0 192.168.1.64:51604 54.210.145.133:443 ESTABLISHED 2062/firefox
tcp 0 0 192.168.1.64:48506 66.96.147.20:443 ESTABLISHED 2062/firefox
tcp 0 0 :::1716 :::* LISTEN 1685/kdeconnectd
tcp 0 0 :::22 :::* LISTEN 1817/sshd
tcp 0 0 ::1:631 :::* LISTEN 1779/cupsd
tcp 0 0 ::1:5432 :::* LISTEN 1825/postgres
tcp 0 0 ::1:25 :::* LISTEN 1902/master
udp 0 0 0.0.0.0:5353 0.0.0.0:* 971/avahi-daemon: r
udp 0 0 0.0.0.0:51024 0.0.0.0:* 971/avahi-daemon: r
udp 0 0 0.0.0.0:68 0.0.0.0:* 30838/dhclient
udp 0 0 0.0.0.0:8854 0.0.0.0:* 30838/dhclient
udp 0 0 :::50353 :::* 971/avahi-daemon: r
udp 0 0 ::1:60600 ::1:60600 ESTABLISHED 1825/postgres
udp 0 0 :::5353 :::* 971/avahi-daemon: r
udp 0 0 :::1716 :::* 1685/kdeconnectd
udp 0 0 :::16802 :::* 30838/dhclient
linux-k0ot:/home/gnuhealth # lsof -i TCP| fgrep LISTEN
trytond 960 tryton 5u IPv4 21826 0t0 TCP localhost:irdmi (LISTEN)
kdeconnec 1685 gnuhealth 13u IPv6 22176 0t0 TCP *:xmsg (LISTEN)
cupsd 1779 root 8u IPv6 23819 0t0 TCP localhost:ipp (LISTEN)
cupsd 1779 root 9u IPv4 23820 0t0 TCP localhost:ipp (LISTEN)
sshd 1817 root 3u IPv4 23495 0t0 TCP *:ssh (LISTEN)
sshd 1817 root 4u IPv6 23497 0t0 TCP *:ssh (LISTEN)
postgres 1825 postgres 3u IPv6 23841 0t0 TCP localhost:postgresql (LISTEN)
postgres 1825 postgres 4u IPv4 23842 0t0 TCP localhost:postgresql (LISTEN)
master 1902 root 13u IPv4 24737 0t0 TCP localhost:smtp (LISTEN)
master 1902 root 14u IPv6 24738 0t0 TCP localhost:smtp (LISTEN)
linux-k0ot:/home/gnuhealth # nmap -sT -O 192.168.1.64
Starting Nmap 6.47 ( http://nmap.org ) at 2017-08-04 11:40 GMT
Nmap scan report for SMCT (192.168.1.64)
Host is up (0.00024s latency).
Not shown: 999 closed ports
PORT STATE SERVICE
22/tcp open ssh
Device type: general purpose
Running: Linux 3.X
OS CPE: cpe:/o:linux:linux_kernel:3
OS details: Linux 3.7 - 3.15
Network Distance: 0 hops
OS detection performed. Please report any incorrect results at http://nmap.org/submit/ .
Nmap done: 1 IP address (1 host up) scanned in 2.50 seconds
Now It is
linux-k0ot:/home/gnuhealth # nmap -sT -O 192.168.1.64
Starting Nmap 6.47 ( http://nmap.org ) at 2017-08-04 12:14 GMT
Nmap scan report for SMCT (192.168.1.64)
Host is up (0.00037s latency).
Not shown: 997 closed ports
PORT STATE SERVICE
22/tcp open ssh
5432/tcp open postgresql
8000/tcp open http-alt
Device type: general purpose
Running: Linux 3.X
OS CPE: cpe:/o:linux:linux_kernel:3
OS details: Linux 3.7 - 3.15
Network Distance: 0 hops
OS detection performed. Please report any incorrect results at http://nmap.org/submit/ .
Nmap done: 1 IP address (1 host up) scanned in 2.60 seconds
On 2017-08-04 01:41, Axel Braun wrote:
Am Donnerstag, 3. August 2017, 12:51:18 CEST schrieb address@hidden:
Absolutely, I will send the upcoming issues for address@hidden. Thanks.
Welcome!
On 2017-08-03 01:27, Axel Braun wrote:
For the connection issue:
- make sure you have port 8000 open in client and server
- once used without SSL, it will throw up an error when connecting with
SSL - what are you using?
I use windows operating system LAN clients. Where to configure SSL? What
is the default state for openSUSE? Should the ports be open from each
operating system?
- SSL is configured on the server side. It was described in the old Tryton-Wiki
(see:
https://github.com/mbehrle/tryton/blob/wiki/InstallationonopenSUSE.md )
- By default *no* SSL is set up
- Generally the port needs to be open on the server, not on the client
(outgoing connection). For testing you may open on the client as well
Is using the workforce server- clients 3.8 tryton on the same router as
this opensuse Trial tryton 4.2 server may be a cause to this connection
issue?
Yes: Server and client need to have the same major version - 4.2 in that case.
When trying to put Static IP, internet connection goes off.
Please describe this in more detail (is not related to GNU Health)
I tried to set it from the terminal or YaST Network but always had no
internet connection in result. I thought it may have some impact on the
server-client connection.
Difficult to say w/o further information. I guess the routing is not set
properly. Try to ping the server from the client.
I can not use the command cdexe for some reason.
the alias is only set up for root - and you dont really need it, as all
required binaries (like gnuhealth-control) are intalled in /usr/bin
That's good to know.
Current systemctl status trytond. A repeated issue of failed for
limit start when trying to change .conf or systemctl start gnuhealth in
attempts which result to reinstall the whole OS
Can you explain more in detail? I doubt that a failed systemd start forces
the reinstallation of the whole operating system! If yo, it should be
reported in bugzilla.opensuse.org
Sorry, I meant that my best solution have been to reinstall the OS.
because when I run into trouble even when I uninstall and reinstall
trytond and gnuhealth, things are not all cleared.
Unlike in other systems for the mass market, package management under Linux
usually works very well, so there is no need to reinstall everything.
Good luck,
Axel