Discuss

discuss@lists.centos.org

34758 discussions

Re: [CentOS] restarting mysql databases
by Robert Moskowitz 07 Oct '14

07 Oct '14

On 10/06/2014 03:27 PM, Reindl Harald wrote: > > > Am 06.10.2014 um 21:24 schrieb Robert Moskowitz: >> >> On 10/06/2014 03:08 PM, Reindl Harald wrote: >>> >>> Am 06.10.2014 um 21:01 schrieb Robert Moskowitz: >>>> I am doing an install of a mysql system, and decided that I needed to >>>> change some things like host name. So I have to go back to square one >>>> with the mysql setup, but can't find any instructions for this. I >>>> TRIED: >>>> >>>> mysql_install_db >>>> >>>> And it did SOMETHING, but >>>> >>>> mysqladmin -u root password 'mypass' >>>> >>>> failed with: >>>> >>>> mysqladmin: connect to server at 'localhost' failed >>>> error: 'Access denied for user 'root'@'localhost' (using password: >>>> NO)' >>>> >>>> I tried 'yum reinstall mysql' and that did not help >>> >>> why should "yum reinstall" change anything? >> >> Some apps reinit there data on reinstalls. Some don't. Don't know >> until you try. > > no they don't > > /var/lib/appname/ is never part of the package > otherwise update swould touch/damage your data > >>> the daemon specific data are below /var&/lib/mysql as for >>> any other software they live below /var/ib/appname >>> >>> no command ever will reset them besides rm -rf /var/lib/mysql/ >>> but what has that all to do with change the hostname? >> >> Don't know what changing the hostname did or does not do. I am digging >> into various info to figure out what to delete or rebuild to get back to >> pristine mysql. I can understand why this should not be easy - for >> someone to remove all of your mysql data, but it should be possible... > > if you have no data: > > * stop the service > * rm -rf /var/lib/mysqld/* Looks like the files: /var/lib/mysql/mysql/user.MYD /var/lib/mysql/mysql/user.MYI /var/lib/mysql/mysql/user.frm have the goo that has to go. > * start the service > * you have a virgin setup > > and as always read some docs > http://dev.mysql.com/doc/refman/5.5/en/privilege-system.html > >

2 1

restarting mysql databases
by Robert Moskowitz 07 Oct '14

07 Oct '14

I am doing an install of a mysql system, and decided that I needed to change some things like host name. So I have to go back to square one with the mysql setup, but can't find any instructions for this. I TRIED: mysql_install_db And it did SOMETHING, but mysqladmin -u root password 'mypass' failed with: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' I tried 'yum reinstall mysql' and that did not help.

3 3

Re: [CentOS] restarting mysql databases
by Robert Moskowitz 06 Oct '14

06 Oct '14

On 10/06/2014 03:27 PM, Reindl Harald wrote: > > > Am 06.10.2014 um 21:24 schrieb Robert Moskowitz: >> >> On 10/06/2014 03:08 PM, Reindl Harald wrote: >>> >>> Am 06.10.2014 um 21:01 schrieb Robert Moskowitz: >>>> I am doing an install of a mysql system, and decided that I needed to >>>> change some things like host name. So I have to go back to square one >>>> with the mysql setup, but can't find any instructions for this. I >>>> TRIED: >>>> >>>> mysql_install_db >>>> >>>> And it did SOMETHING, but >>>> >>>> mysqladmin -u root password 'mypass' >>>> >>>> failed with: >>>> >>>> mysqladmin: connect to server at 'localhost' failed >>>> error: 'Access denied for user 'root'@'localhost' (using password: >>>> NO)' >>>> >>>> I tried 'yum reinstall mysql' and that did not help >>> >>> why should "yum reinstall" change anything? >> >> Some apps reinit there data on reinstalls. Some don't. Don't know >> until you try. > > no they don't > > /var/lib/appname/ is never part of the package > otherwise update swould touch/damage your data What I thought. I guess just shooting in the dark. > >>> the daemon specific data are below /var&/lib/mysql as for >>> any other software they live below /var/ib/appname >>> >>> no command ever will reset them besides rm -rf /var/lib/mysql/ >>> but what has that all to do with change the hostname? >> >> Don't know what changing the hostname did or does not do. I am digging >> into various info to figure out what to delete or rebuild to get back to >> pristine mysql. I can understand why this should not be easy - for >> someone to remove all of your mysql data, but it should be possible... > > if you have no data: > > * stop the service > * rm -rf /var/lib/mysqld/* ls /var/lib/mysqld/* ls: cannot access /var/lib/mysqld/*: No such file or directory did you mean /var/lib/mysql/* ? But that seems risky as there is /var/lib/mysql/mysql that has lots of interesting looking files. But there is an empty directy /var/lib/mysql/foo and /var/lib/mysql/mydb with the file db.opt > * start the service > * you have a virgin setup > > and as always read some docs > http://dev.mysql.com/doc/refman/5.5/en/privilege-system.html I MIGHT have gotten to this in a couple of days or reading. Thanks for the pointer.

