LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 11-25-2010, 04:40 PM   #1
jfraymondpa
Member
 
Registered: Oct 2005
Location: Northeast PA
Distribution: Fedora 15/Ubuntu 10.10
Posts: 53

Rep: Reputation: 15
OO Base to MYSQL login error


I am trying to connect from OO Base to an existing MYSQL Database. I get this error (see attachment)
when I try the "Test Connection" from the login page.
I'm able to access the database either from the command line or from MYSQL Query using the same id and password.
I've double checked the "jar" and "jre" all seem to work correctly.

Any help is greatly appreciated.
John
Attached Thumbnails
Click image for larger version

Name:	LoginError.png
Views:	11
Size:	15.9 KB
ID:	5317  

Last edited by jfraymondpa; 11-25-2010 at 04:42 PM.
 
Old 11-25-2010, 06:26 PM   #2
paulsm4
LQ Guru
 
Registered: Mar 2004
Distribution: SusE 8.2
Posts: 5,863
Blog Entries: 1

Rep: Reputation: Disabled
Q: Have you followed any variation of these instructions:
http://wiki.services.openoffice.org/...MySQL_and_Base

Q: Specifically, have you downloaded and verified either the ODBC or JDBC connectors for MySQL?

Q: What is the exact connection string that's failing?
 
Old 11-26-2010, 07:53 AM   #3
jfraymondpa
Member
 
Registered: Oct 2005
Location: Northeast PA
Distribution: Fedora 15/Ubuntu 10.10
Posts: 53

Original Poster
Rep: Reputation: 15
Quote:
Originally Posted by paulsm4 View Post
Q: Have you followed any variation of these instructions:
http://wiki.services.openoffice.org/...MySQL_and_Base

Q: Specifically, have you downloaded and verified either the ODBC or JDBC connectors for MySQL?

Q: What is the exact connection string that's failing?
Q1 - Yes, that is the site I got the instructions from.
Q2 - Yes, for the JDBC connector.
Q3 - That's the rub, all I see is that error message. Any idea where to look for the SQL that's being sent?

-- John
 
Old 11-26-2010, 12:06 PM   #4
paulsm4
LQ Guru
 
Registered: Mar 2004
Distribution: SusE 8.2
Posts: 5,863
Blog Entries: 1

Rep: Reputation: Disabled
Hi -

This is the error in your screenshot:
Quote:
You have an error in your SQL syntax; check the manual that corresponds to your MySql server version for the right syntax to use near '????????????????' at line 1
It sounds like it might be a language configuration issue.

Please try this (assuming that UTF8 is what you want):
Quote:
http://forums.mysql.com/read.php?39,...751#msg-283751

Go to the [mysqld] section in my.cnf and add two strings:

collation_server=utf8_general_ci
character_set_server=utf8
As far as SQL tracing, try setting "profileSQL=true" in your JDBC connection properties:
http://dev.mysql.com/doc/refman/5.0/...roperties.html

'Hope that helps

Last edited by paulsm4; 11-26-2010 at 12:08 PM.
 
1 members found this post helpful.
Old 11-26-2010, 12:46 PM   #5
jfraymondpa
Member
 
Registered: Oct 2005
Location: Northeast PA
Distribution: Fedora 15/Ubuntu 10.10
Posts: 53

Original Poster
Rep: Reputation: 15
Paul --

Thanks, the utf8 lines fixed the problem.

-- John
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. SpellChainz Linux - Newbie 1 06-23-2007 03:35 PM
Mysql directory base brazilian_user Debian 5 05-22-2007 08:24 AM
dovecot 1 login error with mysql cope Linux - Software 0 04-19-2007 12:20 AM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 08:44 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 12:59 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration