Bug 106942

Summary:	failure connecting to mysql engine as root with valid password, cli and gui
Product:	[Applications] KEXI	Reporter:	Hugh Esco <hesco>
Component:	General	Assignee:	Jarosław Staniek <staniek>
Status:	CLOSED WORKSFORME
Severity:	crash	CC:	daniel.moyne
Priority:	NOR
Version First Reported In:	unspecified
Target Milestone:	---
Platform:	Debian testing
OS:	Linux
Latest Commit:		Version Fixed/Implemented In:
Sentry Crash Report:

Description Hugh Esco 2005-06-07 07:58:35 UTC

Version:           0.1 (using KDE KDE 3.3.2)
Installed from:    Debian testing/unstable Packages
Compiler:          3.3.5 Reading specs from /usr/lib/gcc-lib/i486-linux/3.3.5/specs
Configured with: ../src/configure -v --enable-languages=c,c++,java,f77,pascal,objc,ada,treelang --prefix=/usr--mandir=/usr/share/man --infodir=/usr/share/info --with-gxx-include-dir=/usr/include/c++/3.3 --enable-shared--enable-__cxa_atexit --with-system-zlib --enable-nls --without-included-gettext --enable-clocale=gnu --enable-debug --enable-java-gc=boehm --enable-java-awt=xlib --enable-objc-gc i486-linux
Thread model: posix
gcc version 3.3.5 (Debian 1:3.3.5-12)
OS:                Linux

gui window with error message: 
Could not connect to "root@localhost" database server. 

both when I run:  
kexi -dbdriver mysql -user root -createdb mydb 
and when invoked from gui, it says:  
Could not connect to "localhost" database server.

CLI stderr: 
kexi: ARGC==1
kexi: ARG0= mydb
kexi: Manager::lookup(): kexi/table
kexi: Manager::lookup(): kexi/form
kexi: Manager::lookup(): kexi/report
kexi: Manager::lookup(): kexi/query
kexi: Manager::lookup(): kexi/relation
kexi: Manager::lookup():
kexi: Manager::lookup(): inserting info to kexi/table
kexi: Manager::lookup(): inserting info to kexi/query
kexi: Manager::lookup(): inserting info to kexi/form
kexi: Manager::lookup(): inserting info to kexi/relation
KexiDB (driver impl): MySqlDriver::MySqlDriver()
KexiDB (driver impl): MySqlConnectionInternal::connect()
KexiDB (driver impl): MySqlConnection::disconnect()
KexiDB: Object ERROR: 1045:
KexiDB: Object ERROR: 0:
 and it hangs until I ok the error, then prints: 

kexi: KexiProject::createConnection(): error connecting:
and returns a prompt.  

When using the postgres, (of which I am unsure about my configurations privileges), the gui error reads:  
Could not create project "mydb" 
Error during starting temporary connection using "template1" database name.
Server result number:
0

Comment 1 Jarosław Staniek 2005-06-07 11:16:38 UTC

Are you using local MySQL socket or a port for your local connection?
If you're using a port, try to add --port <number> option.

Anyway, try to play with connection shortcut file, where you can set all the options permamently:

http://www.kexi-project.org/wiki/wikiview/index.php?Startup%20Options#Using_.KEXIS_shortcut_files

Comment 2 Jarosław Staniek 2005-06-07 11:18:28 UTC

BTW, is this an application crash or connection problem?

Comment 3 Jarosław Staniek 2005-06-07 11:19:55 UTC

what

kexi --version

returns?

Comment 4 Hugh Esco 2005-06-07 14:34:01 UTC

I tried the connection dialog and the command line --port 3306.  Both
led to application crashes.  I'm using version 0.10 as mentioned in last
night's bug report.  

-- Hugh

Comment 5 Jarosław Staniek 2005-06-07 14:49:17 UTC

Please download and try most recent Kexi version: 

http://www.kexi-project.org/wiki/wikiview/index.php?Download

Too many things have been changed since 0.1 series.

Comment 6 Hugh Esco 2005-06-07 15:08:21 UTC

Perhaps, but that was what Debian / testing gave me to work with.  

-- Hugh

Comment 7 Jarosław Staniek 2005-06-07 15:14:09 UTC

Without a backtrace I cannot say too much, so if all new kexi versions crases for you may need a version with debug info, i.e. compiled by hand, what's not actually hard especially if you're planning to test/use Kexi also in the future.

Comment 8 Martin Ellis 2005-10-24 20:22:27 UTC

Hi,

Is this bug still present with the current version in unstable (0.9)?

Note that:
> kexi -dbdriver mysql -user root -createdb mydb 
should probably be
> kexi --dbdriver mysql --user root --createdb mydb 

Also, if you still get this error:
> and when invoked from gui, it says:   
> Could not connect to "localhost" database server. 
it may be because localhost is not the first name after 127.0.0.1
in your /etc/hosts file.

Comment 9 Jarosław Staniek 2005-12-09 11:15:16 UTC

Cuuld not reproduce on recent version (SVN trunk).

Comment 10 dmoyne 2008-09-06 19:11:14 UTC

I confirm similar bug : when connecting to existing MtSQL database with valid root username and password the app freezes ; same when testing connection to data base though the window says that connection was succesfull
Regards