Re: [libreoffice-users] Re: Problem with MySQL after upgrading OpSys
Thanks to all who offered assistance with this problem. A couple of days back I decided to attack from a different direction. After all the Change this, Tweak that, Edit such-and-such file etc etc I figured that things were starting to get really messy. So the answer should be - Start again from a clean slate!! I re-installed the OpSys and ran through all my set-up steps again. Now everything seems to be working fine again!! I guess some minor hiccup in the original installation of the new OpSys triggered the whole thing. Will advise If I come across any funnies!! Thanks again to all who helped out - greatly appreciated!! IanW Pretoria RSA -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: Problem with MySQL after upgrading OpSys
Le 12/03/2013 15:37, Tom Davies a écrit : Hi Tom, My quick, probably inaccurate guess is the connector. Is the system 32 or 64bit? Clearly a GnuLinux. Is the MySql on the same computer or on a separate server? It has nothing to do with the connector. We are talking about the (in)correct setup of the combination : - web server (apache or lighttpd ?) ; - mysql server ; - PDO or PDI or mysqli PHP and/or apache modules ; - phpmyadmin (which is called MyAdmin in PCLinuxOS - a dumbass name change for no apparently good reason IMHO, but hey) Ian has established that he can access his mysql server from the command line, so the daemon is running. However, what he has not shown us, and the following is directed to you, Ian : - is the apache daemon (web server) running - my guess is yes, if the phpmyadmin login page actually loads ? - which modules are installed in the web server ? - which PHP version and libraries (modules/plugins) are installed ? The error message that Ian posted is well known, a cursory search on Google brings up : http://stackoverflow.com/questions/13357561/error-1045-cannot-log-in-to-mysql-server-phpmyadmin and http://forums.macrumors.com/showthread.php?t=1228893 just for starters. Things to remember : - phpmyadmin needs to have an id/pwd combo in order to be able to communicate with the mysql server. Usually, this is asked for by the post-installation scripts of the distrib you are using, but sometimes, this can go wrong, leading the user to think that phpmyadmin has been installed and configured successfully when in fact it has not. After all, the whole point of phpmyadmin is to be able to administer your mysql server via a web interface, so it generally requires extensive privileges at the mysql user account level ; - the file config.inc.php, which is required in order to be able to log into the mysql server from the php scripts. Sometimes, this file does not get copied, or configured correctly, resulting in the inability to log in - the most frequent reason is that this file contains wrong or absent information for a default pwd/id combo (hence the links above explaining this point); - as Girvin mentioned, the my.cnf options have changed in more recent versions of mysql with regard to network access, both locally and remotely, meaning that even on a locally hosted mysql server instance, it can be necessary to change the my.cnf file in order to get access via TCP, even from a local IP address such as 127.0.0.1 Alex -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: Problem with MySQL after upgrading OpSys
Thanks Girvin and Alex (I wont echo all your comments here) OK - I'm using MySQL 5.1.55 and phpMyAdmin 3.5.4. Everything is on 'localhost' with just me as the user. I've just checked in PCC and both httpd and MySQL are set to Start on Boot and are running. I found my config.inc.php file (I do not seem to have a config.sample.inc.php file that I can rename!!) and this is what it contains ... /?php// ///* vim: set expandtab sw=4 ts=4 sts=4: */// ///**// // * Config file view and save screen// // *// // * @package PhpMyAdmin-setup// // */// // //if (!defined('PHPMYADMIN')) {// //exit;// //}// // ///**// // * Core libraries.// // */// //require_once './libraries/config/FormDisplay.class.php';// //require_once './setup/lib/index.lib.php';// //require_once './setup/lib/ConfigGenerator.class.php';// // //$config_readable = false;// //$config_writable = false;// //$config_exists = false;// //check_config_rw($config_readable, $config_writable, $config_exists);// //?// //h2?php echo __('Configuration file') ?/h2// //?php display_form_top('config.php'); ?// //input type=hidden name=eol value=?php echo htmlspecialchars(PMA_ifSetOr($_GET['eol'], 'unix')) ? /// //?php display_fieldset_top('', '', null, array('class' = 'simple')); ?// //tr// //td// //textarea cols=50 rows=20 name=textconfig id=textconfig spellcheck=false?php// //echo htmlspecialchars(ConfigGenerator::getConfigFile())// //?/textarea// ///td// ///tr// //tr// //td class=lastrow style=text-align: left// //input type=submit name=submit_download value=?php echo __('Download') ? class=green /// //input type=submit name=submit_save value=?php echo __('Save') ??php if (!$config_writable) echo ' disabled=disabled' ? /// ///td// ///tr// //?php// //display_fieldset_bottom_simple();// //display_form_bottom();// //?/ I added in the following two lines .. /$cfg['Servers'][$i]['root'] = 'root';// //$cfg['Servers'][$i]['password'] = 'x';/ I then tried again to log in via phpMyAdmin. The screen does start OK and I enter 'root' as the user and 'x' as the Password but still get the same error (1045)!! I've re-read all the links you sent me but other than renaming the sample file (which I don't have) I can see no other suggestion. Thanks Guys. IanW Pretoria RSA -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: Problem with MySQL after upgrading OpSys
Le 13/03/13 14:54, Ian Whitfield a écrit : Hi Ian, I added in the following two lines .. /$cfg['Servers'][$i]['root'] = 'root';// //$cfg['Servers'][$i]['password'] = 'x';/ I then tried again to log in via phpMyAdmin. The screen does start OK and I enter 'root' as the user and 'x' as the Password but still get the same error (1045)!! You need to have a mysql user account where the user is root and the password is x (or whatever password you have declared for the root user in your mysql server privilege tables. I was also thinking back to something you mentioned in an earlier mail. You said you started the mysqld server with --skip-privileges, but did you then set up the various user accounts and privileges and restart the mysql server in normal mode (i.e. without skipping privileges) ? If you start the mysql server with --skip-privileges, then the user permissions table is ignored, but then I don't think that will work with phpmyadmin. Alex -- For unsubscribe instructions e-mail to: users+h...@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