from:"Mira Maric"

[Qgis-developer] Using LIKE in search- QGIS web client

2015-02-20 Thread Mira Maric

Hi! I am using qgis web client, and I need to set QGIS server searching.
Is there any way LIKE in query, to change filerOp from '=' to like?

Thanks!
___
Qgis-developer mailing list
Qgis-developer@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-developer

[Qgis-developer] Using qgis with SQL Server

2015-02-02 Thread Mira Maric

Hi.
I am using:
 - Ubuntu 12.04
 - Qgis 2.6.1
 - Windows Server 2008 with SQL Server 2008

Now I am trying to use SQL Server from Ubuntu with qgis.
I install freetds and unixodbc and I can connect to the SQL Server and
I can list tables, but when I try to add layer from SQL Server, QGIS
get a crash.
It's say:
** glibc detected *** /usr/bin/qgis.bin: malloc(): memory corruption:
0x0adac1f0 ***


This is my connections parameter:
Name: SQL Connection
Provider/DNS:driver=FreeTDS;TDS_Version=8.0;port=1433;server=192.168.1.100;database=my_db;
Host:192.168.1.100
Database:my_db

Where I am making mistake?
Thanks!
___
Qgis-developer mailing list
Qgis-developer@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [Qgis-developer] Lizmap edit layer

2014-09-20 Thread Mira Maric

Hi. Same thing is when I save table in public schema or other schema.
When I run:
SELECT type FROM geometry_columns WHERE f_table_name = 'bus_stops' AND
f_table_schema = 'topology'

I get
Type character varying (30)
POINT


2014-09-19 20:40 GMT+00:00 Salvatore Larosa lrssv...@gmail.com:
 Hi,

 On Fri, Sep 19, 2014 at 9:15 PM, Mira Maric mmmx...@gmail.com wrote:
 Hi. I am using lizmap web client form editing layer bus_stops.
 Bus_stops layer is in Postgis database. I am import it to the database
 from the shapefile with SPIT plugin.

 Which QGIS and LizMapWC versions ?


 When I try to edit layer with lizmap webclient I get next message:

 An error occured for : 'SELECT *, ST_AsText() AS astext FROM
 topology.bus_stops WHERE ST_Intersects(
 ST_MakeEnvelope(429253.865738,5407067.308823,429265.809023,5407079.252109,
 3857 ), ST_Transform(, 3857 ) )', the message:invalid query (ERROR:
 syntax error at or near ,

 What the following query returns?:
 SELECT type FROM geometry_columns WHERE f_table_name = 'bus_stops' AND
 f_table_schema = 'topology'

 Why the bus_stops table is into the topology schema? I would
 recommend you to use a different schema

 Regards,
 -SL

 --
 Salvatore Larosa
 linkedIn: http://linkedin.com/in/larosasalvatore
 twitter: @lrssvt
 skype: s.larosa
 IRC: lrssvt on freenode
___
Qgis-developer mailing list
Qgis-developer@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-developer

[Qgis-developer] Lizmap edit layer

2014-09-19 Thread Mira Maric

Hi. I am using lizmap web client form editing layer bus_stops.
Bus_stops layer is in Postgis database. I am import it to the database
from the shapefile with SPIT plugin.

When I try to edit layer with lizmap webclient I get next message:

An error occured for : 'SELECT *, ST_AsText() AS astext FROM
topology.bus_stops WHERE ST_Intersects(
ST_MakeEnvelope(429253.865738,5407067.308823,429265.809023,5407079.252109,
3857 ), ST_Transform(, 3857 ) )', the message:invalid query (ERROR:
syntax error at or near ,
___
Qgis-developer mailing list
Qgis-developer@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-developer

[Qgis-developer] QGIS project with SQL SERVER!

2014-03-04 Thread Mira Maric

I am using QGIS with SQL server 2008. I need to save project on one
computer and then copy project to another 20 clients!

