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.
Fields not showing up from an external table called "user"
Re: Fields not showing up from an external table called "use
Please let me know if you need anything from me to reproduce this problem.
-
- Posts: 7525
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
Re: Fields not showing up from an external table called "use
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?
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
Re: Fields not showing up from an external table called "use
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
)
;
Re: Fields not showing up from an external table called "use
Nothing in System Output. Nothing in system.log or test.log
Re: Fields not showing up from an external table called "use
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!
Thank you!
-
- Posts: 7525
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
Re: Fields not showing up from an external table called "use
Go to the View/Aware IM Server on the Aware IM Control Panel. What is there?
Aware IM Support Team
Re: Fields not showing up from an external table called "use
I'm using it headless on Linux. Is there a log file I should look at?
-
- Posts: 7525
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
Re: Fields not showing up from an external table called "use
Then it's on Linux console
Aware IM Support Team
Re: Fields not showing up from an external table called "use
I don't see anything on my console. I tried stopping and restarting the server to make sure.
Re: Fields not showing up from an external table called "use
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.
-
- Posts: 7525
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
Re: Fields not showing up from an external table called "use
What exactly is the error that you see?
Aware IM Support Team
Re: Fields not showing up from an external table called "use
There is no error at all, it just doesn't import all of the fields.
There are some non-standard field types (uuid, citext):
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.
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
)
;
I'm happy to show you if you want to Skype. I'm in Moscow, so GMT +2.
-
- Posts: 7525
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
Re: Fields not showing up from an external table called "use
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
Re: Fields not showing up from an external table called "use
My DB is behind the firewall. I asked around, and I can't find anyone with a Postgres database without a firewall.