Re: [Qgis-user] 3.20.1 fails on Linux Mint

[Andrea Giudiceandrea]

Il 21/07/2021 18:42, Andrea Giudiceandrea ha scritto:

See https://github.com/qgis/QGIS/issues/44299 for some workarounds: it 
seems the isse is related to the "symbology-style.db" file in the 
profile folder.


The correct link to the Issue on GitHub is 
https://github.com/qgis/QGIS/issues/44293.


Regards.

Andrea
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] 3.20.1 fails on Linux Mint

[Andrea Giudiceandrea]

On Wed Jul 21 09:09:07 PDT 2021, Fernando M. Roxo da Motta
 wrote:

>  Hey!  It really worked this way, which looks quite strange.  It seems
> that it is trying to touch something that is restricted?
>
>  Which file would that be?  The binary executable seems to have the
> correct bits set:


See https://github.com/qgis/QGIS/issues/44299 for some workarounds: it 
seems the isse is related to the "symbology-style.db" file in the 
profile folder.


Regards.

Andrea Giudiceandrea

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] 3.20.1 fails on Linux Mint

[Richard Greenwood]

Same here -
removing ~/.local/share/QGIS/QGIS3/profiles/default/symbology-style.db
fixes the issue.

Many thanks!
Rich

On Wed, Jul 21, 2021 at 11:47 AM Fernando M. Roxo da Motta 
wrote:

> On Wed, 21 Jul 2021 13:05:14 -0400, Randal Hale
>  wrote:
>
>
> > Removing the
> > ~/.local/share/QGIS/QGIS3/profiles/default/symbology-style.db worked
> > for me - it was recreated upon startup.
>
>   Just tried and it worked.
>
>   Sdls.
>
> >
> > Randy
> >
> >
> > On 7/21/21 12:56 PM, Andrea Giudiceandrea wrote:
> > > Il 21/07/2021 18:42, Andrea Giudiceandrea ha scritto:
> > >
> > >> See https://github.com/qgis/QGIS/issues/44299 for some
> > >> workarounds: it seems the isse is related to the
> > >> "symbology-style.db" file in the profile folder.
> > >
> > > The correct link to the Issue on GitHub is
> > > https://github.com/qgis/QGIS/issues/44293.
> > >
> > > Regards.
> > >
> > > Andrea
> > > ___
> > > Qgis-user mailing list
> > > Qgis-user@lists.osgeo.org
> > > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> > > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
> >
>
>
>
>
>
>
>
>
>   Roxo
>
> --
>  Non luctari, ludare ---+ WYSIWYG
> Fernando M. Roxo da Motta   | Editor?
> Except where explicitly stated I speak on my own behalf.|  VI !!
> PU5RXO | PX5Q6048   | I see text,
>  Quis custodiet ipsos custodes?-+ I get text!
>
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>


-- 
Richard W. Greenwood, PLS
www.greenwoodmap.com
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] 3.20.1 fails on Linux Mint

[Fernando M. Roxo da Motta]

On Wed, 21 Jul 2021 13:05:14 -0400, Randal Hale
 wrote:


> Removing the 
> ~/.local/share/QGIS/QGIS3/profiles/default/symbology-style.db worked
> for me - it was recreated upon startup.

  Just tried and it worked.

  Sdls. 

> 
> Randy
> 
> 
> On 7/21/21 12:56 PM, Andrea Giudiceandrea wrote:
> > Il 21/07/2021 18:42, Andrea Giudiceandrea ha scritto:
> >  
> >> See https://github.com/qgis/QGIS/issues/44299 for some
> >> workarounds: it seems the isse is related to the
> >> "symbology-style.db" file in the profile folder.  
> >
> > The correct link to the Issue on GitHub is 
> > https://github.com/qgis/QGIS/issues/44293.
> >
> > Regards.
> >
> > Andrea
> > ___
> > Qgis-user mailing list
> > Qgis-user@lists.osgeo.org
> > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user  
> 








  Roxo

-- 
 Non luctari, ludare ---+ WYSIWYG
Fernando M. Roxo da Motta   | Editor?
Except where explicitly stated I speak on my own behalf.|  VI !!
PU5RXO | PX5Q6048   | I see text,
 Quis custodiet ipsos custodes?-+ I get text!
 
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] 3.20.1 fails on Linux Mint

[Randal Hale]

Removing the 
~/.local/share/QGIS/QGIS3/profiles/default/symbology-style.db worked for 
me - it was recreated upon startup.


Randy


On 7/21/21 12:56 PM, Andrea Giudiceandrea wrote:

