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

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, like my Slackware 
> system, you probably have a system script somewhere that starts 
> mysqld.  The --skip-networking may be in that script.  In Slackware, 
> it is "/etc/rc.d/rc.mysql" which has a macro definition in the 
> beginning: "SKIP=--skip-networking".  Simply commenting that line out 
> with a # in column one enables network (localhost) access.  You might 
> check for something like that on your system. 

I do _NOT_ have this file in my system. I did a search and found this ...

# Shorewall version 4 - MySQL Macro
#
# /usr/share/shorewall/macro.MySQL
#
#    This macro handles connections to the MySQL server.
#
###############################################
#ACTION    SOURCE    DEST    PROTO    DEST    SOURCE    RATE USER/
#                PORT(S)    PORT(S)    LIMIT    GROUP
PARAM    -    -    tcp    3306


> Before first MySQL use, at the shell enter:
>      "mysql_secure_installation" to set the root password, remove the
>      "test" database, and remove network root access. This program will
>      prompt for these items.  Note that removing network root access
>      only applies to remote root MySQL logins, it does not disable all
>      network access as in --skip-networking.

This all worked fine and I entered and got back 'OKs" for all the GRANT 
and CREATE commands.

> Assuming LO Base is already setup, in Base drill down as:
>
>    Edit -> Database -> Connection Type  -> Next -> Test Connection
>    (enter your password when asked)
>
>    You should get the message: "...connection was established 
> successfully"

Started Base and selected my old DB to get to the Edit screen - BUT when 
I go there "Connection Type" is grayed out!!
Tried again selecting the new SQL DB but again the "Connection Type" is 
grayed out!!

Carried on with the Base page and put in all the details - 'Test Class' 
gives me "Succesful"
But 'Test Connection' still gives me the "Communication Failure"!!

> You might also check the MySQL error log in 
> "/var/lib/mysql/<hostname>.err".  You might find something useful there.
> Also, verify "/var/lib/mysql" has owner and group settings of 
> "mysql:mysql"

The var/lib/mysql Folder is there but is EMPTY(??)!!!!! (and has no 
permissions) and I can not delete it.

So we come to a grinding halt yet again!!??

Thanks for the help though - any thoughts???

InW
Pretoria RSA



--
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