After I save project and try to open it on another computer I am
getting error, that I need to HANDLE BAD LAYERS.


How I can setup project that can be used on another computer?
___
Qgis-developer mailing list
Qgis-developer@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [Qgis-developer] Qgis web client search

2014-01-16 Thread Mira Maric

I set up Apache config file:
insert following lines:
- LoadModule wsgi_module modules/mod_wsgi.so
and

 WSGIScriptAlias /wsgi C:\OSGeo4W\apache\htdocs\qgis-web-client-master\wsgi
 WSGIScriptAliasMatch ^/wsgi/([^/]+)
C:\OSGeo4W\apache\htdocs\qgis-web-client-master\$1.wsgi


, after this I create tables in Posgis and modify connection string in
search.wsgi and getSearchGeom.wsgi.

Now when I run web page and try to search in search box I get this error:

Resource interpreted as Script but transferred with MIME type text/plain:
 
http://localhost:89/qgis-web-client-master/wsgi/search.wsgi?query=searchtables=query=89cb=stcCallback1001;.
ext-all.js:7
Uncaught SyntaxError: Unexpected token ILLEGAL search.wsgi:1



2014/1/16 Bernhard Ströbl bernhard.stro...@jena.de:
 Hi,

 I have no idea, where this is located on Windows...
 but you need to adapt the wsgi files you downloaded from github with QWC to
 your db settings (see section 6.2)!

 Bernhard

 P.S. please try to reply to the list

 Am 16.01.2014 10:17, schrieb Mira Maric:

 Hi!
 I do the following:
 I download mod_wsgi.so from
 http://www.lfd.uci.edu/~gohlke/pythonlibs/#mod_wsgi an put it in:
 C:\OSGeo4W\apache\modules
   In Apache config file I added line:
  -LoadModule wsgi_module modules/mod_wsgi.so

 I restart apache and turn it on, it's work OK. Now I don't know  where
 to do this, where is file for this settings?
 I am using Windows!

6.1. Configuration of mod_wsgi
==

 You need to enable mod_wsgi as root. (Ubuntu: a2enmod mod_wsgi).

 You need to configure apache with the following lines (e.g. in file
 /etc/apache2/sites-available/default):

#mod_wsgi
WSGIDaemonProcess gis processes=5 threads=15 display-name=%{GROUP}
WSGIScriptAlias /wsgi/ /home/www/wsgi/
WSGIScriptAliasMatch ^/wsgi/([^/]+) /home/www/wsgi/$1.wsgi



 Thanks!






 2014/1/16 Mira Maricmmmx...@gmail.com:

 Hi!
 I do the following:
 I download mod_wsgi.so from
 http://www.lfd.uci.edu/~gohlke/pythonlibs/#mod_wsgi an put it in:
 C:\OSGeo4W\apache\modules
   In Apache config file I added line:
  -LoadModule wsgi_module modules/mod_wsgi.so

 I restart apache and turn it on, it's work OK. Now I don't know  where
 to do this








 Uncaught SyntaxError: Unexpected token ILLEGAL in search.wsgi:1

 2014/1/16 Bernhard Ströblbernhard.stro...@jena.de:

 Hi,

 did you configure the wsgi scripts to match your database and did you
 provide the search tables in the database?
 Both is described in the README (section 6) [1]

 Bernhard

 [1] https://github.com/qgis/QGIS-Web-Client

 Am 16.01.2014 07:33, schrieb Mira Maric:


   1.


  First I added line in Apache config file:
  -LoadModule wsgi_module modules/mod_wsgi.so

   2.


  In GlobalOption.js I set var useGeoNamesSearchBox = false; var
  searchBoxQueryURL

 =http://localhost:89/qgis-web-client-master/wsgi/search.wsgi?query=;;
  var searchBoxGetGeomURL

 =http://localhost:89/qgis-web-client-master/wsgi/getSearchGeom.wsgi;;

 When i try to search, i do not get anything! Is there any example for
 searching setup?






 __ Information from ESET Mail Security, version of virus signature
 database 9296 (20140115) __

 The message was checked by ESET Mail Security.
 http://www.eset.com