Il 21/07/2021 18:42, Andrea Giudiceandrea ha scritto:

See https://github.com/qgis/QGIS/issues/44299 for some workarounds: 
it seems the isse is related to the "symbology-style.db" file in the 
profile folder.


The correct link to the Issue on GitHub is 
https://github.com/qgis/QGIS/issues/44293.


Regards.

Andrea
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user


--
---
Randal Hale
rjh...@northrivergeographic.com
https://www.northrivergeographic.com
(423)653-3611

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] 3.20.1 fails on Linux Mint

[chris hermansen]

Randal and list,

On Wed, Jul 21, 2021 at 8:32 AM Randal Hale 
wrote:

> So I just did an upgrade on Ubuntu (Pop-os Technically) and if you pop a
> terminal open and do *sudo qgis* it's runs - which makes me think one of
> those bits with the file (<-technical term) aren't set correctly.
>
> Randy
>
>
I just did (less than 10 minutes ago) an apt upgrade to 3.20.1 on Ubuntu
21.04 (vanilla Ubuntu, not Mint, not Pop) and don't see any problems with
running QGIS as installed.


-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] 3.20.1 fails on Linux Mint

[Fernando M. Roxo da Motta]

On Wed, 21 Jul 2021 11:31:56 -0400, Randal Hale
 wrote:


> So I just did an upgrade on Ubuntu (Pop-os Technically) and if you
> pop a terminal open and do *sudo qgis* it's runs - which makes me
> think one of those bits with the file (<-technical term) aren't set
> correctly.

  Hey!  It really worked this way, which looks quite strange.  It seems
that it is trying to touch something that is restricted?

  Which file would that be?  The binary executable seems to have the
correct bits set:

$ ls -l /usr/bin/qgis.bin
-rwxr-xr-x 1 root root 391560 jul 20 21:00 /usr/bin/qgis.bin*

  I went through the installed packages looking for any with restricted
access and found not a single one.

  Perhaps some restricted action like a socket or something like that?

  HTH

> 
> Randy
> 
> On 7/21/21 9:02 AM, Richard Greenwood wrote:
> > I just upgraded from 3.20.0 to 3.20.1 on Linux Mint 20.1. Qgis
> > doesn't start, or more accurately, I don't get a GUI interface. I
> > can see the qgis.bin process running and using 100% of one core, so
> > I guess it's hung. I uninstalled, reinstalled, rebooted, same
> > result. Suggestions?
> >
> > -- 
> > Richard W. Greenwood, PLS
> > www.greenwoodmap.com 
> >
> > ___
> > Qgis-user mailing list
> > Qgis-user@lists.osgeo.org
> > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user  
> 








  Roxo

-- 
 Non luctari, ludare ---+ WYSIWYG
Fernando M. Roxo da Motta   | Editor?
Except where explicitly stated I speak on my own behalf.|  VI !!
PU5RXO | PX5Q6048   | I see text,
 Quis custodiet ipsos custodes?-+ I get text!
 
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] 3.20.1 fails on Linux Mint

[Bernd Vogelgesang]

On 21.07.21 16:37, Fernando M. Roxo da Motta wrote:

On Wed, 21 Jul 2021 07:02:37 -0600, Richard Greenwood
 wrote:



I just upgraded from 3.20.0 to 3.20.1 on Linux Mint 20.1. Qgis doesn't
start, or more accurately, I don't get a GUI interface. I can see the
qgis.bin process running and using 100% of one core, so I guess it's
hung. I uninstalled, reinstalled, rebooted, same result. Suggestions?



   I have just upgraded Qgis in my Ubuntu 20.04.2 LTS and got the same
result, no GUI.

   There are many messages like:

(qgis.bin:62147): Gtk-WARNING **: 11:17:36.524: Theme parsing error:
gtk.css:28:35: Junk at end of value for background-color

or

(qgis.bin:62147): Gtk-WARNING **: 11:17:36.546: Theme parsing error:
gtk-widgets-assets.css:108:32: The style property
GtkWidget:separator-width is deprecated and shouldn't be used anymore.
It will be removed in a future version

But I think that is not the problem here.

   I am still struggling trying to get some clue.




   Roxo


Thanks for the warnings!

I forward it to the developer list.

Cheers,

Bernd

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] 3.20.1 fails on Linux Mint

[Randal Hale]

So I just did an upgrade on Ubuntu (Pop-os Technically) and if you pop a 
terminal open and do *sudo qgis* it's runs - which makes me think one of 
those bits with the file (<-technical term) aren't set correctly.


