Jump to content

Upgrade problems


Guest seanbracken
 Share

Recommended Posts

Guest seanbracken

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

Link to comment
Share on other sites

Guest seanbracken

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Guest seanbracken

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Guest seanbracken

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Guest seanbracken

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

Link to comment
Share on other sites

Guest seanbracken

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

added 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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...