search

google-code-export / gambas

Automatically exported from code.google.com/p/gambas
1 stars 0 forks source link

Database password retrieval error and abort in IDE #257

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
1) Describe the problem.

I'm trying out the gambasforge code to learn how to write a cgi with gambas3.

When I click on the database connection inside the project treeview, I get:

_Desktop_Passwords._get.62: Unable to get password
1: FMain.tvwProject_Menu.233

And the IDE aborts...

2) GIVE THE FOLLOWING INFORMATIONS (if they are appropriate):

[System]
OperatingSystem=Linux
Kernel=2.6.38-14-generic
Architecture=x86_64
Memory=3787800 kB
DistributionVendor=Ubuntu
DistributionRelease="Ubuntu 11.04"
Desktop=Gnome

[Gambas 2]
Version=2.24.0
Path=/usr/local/bin/gbx2

[Gambas 3]
Version=3.2.0
Path=/usr/local/bin/gbx3

[Libraries]
Qt4=libQtCore.so.4.7.2
GTK+=libgtk-x11-2.0.so.0.2400.4

Gambas 3 version is trunk at rev 4846

Original issue reported on code.google.com by r...@cyberjunky.nl on 18 Jun 2012 at 1:27

GoogleCodeExporter commented 9 years ago 
Additional info: you get the abort if you right click the connection and choose 
properties.

Original comment by r...@cyberjunky.nl on 18 Jun 2012 at 1:39

GoogleCodeExporter commented 9 years ago 
There is a problem with Gnome keyring. Do you run Gnome3 ?

Original comment by benoit.m...@gmail.com on 19 Jun 2012 at 12:17

GoogleCodeExporter commented 9 years ago 
I'm running Ubuntu 11.04, so I'm still at the default Gnome 2.32.1
I know I must upgrade but I have a hard time getting to install Gambas2 then.

Original comment by r...@cyberjunky.nl on 19 Jun 2012 at 9:08

GoogleCodeExporter commented 9 years ago 
So that's not that (gnome keyring is a Gnome2 thing). Do you see any reason why 
your gnome keyring cannot be accessed?

Original comment by benoit.m...@gmail.com on 19 Jun 2012 at 9:26

GoogleCodeExporter commented 9 years ago 
No, I use it for my svn commit passwords, so it works as the user I run gambas3 
with.

Looking at the source code I find, this return fails:

    Case "GNOME", "LXDE"

      Return _Keyring.GetPassword(Key)

How can I test this?

Original comment by r...@cyberjunky.nl on 20 Jun 2012 at 3:39

GoogleCodeExporter commented 9 years ago 
I am also in the same situation. I wan to set up a code forge for the Spanish 
Community using gambasForge, but I'm facing the same problems.

Gambas 3.2.x rev #4904

[System]
OperatingSystem=Linux
Kernel=3.2.0-23-generic
Architecture=i686
Memory=2061788 kB
DistributionVendor=LinuxMint
DistributionRelease="Linux Mint 13 Maya"
Desktop=Mate <--- not detected, so hand written

[Gambas 2]
Version=2.23.1
Path=/usr/bin/gbx2

[Gambas 3]
Version=3.2.0
Path=/usr/local/bin/gbx3

[Libraries]
Qt4=libQtCore.so.4.8.1
GTK+=libgtk-x11-2.0.so.0.2400.10

gnome-keyring and mate-keyring are installed on my system. Looking the Web for 
an answer to a possible bug in Mate desktop, I've found this:

http://community.linuxmint.com/tutorial/view/848

But after following all these steps, nothing changes. Still got the 
"_Desktop_Passwords._get.62: Unable to get password" error. 

Hope this helps somehow...

Original comment by ea7...@gmail.com on 8 Jul 2012 at 11:52

GoogleCodeExporter commented 9 years ago 
To ea7dfh@gmail.com, you might try compiling from the latest svn. I had the 
same problem while using Mate and the problem was resolved. I am now able to 
save and retrieve passwords without error.

Original comment by green.da...@gmail.com on 8 Jul 2012 at 1:03

GoogleCodeExporter commented 9 years ago 
Hi Danny

