quinta-feira, 19 de novembro de 2009

Ubuntu Server: Can't shutdown from power button - Ubuntu Forums

Thread Tools Display Modes
Old May 13th, 2006 #1
bullgr
Gee! These Aren't Roasted!

bullgr's Avatar

Join Date: Apr 2006
Location: Greece
Beans: 198
Ubuntu 9.04 Jaunty Jackalope
Send a message via ICQ to bullgr Send a message via AIM to bullgr
Ubuntu Server: Can't shutdown from power button

Hi...

Need help... please, it's important for me...

I have setup a Ubuntu file server with ubuntu server cd 5.10 "Breezy Badger" in my workplace.

Because the other co workers are "winblows zombies" i want to start and shutdown the pc from the power button.

Starting is ok... i power on the pc and leave it as it is in the login prompt without login and all works fine.

But to shutdown, the power button are not respond. I must login and shutdown from the command line.

For me its ok but for the "winblows zombies" is this unacceptable.
And i can't always there to shutdown the pc (vacation, sik etc).

In my home the power button works fine and for shutdown, but there i have the ubuntu desktop version installed.

The server pc is a P4 1.8

Thank's
bullgr is offline Reply With Quote
Old May 13th, 2006 #2
skippy81
Way Too Much Ubuntu

Join Date: May 2006
Beans: 224
Dapper Drake Testing/
Re: Ubuntu Server: Can't shutdown from power button

Firstly you need to focus on ACPI, since it the powerbutton produces an ACPI event. Therefore you want to have ACPI enabled in BIOS and in the Kernel - if you installed your server using "noacpi" as a boot option, then that would explain the problem.

Try doing this from a terminal

Quote:
sudo gedit /etc/acpi/events/powerbtn
This is what my file looks like:-

Quote:
# /etc/acpi/events/powerbtn
# This is called when the user presses the power button and calls
# /etc/acpi/powerbtn.sh for further processing.

# Optionally you can specify the placeholder %e. It will pass
# through the whole kernel event message to the program you've
# specified.

# We need to react on "button power.*" and "button/power.*" because
# of kernel changes.

event=button[ /]power
action=/etc/acpi/powerbtn.sh
as you can see it runs a script called powerbtn.sh that looks like this

Quote:
#!/bin/sh
# /etc/acpi/powerbtn.sh
# Initiates a shutdown when the power putton has been
# pressed.

[ -f /var/lock/acpisleep ] && exit 0

# If gnome-power-manager is running, let it handle policy
if [ `pidof gnome-power-manager` ]; then
exit
fi

# Check for kpowersave
if [ `pidof kpowersave` ]; then
exit
fi

# And for kded/klaptopdaemon
if test -f /usr/bin/dcop; then
if [ "x$(dcop kded | grep klaptopdaemon)" != x ]; then
exit
fi
fi

# Otherwise, if KDE is found, try to ask it to logout.
# If KDE is not found, just shutdown now.
if ps -Af | grep -q '[k]desktop' && test -f /usr/bin/dcop
then
dcop --all-sessions --all-users ksmserver ksmserver logout 0 2 0 && exit 0
else
/sbin/shutdown -h now "Power button pressed"
fi
Check if your files look the same as mine.
skippy81 is offline Reply With Quote
Old May 13th, 2006 #3
bullgr
Gee! These Aren't Roasted!

bullgr's Avatar

Join Date: Apr 2006
Location: Greece
Beans: 198
Ubuntu 9.04 Jaunty Jackalope
Send a message via ICQ to bullgr Send a message via AIM to bullgr
Re: Ubuntu Server: Can't shutdown from power button

thank's for the quick response...

The problem is that were is not any
/etc/acpi
the folder does not exist...

Don't forget, i have Ubuntu Server installed
bullgr is offline Reply With Quote
Old May 13th, 2006 #4
jtibau
Just Give Me the Beans!

jtibau's Avatar

Join Date: Apr 2006
Location: Guayaquil, Ecuador
Beans: 74
Ubuntu 6.10 Edgy
Send a message via MSN to jtibau Send a message via Skype™ to jtibau
Re: Ubuntu Server: Can't shutdown from power button

Since the file server is used at an office I guess you want it to shutdown everyday at the same time... After everyone leaves.
Sounds to me like you could try setting up a task that shuts it down every day after office hours. I think the cron service manages that kind of stuff but I don't know how to configure it yet . I'll let you know if I figure it out soon...
jtibau is offline Reply With Quote
Old May 13th, 2006 #5
bullgr
Gee! These Aren't Roasted!

bullgr's Avatar

Join Date: Apr 2006
Location: Greece
Beans: 198
Ubuntu 9.04 Jaunty Jackalope
Send a message via ICQ to bullgr Send a message via AIM to bullgr
Re: Ubuntu Server: Can't shutdown from power button

I find the solution... because a install from "Ubuntu Server cd" don't install acpi by default (like the desktop version), i must install it manualy

Quote:
sudo apt-get install acpid
and all is done... now everyone can shutdown the server from the power button (even the winblows zombies) without the need to login first.

Thank's for the help and for the quick response
bullgr is offline Reply With Quote
Old July 15th, 2008 #6
nexxus07
5 Cups of Ubuntu