___
Qgis-developer mailing list
Qgis-developer@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [Qgis-developer] Qgis web client search

2014-01-16 Thread Mira Maric

When I enter URL in browser:
http://localhost:89/qgis-web-client-master/wsgi/search.wsgi?query=searchtables=query=plcb=stcCallback1002
I get the content of search.wsgi file!
This is my log of access file:
127.0.0.1 - - [16/Jan/2014:11:50:26 +0100] GET
/qgis-web-client-master/wsgi/search.wsgi?query=searchtables=query=89cb=stcCallback1001
HTTP/1.1 200 5723
127.0.0.1 - - [16/Jan/2014:12:08:29 +0100] GET
/qgis-web-client-master/wsgi/search.wsgi?query=searchtables=query=plcb=stcCallback1002
HTTP/1.1 200 5723
This is my log of error file:

[Thu Jan 16 11:50:49 2014] [notice] Parent: Received restart signal --
Restarting the server.
[Thu Jan 16 11:50:49 2014] [notice] Child 8856: Exit event signaled.
Child process is ending.
[Thu Jan 16 11:50:49 2014] [warn] mod_wsgi: Compiled for Python/3.3.0.
[Thu Jan 16 11:50:49 2014] [warn] mod_wsgi: Runtime using Python/3.3.2.
[Thu Jan 16 11:50:49 2014] [notice] Apache/2.2.14 (Win32)
mod_wsgi/3.5-BRANCH Python/3.3.2 mod_fcgid/2.3.6 configured --
resuming normal operations
[Thu Jan 16 11:50:49 2014] [notice] Server built: Sep 28 2009 22:41:08
[Thu Jan 16 11:50:49 2014] [notice] Parent: Created child process 6020
[Thu Jan 16 11:50:49 2014] [warn] mod_wsgi: Compiled for Python/3.3.0.
[Thu Jan 16 11:50:49 2014] [warn] mod_wsgi: Runtime using Python/3.3.2.
[Thu Jan 16 11:50:49 2014] [notice] Child 6020: Child process is running
[Thu Jan 16 11:50:50 2014] [notice] Child 6020: Acquired the start mutex.
[Thu Jan 16 11:50:50 2014] [notice] Child 8856: Released the start mutex
[Thu Jan 16 11:50:50 2014] [notice] Child 6020: Starting 64 worker threads.
[Thu Jan 16 11:50:50 2014] [notice] Child 6020: Starting thread to
listen on port 89.
[Thu Jan 16 11:50:51 2014] [notice] Child 8856: All worker threads have exited.
[Thu Jan 16 11:50:51 2014] [notice] Child 8856: Child process is exiting



2014/1/16 Bernhard Ströbl bernhard.stro...@jena.de:
 Hi,

 try to enter the url of the wsgi-script directly in your browser and see
 what it returns, check QWC's log file for any errors of the wsgi script.

 Bernhard

 Am 16.01.2014 12:09, schrieb Mira Maric:

 I set up Apache config file:
 insert following lines:
 - LoadModule wsgi_module modules/mod_wsgi.so
 and

   WSGIScriptAlias /wsgi
 C:\OSGeo4W\apache\htdocs\qgis-web-client-master\wsgi
   WSGIScriptAliasMatch ^/wsgi/([^/]+)
 C:\OSGeo4W\apache\htdocs\qgis-web-client-master\$1.wsgi


 , after this I create tables in Posgis and modify connection string in
 search.wsgi and getSearchGeom.wsgi.

 Now when I run web page and try to search in search box I get this error:

 Resource interpreted as Script but transferred with MIME type text/plain:

 http://localhost:89/qgis-web-client-master/wsgi/search.wsgi?query=searchtables=query=89cb=stcCallback1001;.
 ext-all.js:7
 Uncaught SyntaxError: Unexpected token ILLEGAL search.wsgi:1



 2014/1/16 Bernhard Ströblbernhard.stro...@jena.de:

 Hi,

 I have no idea, where this is located on Windows...
 but you need to adapt the wsgi files you downloaded from github with QWC
 to
 your db settings (see section 6.2)!

 Bernhard

 P.S. please try to reply to the list

 Am 16.01.2014 10:17, schrieb Mira Maric:

 Hi!
 I do the following:
 I download mod_wsgi.so from
 http://www.lfd.uci.edu/~gohlke/pythonlibs/#mod_wsgi an put it in:
 C:\OSGeo4W\apache\modules
