ERROR: relation "searchapp.search_auth_user" does not exist

[ssm...@txbiomed.org]

I am trying to load the transmart database and get the error:   ERROR:  relation "searchapp.search_auth_user" does not exist.

It is looking for the admin account.   Can someone tell me how I can add this account and what the password should be?

Thanks, 

Sandy

[Peter Rice]

Hi Sandy,

How are you loading the database?

Sounds like the tables do not exist yet - you will need the schema set
up before you can login with tranSMART.

regards,

Peter Rice
Axiomedix Inc.

> --
> For more ways to get in contact with the tranSMART community visit
> https://wiki.transmartfoundation.org/display/transmartwiki/Getting+Support
> ---
> You received this message because you are subscribed to the Google
> Groups "transmart-discuss" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to transmart-disc...@googlegroups.com
> <mailto:transmart-disc...@googlegroups.com>.
> To post to this group, send email to transmar...@googlegroups.com
> <mailto:transmar...@googlegroups.com>.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/transmart-discuss/8bba6389-00c0-4813-9e45-6878dff39ee2%40googlegroups.com
> <https://groups.google.com/d/msgid/transmart-discuss/8bba6389-00c0-4813-9e45-6878dff39ee2%40googlegroups.com?utm_medium=email&utm_source=footer>.
> For more options, visit https://groups.google.com/d/optout.

---
This email has been checked for viruses by AVG.
https://www.avg.com

[ssm...@txbiomed.org]

Hi Peter, 

I loaded the InstallTransmart.sh script.   I had several errors, but verified the services where running.   The problem seems to be with setting up basic PostgreSQL.   I tried to work around it by manually setting it up, but must be missing something.   Here is the log:

++++++++++++++++++++++++++++

+  Set up basic PostgreSQL; supports transmart login

++++++++++++++++++++++++++++

ERROR:  relation "searchapp.search_auth_user" does not exist

LINE 1: select username from searchapp.search_auth_user where userna...

                             ^

Setting up PostgreSQL database

make -C ddl/postgres/GLOBAL createdb

make[1]: Entering directory '/home/transmart/transmart/transmart-data/ddl/postgres/GLOBAL'

make[1]: Nothing to be done for 'createdb'.

make[1]: Leaving directory '/home/transmart/transmart/transmart-data/ddl/postgres/GLOBAL'

make postgres_load

make[1]: Entering directory '/home/transmart/transmart/transmart-data'

make -C ddl/postgres load

make[2]: Entering directory '/home/transmart/transmart/transmart-data/ddl/postgres'

test -n "$skip_ddl_global" || make -C GLOBAL load

make[3]: Entering directory '/home/transmart/transmart/transmart-data/ddl/postgres/GLOBAL'

/usr/bin/psql -v ON_ERROR_STOP=1 --single-transaction -X -f cast_varchar_numeric.sql

/usr/bin/psql -v ON_ERROR_STOP=1 --single-transaction -X -f roles.sql

/usr/bin/psql -v ON_ERROR_STOP=1 --single-transaction -X -f extensions.sql

test `/usr/bin/psql -v ON_ERROR_STOP=1 --single-transaction -X -c "select exists (select spcname from pg_tablespace where spcname = 'transmart')" -tA` \

= 't' || { \

make /home/transmart/pg/tablespaces/transmart; \

/usr/bin/psql -v ON_ERROR_STOP=1 --single-transaction -X -c "CREATE TABLESPACE transmart LOCATION '/home/transmart/pg/tablespaces/transmart'"; }

psql: could not connect to server: No such file or directory

Is the server running locally and accepting

connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

Thank You in advance!

Sandy

[ssm...@txbiomed.org]

One more thing to add, when I run the "make -j4 postgres" command, I pretty much get the same error.   

Thanks, 

Sandy

On Wednesday, September 19, 2018 at 10:11:13 AM UTC-5, ssm...@txbiomed.org wrote:

[ssm...@txbiomed.org]

I was able to get the database installed but now have the following error:  Error 500: Executing action [authfail] of controller [LoginController] caused exception: Runtime error executing action
Servlet: grails