[GeoNode-users] Cannot load geonode page: DoesNotExist: Site matching query does not exist. IntegrityError: Problem installing fixture

[Paolo Corti]

I see you are connected to postgres now, therefore you can run the SQL
command from there:

psql(9.1.13)
insert into django_site (id, domain, name) values (1, 'domain', 'name');

In case you are in troubles making this work, please try to read some
psql documentation.

regards
p

On Wed, Dec 23, 2015 at 2:06 AM, Shah Md. Rajibul Islam
<rajibul.islam at cdmp.org.bd> wrote:
> Dea Paolo,
>
> I have tried to do as you mentioned but it gave following message:
>
> root at geonode:~# sudo su postgres
> postgres at geonode:/root$ psql geonode
> could not change directory to "/root"
> psql (9.1.13)
>
> how can open the django_site to insert id, domain, name as you mentioned.
> What is name refers here database name/site name?
>
> Regards
> Rajib
>
> On Wed, Dec 23, 2015 at 3:43 AM, Paolo Corti <pcorti at gmail.com> wrote:
>>
>> something like (not tested it):
>>
>> ssh user at servername (not sure how it works on putty)
>> sudo su postgres
>> psql databasename
>> insert into django_site (id, domain, name) values (1, 'domain', 'name');
>>
>> regards
>> p
>>
>> On Tue, Dec 22, 2015 at 1:45 PM, Shah Md. Rajibul Islam
>> <rajibul.islam at cdmp.org.bd> wrote:
>> > Dear Paolo,
>> >
>> > Thank you for your reply. I am not good in psql and related coding as
>> > well
>> > and have very limited programming knowledge. It would be very helpful
>> > for me
>> > if you could also tell me the steps and codes that I have follow to do
>> > this.
>> >
>> > Best regards
>> > Rajib
>> >
>> > On Tue, Dec 22, 2015 at 11:43 PM, Paolo Corti <pcorti at gmail.com> wrote:
>> >>
>> >> Then do a ssh connection to the server, and use psql in place of
>> >> pgadmin
>> >> regards
>> >> p
>> >>
>> >> On Tue, Dec 22, 2015 at 3:55 AM, Shah Md. Rajibul Islam
>> >> <rajibul.islam at cdmp.org.bd> wrote:
>> >> > Dear Ariel,
>> >> >
>> >> > Thank you for your reply and I am really sorry for late reply.
>> >> >
>> >> > Is there other way to do the required task you mentioned? It would be
>> >> > better
>> >> > if I can do this using ssh client putty.
>> >> >
>> >> > Looking forward to your reply.
>> >> >
>> >> > Best regards
>> >> > Rajib
>> >> >
>> >> >
>> >> > Sent from Samsung Mobile
>> >> >
>> >> >
>> >> >
>> >> > -------- Original message --------
>> >> > From: Ariel Nunez <ingenieroariel at gmail.com>
>> >> > Date: 12/14/2015 8:06 PM (GMT+06:00)
>> >> > To: "Shah Md. Rajibul Islam" <rajibul.islam at cdmp.org.bd>
>> >> > Cc: geonode-users at lists.osgeo.org
>> >> > Subject: Re: [GeoNode-users] Cannot load geonode page: DoesNotExist:
>> >> > Site
>> >> > matching query does not exist. IntegrityError: Problem installing
>> >> > fixture
>> >> >
>> >> >
>> >> > Hello Rajib,
>> >> >
>> >> > Since you deleted the default Site (with id=1) instead of editing the
>> >> > site
>> >> > name and url this caused problems with the permissions and all around
>> >> > the
>> >> > site.
>> >> >
>> >> > Your best bet is to create a new Site object with id =1 and the right
>> >> > name
>> >> > and dome. Are you familiar with pgadminIII ? You can use that to
>> >> > connect
>> >> > to
>> >> > your database and recreate the missing entry in sites_site
>> >> > graphically.
>> >> >
>> >> > -a
>> >> >
>> >> > On Sun, Dec 13, 2015 at 12:29 AM, Shah Md. Rajibul Islam
>> >> > <rajibul.islam at cdmp.org.bd> wrote:
>> >> >>
>> >> >> Hi,
>> >> >>
>> >> >>
>> >> >>
>> >> >> I am using geonode 2.0 on Ubuntu 12.04
>> >> >>
>> >> >>
>> >> >>
>> >> >> I am having a problem while loading the geonode site as follows-
>> >> >>
>> >> >> “There was a problem loading this page. Please contact your GeoNode
>> >> >> administrator (he may have received an email automatically if he
>> >> >> configured
>> >> >> it properly). If you are the site administrator, enable debug mode
>> >> >> to
>> >> >> see
>> >> >> the actual error and fix it or file an issue in GeoNode's issue
>> >> >> tracker”
>> >> >>
>> >> >>
>> >> >>
>> >> >> It probably happened when I deleted the IP address from geoserver
>> >> >> site
>> >> >> management and add a site name geonode.dmic.org.bd. However, I have
>> >> >> added
>> >> >> the IP again to the site.
>> >> >>
>> >> >>
>> >> >>
>> >> >> I tried to update the IP again using sudo geonode-updateip
>> >> >> 203.83.183.18
>> >> >> and gives following error:
>> >> >>
>> >> >> DoesNotExist: Site matching query does not exist.
>> >> >>
>> >> >>
>> >> >>
>> >> >> When I run the sudo apt-get install --reinstall geonode command it
>> >> >> gives
>> >> >> following error message:
>> >> >>
>> >> >> IntegrityError: Problem installing fixture
>> >> >> '/usr/local/lib/python2.7/dist-packag
>> >> >> es/geonode/layers/fixtures/initial_data.json': Could not load
>> >> >> security.GenericOb
>> >> >> jectRoleMapping(pk=3): duplicate key value violates unique
>> >> >> constraint
>> >> >> "security_
>> >> >> genericobjectrolemap_subject_object_ct_id_object_i_key"
>> >> >>
>> >> >> DETAIL:  Key (subject, object_ct_id, object_id, role_id)=(anonymous,
>> >> >> 42,
>> >> >> 1, 4) already exists.
>> >> >>
>> >> >>
>> >> >>
>> >> >> Is there any suggestions please?
>> >> >>
>> >> >>
>> >> >>
>> >> >> Best regards
>> >> >>
>> >> >> Rajib
>> >> >>
>> >> >>
>> >> >>
>> >> >> Shah Md. Rajibul Islam
>> >> >>
>> >> >> GIS Analyst
>> >> >> CDMP – II, UNDP
>> >> >> Disaster Management & Relief Bhaban
>> >> >> 92-93, Mohakhali C/A, Dhaka - 1212
>> >> >> Tel # 989 0937; 882 1255; 882 1459, Ext - 303
>> >> >> Mobile: +88 01716 027389, E-mail: rajibul.islam at cdmp.org.bd
>> >> >> Web: www.cdmp.org.bd
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >> _______________________________________________
>> >> >> geonode-users mailing list
>> >> >> geonode-users at lists.osgeo.org
>> >> >> http://lists.osgeo.org/mailman/listinfo/geonode-users
>> >> >>
>> >> >
>> >> >
>> >> > _______________________________________________
>> >> > geonode-users mailing list
>> >> > geonode-users at lists.osgeo.org
>> >> > http://lists.osgeo.org/mailman/listinfo/geonode-users
>> >> >
>> >>
>> >>
>> >>
>> >> --
>> >> Paolo Corti
>> >> Geospatial software developer
>> >> web: http://www.paolocorti.net
>> >> twitter: @capooti
>> >> skype: capooti
>> >
>> >
>> >
>> >
>> > --
>> > Shah Md. Rajibul Islam
>> > GIS Analyst
>> > CDMP – II, UNDP
>> > Disaster Management & Relief Bhaban
>> > 92-93, Mohakhali C/A, Dhaka - 1212
>> > Tel # 989 0937; 882 1255; 882 1459, Ext - 303
>> > Mobile: +88 01716 027389, E-mail: rajibul.islam at cdmp.org.bd
>> > Web: www.cdmp.org.bd
>>
>>
>>
>> --
>> Paolo Corti
>> Geospatial software developer
>> web: http://www.paolocorti.net
>> twitter: @capooti
>> skype: capooti
>
>
>
>
> --
> Shah Md. Rajibul Islam
> GIS Analyst
> CDMP – II, UNDP
> Disaster Management & Relief Bhaban
> 92-93, Mohakhali C/A, Dhaka - 1212
> Tel # 989 0937; 882 1255; 882 1459, Ext - 303
> Mobile: +88 01716 027389, E-mail: rajibul.islam at cdmp.org.bd
> Web: www.cdmp.org.bd



-- 
Paolo Corti
Geospatial software developer
web: http://www.paolocorti.net
twitter: @capooti
skype: capooti