Randy

On 7/21/21 9:02 AM, Richard Greenwood wrote:
I just upgraded from 3.20.0 to 3.20.1 on Linux Mint 20.1. Qgis doesn't 
start, or more accurately, I don't get a GUI interface. I can see the 
qgis.bin process running and using 100% of one core, so I guess it's 
hung. I uninstalled, reinstalled, rebooted, same result. Suggestions?


--
Richard W. Greenwood, PLS
www.greenwoodmap.com 

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user


--
---
Randal Hale
rjh...@northrivergeographic.com
https://www.northrivergeographic.com
(423)653-3611

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] 3.20.1 fails on Linux Mint

[Fernando M. Roxo da Motta]

On Wed, 21 Jul 2021 07:02:37 -0600, Richard Greenwood
 wrote:


> I just upgraded from 3.20.0 to 3.20.1 on Linux Mint 20.1. Qgis doesn't
> start, or more accurately, I don't get a GUI interface. I can see the
> qgis.bin process running and using 100% of one core, so I guess it's
> hung. I uninstalled, reinstalled, rebooted, same result. Suggestions?
> 


  I have just upgraded Qgis in my Ubuntu 20.04.2 LTS and got the same
result, no GUI.

  There are many messages like:

(qgis.bin:62147): Gtk-WARNING **: 11:17:36.524: Theme parsing error:
gtk.css:28:35: Junk at end of value for background-color 

or

(qgis.bin:62147): Gtk-WARNING **: 11:17:36.546: Theme parsing error:
gtk-widgets-assets.css:108:32: The style property
GtkWidget:separator-width is deprecated and shouldn't be used anymore.
It will be removed in a future version 

But I think that is not the problem here.

  I am still struggling trying to get some clue.




  Roxo

-- 
 Non luctari, ludare ---+ WYSIWYG
Fernando M. Roxo da Motta   | Editor?
Except where explicitly stated I speak on my own behalf.|  VI !!
PU5RXO | PX5Q6048   | I see text,
 Quis custodiet ipsos custodes?-+ I get text!
 
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Fix table unique column

[Yamen Tekaji]

Dears,

I connected QGIS to Oracle DB which contains tables with GEOMETRY and
spatial data.

When trying to add some tables to the layer window, I saw this error
message:

2021-07-13T16:48:15 WARNINGPrimary key field 'INSERT_DATE' for view
not unique.


This INSERT_DATE is not my primary Key column. I have a column called ID
which is the primary key. How can I tell QGIS which columns are the primary
keys in the tables I want to add to layers?


Please advise.


Regards,

Yamen
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Select by Expression: exclusive (not inclusive)

[Andy Harfoot]

Out of curiosity, what happens if you execute the same query via the 
Virtual layer dialog or through the DB Manager? This would highlight any 
differences between QGIS Expression SQL and a DBMS (the SQLite engine).


On 15/07/2021 08:17, Andrew Hughes wrote:

*CAUTION:* This e-mail originated outside the University of Southampton.
Thanks Marco,

You've answered my question, so thank you. For reference, I've never 
see this in any sql rmdbs.


Some examples my help the community, hopefully I will be able to 
contribute sooner or later.


Thanks again!
Andrew


On Wed, 7 Jul 2021 at 17:43, GMAIL > wrote:


This is how sql works.
You want to apply a function to one column, and the column you are
comparing must have a value.
Consider this: tag_service != 'xxx' or null != 'xxx'. Null can't be
equal or unequal to any value. Even null = null or null != null
returns
false

hth
marco
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org 
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user


Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user




___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user


--
Andy Harfoot

Skype: gdi_ajph
Teams: a...@soton.ac.uk

GeoData Institute
University of Southampton
Southampton
SO17 1BJ

www.geodata.soton.ac.uk

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] 3.20.1 fails on Linux Mint

[Richard Greenwood]

I just upgraded from 3.20.0 to 3.20.1 on Linux Mint 20.1. Qgis doesn't
start, or more accurately, I don't get a GUI interface. I can see the
qgis.bin process running and using 100% of one core, so I guess it's hung.
I uninstalled, reinstalled, rebooted, same result. Suggestions?

-- 
Richard W. Greenwood, PLS
www.greenwoodmap.com
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Tell QGIS 3.16 to use "mysql_native_password" auth

[Victor Rodriguez]

Hello,

