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

Tue Dec 22 23:06:12 PST 2015

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geonode-users/attachments/20151223/33ee9bab/attachment-0001.html>