In Apache config file I added line:
   -LoadModule wsgi_module modules/mod_wsgi.so

 I restart apache and turn it on, it's work OK. Now I don't know  where
 to do this, where is file for this settings?
 I am using Windows!

 6.1. Configuration of mod_wsgi
 ==

 You need to enable mod_wsgi as root. (Ubuntu: a2enmod mod_wsgi).

 You need to configure apache with the following lines (e.g. in file
 /etc/apache2/sites-available/default):

 #mod_wsgi
 WSGIDaemonProcess gis processes=5 threads=15 display-name=%{GROUP}
 WSGIScriptAlias /wsgi/ /home/www/wsgi/
 WSGIScriptAliasMatch ^/wsgi/([^/]+) /home/www/wsgi/$1.wsgi



 Thanks!






 2014/1/16 Mira Maricmmmx...@gmail.com:


 Hi!
 I do the following:
 I download mod_wsgi.so from
 http://www.lfd.uci.edu/~gohlke/pythonlibs/#mod_wsgi an put it in:
 C:\OSGeo4W\apache\modules
In Apache config file I added line:
   -LoadModule wsgi_module modules/mod_wsgi.so

 I restart apache and turn it on, it's work OK. Now I don't know  where
 to do this








 Uncaught SyntaxError: Unexpected token ILLEGAL in search.wsgi:1

 2014/1/16 Bernhard Ströblbernhard.stro...@jena.de:


 Hi,

 did you configure the wsgi scripts to match your database and did you
 provide the search tables in the database?
 Both is described in the README (section 6) [1]

 Bernhard

 [1] https://github.com/qgis/QGIS-Web-Client

 Am 16.01.2014 07:33, schrieb Mira Maric:



1.


   First I added line in Apache config file:
   -LoadModule wsgi_module modules/mod_wsgi.so

2.


   In GlobalOption.js I set var useGeoNamesSearchBox = false; var
   searchBoxQueryURL


 =http

[Qgis-developer] Qgis web client search

2014-01-15 Thread Mira Maric

   1.

   First I added line in Apache config file:
   -LoadModule wsgi_module modules/mod_wsgi.so
   2.

   In GlobalOption.js I set var useGeoNamesSearchBox = false; var
   searchBoxQueryURL
   =http://localhost:89/qgis-web-client-master/wsgi/search.wsgi?query=;;
   var searchBoxGetGeomURL
   =http://localhost:89/qgis-web-client-master/wsgi/getSearchGeom.wsgi;;

When i try to search, i do not get anything! Is there any example for
searching setup?
___
Qgis-developer mailing list
Qgis-developer@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-developer

[Qgis-developer] Using LIKE in search- QGIS web client

[Qgis-developer] Using qgis with SQL Server

Re: [Qgis-developer] Lizmap edit layer

[Qgis-developer] Lizmap edit layer

[Qgis-developer] QGIS project with SQL SERVER!

Re: [Qgis-developer] Qgis web client search

Re: [Qgis-developer] Qgis web client search

[Qgis-developer] Qgis web client search

8 matches

Site Navigation

Mail list logo

Footer information