Guest seanbracken Posted December 18, 2005 Report Share Posted December 18, 2005 Hi, I've just upgraded from Mandrake 10.1 to Mandriva 2006. I can't access MySQL. I have to reconfigure my configuration everytime I reboot in order to access the Internet. Mozilla won't boot at all. Any advice or pointers would be much appreciated. Regards, Sean Bracken Quote Link to comment Share on other sites More sharing options...
Guest seanbracken Posted December 18, 2005 Report Share Posted December 18, 2005 The MySQL problem seems to be related to the host name. I used to logon through Webmin at localhost:10000, I can now connect as topup.ie:10000. However if I use that address for my radius server it won't work. I'm panicking at this stage and I've discovered that my backup of the old system is corrupt so I have no fallback. Quote Link to comment Share on other sites More sharing options...
ianw1974 Posted December 18, 2005 Report Share Posted December 18, 2005 How did you do the upgrade? From urpmi sources, or using CD/DVD media? Quote Link to comment Share on other sites More sharing options...
Guest seanbracken Posted December 18, 2005 Report Share Posted December 18, 2005 From a DVD. It seems as if MySQL isn't running. I might leave everything till tomorrow. I'm very panicked at the moment and I can't think straight Quote Link to comment Share on other sites More sharing options...
ianw1974 Posted December 18, 2005 Report Share Posted December 18, 2005 If you've been working at it a long time, yes give it a rest for now, and have a think. See if anything comes obvious to you. One thing worth trying though to make sure everything is up-to-date. Ensure you have urpmi sources configured for main, contrib, jpackage, updates, plf-free and plf-nonfree. Then check in System Updates and apply all updates. Then, after you've applied all normal, security and bug fix updates we can then check the rest of the system is up-to-date with: urpmi --auto-select --auto However, backup your mysql databases first running the following command: mysqldump -uroot -p$PASSWORD -hlocalhost --all-databases --all --opt --allow-keywords --flush-logs --hex-blob --master-data --max_allowed_packet=16M --quote-names --result-file=full_mysql_backup.sql then copy this file off somewhere. This command is all on one line. Quote Link to comment Share on other sites More sharing options...
ianw1974 Posted December 18, 2005 Report Share Posted December 18, 2005 One more thing, first check that mysql is installed, and able to run as a service. At the command line, you can type: rpm -qa mysql and see what it comes back with. If nothing, then mysql isn't installed. Check your services with: chkconfig --list and see if mysql is on the list of services. And you can check if it's running with: service mysql status Quote Link to comment Share on other sites More sharing options...
Guest seanbracken Posted December 18, 2005 Report Share Posted December 18, 2005 Hi Ian, Thanks for the reply. rpm -qa mysql produces no response. chkconfig --list produces adsl 0:off 1:off 2:off 3:off 4:off 5:off 6:off alsa 0:off 1:off 2:on 3:on 4:on 5:on 6:off atd 0:off 1:off 2:off 3:on 4:on 5:on 6:off crond 0:off 1:off 2:on 3:on 4:on 5:on 6:off dm 0:off 1:off 2:off 3:off 4:off 5:on 6:off haldaemon 0:off 1:off 2:off 3:on 4:on 5:on 6:off harddrake 0:off 1:off 2:off 3:on 4:on 5:on 6:off httpd 0:off 1:off 2:off 3:on 4:on 5:on 6:off keytable 0:off 1:off 2:on 3:on 4:on 5:on 6:off kheader 0:off 1:off 2:on 3:on 4:off 5:on 6:off mDNSResponder 0:off 1:off 2:off 3:on 4:on 5:on 6:off mailman 0:off 1:off 2:on 3:on 4:on 5:on 6:off messagebus 0:off 1:off 2:off 3:on 4:on 5:on 6:off mysqld 0:off 1:off 2:off 3:off 4:off 5:off 6:off netfs 0:off 1:off 2:off 3:on 4:on 5:on 6:off netplugd 0:off 1:off 2:off 3:off 4:off 5:off 6:off network 0:off 1:off 2:on 3:on 4:on 5:on 6:off nifd 0:off 1:off 2:off 3:on 4:on 5:on 6:off numlock 0:off 1:off 2:off 3:on 4:on 5:on 6:off oki4daemon 0:off 1:off 2:off 3:off 4:off 5:off 6:off partmon 0:off 1:off 2:off 3:on 4:on 5:on 6:off pcmcia 0:off 1:off 2:on 3:on 4:on 5:on 6:off portmap 0:off 1:off 2:off 3:on 4:on 5:on 6:off postfix 0:off 1:off 2:on 3:on 4:on 5:on 6:off rawdevices 0:off 1:off 2:off 3:on 4:on 5:on 6:off sound 0:off 1:off 2:on 3:on 4:on 5:on 6:off syslog 0:off 1:off 2:on 3:on 4:on 5:on 6:off xfs 0:off 1:off 2:on 3:on 4:on 5:on 6:off xinetd 0:off 1:off 2:off 3:on 4:on 5:on 6:off xinetd based services: imap: off imaps: off ipop2: off ipop3: on pop3s: off rsync: off service mysql status produces Cannot find mysql service Usage: service -[Rfshv] SERVICE ARGUMENTS -f|--full-restart: Do a fullrestart of the service. -R|--full-restart-all: Do a fullrestart of all services currently running. -s|--status-all: Print a status of all services. -d|--debug: Launch with debug. -h|--help: This help. -v|--version: Print version. So it seems as if MySQL is not installed. Could the upgrade have removed MySQL from the system? When I tried to install MySQL from the DVD using Configuration it doesn't appear as an option, but it isn't available to remove either. Quote Link to comment Share on other sites More sharing options...
ianw1974 Posted December 18, 2005 Report Share Posted December 18, 2005 OK, what version is it you have of 2006? Free, Power Pack? I would suggest that you add the urpmi sources for main, contrib, jpackage, plf-free, plf-nonfree, updates. This will give you access to stuff not on the DVD. Then you can look at installing mysql, to hopefully get you back on track as it doesn't seem to be there. I've noticed with 2006 Free and Powerpack, that even if I select some services, such as FTP, or whatever, they don't get installed. I had to use the urpmi sources to get it installed, and then things worked. You might have the same issue that mysql was not on the CD/DVD media. Quote Link to comment Share on other sites More sharing options...
Guest seanbracken Posted December 18, 2005 Report Share Posted December 18, 2005 It is the free version. when I try to use urpmi for MySQL it says that it is installed. When I try to install the packages that you suggested it says that they don't exist. Regards, Sean Quote Link to comment Share on other sites More sharing options...
ianw1974 Posted December 18, 2005 Report Share Posted December 18, 2005 OK, if you go into System/Configuration/Packages/Software Media Manager, what repositories do you have listed? I have a feeling all you have is the CD/DVD media. At the top of this page is a link for easyurpmi. This is where you can choose 2006, i586 and then main, contrib, etc, etc, etc. I suggest you get these added using easy urpmi, and it'll give you the code to add the mirrors using the command line/console window. Then try urpmi mysql, and you should then find it'll work. Add all repositories though, for dependency issues. Quote Link to comment Share on other sites More sharing options...
ianw1974 Posted December 18, 2005 Report Share Posted December 18, 2005 Another way to check if mysql is installed, is go into System/Configuration/Packaging/Remove Software. We won't actually remove anything, but you can search for mysql to see if it's installed. However, the rpm -qa command earlier, kind of shows it's not installed, as it should have listed a response. Quote Link to comment Share on other sites More sharing options...
Guest seanbracken Posted December 18, 2005 Report Share Posted December 18, 2005 OK You're right the only update source is the DVD. However I can't find the link that you mentioned. What is the address for Mandriva updates? Thanks for your help. Sean Quote Link to comment Share on other sites More sharing options...
ianw1974 Posted December 18, 2005 Report Share Posted December 18, 2005 Here's the link for easy urpmi.... http://www.mandrivausers.org/easyurpmi/index.php Quote Link to comment Share on other sites More sharing options...
Guest seanbracken Posted December 18, 2005 Report Share Posted December 18, 2005 Hi Ian, I tried that with this result. [root@topup sean]# urpmi.addmedia main ftp://ftp.clinet.fi/pub/mirrors/Mandrake-...i586/media/main with media_info/hdlist.czadded medium main wrote config file [/etc/urpmi/urpmi.cfg] urpmi database locked [root@topup sean]# urpmi.addmedia contrib ftp://ftp.caliu.info/pub/distribucions/ma...6/media/contrib with media_info/hdlist.cz unable to access hdlist file of "main", medium ignored added medium contrib wrote config file [/etc/urpmi/urpmi.cfg] urpmi database locked Sean Quote Link to comment Share on other sites More sharing options...
ianw1974 Posted December 18, 2005 Report Share Posted December 18, 2005 OK, the urpmi database is locked. Reboot the system, and then try adding the sources again. There is a way to release the lock without rebooting, I just don't know what file to remove. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.