Where do you get the " schema/ directory containing PostgreSQL-specific SQL scripts required to set up the database"?
From: Lance Gropper <[email protected]> Sent: Thursday, April 25, 2019 11:25 AM To: [email protected] Subject: RE: admin password not working [ CAUTION ] This email originated outside Deluxe. Hello Nick: I'm stuck fighting a chicken/egg problem: When I tried to add a user for postgresql, it said it couldn't be done as a privileged user, so I created a non-privileged (system) user. When that user tries to add itself as a user on postgresql, it says the user has to be privileged user. Lance From: Lance Gropper Sent: Thursday, April 25, 2019 11:05 AM To: [email protected] Subject: RE: admin password not working Here's more from journalctl - following what it says farther below, postgresql is running, but I get this: [root@guacamole-post system]# createdb guacamole_db createdb: could not connect to database template1: FATAL: role "root" does not exist ---farther below--- Apr 25 11:02:33 guacamole-post.post.ad polkitd[5966]: Registered Authentication Agent for unix-process:5476:7008494 (system bus name :1.333 [/usr/bin/pktty Apr 25 11:02:33 guacamole-post.post.ad systemd[1]: Reloading. Apr 25 11:02:33 guacamole-post.post.ad polkitd[5966]: Unregistered Authentication Agent for unix-process:5476:7008494 (system bus name :1.333, object path Apr 25 11:02:38 guacamole-post.post.ad polkitd[5966]: Registered Authentication Agent for unix-process:5500:7009015 (system bus name :1.334 [/usr/bin/pktty Apr 25 11:02:38 guacamole-post.post.ad systemd[1]: Starting PostgreSQL database server... -- Subject: Unit postgresql.service has begun start-up -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- Unit postgresql.service has begun starting up. Apr 25 11:02:38 guacamole-post.post.ad postgresql-check-db-dir[5516]: "/var/lib/pgsql/data" is missing or empty. Apr 25 11:02:38 guacamole-post.post.ad postgresql-check-db-dir[5516]: Use "postgresql-setup initdb" to initialize the database cluster. Apr 25 11:02:38 guacamole-post.post.ad postgresql-check-db-dir[5516]: See /usr/share/doc/postgresql-9.2.24/README.rpm-dist for more information. Apr 25 11:02:38 guacamole-post.post.ad polkitd[5966]: Unregistered Authentication Agent for unix-process:5500:7009015 (system bus name :1.334, object path Apr 25 11:02:38 guacamole-post.post.ad systemd[1]: postgresql.service: control process exited, code=exited status=1 Apr 25 11:02:38 guacamole-post.post.ad systemd[1]: Failed to start PostgreSQL database server. -- Subject: Unit postgresql.service has failed -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- Unit postgresql.service has failed. -- -- The result is failed. Apr 25 11:02:38 guacamole-post.post.ad systemd[1]: Unit postgresql.service entered failed state. Apr 25 11:02:38 guacamole-post.post.ad systemd[1]: postgresql.service failed. From: Lance Gropper Sent: Thursday, April 25, 2019 11:01 AM To: [email protected] Subject: RE: admin password not working I figured out part of it - I only had the postgresql client installed - not the server. Now with the server installed: [root@guacamole-post system]# systemctl status postgresql.service ● postgresql.service - PostgreSQL database server Loaded: loaded (/usr/lib/systemd/system/postgresql.service; disabled; vendor preset: disabled) Active: failed (Result: exit-code) since Thu 2019-04-25 11:00:10 PDT; 10s ago Process: 5343 ExecStartPre=/usr/bin/postgresql-check-db-dir ${PGDATA} (code=exited, status=1/FAILURE) Apr 25 11:00:10 guacamole-post.post.ad systemd[1]: Starting PostgreSQL database server... Apr 25 11:00:10 guacamole-post.post.ad systemd[1]: postgresql.service: control process exited, code=exited status=1 Apr 25 11:00:10 guacamole-post.post.ad systemd[1]: Failed to start PostgreSQL database server. Apr 25 11:00:10 guacamole-post.post.ad systemd[1]: Unit postgresql.service entered failed state. Apr 25 11:00:10 guacamole-post.post.ad systemd[1]: postgresql.service failed. From: Lance Gropper Sent: Thursday, April 25, 2019 10:57 AM To: '[email protected]' <[email protected]> Subject: RE: admin password not working [root@guacamole-post guacamole]# service postgresql start Redirecting to /bin/systemctl start postgresql.service Failed to start postgresql.service: Unit not found. [root@guacamole-post guacamole]# systemctl start postgresql Failed to start postgresql.service: Unit not found. From: Lance Gropper Sent: Thursday, April 25, 2019 10:54 AM To: [email protected] Subject: RE: admin password not working So I have postgresql installed. How do I start it? [root@guacamole-post init.d]# createdb guacamole_db createdb: could not connect to database template1: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"? From: Nick Couchman <[email protected]> Sent: Thursday, April 25, 2019 10:47 AM To: [email protected] Subject: Re: admin password not working [ CAUTION ] This email originated outside Deluxe. On Thu, Apr 25, 2019 at 1:43 PM Lance Gropper <[email protected]<mailto:[email protected]>> wrote: Hello Nick: I'm working on it - I haven't done anything with SQL before (I'm trying this with postgresql). One thing I'm running into is in the instructions, it keeps referring to a folder called "GUACAMOLE_HOME" - where is this located? Many thanks for your help so far. http://guacamole.apache.org/doc/gug/configuring-guacamole.html#guacamole-home<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fguacamole.apache.org%2Fdoc%2Fgug%2Fconfiguring-guacamole.html%23guacamole-home&data=02%7C01%7CLance.Gropper%40encorehollywood.com%7C92c05ad5dcb3491ca2c608d6c9aca021%7C8688c7c41f2a4115a918361023dde469%7C1%7C0%7C636918140601883811&sdata=EmB0ovwvReUJUzl8VGRRiQTnlCpFJXZqgC3ZDOFBllE%3D&reserved=0> I use PostgreSQL routinely, so you shouldn't have any issues with that, but post back if you do. -Nick [ CAUTION ] DO NOT open attachments or click links from unknown senders. Only respond if you can validate the senders legitimacy. This e-mail and any attachments are intended only for use by the addressee(s) named herein and may contain confidential information. If you are not the intended recipient of this e-mail, you are hereby notified any dissemination, distribution or copying of this email and any attachments is strictly prohibited. If you receive this email in error, please immediately notify the sender by return email and permanently delete the original, any copy and any printout thereof. The integrity and security of e-mail cannot be guaranteed. [ CAUTION ] DO NOT open attachments or click links from unknown senders. Only respond if you can validate the senders legitimacy. This e-mail and any attachments are intended only for use by the addressee(s) named herein and may contain confidential information. If you are not the intended recipient of this e-mail, you are hereby notified any dissemination, distribution or copying of this email and any attachments is strictly prohibited. If you receive this email in error, please immediately notify the sender by return email and permanently delete the original, any copy and any printout thereof. The integrity and security of e-mail cannot be guaranteed.