Join Date: Apr 2008
Beans: 15
Re: Ubuntu Server: Can't shutdown from power button

Thank you, this was very helpful for stopping my virtualbox machines which are set up to start with the init.d.

This script helped me a great deal in setting it up:
http://farfewertoes.com/code/vboxcontrol/

and now they shut down and start up completely automatically which is just what I need.
nexxus07 is offline Reply With Quote

quarta-feira, 4 de novembro de 2009

MySQL: “Access denied for user ‘debian-sys-maint’@’localhost’” « RU-FI-OOOOOH!

MySQL: “Access denied for user ‘debian-sys-maint’@’localhost’” « RU-FI-OOOOOH!: "RU-FI-OOOOOH!

Sohail Mirza, standing in for Peter.
MySQL: “Access denied for user ‘debian-sys-maint’@'localhost’”

with 3 comments

For all you Ubuntu/MySQL developers out there, have you ever seen the following?

neo@thematrix:~$ sudo /etc/init.d/mysql restart
* Stopping MySQL database server mysqld [fail]
* Starting MySQL database server mysqld [ OK ]
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'

So, what is this “debian-sys-maint” user? Well, this MySQL user is created for the Ubuntu to be able to start/stop the database and to carry out other maintenance operations.

Sounds well enough, but then why do I keep running into the “access denied” problem for this user? Well, the issue is that with each update to MySQL, the user’s password in the database is overwritten. Ubuntu seems to go to the file /etc/mysql/debian.cnf in order to find this user’s password, but obviously the password is out of sync after the update has been applied.

As a result of this behaviour, I’ll run into the “access denied” problem every so often. Thankfully, the solution to this issue is fairly simple.

First, list the contents of the /etc/mysql/debian.cnf file:

neo@thematrix:~$ sudo cat /etc/mysql/debian.cnf

The contents of the file should look something like the following:

# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host = localhost
user = debian-sys-maint
password = n4aSHUP04s1J32X5
socket = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
user = debian-sys-maint
password = n4aSHUP04s1J32X5
socket = /var/run/mysqld/mysqld.sock
basedir = /usr

See that password? That’s what we’re looking for!

Next, we want to issue a command to MySQL that tells it to grant the debian-sys-maint user all necessary privileges using the new password.

Login to your mysql server using your root account and the root password you had originally set:

neo@thematrix:~$ mysql -u root -p <password>

Issue the GRANT command now to grant those permissions:

mysql> GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'n4aSHUP04s1J32X5';

Voila! If you restart MySQL, you’ll find that you should no longer be getting the “access denied” error message.

neo@thematrix:~$ sudo /etc/init.d/mysql restart
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.

Bear in mind, because we just switched the password, and the change hasn’t been affected yet, you may need to kill the MySQL server processes in order to get MySQL to shut down at all.

Possibly related posts: (automatically generated)

* MySQL create an Anonymous or limited access only account
* Connecting from windows to MYSQL on Ubuntu

Written by Sohail Mirza

January 16, 2009 at 6:51 pm

Posted in Development, Ubuntu

Tagged with debian, error, mysql, Ubuntu
« dpkg problems relating to ‘cups’ in Ubuntu
Riding Tokyo »
3 Responses

Subscribe to comments with RSS.

1.

Right tf on!

Oogliby

February 11, 2009 at 8:44 am
Reply
*

I see this is an older post, but just ran into this, myself. Reseting the debian-sys-maint password in mysql to match the debian.cnf file takes care of it – but do you know if there is a bug filed against this?

No other mysql passwords are reset during updates – so this seems odd to me.

Jere

October 16, 2009 at 11:47 am
Reply
o

In my research of the solution, I can’t say I did come across a bug filed for this issue.

Sohail Mirza

October 16, 2009 at 11:57 am


Leave a Reply
Click here to cancel reply.

Name (required)

E-mail (will not be published) (required)

Website

Notify me of follow-up comments via email.
Who am I?
Sohail Mirza is a software professional with a background in both design and development. He blogs about both, as well as other matters, real & virtual.
Search for:
Top Posts

* Helpful Hints - Apple Movie Trailers download using Firefox, Greasemonkey, and User Agent hack
* Star Trek beams onto Apple Movie Trailers
* Helpful Hints - Downloading HD Trailers from Apple Trailers
* MySQL: 'Access denied for user 'debian-sys-maint'@'localhost''
* Helpful Hints - Running multiple instances of Firefox

Browse a category
My del.icio.us

* BBC NEWS | Middle East | Israel 'cuts Palestinian water'
* Asia Sentinel - Pakistan's Persecuted Minority
* Michael Jordan's Top 23 Moments
* Why AI is a dangerous dream - opinion - 01 September 2009 - New Scientist
* Build an Insanely Great Web Service - ReadWriteStart
* BBC NEWS | Middle East | Gaza sewage 'a threat to Israel'
* Django Con High Performance Django
* PreciseJava.com - The path to improvement
* Django-Socialauth - GitHub
* Andy Kessler: Why AT&T Killed Google Voice - WSJ.com

Archives

Blog at WordPress.com. — Journalist theme by Lucian E. Marin"