Indeed, I was using latest revision 3 hours ago. Just in case I've updated to 
latest one (#4909) and the error persists. I've disabled the keyring at all, to 
no avail. Please, what other things have you done since this worked again?

 To the developers, do you need any other information?

Original comment by ea7...@gmail.com on 8 Jul 2012 at 3:36

GoogleCodeExporter commented 9 years ago 
Although I was able to bypass the issue by deleting and recreating the 
connection file (in the gambasforge project) here is a bit of information I've 
research:

Tested on Debian Squeeze with an old revision 4793 didn't solve the issue. 
Updated to latest svn, also the same problem. The content of the original 
"GambasForge.connection" file was:

# Gambas Connection File 3.0
    [Connection]
    Type="mysql"
    Host="localhost"
    User="root"
    RememberPassword=True
    IgnoreCharset=True
    Database="GambasForge"

Deleting connection file and creating a new one solves this problem. Of course, 
its contents is the same in both files, old and newer. Tested on Squeeze and 
Linux Mint 13. Perhaps we'll never know ;-)

Thanks anyway, now I'm struggling on how to install GambasForge on my test 
server

Original comment by ea7...@gmail.com on 8 Jul 2012 at 6:05

GoogleCodeExporter commented 9 years ago

Original comment by benoit.m...@gmail.com on 15 Jul 2012 at 10:19

GoogleCodeExporter commented 9 years ago

Original comment by benoit.m...@gmail.com on 15 Jul 2012 at 10:56

GoogleCodeExporter commented 9 years ago 
Same issue.
Once a connection has been created, when running the app it cannot connect to 
mysql server.

Here is my system info:

[System]
OperatingSystem=Linux
Kernel=3.2.0-35-generic
Architecture=x86_64
Memory=3965768 kB
DistributionVendor=Ubuntu
DistributionRelease="Ubuntu 12.04.1 LTS"
Desktop=Gnome

[Gambas 3]
Version=3.3.4
Path=/usr/local/bin/gbx3

[Libraries]
Qt4=libQtCore.so.4.8.1
GTK+=libgtk-x11-2.0.so.0.2400.10

Original comment by mig...@gmail.com on 1 Jan 2013 at 1:33

GoogleCodeExporter commented 9 years ago 
More info about the error. This is the error message:
gb.db: warning: unable to retrieve connection password: mydatabase/Connection1: 
Unknown symbol 'Passwords' in class 'Desktop'

Original comment by mig...@gmail.com on 1 Jan 2013 at 1:36

GoogleCodeExporter commented 9 years ago 
I am having the same problem, It seems to be random, in that I create a data 
source and add the connection and Table, but some times this does not happen 
untill after I add the data view and col definitions.... after that I get the 
error  as described by others, but all the time I am able to use the connection 
in my project to access the tables add data etc, also the sample mysql program 
crashes with an illegal call as follows

modMain.Main.41::'Form.Refresh' is incorrectly overridden in class 'FTables'

Here is the information requested

[System]
OperatingSystem=Linux
Kernel=3.4.28-2.20-default
Architecture=i686
Memory=2065720 kB
DistributionVendor=SuSE
DistributionRelease=openSUSE 12.2 (i586)
VERSION = 12.2
CODENAME = Mantis
Desktop=KDE4

[Gambas 3]
Version=3.3.4
Path=/usr/bin/gbx3

[Libraries]
Qt4=libQtCore.so.4.8.1
GTK+=libgtk-x11-2.0.so.0.2400.10

Simple application
   new database program, add connection, add data source, configure(set connection and table), add dataview. configure(set table)

That's it, I can not get any further!

Original comment by justlost...@gmail.com on 14 Feb 2013 at 6:30

GoogleCodeExporter commented 9 years ago 
This is the message from the compiled program:

Cannot open database: Access denied for user 'root'@'localhost' (using 
password: NO).
Common.CheckDB.34

Original comment by justlost...@gmail.com on 14 Feb 2013 at 6:44

GoogleCodeExporter commented 9 years ago 
I have the same problem. I have migrated from Xubuntu to Linux Mint 17 KDE, but 
the problem persists. First, do not save passwords in XCFE knew. Out of bounds, 
he said. Then So, I tried KDE. I have kwallet disabled, and now the problem is 
that it does not handle well the sql user passwords. When I establish a 
connection, it seems to work, I have access to the tables and the data stored 
on them. But when I run the program, I get the hateful warning.
gb.db: warning: unable to retrieve connection password: Dams / Connection1: 
Unknown symbol 'Passwords' in class 'Desktop'

It is a problem Gambas? Or all desktops I've tried?

Original comment by raulmm...@gmail.com on 9 Sep 2014 at 10:57

Attachments:

GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
The message is incorrect. Your project actually needs the 'gb.desktop' 
component to be able to access the database passwords stored in the KDE wallet 
/ GNOME keyring.

As for XFCE, I don't know if it has something like a specific password wallet.

At the moment, if the desktop is KDE/KDE4, the KDE wallet is used. Otherwise 
the GNOME 2 keyring is used.

Original comment by benoit.m...@gmail.com on 14 Sep 2014 at 3:14

GoogleCodeExporter commented 9 years ago 
hi  guy  i have  the same  problem (use gambas 3 ) , common.checkdb.34 i  use  
lubuntu 14  and  i add component  gb.desktop , and gb.desktop.gnome ,  but  
have  the  same problem  , somthing  have  some idea''

Original comment by eofficec...@gmail.com on 9 Dec 2014 at 11:10