I'm having trouble connecting QGIS 3.16 to a MySQL Server v 5.7.32
(iirc). The PC runs Linux Mint 20.2, based on Ubuntu 20.04. The MySQL
client library available in this system is "libmysqlclient21", which is
based on MySQL 8. This version of MySQL changed the default
authentication from "mysql_native_password" to "caching_sha2_password".
That means that if you dont tell a MySQL8 client to use the older
authentication mechanism it will use the new one by default, which won't
work for a MySQL 5.7 server.

The error message I'm getting is:

'Extended error information:

MySQL connect failed for:
dbserver,host=10.10.4.4,port=3306,user=qgisuser,password=XX
Error: Access denied for user 'qgisuser'@'10.0.0.3' (using password: NO)'

I have seen this error before using Python scripts which used old
libraries that did not allowed to set the auht mechanism to
"mysql_native_password" or did not read /etc/mysql/mysql.cnf for:

[client]
default-auth=mysql_native_password

How can I tell QGIS to use "mysql_native_password" as the authentication
mechanism?

Thank you.




___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [QGIS-it-user] Cosa usare al posto di Nabble per la nostra lista?

[andy]

Buongiorno,
anche io trovo scomode le mailing list, per scriversi in comunità.
Faccio le mie valutazioni sulla modalità di fruizione attuale che è un
client email e questi elenchi HTML
.

Cosa mi piace di vari strumenti alternativi:

   - poter seguire anche soltanto un thread;
   - poter fare ricerche semplici ed avanzate;
   - avere a disposizione il *syntax highlighting *(non serve in tutte le
   comunità, ma qui sì);
   - il *tagging *degli utenti, per fare - quando serve - toc toc sulle
   spalle a quelle/i giuste/i;
   - l'ipertesto ricco, in modo da poter scrivere e descrivere meglio (mi
   piace molto se un po' normalizzato, come avviene con il markdown);
   - l'alta leggibilità del testo e della struttura, su tutti i tipi di
   terminali.


La prima domanda è: qui è cosa condivisa il fatto che sarebbe meglio
passare ad altro?

Se sì, ci sono enne strumenti. Non so come si prendono decisioni qui, ma
aggiungo due considerazioni:

   - sceglierei qualcosa che non richiede tempo per aggiornare, manutenere,
   mettere in sicurezza. O per meglio dire qualcosa in cui tutto questo fa già
   parte del pacchetto;
   - non metterei come requisito l'import delle vecchio sul nuovo, perché
   pone vincoli e richiede lavoro;
   - non schiaccerei questa comunità su chat (di qualsiasi tipo) e su
   social. Uno spazio discussione non in real-time e "moderno", può essere
   d'aiuto.

Le GitHub discussions sono a mio avviso un'ottima scelta, con la
possibilità di avere *thread*, da inserire anche in macro categorie. E c'è
un tipo di categoria con un comportamento comodissimo per spazi come
questo: la categoria in cui sono abilitate le risposte, per intenderci alla
stackoverflow, in cui l'utente che pone la domanda, potrà "markare" la
risposta giusta. E con le altre categoria si possono sollecitare altri tipi
di azione.
E nelle discussions c'è anche la categoria con il comportamento da
"annunci", quindi diciamo in broadcasting, senza commenti.
E le pinned discussions, per i temi caldi del momento.

[image: image.png]

Se si vuole avere qualcosa da gestire in autonomia, discourse
 è un gran prodotto.

Saluti


-- 
___

Andrea Borruso
website: https://medium.com/tantotanto
38° 7' 48" N, 13° 21' 9" E, EPSG:4326
___

"cercare e saper riconoscere chi e cosa,
 in mezzo all’inferno, non è inferno,
e farlo durare, e dargli spazio"

Italo Calvino
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user

Re: [Qgis-user] Symbology using an expression to find a field with known suffix

[Delaz J]

Hi Andrew,

Try something like

 eval(
  array_to_string(
   array_filter(
    map_akeys(attributes()),
    right(@element, 5) = '_blah')
  )
 )

You may want to read the help of each involved function to better 
understand how things work here.


HTH,

Harrissou

Le 21/07/2021 à 02:36, Andrew Hughes a écrit :

Hi All,

Any help would be much appreciated,  sorry for just throwing this out 
there... QGIS is very new to me.


I have lots of tables that I would like to apply common symbology and 
best I explain with an example:


table_a.foo_blah
table_b.boo_blah
table_c.whatever_blah
table_d.i_cant_believe_its_not_butter_blah

Q: What would the expression be to find the field ending with "_blah" 
and use/return that fields value (as the symbology's categorical 
value)? I will never know what the field is called, just that it 
always ends in _blah.


Big thanks in advance,
Andrew







___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user