Bug 106942 - failure connecting to mysql engine as root with valid password, cli and gui
Summary: failure connecting to mysql engine as root with valid password, cli and gui
Status: CLOSED WORKSFORME
Alias: None
Product: KEXI
Classification: Applications
Component: General (show other bugs)
Version: unspecified
Platform: Debian testing Linux
: NOR crash
Target Milestone: ---
Assignee: Jarosław Staniek
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-06-07 07:58 UTC by Hugh Esco
Modified: 2016-01-29 19:57 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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