| 295 | == Configuration for publishing == |
| 296 | |
| 297 | The installation process should have created a user in the postgres database, named rootAdmin. You can check it by running {{{psql -U dbsuper -d esgcet}}} (to access the postgres cli) and visualizing the table esgf_security.user. |
| 298 | |
| 299 | {{{ |
| 300 | esgcet=# select * from esgf_security.user; |
| 301 | id | firstname | middlename | lastname | email | username | password | dn | openid | organization | organization_type | city | state | country | status_code | verificat |
| 302 | ion_token | notification_code |
| 303 | ----+-----------+------------+-------------+------------------------+-----------+------------------------------------+----+---------------------------------------------------------+--------------+-------------------+------+-------+---------+-------------+------------------- |
| 304 | -------------------+------------------- |
| 305 | 1 | Admin | | User | emailOfTheAdmin | rootAdmin | hashOfThePassword | | https://domain/esgf-idp/openid/rootAdmin | Institution | | City | State | Country | 1 | 79563dfc-ad55-4aa1 |
| 306 | -b50e-d43692adc5e5 | |
| 307 | }}} |
| 308 | |
| 309 | In order to test the publication, create a new user using the CoG web interface (https://[index_node_fqdn]). You should click on 'Create Account' and fill the form. Once the user is created using the CoG interface, it should be visible in the esgf_security.user table of the postgres database. |
| 310 | |
| 311 | {{{ |
| 312 | esgcet=# select * from esgf_security.user; |
| 313 | id | firstname | middlename | lastname | email | username | password | dn | openid | organization | organization_type | city | state | country | status_code | verificat |
| 314 | ion_token | notification_code |
| 315 | ----+-----------+------------+-------------+------------------------+-----------+------------------------------------+----+---------------------------------------------------------+--------------+-------------------+------+-------+---------+-------------+------------------- |
| 316 | -------------------+------------------- |
| 317 | 1 | Admin | | User | emailOfTheAdmin | rootAdmin | hashOfThePassword | | https://domain/esgf-idp/openid/rootAdmin | Institution | | City | State | Country | 1 | 79563dfc-ad55-4aa1 |
| 318 | -b50e-d43692adc5e5 | 0 |
| 319 | 2 | zequi | | cimadevilla | emailOfZequi | zequi | hashOfThePassword | | https://domain/esgf-idp/openid/zequi | asdf | | asdf | asdf | asdf | 1 | f187f706-b03c-467b-a570-c4ddc7afc70e | |
| 320 | }}} |
| 321 | |