4 9

Re: [CentOS] restarting mysql databases
by Robert Moskowitz 06 Oct '14

06 Oct '14

On 10/06/2014 03:08 PM, Reindl Harald wrote: > > Am 06.10.2014 um 21:01 schrieb Robert Moskowitz: >> I am doing an install of a mysql system, and decided that I needed to >> change some things like host name. So I have to go back to square one >> with the mysql setup, but can't find any instructions for this. I TRIED: >> >> mysql_install_db >> >> And it did SOMETHING, but >> >> mysqladmin -u root password 'mypass' >> >> failed with: >> >> mysqladmin: connect to server at 'localhost' failed >> error: 'Access denied for user 'root'@'localhost' (using password: NO)' >> >> I tried 'yum reinstall mysql' and that did not help > > why should "yum reinstall" change anything? Some apps reinit there data on reinstalls. Some don't. Don't know until you try. > the daemon specific data are below /var&/lib/mysql as for > any other software they live below /var/ib/appname > > no command ever will reset them besides rm -rf /var/lib/mysql/ > but what has that all to do with change the hostname? Don't know what changing the hostname did or does not do. I am digging into various info to figure out what to delete or rebuild to get back to pristine mysql. I can understand why this should not be easy - for someone to remove all of your mysql data, but it should be possible...

1 0

openswan and klips ipsec stack
by Eero Volotinen 06 Oct '14

06 Oct '14

Hi List, Is there easy way to get klips ipsec stack into centos 6? As it makes firewalling ipsec traffic much easier.. Eero

2 3

trying to kickstart a vm guest from my datastore
by Dan Hyatt 06 Oct '14

06 Oct '14

I have a new ESXi server (5.x), and trying to load some VM guests on there. I have the guests configured, but when I try and boot from ISO image, the graphics are so bad it is futile. No worries I normally use kickstart anyways. Because the ESXi (on the same network as my physical servers) cannot talk to the PXE server. But works fine on the network (I can ssh/scp in and out of the ESXi server). i am unable to kickstart from the network. As this is a blade, there is not DVD access. But I have a kickstart file, an iso image on my datastore. Really I have two questions: 1. how do I "test" or troubleshoot WHY ESXi cannot reach the pxe server. The mac addresses/ips/hostnames of the VM guests are in DNS and DHCP. 2. How do I kickstart a VM guest from the datastore kickstart file/iso image? D.

2 1

massive load caused by smartvd
by Tim Dunphy 06 Oct '14

06 Oct '14

