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

Hi Ian,
I don't use MyAdmin but prefer to use the mysql command-line client. This may
be a "fad" of mine, but I like to have "total control" of what I do by using
bare-bone commands...
Could it be that you have to specify something in the php.ini configuration
file regarding mysqli?
Regarding your connection problem: provided that you have added the .jar file
for the JDBC-connector (which it seems you have done!) the situation seems to most
likely have to do with missing privileges for your userid ianw, since I do assume
you entered the password when trying to connect to the server via LO-Base.
Sorry I can't be of more help. Good luck in any case.
Regards from snowed-in Salzburg
Heinrich

P.S.: below is a snippet of my php.ini
-------------------------------------------------------------------------
[MySQLi]

; Maximum number of persistent links.  -1 means no limit.
; http://php.net/mysqli.max-persistent
mysqli.max_persistent = -1

; Allow accessing, from PHP's perspective, local files with LOAD DATA statements
; http://php.net/mysqli.allow_local_infile
;mysqli.allow_local_infile = On

; Allow or prevent persistent links.
; http://php.net/mysqli.allow-persistent
mysqli.allow_persistent = On

; Maximum number of links.  -1 means no limit.
; http://php.net/mysqli.max-links
mysqli.max_links = -1

; If mysqlnd is used: Number of cache slots for the internal result set cache
; http://php.net/mysqli.cache_size
mysqli.cache_size = 2000

; http://php.net/mysqli.cache_size
mysqli.cache_size = 2000

; Default port number for mysqli_connect().  If unset, mysqli_connect() will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
; compile-time value defined MYSQL_PORT (in that order).  Win32 will only look
; at MYSQL_PORT.
; http://php.net/mysqli.default-port
mysqli.default_port = 3306

; Default socket name for local MySQL connects.  If empty, uses the built-in
; MySQL defaults.
; http://php.net/mysqli.default-socket
mysqli.default_socket =

; Default host for mysql_connect() (doesn't apply in safe mode).
; http://php.net/mysqli.default-host
mysqli.default_host =

; Default user for mysql_connect() (doesn't apply in safe mode).
; http://php.net/mysqli.default-user
mysqli.default_user =

; Default password for mysqli_connect() (doesn't apply in safe mode).
; Note that this is generally a *bad* idea to store passwords in this file.
; *Any* user with PHP access can run 'echo get_cfg_var("mysqli.default_pw")
; and reveal this password!  And of course, any users with read access to this
; file will be able to reveal the password as well.
; http://php.net/mysqli.default-pw
mysqli.default_pw =

; Allow or prevent reconnect
mysqli.reconnect = Off
------------------------------------------------------------------------------




On Wed, 20 Feb 2013 11:52:42 +0100, Ian Whitfield <whitfield@telkomsa.net> wrote:

> Hi All
>
> (In particular I hope *Heinz* picks this up as he was so helpful last
> time!!)
>
> I have just upgraded my PClinuxOS system with the latest 2013.02
> version. To do this I used an ISO disk and ran the upgrade without
> overwriting or formatting 'home' to preserve my data etc. It installed
> perfectly and almost all my stuff is available and working.
>
> The two areas I have problems with are -
> 1) I have no sound (but will work on that later).
> 2) More importantly I can not access my MySQL Database!!
>
> MySQL is part of the new installation and I have set it to 'Start on Boot'.
> I re-installed MyAdmin via Synaptic
> I should have the Connector in the installation.
> I edited out the "skip networking" line in /etc/my.cnf
>
> Now if I try to run MyAdmin I get the error ...
>
> /"//The mysqli extension is missing. Please check your PHP
> configuration. <a href="Documentation.html#faqmysql"
> target="documentation"><img src="themes/dot.gif" title="Documentation"
> alt="Documentation" class="icon ic_b_help" /></a>"/
>
> So I installed mysqli via Synaptic, did a re-boot and tried again but
> still get the same error!!
>
> I decided to move on anyway and started Base, selected Connect to
> existing database, using JDBC, entered DB Name, localhost, port 3306 and
> tested the connection. It gives me "JDBC Driver loaded OK"
>
> I accepted the Driver Class and tested and I get the error ...
>
> /"Error code: 1045//
> //Access denied for user 'ianw'@'localhost' (using password: YES)"/
>
> Where have I gone wrong or can you see any errors on my part??
>
> This MySQL Database was working perfectly before I upgraded the OpSys!!
>
> Very many thanks as always!!
>
> IanW
> Pretoria RSA


--
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/

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