Re: [libreoffice-users] Connecting LO Base to an SQL DB

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_ stored the link in it's Driver Class!! After a couple of 
> re-tries it now seems to have done that and I can now get past the 
> 'Test Class' stage OK!!!
>
> The next screen is 'Authentication' - I enter the User Name and select 
> "Test Connection" and I get
>
>    Communication Link Failure
>    The last packet sent successfully to the Server was 0 milliseconds 
> ago.
>    The driver has not received any packets from the Server.
>
> OK - Now I'm stuck again...... My Database (Schema) was called 
> 'federals_Members.sql' when I first created it but last week I had to 
> re-install my OpSys and to get it back into MyAdmin I had to import it 
> and it's now there called 'Test'!! Neither of the above two file names 
> make any difference to the error message.
>
> Next the User Name - In My Admin it is 'root', when I set-up the 
> Database I used 'Ianw' and my System login is 'Ianw' also. Again 
> neither of these changes the error message.
>
> To check I started MyAdmin and it connects fine with the Database and 
> displays the table structure just fine.
>
> So why wont Base connect to it???
>
> Thanks
>
> IanW
     I see you created a user name 'lanw' in My Admin. That is a good 
start. You also have to use My Admin to define what schema 'lanw' can 
access. Then you need to define what privileges 'lanw' should have for 
the databases in those schema.
     I can not be very specific because I no longer use MySQL 5.1. When 
I updated my Ubuntu OS, it installed MySQL 5.6. But I do know from 
personal experience that you can not access a database using a user name 
until you have entered what Schema it can access and what privileges it 
has for specific databases within the schema for which it has access.

--Dan

--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted