Errors at first launch

Help / Discuss
#1

Hello. Im first time setuping wiki and dont understand wheere im wrong. Doing all stuff from https://www.xwiki.org/xwiki/bin/view/Documentation/AdminGuide/Installation/
Dedicated server Centos 8 + PostgreSql 10, + jar 42.2.9 + Tomcat 9 + Java 1.8,
Got error on first launch

HTTP Status 500 – Internal Server Error

Type Exception Report

Message com.xpn.xwiki.XWikiException: Error number 11007 in 0: Failed to extract Entity Resource Reference from URL [http://192.168.255.23:8080/xwiki/bin/view/Main/]

Full log https://pastebin.com/CMDfSCMU

  1. Where i should add new index ?
#2

org.postgresql.util.PSQLException: FATAL: Ident authentication failed for user “adminwiki”

Looks like the user/password you indicated in hibernate.cfg.xml is not known in your PostgreSql server.

#3

i checked it a lot of times, and re-create users and db.
image

<property name="connection.url">jdbc:postgresql://192.168.255.23/xwiki</property>
<property name="connection.username">adminwiki</property>
<property name="connection.password">Mumnet1706</property>
<property name="connection.driver_class">org.postgresql.Driver</property>
<property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property>
<property name="jdbc.use_streams_for_binary">false</property>
<property name="xwiki.virtual_mode">schema</property>

<property name="hibernate.connection.charSet">UTF-8</property>
<property name="hibernate.connection.useUnicode">true</property>
<property name="hibernate.connection.characterEncoding">utf8</property>

<mapping resource="xwiki.postgresql.hbm.xml"/>
<mapping resource="feeds.hbm.xml"/>
<mapping resource="instance.hbm.xml"/>
<mapping resource="notification-filter-preferences.hbm.xml"/>
<mapping resource="mailsender.hbm.xml"/>
#4

Im fixed login error with

GRANT ALL ON DATABASE database TO user;

seems another outdated line in offical guide

I keep trying to beat others

#5

also no any word in install guide about pg_hba.conf postgresql.conf and selinux
in pg_hba.conf im added all my IPs

all all 192.168.20.0/24 ident

in postgresql.conf listening adresses = “*”
selinux is disabled

now im got

java.net.ConnectException: Connection refused (Connection refused)
org.postgresql.util.PSQLException: Connection to 192.168.255.23:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.

sudo lsof -n -u postgres |grep LISTEN

postmaste 25789 postgres 3u IPv6 224567 0t0 TCP [::1]:postgres (LISTEN)
postmaste 25789 postgres 4u IPv4 224568 0t0 TCP 127.0.0.1:postgres (LISTEN)

#6

Hi!
Java wants to connect to 192.168.255.23:5432, but postgres listen only on 127.0.0.1. Maybe try to configure xwiki use 127.0.0.1 instead of 192.168.255.23?

Regards, Vadim

#7

im configure postgresql.conf

listen_addresses = “*” or “0.0.0.0”

its should listen all IPs
but he dont.
now im get

FATAL: Ident authentication failed for user “***”)

#8

You have misconfigured postgres.
Add
host all all 127.0.0.1/32 ident
to your postgres config, and read postgres configuretion how to configure it properly.

Regards, Vadim

#10

its already in pg_hba.conf

#11

OK. im found this sh*t
in pg_hba.conf need change from

ident

to

md5

#12

now i can write a my own install guide / lol :smiley: