Error on postgresql ubuntu

ritesh 3 years ago

i am getting this error

ERROR: Main method error - ERROR: permission denied for schema public
  Position: 14 - PSQLException (... < DatabaseModule:95 < <gener:-1 < *:-1 < ... < Main:126 < ...)

my command

cat > /opt/traccar/conf/traccar.xml << EOF
<?xml version='1.0' encoding='UTF-8'?>

<!DOCTYPE properties SYSTEM 'http://java.sun.com/dtd/properties.dtd'>

<properties>

    <entry key="config.default">./conf/default.xml</entry>

<entry key='database.driver'>org.postgresql.Driver</entry>
<entry key='database.url'>jdbc:postgresql://127.0.0.1:5432/traccar</entry>
<entry key='database.user'>user</entry>
<entry key='database.password'>password</entry>

</properties>
EOF
sudo -u postgres psql
CREATE DATABASE traccar;
CREATE USER user WITH ENCRYPTED PASSWORD 'password';
GRANT ALL PRIVILEGES ON DATABASE traccar TO user;
GRANT USAGE ON schema public TO user;

Can anybody user postgresql ubuntu?
help me out.

Anton Tananaev 3 years ago

The error is coming from Postgres, so seems like there's some problem with your permission configuration.

Tony Shelver 3 years ago

As Anton says, looks like a permission issue Have you given the traccar user full permissions on the traccar database?