Fields not showing up from an external table called "user"

If you think that something doesn't work in Aware IM post your message here
RLOMASKY
Posts: 60
Joined: Mon Jan 16, 2017 10:10 pm

Fields not showing up from an external table called "user"

Post by RLOMASKY »

I'm using an external Postgresql database. I need to import a table named "user". I understand that name is reserved, so I named my BO differently. But when I try to import the user table, even though I've said it's persisted externally, I'm still not getting the fields. I assume I'm getting the internal user table instead.
Screen Shot 2017-08-22 at 11.41.03 PM.png
Screen Shot 2017-08-22 at 11.41.03 PM.png (186.02 KiB) Viewed 29076 times
RLOMASKY
Posts: 60
Joined: Mon Jan 16, 2017 10:10 pm

Re: Fields not showing up from an external table called "use

Post by RLOMASKY »

Please let me know if you need anything from me to reproduce this problem.
aware_support
Posts: 7523
Joined: Sun Apr 24, 2005 12:36 am
Contact:

Re: Fields not showing up from an external table called "use

Post by aware_support »

Do you mean that you cannot "discover" the attributes? If so, it has nothing to do with the name of the table - the "user" table works for us. Most probably it is some column in this table that is causing the problem.

What's in the output of the Aware IM Server when you do this? Also, what's in the View/System Output window?
Aware IM Support Team
RLOMASKY
Posts: 60
Joined: Mon Jan 16, 2017 10:10 pm

Re: Fields not showing up from an external table called "use

Post by RLOMASKY »

Here is the DDL of the table, which is very different from what is showing up when I click "Discover Attributes":

Code: Select all

create table wevo."user"
(
	id bigserial not null
		constraint user_pkey
			primary key,
	public_id uuid default uuid_generate_v4() not null,
	first_name text not null,
	email_address citext not null,
	password_hash text not null,
	date_created timestamp with time zone default now() not null,
	is_active boolean default true not null,
	is_admin boolean default false not null,
	last_name text not null
)
;

RLOMASKY
Posts: 60
Joined: Mon Jan 16, 2017 10:10 pm

Re: Fields not showing up from an external table called "use

Post by RLOMASKY »

Nothing in System Output. Nothing in system.log or test.log
RLOMASKY
Posts: 60
Joined: Mon Jan 16, 2017 10:10 pm

Re: Fields not showing up from an external table called "use

Post by RLOMASKY »

Looking at the DDL, I realize there are a few weird fields. I would have no problem if those fields just didn't import, but I need the rest.

Thank you!
aware_support
Posts: 7523
Joined: Sun Apr 24, 2005 12:36 am
Contact:

Re: Fields not showing up from an external table called "use

Post by aware_support »

Go to the View/Aware IM Server on the Aware IM Control Panel. What is there?
Aware IM Support Team
RLOMASKY
Posts: 60
Joined: Mon Jan 16, 2017 10:10 pm

Re: Fields not showing up from an external table called "use

Post by RLOMASKY »

I'm using it headless on Linux. Is there a log file I should look at?
aware_support
Posts: 7523
Joined: Sun Apr 24, 2005 12:36 am
Contact:

Re: Fields not showing up from an external table called "use

Post by aware_support »

Then it's on Linux console
Aware IM Support Team
RLOMASKY
Posts: 60
Joined: Mon Jan 16, 2017 10:10 pm

Re: Fields not showing up from an external table called "use

Post by RLOMASKY »

I don't see anything on my console. I tried stopping and restarting the server to make sure.
RLOMASKY
Posts: 60
Joined: Mon Jan 16, 2017 10:10 pm

Re: Fields not showing up from an external table called "use

Post by RLOMASKY »

I installed AwareIM locally on my Mac so I could follow the directions, and still I don't see anything in any of the windows. In the Server Output, I do see an error when I tried to import a madeup table, so it is logging.
aware_support
Posts: 7523
Joined: Sun Apr 24, 2005 12:36 am
Contact:

Re: Fields not showing up from an external table called "use

Post by aware_support »

What exactly is the error that you see?
Aware IM Support Team
RLOMASKY
Posts: 60
Joined: Mon Jan 16, 2017 10:10 pm

Re: Fields not showing up from an external table called "use

Post by RLOMASKY »

There is no error at all, it just doesn't import all of the fields.

There are some non-standard field types (uuid, citext):

Code: Select all

create table wevo."user"
(
   id bigserial not null
      constraint user_pkey
         primary key,
   public_id uuid default uuid_generate_v4() not null,
   first_name text not null,
   email_address citext not null,
   password_hash text not null,
   date_created timestamp with time zone default now() not null,
   is_active boolean default true not null,
   is_admin boolean default false not null,
   last_name text not null
)
;
The fields that show up when I do Discover attributes are just current_user and company, which I don't even think it's getting from that table.

I'm happy to show you if you want to Skype. I'm in Moscow, so GMT +2.
aware_support
Posts: 7523
Joined: Sun Apr 24, 2005 12:36 am
Contact:

Re: Fields not showing up from an external table called "use

Post by aware_support »

Is there any way for you to put this table (even without any data) on some server where I could access it remotely and discover attributes?
Aware IM Support Team
RLOMASKY
Posts: 60
Joined: Mon Jan 16, 2017 10:10 pm

Re: Fields not showing up from an external table called "use

Post by RLOMASKY »

My DB is behind the firewall. I asked around, and I can't find anyone with a Postgres database without a firewall.
Post Reply