On Tue, Nov 6, 2012 at 2:41 AM, Ian Whitfield whitfi...@telkomsa.netwrote:
Thanks Guys!! (Girvin, Henirich, Dan, Mas and maybe others!!)
You have all added some pieces to the Jigsaw and I'm pleased to say..
*I now have Base working with a MySQL Database (at last!!)*
As Girvin would
Hello LibO experts,
and congratulations IanW!
It has been very interesting to follow this discussion getting Base
working with MySQL.
Unfortunately -- if I got it right - is Ian's OS a Linux (Ubuntu?)
Would it be possible to get the same proceeding described as a
step-by-step instruction for
On 11/06/2012 11:34 AM, Pertti Rönnberg wrote:
Hello LibO experts,
and congratulations IanW!
It has been very interesting to follow this discussion getting Base
working with MySQL.
Unfortunately -- if I got it right - is Ian's OS a Linux (Ubuntu?)
Would it be possible to get the same
The way I extracted my data was to right-click on each table and copy, and
then open a new spreadsheet and paste. Once in the spreadsheet you can then
save as CSV for easy importing into MYSQL.
On 6 November 2012 10:10, Ian Whitfield whitfi...@telkomsa.net wrote:
On 11/06/2012 11:34 AM, Pertti
Hello Pertti,
Just for kicks: I used to personally know some of the old IBMers who
actually invented SQL, in particular DB2. That's a long time ago though...
I have LO running on Linux-Debian, Linux-Mint, and Windows/Vista (32 Bit).
The MySQL server runs on Linux, the clients run on all of these
On 11/06/2012 02:41 AM, Ian Whitfield wrote:
Thanks Guys!! (Girvin, Henirich, Dan, Mas and maybe others!!)
You have all added some pieces to the Jigsaw and I'm pleased to say..
*I now have Base working with a MySQL Database (at last!!)*
As Girvin would say My Bad!! I had been looking
Base as a stand alone refers to embedded databases (the database
data is contained in the database file. This type of database can lose data.
However, this does not mean that you have to use MySQL,
Presgresql, or Oracle, ... Nor do you have to install a JDBC or ODBC
driver for Base to
Thank you Dan, IanW and Heinrich
for your kind answering and encouraging!
The other day when some spare time I shall study your advice and try again.
Is it not fantastic that we like this can discuss things all across the
word!!!
Pertti Rönnberg (Finland)
On 6.11.2012 15:12, Dan Lewis wrote:
http://wiki.documentfoundation.org/Documentation/Publications
This is the link to the LibreOffice guides. The Base section
contain links to the first 3 chapters of the Base Guide. Chapter 1 has
been published. Chapter 2 3 are still in draft form.
--Dan (Eastern US)
On 11/06/2012 10:29
Sent: Tuesday, 6 November 2012, 19:38
Subject: Re: [libreoffice-users] Connecting LO Base to an SQL DB [SOLVED]
http://wiki.documentfoundation.org/Documentation/Publications
This is the link to the LibreOffice guides. The Base section contain
links to the first 3 chapters of the Base
Ian Whitfield wrote:
Thanks Guys!! (Girvin, Henirich, Dan, Mas and maybe others!!)
You have all added some pieces to the Jigsaw and I'm pleased to say..
*I now have Base working with a MySQL Database (at last!!)*
snip
IanW
Pretoria RSA.
Ian,
Glad to hear you got it working.
Thanks Guys!! (Girvin, Henirich, Dan, Mas and maybe others!!)
You have all added some pieces to the Jigsaw and I'm pleased to say..
*I now have Base working with a MySQL Database (at last!!)*
As Girvin would say My Bad!! I had been looking for the file 'my.cfg'
when it should have
On 2012-11-06 20:41, Ian Whitfield wrote:
Thanks Guys!! (Girvin, Henirich, Dan, Mas and maybe others!!)
You have all added some pieces to the Jigsaw and I'm pleased to say..
*I now have Base working with a MySQL Database (at last!!)*
As Girvin would say My Bad!! I had been looking
Thanks once again Girvin
On 11/03/2012 11:30 PM, Girvin R. Herr wrote:
1. Look at /etc/my.cfg, the mysqld configuration file.
I have searched my whole drive and can not find a file with this name (??)
[even after running mysql_install_db as mentioned below - No such file
on my system!!]
Ian,
The file is called my.cnf (NOT my.cfg!) on my system.
Regards
H
On Sun, 04 Nov 2012 10:59:04 +0100, Ian Whitfield whitfi...@telkomsa.net
wrote:
Thanks once again Girvin
On 11/03/2012 11:30 PM, Girvin R. Herr wrote:
1. Look at /etc/my.cfg, the mysqld configuration file.
I have
Thanks Girvin!!!
I had decided last night that I would completely remove phpMyAdmin today
and try again and then your valuable info came into me this morning so I
thought - This *IS* the way to go!!
On 11/02/2012 08:37 PM, Girvin R. Herr wrote:
If mysqld starts automatically at boot, then,
UPDATE TO PREVIOUS POST
After opening MyAdmin and importing my 'empty' Table I find that Base
now allowed me to go right through the connection process and asks me
where I want to store the DB.
*BUT* When I go there and select it it opens and asks me for password
and after that gives me the
On Nov 3, 2012 7:40 AM, Ian Whitfield whitfi...@telkomsa.net wrote:
UPDATE TO PREVIOUS POST
After opening MyAdmin and importing my 'empty' Table I find that Base now
allowed me to go right through the connection process and asks me where I
want to store the DB.
*BUT* When I go there and
On 11/03/2012 06:35 PM, Mas wrote:
Are you able to connect to mysql via the command line?
Yes Mas, (as far as I understand it)
See below for terminal input/Output...
[ian@localhost ~]$ mysql --user=root -p mysql
Enter password:/[entered password]/
Welcome to the MySQL monitor.
Ian,
It sounds like you are getting close, but there is still something
blocking your access to the MySQL server (mysqld). All of these
symptoms sure sound like the server is not looking at the localhost port.
Ian Whitfield wrote:
snip
I do _NOT_ have this file in my system. I did a search
On 11/01/2012 11:14 PM, Girvin R. Herr wrote:
Ian,
Are you starting mysqld with --skip-networking?
If so, then remove it for localhost access. LO Base uses localhost
to access mysqld and will give a failed to connect error if it can't
connect via localhost. MyAdmin does not use localhost to
Ian Whitfield wrote:
On 11/01/2012 11:14 PM, Girvin R. Herr wrote:
Ian,
Are you starting mysqld with --skip-networking?
If so, then remove it for localhost access. LO Base uses localhost
to access mysqld and will give a failed to connect error if it can't
connect via localhost. MyAdmin
On 10/31/2012 07:28 PM, Heinrich Stoellinger wrote:
Hi Ian,
To be honest - I am somewhat confused regarding the issue of where is
the
native connector! It might be that going to extensions and then
download/installing
the native connector (for OpenOffice) does the trick. On the other
hand, I
Thanks Heinz
Well I even went off this morning looking at 'other' solutions for this
and it seems to be - Use Base or go and learn PHP or Ruby or something
like that!!
So I got into Base again and found an interesting fact - Base had _NOT_
stored the link in it's Driver Class!! After a
November 2012, 12:42
Subject: Re: [libreoffice-users] Connecting LO Base to an SQL DB
Thanks Heinz
Well I even went off this morning looking at 'other' solutions for this and it
seems to be - Use Base or go and learn PHP or Ruby or something like that!!
So I got into Base again and found
Ian Whitfield wrote:
Thanks Heinz
Well I even went off this morning looking at 'other' solutions for
this and it seems to be - Use Base or go and learn PHP or Ruby or
something like that!!
So I got into Base again and found an interesting fact - Base had
_NOT_ stored the link in it's
On 11/01/2012 08:42 AM, Ian Whitfield wrote:
Thanks Heinz
Well I even went off this morning looking at 'other' solutions for
this and it seems to be - Use Base or go and learn PHP or Ruby or
something like that!!
So I got into Base again and found an interesting fact - Base had
_NOT_
Hi All
Am trying to use Base with a MySQL Database and need help please.
OpSys - PCLinux 2012-6 KDE
LO - Version 3.6.2.2
My SQL is installed and running.
MyAdmin is installed (and I have created an empty Database with this)
MySQL connector - Downloaded 'mysql-connector-java-5.1.22'
Restarted LO
Hello Ian,
Just one question: the native MySQL-Connector should be included in
3.6.2. I had a lot of trouble in the past with it, but now it seems to be
the best choice of all the possible connectors (Native, ODBC, JDBC).
In any case, reading through your steps - I think that
- the database name
On 10/31/2012 05:27 PM, Heinrich Stoellinger wrote:
Just one question: the native MySQL-Connector should be included in
3.6.2. I had a lot of trouble in the past with it, but now it seems to be
the best choice of all the possible connectors (Native, ODBC, JDBC).
In any case, reading through your
Hi Ian,
To be honest - I am somewhat confused regarding the issue of where is the
native connector! It might be that going to extensions and then
download/installing
the native connector (for OpenOffice) does the trick. On the other hand, I think
that it should come automatically with the newest
31 matches
Mail list logo