Hey all, I noticed that my puppet server running CentOS 6.5 was acting a little pokey. So I logged in and did what well just about anyone would've done. And ran the uptime command to have a look at the load. And it was astonishingly high! [root@puppet:~] #uptime 21:28:01 up 1:26, 3 users, load average: 107.37, 72.06, 75.52 So then I had a look at top and saw a LOT of processes by the name of smartvd. 7332 root 20 0 423m 1808 0 S 5.6 0.1 0:49.30 smarvtd 5469 root 20 0 423m 1804 0 S 4.6 0.1 0:49.55 smarvtd 2042 root 20 0 423m 1804 0 S 3.7 0.1 0:49.66 smarvtd 2421 root 20 0 423m 1808 0 S 3.7 0.1 0:47.62 smarvtd 3081 root 20 0 423m 1808 0 S 3.7 0.1 0:47.08 smarvtd 3366 root 20 0 423m 1804 0 S 3.7 0.1 0:47.87 smarvtd 3568 root 20 0 423m 1808 0 S 3.7 0.1 0:48.94 smarvtd 3971 root 20 0 423m 1812 0 S 3.7 0.1 0:49.18 smarvtd 4264 root 20 0 423m 1812 0 S 3.7 0.1 0:48.33 smarvtd 4585 root 20 0 423m 1812 0 S 3.7 0.1 0:48.44 smarvtd 5277 root 20 0 423m 1808 0 S 3.7 0.1 0:48.13 smarvtd 6160 root 20 0 423m 1812 0 S 3.7 0.1 0:49.33 smarvtd 6441 root 20 0 423m 1808 0 S 3.7 0.1 0:48.17 smarvtd 6746 root 20 0 423m 1804 0 S 3.7 0.1 0:49.60 smarvtd 7612 root 20 0 423m 1812 0 S 3.7 0.1 0:48.97 smarvtd 7919 root 20 0 423m 1808 0 S 3.7 0.1 0:47.33 smarvtd 8202 root 20 0 423m 1812 0 S 3.7 0.1 0:49.67 smarvtd 26526 root 20 0 423m 1812 0 S 3.7 0.1 1:22.17 whitptabil 2747 root 20 0 423m 1812 0 S 2.8 0.1 0:48.41 smarvtd 4952 root 20 0 423m 1812 0 S 2.8 0.1 0:48.43 smarvtd 5878 root 20 0 423m 1808 0 S 2.8 0.1 0:48.02 smarvtd 7048 root 20 0 423m 1808 0 S 2.8 0.1 0:48.51 smarvtd So my question to you is what the HELL is smartvd ? Seems like a virus to me. And of course how do I get rid of it? Also curious what whitptabil is and how to get rid of it. I tried doing a search for both: [root@puppet:~] #rpm -qa | grep smartvd [root@puppet:~] # [root@puppet:~] #find / -name smartvd [root@puppet:~] # [root@puppet:~] #rpm -qa | grep whitptabil [root@puppet:~] #find / -name whitptabil /etc/whitptabil [root@puppet:~] # At least I found a file associated with the latter. Really really curious here, guys. What do y'all think??? Thanks Tim -- GPG me!! gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B

5 7

DHCP with ipv6 tunnel
by Ashley M. Kirchner 06 Oct '14

06 Oct '14

I'm completely confused here and I'm hoping someone here has a setup they're willing to share, or help me configure things on my end. My connectivity is through Comcast, who unfortunately, does not offer ipv6 in my area. My connection goes like this: Comcast -> Motorola Surfboard Cable Router -> CentOS 6.5 server The CentOS server is multi-homed and manages the internal 192.168.x.x network by offering DHCP and firewall service (NATting and others.) DNS lookups are going to Comcast's servers. I have an IPV6 tunnel through Hurricane Electric (www.tunnelbroker.net) The tunnel is configured and is up and running on the CentOS server. I can ping several IPV6 addresses from it just fine: ping6 -n ipv6.google.com PING ipv6.google.com(2607:f8b0:400f:801::1006) 56 data bytes 64 bytes from 2607:f8b0:400f:801::1006: icmp_seq=1 ttl=53 time=109 ms 64 bytes from 2607:f8b0:400f:801::1006: icmp_seq=2 ttl=53 time=109 ms 64 bytes from 2607:f8b0:400f:801::1006: icmp_seq=3 ttl=53 time=106 ms ^C --- ipv6.google.com ping statistics --- 3 packets transmitted, 3 received, 0% packet loss, time 2436ms rtt min/avg/max/mdev = 106.905/108.723/109.756/1.317 ms What I'd like to do now is have DHCP offer ipv6 addresses as well. Problem is, I don't know how to configure it properly using the information given to me by Hurricane. I have my client address which is what the CentOS tunnel interface is. Then I have a routed /64 and /48 prefix which I *think* is what I'm supposed to use for my internal network (according to their info popup window) but I don't know how to configure DHCPd to use that and then route through the ipv6 interface. So does anyone here have a tunnel from HE and are using DHCP on an internal network handing out ipv6 addresses? Any suggestions of how to configure dhcpd6.conf? Thanks all. Ash

11 19

About CentOS Storage SIG and RedHat Storage Server 3.0
by C. L. Martinez 06 Oct '14

06 Oct '14

Hi all, Does someone from CentOS Storage SIG can say something about this subject? Is it planned to accomplish some RHSS 3 rebuild for CentOS 6.5?? Thanks.

1 0

Centos 7: Remove Gnome from GDM options
by Frank Cox 05 Oct '14

05 Oct '14

When you click on the gear icon on the GDM login screen, it provides a list of the available desktop environments so you can pick between them. Since I exclusively use Mate on this computer, how can I remove the other options from that menu? Earlier today when I logged in the machine decided on its own that what I really wanted was Gnome Classic, so I had to log out to change it back to Mate, then log in again. I would like to tell it to use Mate exclusively, with no other options to select by mistake. -- MELVILLE THEATRE ~ Real D 3D Digital Cinema ~ www.melvilletheatre.com

4 6

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

Discuss