Re: MySQL upgrade failed PLEASE HELP!!!
On Sat, 6 Mar 2010 15:22:01 -0500 (EST), Oscar Corte wrote: > > Just today I upgraded my Debian Lenny Server, many packages > were upgraded succesfully, but MySQL server wich is not working anymore. > > What can I do to restore MySQL server? > > Error messages shown are these: > > Starting MySQL database server: mysql . . . . . failed! > invoke-rc.d: initscript mysql, action "start" failed. > dpkg: error processing mysql-server-5.0 (--configure): > subprocess post-installation script returned error exit status 1 > dpkg: dependency problems prevent configuration of mysql-server: > mysql-server depends on mysql-server-5.0; however: > Package mysql-server-5.0 is not configured yet. > dpkg error: error processing mysql-server (--configure): > dependency problems - leaving unconfigured > > Thanks in advance for any advice I'm not sure that this is the time or the place for this, but I have to admit it irritates me when people say "Thanks in advance." It irritates me primarily because it appears to be an excuse for not saying "thank you" later if someone really does help you. Saying "thanks" afterward shows gratefulness. Saying "thanks" in advance seems somewhat presumptuous to me. But anyway, here are some things you can try. First, check out /var/log/syslog to see if there are any useful diagnostic messages there. dmesg|less is another place you can check. Also try invoking the following commands as root: /etc/init.d/mysql stop dpkg-reconfigure -plow mysql-server-5.0 /etc/init.d/mysql start and see if any informative messages show up on the console or in /var/log/syslog. -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org Archive: http://lists.debian.org/958077314.17277891267914925185.javamail.r...@md01.wow.synacor.com
RE: MySQL upgrade failed PLEASE HELP!!!
Same result. It seems to try to start the server an it fails. I happens too when using aptitude. > Date: Sat, 6 Mar 2010 22:39:40 +0200 > From: brentgclarkl...@gmail.com > To: debian-user@lists.debian.org > Subject: Re: MySQL upgrade failed PLEASE HELP!!! > > On 06/03/2010 22:22, Oscar Corte wrote: > > Error messages shown are these: > > > > Starting MySQL database server: mysql . . . . . failed! > > invoke-rc.d: initscript mysql, action "start" failed. > > dpkg: error processing mysql-server-5.0 (--configure): > > subprocess post-installation script returned error exit status 1 > > dpkg: dependency problems prevent configuration of mysql-server: > > mysql-server depends on mysql-server-5.0; however: > > Package mysql-server-5.0 is not configured yet. > > dpkg error: error processing mysql-server (--configure): > > dependency problems - leaving unconfigured > > Hiya > > Did you even calm down and even take the time to read the messages. > > dpkg --configure -a > > HTH > > Brent Clark > > > -- > To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org > with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org > Archive: http://lists.debian.org/4b92bd8c.6070...@gmail.com > _ Hotmail: Powerful Free email with security by Microsoft. https://signup.live.com/signup.aspx?id=60969
RE: MySQL upgrade failed PLEASE HELP!!!
Hi:
Manual starting also fails. I'll check the log file
> Date: Sat, 6 Mar 2010 15:41:21 -0500
> From: allan_w...@lifeintegrity.com
> To: debian-user@lists.debian.org
> Subject: Re: MySQL upgrade failed PLEASE HELP!!!
>
> On 2010-03-06T20:22:01, Oscar Corte wrote:
> > Error messages shown are these:
> >
> > Starting MySQL database server: mysql . . . . . failed!
> > invoke-rc.d: initscript mysql, action "start" failed.
> > dpkg: error processing mysql-server-5.0 (--configure):
> > subprocess post-installation script returned error exit status 1
>
> <http://www.linuxquestions.org/questions/debian-26/is-invoke-rc.d-the-problem-671401/?s=e9411ab4a75a798bf854db454fe40961>
>
> perhaps?
>
> Check the mysql log files:
>
> less /var/log/mysql.{err.log}
>
> Is there a mysql process running?
>
> Try start it by mysql by hand and see if you get anything
> interesting:
>
> /etc/init.d/mystart start
>
>
> /Allan
> --
> Allan Wind
> Life Integrity, LLC
> <http://lifeintegrity.com>
>
>
> --
> To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org
> with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
> Archive: http://lists.debian.org/20100306204121.ga30...@lifeintegrity.com
>
_
Hotmail: Powerful Free email with security by Microsoft.
https://signup.live.com/signup.aspx?id=60969
Re: MySQL upgrade failed PLEASE HELP!!!
On 2010-03-06T20:22:01, Oscar Corte wrote:
> Error messages shown are these:
>
> Starting MySQL database server: mysql . . . . . failed!
> invoke-rc.d: initscript mysql, action "start" failed.
> dpkg: error processing mysql-server-5.0 (--configure):
> subprocess post-installation script returned error exit status 1
<http://www.linuxquestions.org/questions/debian-26/is-invoke-rc.d-the-problem-671401/?s=e9411ab4a75a798bf854db454fe40961>
perhaps?
Check the mysql log files:
less /var/log/mysql.{err.log}
Is there a mysql process running?
Try start it by mysql by hand and see if you get anything
interesting:
/etc/init.d/mystart start
/Allan
--
Allan Wind
Life Integrity, LLC
<http://lifeintegrity.com>
--
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Archive: http://lists.debian.org/20100306204121.ga30...@lifeintegrity.com
Re: MySQL upgrade failed PLEASE HELP!!!
On 06/03/2010 22:22, Oscar Corte wrote: Error messages shown are these: Starting MySQL database server: mysql . . . . . failed! invoke-rc.d: initscript mysql, action "start" failed. dpkg: error processing mysql-server-5.0 (--configure): subprocess post-installation script returned error exit status 1 dpkg: dependency problems prevent configuration of mysql-server: mysql-server depends on mysql-server-5.0; however: Package mysql-server-5.0 is not configured yet. dpkg error: error processing mysql-server (--configure): dependency problems - leaving unconfigured Hiya Did you even calm down and even take the time to read the messages. dpkg --configure -a HTH Brent Clark -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org Archive: http://lists.debian.org/4b92bd8c.6070...@gmail.com
MySQL upgrade failed PLEASE HELP!!!
Hi all: Just today I upgraded my Debian Lenny Server, many packages were upgraded succesfully, but MySQL server wich is not working anymore. What can I do to restore MySQL server? Error messages shown are these: Starting MySQL database server: mysql . . . . . failed! invoke-rc.d: initscript mysql, action "start" failed. dpkg: error processing mysql-server-5.0 (--configure): subprocess post-installation script returned error exit status 1 dpkg: dependency problems prevent configuration of mysql-server: mysql-server depends on mysql-server-5.0; however: Package mysql-server-5.0 is not configured yet. dpkg error: error processing mysql-server (--configure): dependency problems - leaving unconfigured Thanks in advance for any advice Regards Oscar Corte _ Hotmail: Trusted email with Microsoft’s powerful SPAM protection. https://signup.live.com/signup.aspx?id=60969
Re: MySQL server from backports.org issue
On 17/12/2009 01:38, JW Foster wrote: Somehow the server is running and my apps seem to be running OK, but I just do not like the mess the debian developers have made of this. I also can not uninstall the server to go back to the stable version. Hiya K why dont you start by purging all the mysql packages. Then, exercise an aptitude install of mysql-server but from backupports ( -t lenny-backports ) Then take the last backup of before the backports upgrade and then repopulate the db i.e. mysql < database.sql. HTH Brent Clark -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
MySQL server from backports.org issue
Maybe I can get a response with more info. I upgraded to MySQL-server 5.1.1 from stable using the backports.org apps in my sources.list & pinning them . I also upgraded all of MySql as well. I did not realize there was any difference until I tried to upgrade the backports installation & I can not do it. I have discovered several things. 1. the database mysql seems to be screwed up some way. 2. I can not edit it or even open it from Webmin or MySqladmin or from any other app. I get this error: "SQL show index from `event` failed : Can't find file: './mysql/event.frm' (errno: 13)" 3. I also can not change the password for the 'required' user 'debian-system-maint' ( why is there a required user) (was not needed b/4?) 4. Basic global install requires my.cnf for it to be effective. I did as normal taking the dist file, editing it & changing the name to my.cnf. I noticed it shows the user as mysql. which I have enabled. I also see that the 'required' user 'debian-system-maint' is enabled using webmin to view this. 5. The debian-start requires the debian.cnf file and it says to NOT edit it. I did see the it indicates the user as debian-system-maint with what appears to be an obscured password. 6. I rarely have any gripes with the developers, however this just seems to be unnecessary over engineering in order to debianize the server install. 7. My question is how do I fix this? The debian readme does NOT supply an answer. Somehow the server is running and my apps seem to be running OK, but I just do not like the mess the debian developers have made of this. I also can not uninstall the server to go back to the stable version. -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
MySql-sever 5.1.3 from BPO ISSUES
I have recently installed the 5.1 versions from back-ports Lenny & since the installation the systems works from a reboot but I can not manually stop or start the server, therefore I cant do the updates as they are posted from BPO. I read the installation material in regards to the new users debian-system-maint about reseting the passwords & flushing priviledges. That does not work. I tried from MySqlAdmin & from Webmin. it errors out. Aslso I cant get synaptic to install the upgrade to 5.1.3 for this reason. Tips are appreciated. -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Re: Best method for stopping/starting MySQL?
Tim Legg schreef:
> My output is similar to this (Thanks to grc.com password generator).
>
> +--+---+---+
> | User | Host | Password |
> +--+---+---+
> | root | localhost | *4883CCF9DC8AAC41CBE1576EE7C30ECFFDB1EE23 |
> | debian-sys-maint | localhost | 2qcvaMBnP8qwm5Ik |
> | legg | localhost | *FA5726D8387429018CC8BE7FACBC43F1E51D5C2F |
> +--+---+---+
>
> I see the password in plain text while the others are in a hash of some sort.
> That is probably where the problem is, and now I need to find a solution.
>> You can change the password with command
>>
>> mysql> update mysql.user set
>> password=PASSWORD('new-password')
>> where User =
>> 'debian-sys-maint' ;
>> mysql> flush privileges;
Reset the password with the method mentioned above. You probably set the
password not putting it in the PASSWORD('password') brackets. The
PASSWORD() command converts the plaintext password to a hash MySQL uses.
Good luck.
Sjoerd
signature.asc
Description: OpenPGP digital signature
Re: Best method for stopping/starting MySQL?
Hello Mike, On 2009-10-19, Mike Ayers wrote: > On Mon, Oct 19, 2009 at 10:49:36AM -0700, Tim Legg wrote: >> Hello again! >> >> I would like to shutdown mysql periodically to make backups of the >> databases. I would like to know what >> is the official Debian way of stopping and restarting MySQL. > >> >> >> When I follow the intuitive steps for shutting it down, it doesn't work. >> >> # /etc/init.d/mysql stop >> Stopping MySQL database server: mysqld failed! >> >> So I investigate further and find that this doesn't work either >> >> # mysqladmin shutdown >> mysqladmin: connect to server at 'localhost' failed >> error: 'Access denied for user 'root'@'localhost' (using password: NO)' >> >> I am root and should be able to do anything... >> >> So I do cooperate and provide it a user and password >> >> # mysqladmin -u root -p shutdown >> Enter password: >> # >> >> And so it works. Starting it back up isn't nearly as clean though >> >> # /etc/init.d/mysql start >> Starting MySQL database server: mysqld. >> Checking for corrupt, not cleanly closed and upgrade needing tables.. >> /usr/bin/mysqladmin: connect to server at 'localhost' failed >> error: 'Access denied for user 'debian-sys-maint'@'localhost' (using >> password: YES)' >> ERROR 1045 (28000): Access denied for user 'debian-sys-maint'@'localhost' >> (using password: YES) >> >> So, I choose to reboot the system instead. Is there a better way? >> >> Tim Legg >> > how about: > "/etc/init.d/mysql stop" to stop it > and "/etc/init.d/mysql" start to restart it > You did read the message from the OP that You quoted in Your mail (see above), did You? It clearly states that what You suggest does not work for him. Regards, -- Christer Email: coldh...@swipnet.se -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Re: Best method for stopping/starting MySQL?
On Mon, Oct 19, 2009 at 10:49:36AM -0700, Tim Legg wrote: > Hello again! > > I would like to shutdown mysql periodically to make backups of the databases. > I would like to know what is the official Debian way of stopping and > restarting MySQL. > > > > When I follow the intuitive steps for shutting it down, it doesn't work. > > # /etc/init.d/mysql stop > Stopping MySQL database server: mysqld failed! > > So I investigate further and find that this doesn't work either > > # mysqladmin shutdown > mysqladmin: connect to server at 'localhost' failed > error: 'Access denied for user 'root'@'localhost' (using password: NO)' > > I am root and should be able to do anything... > > So I do cooperate and provide it a user and password > > # mysqladmin -u root -p shutdown > Enter password: > # > > And so it works. Starting it back up isn't nearly as clean though > > # /etc/init.d/mysql start > Starting MySQL database server: mysqld. > Checking for corrupt, not cleanly closed and upgrade needing tables.. > /usr/bin/mysqladmin: connect to server at 'localhost' failed > error: 'Access denied for user 'debian-sys-maint'@'localhost' (using > password: YES)' > ERROR 1045 (28000): Access denied for user 'debian-sys-maint'@'localhost' > (using password: YES) > > So, I choose to reboot the system instead. Is there a better way? > > Tim Legg > > > > > > > -- > To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org > with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org > > how about: "/etc/init.d/mysql stop" to stop it and "/etc/init.d/mysql" start to restart it -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Re: Best method for stopping/starting MySQL?
--- On Mon, 10/19/09, Jari Fredriksson wrote:
> From: Jari Fredriksson
> Subject: Re: Best method for stopping/starting MySQL?
> To: debian-user@lists.debian.org
> Date: Monday, October 19, 2009, 1:15 PM
>
>
> 19.10.2009 20:49, Tim Legg kirjoitti:
> > Hello again!
> >
> > I would like to shutdown mysql periodically to make
> backups of the databases. I would like to know what is
> the official Debian way of stopping and restarting MySQL.
> >
> >
> >
> > When I follow the intuitive steps for shutting it
> down, it doesn't work.
> >
> > # /etc/init.d/mysql stop
> > Stopping MySQL database server: mysqld failed!
> >
> > So I investigate further and find that this doesn't
> work either
> >
> > # mysqladmin shutdown
> > mysqladmin: connect to server at 'localhost' failed
> > error: 'Access denied for user 'root'@'localhost'
> (using password: NO)'
> >
> > I am root and should be able to do anything...
> >
> > So I do cooperate and provide it a user and password
> >
> > # mysqladmin -u root -p shutdown
> > Enter password:
> > #
> >
> > And so it works. Starting it back up isn't
> nearly as clean though
> >
> > # /etc/init.d/mysql start
> > Starting MySQL database server: mysqld.
> > Checking for corrupt, not cleanly closed and upgrade
> needing tables..
> > /usr/bin/mysqladmin: connect to server at 'localhost'
> failed
> > error: 'Access denied for user
> 'debian-sys-maint'@'localhost' (using password: YES)'
> > ERROR 1045 (28000): Access denied for user
> 'debian-sys-maint'@'localhost' (using password: YES)
> >
> > So, I choose to reboot the system instead. Is
> there a better way?
> >
>
> Something is broken in your installation.. Do you have
>
> /etc/mysql/debian.cnf
>
It exists.
> And the password there.
>
It has a password
> If you log in to the MySQL as root, and
>
> mysql> select User, Host from
> mysql.user;
>
> Is the debian-sys-maint there? With the password you have
> in the
> debian.cnf? And Host as 'localhost'?
>
Yes,
select User, Host, Password from mysql.user;
revealed the password. I diff'd the two passwords and ensured they are
correct. But I noticed something wasn't quite right.
My output is similar to this (Thanks to grc.com password generator).
+--+---+---+
| User | Host | Password |
+--+---+---+
| root | localhost | *4883CCF9DC8AAC41CBE1576EE7C30ECFFDB1EE23 |
| debian-sys-maint | localhost | 2qcvaMBnP8qwm5Ik |
| legg | localhost | *FA5726D8387429018CC8BE7FACBC43F1E51D5C2F |
+--+---+---+
I see the password in plain text while the others are in a hash of some sort.
That is probably where the problem is, and now I need to find a solution.
> You can change the password with command
>
> mysql> update mysql.user set
> password=PASSWORD('new-password')
> where User =
> 'debian-sys-maint' ;
> mysql> flush privileges;
>
>
>
Also thanks to Joe for the mysqldump suggestions. I have just implemented that
as a solution. Now to fix this password problem...
Tim Legg
--
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Re: Best method for stopping/starting MySQL?
19.10.2009 22:32, Joe kirjoitti: 19.10.2009 20:49, Tim Legg kirjoitti: Hello again! I would like to shutdown mysql periodically to make backups of the databases. I would like to know what is the official Debian way of stopping and restarting MySQL. You might also consider a backup method which does not require MySQL to be stopped. Here's what I use, as I have some InnoDB tables: http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html For some databases, daily: #!/bin/bash OF=/data/smb1/backups/mysql/important-$(date +%Y%m%d).sql.bz2 mysqldump -u backup -psecret --databases verses finance Calendar domestic music MasterDirectory | bzip2 > $OF or all of them, less often: #!/bin/bash OF=/data/smb1/backups/mysql/databases-$(date +%Y%m%d).sql.bz2 mysqldump -A -u backup -psecret | bzip2 > $OF All my databases are human-driven and the backup jobs run when nothing else will be happening, so I don't bother locking things, but you obviously can. This all happens at the database level, so there's no flushing to disc to worry about. If you use phpMyAdmin, that can also backup and restore databases online remotely using a browser, but I don't think it can be scripted locally. I have this /etc/cron.daily/backup-mysql --- #!/bin/sh DATABASES=`mysql -h dbsrv --user=backup -psecret --skip-column-names --batch -e "show databases" | egrep -v information_schema|mysql|bacula|eroperhe` BACKUPDIR=/usr/local/srv/dbbackup echo [ Backing up databases from MySQL into $BACKUPDIR ] for DB in $DATABASES; do echo -n " Backing up" $DB.. mysqldump -h dbsrv --user=backup -psecret --opt $DB | bzip2 >$BACKUPDIR/$DB.sql.bz2 echo done echo [ Done ] --- It backs up every database except those mentioned in egrep filter. Each database into its own .sql file. The database is assumed to be in server dbsrv, that can be left off if it is on localhost. -- http://www.iki.fi/jarif/ Your boss climbed the corporate ladder, wrong by wrong. pgpUoLwNmrN57.pgp Description: PGP signature
Re: Best method for stopping/starting MySQL?
19.10.2009 20:49, Tim Legg kirjoitti: Hello again! I would like to shutdown mysql periodically to make backups of the databases. I would like to know what is the official Debian way of stopping and restarting MySQL. You might also consider a backup method which does not require MySQL to be stopped. Here's what I use, as I have some InnoDB tables: http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html For some databases, daily: #!/bin/bash OF=/data/smb1/backups/mysql/important-$(date +%Y%m%d).sql.bz2 mysqldump -u backup -psecret --databases verses finance Calendar domestic music MasterDirectory | bzip2 > $OF or all of them, less often: #!/bin/bash OF=/data/smb1/backups/mysql/databases-$(date +%Y%m%d).sql.bz2 mysqldump -A -u backup -psecret | bzip2 > $OF All my databases are human-driven and the backup jobs run when nothing else will be happening, so I don't bother locking things, but you obviously can. This all happens at the database level, so there's no flushing to disc to worry about. If you use phpMyAdmin, that can also backup and restore databases online remotely using a browser, but I don't think it can be scripted locally. -- Joe -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Re: Best method for stopping/starting MySQL?
19.10.2009 20:49, Tim Legg kirjoitti:
Hello again!
I would like to shutdown mysql periodically to make backups of the databases.
I would like to know what is the official Debian way of stopping and restarting
MySQL.
When I follow the intuitive steps for shutting it down, it doesn't work.
# /etc/init.d/mysql stop
Stopping MySQL database server: mysqld failed!
So I investigate further and find that this doesn't work either
# mysqladmin shutdown
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
I am root and should be able to do anything...
So I do cooperate and provide it a user and password
# mysqladmin -u root -p shutdown
Enter password:
#
And so it works. Starting it back up isn't nearly as clean though
# /etc/init.d/mysql start
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password:
YES)'
ERROR 1045 (28000): Access denied for user 'debian-sys-maint'@'localhost'
(using password: YES)
So, I choose to reboot the system instead. Is there a better way?
Something is broken in your installation.. Do you have
/etc/mysql/debian.cnf
And the password there.
If you log in to the MySQL as root, and
mysql> select User, Host from mysql.user;
Is the debian-sys-maint there? With the password you have in the
debian.cnf? And Host as 'localhost'?
You can change the password with command
mysql> update mysql.user set password=PASSWORD('new-password')
where User = 'debian-sys-maint' ;
mysql> flush privileges;
--
http://www.iki.fi/jarif/
Good day for a change of scene. Repaper the bedroom wall.
pgpLhTHamlATy.pgp
Description: PGP signature
Best method for stopping/starting MySQL?
Hello again! I would like to shutdown mysql periodically to make backups of the databases. I would like to know what is the official Debian way of stopping and restarting MySQL. When I follow the intuitive steps for shutting it down, it doesn't work. # /etc/init.d/mysql stop Stopping MySQL database server: mysqld failed! So I investigate further and find that this doesn't work either # mysqladmin shutdown mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' I am root and should be able to do anything... So I do cooperate and provide it a user and password # mysqladmin -u root -p shutdown Enter password: # And so it works. Starting it back up isn't nearly as clean though # /etc/init.d/mysql start Starting MySQL database server: mysqld. Checking for corrupt, not cleanly closed and upgrade needing tables.. /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)' ERROR 1045 (28000): Access denied for user 'debian-sys-maint'@'localhost' (using password: YES) So, I choose to reboot the system instead. Is there a better way? Tim Legg -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Re: Ubuntu noninteractive aptitude mysql install
On Mon, Oct 12, 2009 at 7:09 PM, Daniel Burrows wrote: > Maybe you could run pstree to find out what's generating that prompt? Thanks for the replies, Daniel. I'm positive it is the interactive mysql server password prompt causing the hang, every other apt package installs fine with this same approach. My problem is that my "Flags: seen" hack to the debconf passwords.dat is not always disabling the prompt as (I assume) it should: http://github.com/thewoolleyman/rails/blob/master/ci/setup_rails_dependencies.rb#L26 -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Re: Ubuntu noninteractive aptitude mysql install
On Mon, Oct 12, 2009 at 05:20:29PM -0700, Chad Woolley
was heard to say:
> On Sat, Oct 10, 2009 at 4:57 PM, Daniel Burrows wrote:
> > You're becoming root like this:
> >
> > $ run "sudo su -c 'echo \"#{pw_file}\" >
> > /var/cache/debconf/passwords.dat'"
> >
> > It sounds like you're getting a prompt from sudo?
>
> No, that's not it - I have nopasswd set in sudoers. All other
> commands I run via sudo run fine. It is just the mysql server install
> that hangs.
Maybe you could run pstree to find out what's generating that prompt?
Daniel
--
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Re: Ubuntu noninteractive aptitude mysql install
On Sat, Oct 10, 2009 at 4:57 PM, Daniel Burrows wrote:
> On Tue, Oct 06, 2009 at 09:42:57AM -0700, Chad Woolley
> was heard to say:
>> When scripting an aptitude install of mysql on ubuntu, how can I avoid
>> blocking at aptitude's interactive root password prompt?
>
> aptitude doesn't prompt for a root password at the command line.
>
>> I tried the following, but it doesn't work on when I run it on a clean
>> EC2 image:
>>
>> http://github.com/thewoolleyman/rails/blob/master/ci/setup_rails_dependencies.rb#L26
>>
>> Maddeningly, it works fine when I immediately do the same thing again.
>
> You're becoming root like this:
>
> $ run "sudo su -c 'echo \"#{pw_file}\" > /var/cache/debconf/passwords.dat'"
>
> It sounds like you're getting a prompt from sudo?
No, that's not it - I have nopasswd set in sudoers. All other
commands I run via sudo run fine. It is just the mysql server install
that hangs.
--
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Re: Ubuntu noninteractive aptitude mysql install
On Tue, Oct 06, 2009 at 09:42:57AM -0700, Chad Woolley
was heard to say:
> When scripting an aptitude install of mysql on ubuntu, how can I avoid
> blocking at aptitude's interactive root password prompt?
aptitude doesn't prompt for a root password at the command line.
> I tried the following, but it doesn't work on when I run it on a clean
> EC2 image:
>
> http://github.com/thewoolleyman/rails/blob/master/ci/setup_rails_dependencies.rb#L26
>
> Maddeningly, it works fine when I immediately do the same thing again.
You're becoming root like this:
$ run "sudo su -c 'echo \"#{pw_file}\" > /var/cache/debconf/passwords.dat'"
It sounds like you're getting a prompt from sudo?
Daniel
--
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Re: MySQL client in Squeeze
On Wed, Oct 7, 2009 at 11:47 PM, Jason Filippou
wrote:
> Hello,
>
> The following is aptitude output when I try to resolve the
> dependencies associated with mysql-client5.1:
>
> Accept this solution? [Y/n/q/?] y
> The following NEW packages will be installed:
> mysql-client mysql-client-5.1{a} mysql-server-5.1{a}
> The following packages will be REMOVED:
> mysql-client-5.0{a} mysql-server-5.0{a}
> The following packages will be upgraded:
> mysql-server
> 1 packages upgraded, 3 newly installed, 2 to remove and 2 not upgraded.
> Need to get 19.3MB of archives. After unpacking 56.8MB will be freed.
> Do you want to continue? [Y/n/?] y
> Writing extended state information... Done
> Get:1 http://http.us.debian.org unstable/main mysql-server 5.1.39-1 [57.4kB]
> Get:2 http://http.us.debian.org testing/main mysql-client-5.1 5.1.37-2
> [8,247kB]
> Get:3 http://http.us.debian.org testing/main mysql-server-5.1 5.1.37-2
> [11.0MB]
> Get:4 http://http.us.debian.org testing/main mysql-client 5.1.37-2
> [61.0kB]
> Fetched 19.3MB in 35s (550kB/s)
> Reading package fields... Done
> Reading package status... Done
> Retrieving bug reports... Done
> Parsing Found/Fixed information... Done
> grave bugs of mysql-server-5.1 (-> 5.1.37-2)
> #545751 - mysql-server-5.1 installation failure
> Merged with: 545752
> Summary:
> mysql-server-5.1(1 bug)
> Are you sure you want to install/upgrade the above packages? [Y/n/?/...]
>
> What would my preferred course of action be?
Maybe if you install without recommendations it will work without mysql-server
aptitude -R install mysql-client
Regards,
--
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
MySQL client in Squeeze
Hello,
The following is aptitude output when I try to resolve the
dependencies associated with mysql-client5.1:
Accept this solution? [Y/n/q/?] y
The following NEW packages will be installed:
mysql-client mysql-client-5.1{a} mysql-server-5.1{a}
The following packages will be REMOVED:
mysql-client-5.0{a} mysql-server-5.0{a}
The following packages will be upgraded:
mysql-server
1 packages upgraded, 3 newly installed, 2 to remove and 2 not upgraded.
Need to get 19.3MB of archives. After unpacking 56.8MB will be freed.
Do you want to continue? [Y/n/?] y
Writing extended state information... Done
Get:1 http://http.us.debian.org unstable/main mysql-server 5.1.39-1 [57.4kB]
Get:2 http://http.us.debian.org testing/main mysql-client-5.1 5.1.37-2 [8,247kB]
Get:3 http://http.us.debian.org testing/main mysql-server-5.1 5.1.37-2
[11.0MB]
Get:4 http://http.us.debian.org testing/main mysql-client 5.1.37-2
[61.0kB]
Fetched 19.3MB in 35s (550kB/s)
Reading package fields... Done
Reading package status... Done
Retrieving bug reports... Done
Parsing Found/Fixed information... Done
grave bugs of mysql-server-5.1 (-> 5.1.37-2)
#545751 - mysql-server-5.1 installation failure
Merged with: 545752
Summary:
mysql-server-5.1(1 bug)
Are you sure you want to install/upgrade the above packages? [Y/n/?/...]
What would my preferred course of action be?
Thank you.
--
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Ubuntu noninteractive aptitude mysql install
Hi, When scripting an aptitude install of mysql on ubuntu, how can I avoid blocking at aptitude's interactive root password prompt? I tried the following, but it doesn't work on when I run it on a clean EC2 image: http://github.com/thewoolleyman/rails/blob/master/ci/setup_rails_dependencies.rb#L26 Maddeningly, it works fine when I immediately do the same thing again. Thanks, -- Chad -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Re: Failed to install libmysql library for MYSQL client
On Thu, Sep 24, 2009 at 05:17:20PM +0530, Dinesh Lohan wrote: > Hi, > I am using TS-7300 board having Debain Linux version 2.86 2.86 is not the version of Debian (or Linux). It is the version of /sbin/init. Debian is probablt 4.0 (Etch) or 5.0 (Lenny). > and Installed > mysql client but when trying to > install library for mysql client using apt-get install libmysqlclient15-dev > its > not working. > -- > r...@ts7300:apt-get install libmysqlclient15-dev > Reading package lists...Done > Building dependency tree... Done > you might want to run 'apt-get -f install' to correct these: > The following packages have unmet dependencies: > binutils:depends:Lib6(>=2.7-1) but 2.3.6.ds1-13etch4 is to be installed > libc6:depends:tzdata but it is not going to be installed $ rmadison libc6 libc6 | 2.3.6.ds1-13 | etch-m68k | m68k libc6 | 2.3.6.ds1-13etch9 | oldstable | amd64, arm, hppa, mips, mipsel, powerpc, s390, sparc libc6 | 2.3.6.ds1-13etch9+b1 | oldstable | i386 libc6 | 2.7-18 |stable | amd64, arm, armel, hppa, i386, mips, mipsel, powerpc, s390, sparc libc6 | 2.9-25 | testing | amd64, armel, hppa, i386, mips, mipsel, powerpc, s390, sparc libc6 | 2.9-26 | unstable | amd64, armel, hppa, i386, mips, mipsel, powerpc, s390, sparc libc6 | 2.10.1-0exp1 | experimental | amd64, armel, powerpc You seem to have an Etch version of libc6 (glibc) but you attempt to install a package that requires the Lenny version of it. Upgrading the system to Lenny may be a good idea, but then again, it may not be a possible alternative for you. In addition to the question about sources.list , what is the output of: uname -a -- Tzafrir Cohen | tzaf...@jabber.org | VIM is http://tzafrir.org.il || a Mutt's tzaf...@cohens.org.il || best ICQ# 16849754 || friend -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Re: Failed to install libmysql library for MYSQL client
Dinesh Lohan wrote: Hi, I am using TS-7300 board having Debain Linux version 2.86 and Installed mysql client but when trying to install library for mysql client using apt-get install libmysqlclient15-dev its not working. -- r...@ts7300:apt-get install libmysqlclient15-dev Reading package lists...Done Building dependency tree... Done you might want to run 'apt-get -f install' to correct these: The following packages have unmet dependencies: binutils:depends:Lib6(>=2.7-1) but 2.3.6.ds1-13etch4 is to be installed libc6:depends:tzdata but it is not going to be installed libc6-dev:depend:libc6(=2.7-18) but 2.3.6.ds1-13etch4 is to be installed libmysqlclient15-dev:depend:libmysqlclient15off (>=5.0.51a-24+lenny2)but 5.0.32-7etch3 is to be installed Depend :libc6(>=2.7-1) but 2.3.6.ds1-13etch4 is to be installed E:Unmet dependencies.Try 'apt-get -f install' with no packages. --- Tried 'apt-get -f install' ,not working. Kernel 2.4.26-ts11 source.list :deb ftp://ftp.us.debain.org/debain stable main contrib non-free Please suggest me upon this.Will I need to changes in sources list file We might be able to help if you can supply us with more information. What is in your sources file now? Did you run 'aptitude update (debian preferred method) or apt-get update before you tried the install? I don't know whether this right forum for above Query or not... It is. Wayne -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Failed to install libmysql library for MYSQL client
Hi, I am using TS-7300 board having Debain Linux version 2.86 and Installed mysql client but when trying to install library for mysql client using apt-get install libmysqlclient15-dev its not working. -- r...@ts7300:apt-get install libmysqlclient15-dev Reading package lists...Done Building dependency tree... Done you might want to run 'apt-get -f install' to correct these: The following packages have unmet dependencies: binutils:depends:Lib6(>=2.7-1) but 2.3.6.ds1-13etch4 is to be installed libc6:depends:tzdata but it is not going to be installed libc6-dev:depend:libc6(=2.7-18) but 2.3.6.ds1-13etch4 is to be installed libmysqlclient15-dev:depend:libmysqlclient15off (>=5.0.51a-24+lenny2)but 5.0.32-7etch3 is to be installed Depend :libc6(>=2.7-1) but 2.3.6.ds1-13etch4 is to be installed E:Unmet dependencies.Try 'apt-get -f install' with no packages. --- Tried 'apt-get -f install' ,not working. Kernel 2.4.26-ts11 source.list :deb ftp://ftp.us.debain.org/debain stable main contrib non-free Please suggest me upon this.Will I need to changes in sources list file I don't know whether this right forum for above Query or not... -- Dinesh -- Dinesh
Re: how to migrate request-tracker database from sqlite3 to mysql
Boyd Stephen Smith Jr. wrote: > > No, thank $DEITY. I had a couple of jobs involving Oracle, but I tend to > avoid anything were I have to deal with too much proprietary software. I am using oracle at work and compiled tora with ora support. At this point I wanted to install the export tool and that's how I found out what's going on - _crazy_. > >>... so programmers can be kept buzzy :-) otherways we could have an AI >>engine about 10 years ago. > > Weak AI has existed for more than 10 years. if a state machine with a bit of variations is kind of AI ... well the steam engine was also kind of invention and progress for about a century > > Strong AI is still a pipe dream. It's not "just" a issue of time, we > don't > really have an idea what goes into a system like that. We don't know how > to imbue consciousness (or if that's just an illusion of complex > interactions) or even how to write a general learning system that can both > expand it's own scope with "meta"-assertions and operate both in > non-deterministic way and with incomplete information with > "fuzzy"-assertions. > > We've got some really interesting research projects happening now and in > the > past. Some have seen commercial applications. Japan has very interesting > specialty robots, but none driven by what anyone would consider a "strong" > AI. > > I'm not even sure we want strong AI. yes and no, what I mean that people get focused on stuff that shouldn't matter and could be solved in the way w3c does it. We and commercials too should focus on what's really important - education (from ai-it perspective). this will bring us closer to real AI. It's just a matter of time. do we want it sooner or later is our choice - or may be not. > >>functions are a big pain because PL/SQL is proprietary ... then there was >>the pgSQL coming close to PL/SQL but not exactly ... and so on, so I'm >>wondering where the world and we are going. especially open source >>community could be more standard oriented. > > That would be nice. I'd like to see more Free Software be certified, but > that usually costs , and doesn't always mesh well with the > Bazaar-style development that some projects use. > >>Perhaps we have to ask w3c to provide a markup for database and leave all >>this "pretty close" sql sh*t. > > Right, because every piece of HTML you see is strictly-conforming. W3C > hasn't done any better than any other standards organization. so DTD for SQL :-) > >>However I learned years ago something useful about databases. You have to >>plan the size, speed, scalability, functionality etc. _before_ you start >>using whatever database. >>You have to check export/import _before_ you start using whatever >> database. You better simulate database corruption _before_ you start >> using whatever database and so on. > > You should really be doing that with any piece of software. If you can't > evaluate it, definitely don't spend any money on it. If you haven't > tested it, don't put it into production. I mean databases turn to be critical at some point of time and it's usually too late to think about migration. That's how $$ software get's sold. The keyword is scalability. regards -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Re: how to migrate request-tracker database from sqlite3 to mysql
In , Emanoil Kotsev wrote: >Boyd Stephen Smith Jr. wrote: >> In , Emanoil Kotsev wrote: >>>Boyd Stephen Smith Jr. wrote: In , Emanoil Kotsev wrote: >Yeah, somehow SQL does not seem to be really "S"tandard :-) The "S" in SQL stands/stood for "Structured". [...] >>> >>>hehe, I was thinking (because reading about standardization of SQL) it >>>stands for standard. >>> >> Functions are a real issue. I believe there's some allowances for them >> in the standard, but the function body usually ends up being >> implementation specific. > >yeah tell me about that ... you ever tried to migrate oracle to oracle >higher/lower version?! No, thank $DEITY. I had a couple of jobs involving Oracle, but I tend to avoid anything were I have to deal with too much proprietary software. >... so programmers can be kept buzzy :-) otherways we could have an AI >engine about 10 years ago. Weak AI has existed for more than 10 years. Strong AI is still a pipe dream. It's not "just" a issue of time, we don't really have an idea what goes into a system like that. We don't know how to imbue consciousness (or if that's just an illusion of complex interactions) or even how to write a general learning system that can both expand it's own scope with "meta"-assertions and operate both in non-deterministic way and with incomplete information with "fuzzy"-assertions. We've got some really interesting research projects happening now and in the past. Some have seen commercial applications. Japan has very interesting specialty robots, but none driven by what anyone would consider a "strong" AI. I'm not even sure we want strong AI. >functions are a big pain because PL/SQL is proprietary ... then there was >the pgSQL coming close to PL/SQL but not exactly ... and so on, so I'm >wondering where the world and we are going. especially open source >community could be more standard oriented. That would be nice. I'd like to see more Free Software be certified, but that usually costs , and doesn't always mesh well with the Bazaar-style development that some projects use. >Perhaps we have to ask w3c to provide a markup for database and leave all >this "pretty close" sql sh*t. Right, because every piece of HTML you see is strictly-conforming. W3C hasn't done any better than any other standards organization. >However I learned years ago something useful about databases. You have to >plan the size, speed, scalability, functionality etc. _before_ you start >using whatever database. >You have to check export/import _before_ you start using whatever > database. You better simulate database corruption _before_ you start > using whatever database and so on. You should really be doing that with any piece of software. If you can't evaluate it, definitely don't spend any money on it. If you haven't tested it, don't put it into production. -- Boyd Stephen Smith Jr. ,= ,-_-. =. b...@iguanasuicide.net ((_/)o o(\_)) ICQ: 514984 YM/AIM: DaTwinkDaddy `-'(. .)`-' http://iguanasuicide.net/\_/ signature.asc Description: This is a digitally signed message part.
Re: how to migrate request-tracker database from sqlite3 to mysql
Boyd Stephen Smith Jr. wrote: > In , Emanoil Kotsev wrote: >>Boyd Stephen Smith Jr. wrote: >>> In , Emanoil Kotsev wrote: >>>>Yeah, somehow SQL does not seem to be really "S"tandard :-) >>> >>> The "S" in SQL stands/stood for "Structured". [...] >>> >>> In short, most SQL you will find is not strictly-conforming, just like >>> most shell scripts and C/C++ programs. >> >>hehe, I was thinking (because reading about standardization of SQL) it >>stands for standard. >>Thanks for pointing out. >> >>I've been playing with import/export sqlite - mysql/oracle. >>Exporting only simple sql structure works (no indices and funktions). > > Functions are a real issue. I believe there's some allowances for them in > the standard, but the function body usually ends up being implementation > specific. > > Plain indexes should be able to be pulled over fairly easily, though. > Unless you are using some odd index type (e.g.: Oracle's bit-mask index > type), it should have come over easily enough. > > Also, some *SQL products do not implement the whole of the standard or an > older version[1], which causes more problems for portability of SQL code. yeah tell me about that ... you ever tried to migrate oracle to oracle higher/lower version?! ... so programmers can be kept buzzy :-) otherways we could have an AI engine about 10 years ago. functions are a big pain because PL/SQL is proprietary ... then there was the pgSQL coming close to PL/SQL but not exactly ... and so on, so I'm wondering where the world and we are going. especially open source community could be more standard oriented. Perhaps we have to ask w3c to provide a markup for database and leave all this "pretty close" sql sh*t. However I learned years ago something useful about databases. You have to plan the size, speed, scalability, functionality etc. _before_ you start using whatever database. You have to check export/import _before_ you start using whatever database. You better simulate database corruption _before_ you start using whatever database and so on. sd story but at the time after Columbus there were also no planes ;-) regards -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Re: how to migrate request-tracker database from sqlite3 to mysql
In , Emanoil Kotsev wrote: >Boyd Stephen Smith Jr. wrote: >> In , Emanoil Kotsev wrote: >>>Yeah, somehow SQL does not seem to be really "S"tandard :-) >> >> The "S" in SQL stands/stood for "Structured". [...] >> >> In short, most SQL you will find is not strictly-conforming, just like >> most shell scripts and C/C++ programs. > >hehe, I was thinking (because reading about standardization of SQL) it >stands for standard. >Thanks for pointing out. > >I've been playing with import/export sqlite - mysql/oracle. >Exporting only simple sql structure works (no indices and funktions). Functions are a real issue. I believe there's some allowances for them in the standard, but the function body usually ends up being implementation specific. Plain indexes should be able to be pulled over fairly easily, though. Unless you are using some odd index type (e.g.: Oracle's bit-mask index type), it should have come over easily enough. Also, some *SQL products do not implement the whole of the standard or an older version[1], which causes more problems for portability of SQL code. -- Boyd Stephen Smith Jr. ,= ,-_-. =. b...@iguanasuicide.net ((_/)o o(\_)) ICQ: 514984 YM/AIM: DaTwinkDaddy `-'(. .)`-' http://iguanasuicide.net/\_/ [1] I think the most recent is SQL 2003. signature.asc Description: This is a digitally signed message part.
Re: how to migrate request-tracker database from sqlite3 to mysql
Boyd Stephen Smith Jr. wrote: > In , Emanoil Kotsev wrote: > >>Yeah, somehow SQL does not seem to be really "S"tandard :-) > > The "S" in SQL stands/stood for "Structured". However, SQL has been > standardized about 3 times, roughly the same number of times UNIX has been > standardized. However, like UNIX, each implementation has many, many > extensions that the uninformed or undisciplined commonly use. Also like > UNIX, in places where the standard has undefined or implementation-defined > behavior each implementation generally has consistent and predictable > behavior that even disciplined, experienced users may end up expecting > from an alternative implementation. > > In short, most SQL you will find is not strictly-conforming, just like > most shell scripts and C/C++ programs. hehe, I was thinking (because reading about standardization of SQL) it stands for standard. Thanks for pointing out. I know there are non-free import/export tools if in hurry and it's important, may be it's worth paying. I've been playing with import/export sqlite - mysql/oracle. Exporting only simple sql structure works (no indices and funktions). regards -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Re: how to migrate request-tracker database from sqlite3 to mysql
In , Emanoil Kotsev wrote: >Yeah, somehow SQL does not seem to be really "S"tandard :-) The "S" in SQL stands/stood for "Structured". However, SQL has been standardized about 3 times, roughly the same number of times UNIX has been standardized. However, like UNIX, each implementation has many, many extensions that the uninformed or undisciplined commonly use. Also like UNIX, in places where the standard has undefined or implementation-defined behavior each implementation generally has consistent and predictable behavior that even disciplined, experienced users may end up expecting from an alternative implementation. In short, most SQL you will find is not strictly-conforming, just like most shell scripts and C/C++ programs. -- Boyd Stephen Smith Jr. ,= ,-_-. =. b...@iguanasuicide.net ((_/)o o(\_)) ICQ: 514984 YM/AIM: DaTwinkDaddy `-'(. .)`-' http://iguanasuicide.net/\_/ signature.asc Description: This is a digitally signed message part.
Re: how to migrate request-tracker database from sqlite3 to mysql
Martin Kraus wrote: >> >> there is actually a nice php interface to sqlite which can do the export >> in sql. I'm not sure if you can import into mzsql, but I think there is >> such an option in phpmyadmin > > it's not a problem with exporting into sql. it's a problem with importing > sql into mysql, because there a subtle differences in table definitions > and for some reason importing into mysql didn't work twice. I've managed > to get it to work third time around. > > mk Yeah, somehow SQL does not seem to be really "S"tandard :-) ... and people are finding it out too late. Just curious - can you import into postres or other 'SQL' database? regards -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Re: how to migrate request-tracker database from sqlite3 to mysql
On Thu, Aug 20, 2009 at 06:55:25PM +0200, Emanoil Kotsev wrote: > Martin Kraus wrote: > > > > > hi. I'm trying to migrate request-tracker3.6 database from sqlite to mysql > > on > > lenny. Is there a way to export data from sqlite so they can be imported > > into mysql for request-tracker3.6? > > > > rt-dump-database doesn't export sqlite database and sqlite and mysql > > databases for rt are not compatible even if I dump sqlite database into > > sql and modify the file it can be imported into mysql. > > > > thanks for any tips > > martin > > there is actually a nice php interface to sqlite which can do the export in > sql. I'm not sure if you can import into mzsql, but I think there is such > an option in phpmyadmin it's not a problem with exporting into sql. it's a problem with importing sql into mysql, because there a subtle differences in table definitions and for some reason importing into mysql didn't work twice. I've managed to get it to work third time around. mk -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Re: how to migrate request-tracker database from sqlite3 to mysql
Martin Kraus wrote: > > hi. I'm trying to migrate request-tracker3.6 database from sqlite to mysql > on > lenny. Is there a way to export data from sqlite so they can be imported > into mysql for request-tracker3.6? > > rt-dump-database doesn't export sqlite database and sqlite and mysql > databases for rt are not compatible even if I dump sqlite database into > sql and modify the file it can be imported into mysql. > > thanks for any tips > martin there is actually a nice php interface to sqlite which can do the export in sql. I'm not sure if you can import into mzsql, but I think there is such an option in phpmyadmin regards -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Re: how to migrate request-tracker database from sqlite3 to mysql
In <20090819224241.gc22...@finrod>, Martin Kraus wrote: >On Wed, Aug 19, 2009 at 10:17:03PM +0200, Jesús M. Navarro wrote: >> On Wednesday 19 August 2009 02:37:37 Martin Kraus wrote: >> > hi. I'm trying to migrate request-tracker3.6 database from sqlite to >> > mysql on lenny. Is there a way to export data from sqlite so they can >> > be imported into mysql for request-tracker3.6? >> > >> > rt-dump-database doesn't export sqlite database and sqlite and mysql >> > databases for rt are not compatible even if I dump sqlite database into >> > sql and modify the file it can be imported into mysql. >> >> Did you already do your homework? >> >> <http://pkg-request-tracker.alioth.debian.org/3.6-databases/> > >Yes I did. It describes how to change database backend, bud rt-dump-database >doesn't dump ticket data from sqlite so it can't be imported into mysql. If > I do it by hand by dumping sql syntax from sqlite and (after tons of >modifications) import it into mysql, rt can see the tickets, search and > stuff, but can't add tickets, there are problems with user logins etc. Some sort of mixed approach sounds like it might work. Follow the directions to get everything but old tickets, then do you manual process to get all the existing tickets in. You might have to adjust the values of the MySQL SEQUENCEs (or whatever they call them). -- Boyd Stephen Smith Jr. ,= ,-_-. =. b...@iguanasuicide.net ((_/)o o(\_)) ICQ: 514984 YM/AIM: DaTwinkDaddy `-'(. .)`-' http://iguanasuicide.net/\_/ signature.asc Description: This is a digitally signed message part.
Re: how to migrate request-tracker database from sqlite3 to mysql
On Wed, Aug 19, 2009 at 10:17:03PM +0200, Jesús M. Navarro wrote: > On Wednesday 19 August 2009 02:37:37 Martin Kraus wrote: > > hi. I'm trying to migrate request-tracker3.6 database from sqlite to mysql > > on lenny. Is there a way to export data from sqlite so they can be > > imported into mysql for request-tracker3.6? > > > > rt-dump-database doesn't export sqlite database and sqlite and mysql > > databases for rt are not compatible even if I dump sqlite database into sql > > and modify the file it can be imported into mysql. > > Did you already do your homework? > > Google: "request tracker" migration from sqlite to mysql -> > http://pkg-request-tracker.alioth.debian.org/3.6-databases/ Yes I did. It describes how to change database backend, bud rt-dump-database doesn't dump ticket data from sqlite so it can't be imported into mysql. If I do it by hand by dumping sql syntax from sqlite and (after tons of modifications) import it into mysql, rt can see the tickets, search and stuff, but can't add tickets, there are problems with user logins etc. mk -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Re: how to migrate request-tracker database from sqlite3 to mysql
On Wednesday 19 August 2009 02:37:37 Martin Kraus wrote: > hi. I'm trying to migrate request-tracker3.6 database from sqlite to mysql > on lenny. Is there a way to export data from sqlite so they can be > imported into mysql for request-tracker3.6? > > rt-dump-database doesn't export sqlite database and sqlite and mysql > databases for rt are not compatible even if I dump sqlite database into sql > and modify the file it can be imported into mysql. Did you already do your homework? Google: "request tracker" migration from sqlite to mysql -> http://pkg-request-tracker.alioth.debian.org/3.6-databases/ -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Re: how to migrate request-tracker database from sqlite3 to mysql
On Wed, Aug 19, 2009 at 10:18:49AM -0500, Boyd Stephen Smith Jr. wrote: > So, request-tracker uses a different table layout (schema) depending on what > database server it is connecting to? If so, you'll probably have to roll a > one-off to translate from one to the other. If not, please clarify. > > The one-off can probably be as simple has using the SQLite command-line > tools to execute a select that matches each table in the MySQL schema. > Then, you slightly munge the data into INSERT statements that you feed into > MySQL with its command-line tools. I've done that, but even if the import is successfull, there are areas of rt that just do not work. Tables look almost the same, if I take the time to convert some of the NULLs into 0. Since it doesn't work, there are some other problems but I can't figure out what they are. I'm not much into programing and not at all into perl, co before I go that way, I just figured I'd ask if someone else faced the same problem of migration from sqlite to mysql and just copy that:) mk -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Re: how to migrate request-tracker database from sqlite3 to mysql
In <20090819003737.gd2...@finrod>, Martin Kraus wrote: >hi. I'm trying to migrate request-tracker3.6 database from sqlite to mysql > on lenny. Is there a way to export data from sqlite so they can be > imported into mysql for request-tracker3.6? > >rt-dump-database doesn't export sqlite database and sqlite and mysql > databases for rt are not compatible even if I dump sqlite database into > sql and modify the file it can be imported into mysql. So, request-tracker uses a different table layout (schema) depending on what database server it is connecting to? If so, you'll probably have to roll a one-off to translate from one to the other. If not, please clarify. The one-off can probably be as simple has using the SQLite command-line tools to execute a select that matches each table in the MySQL schema. Then, you slightly munge the data into INSERT statements that you feed into MySQL with its command-line tools. -- Boyd Stephen Smith Jr. ,= ,-_-. =. b...@iguanasuicide.net ((_/)o o(\_)) ICQ: 514984 YM/AIM: DaTwinkDaddy `-'(. .)`-' http://iguanasuicide.net/\_/ signature.asc Description: This is a digitally signed message part.
Re: how to migrate request-tracker database from sqlite3 to mysql
> > hi. I'm trying to migrate request-tracker3.6 database from sqlite > to mysql on lenny. Is there a way to export data from sqlite > so they can be imported into mysql for request-tracker3.6? > martin One way might be to export from sqlite as .csv files and then import into mysql Following is an example sqlite session for the export of two tables that comprise a simple data base $ sqlite3 abook.sql3 SQLite version 3.5.9 Enter ".help" for instructions sqlite> sqlite> .tables addr names sqlite> sqlite> .mode csv sqlite> sqlite> .output addr.csv sqlite> select * from addr ; sqlite> sqlite> .output names.csv sqlite> select * from names ; sqlite> sqlite> .quit -- Stanley C. Kitching Human Being Phoenix, Arizona -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
how to migrate request-tracker database from sqlite3 to mysql
hi. I'm trying to migrate request-tracker3.6 database from sqlite to mysql on lenny. Is there a way to export data from sqlite so they can be imported into mysql for request-tracker3.6? rt-dump-database doesn't export sqlite database and sqlite and mysql databases for rt are not compatible even if I dump sqlite database into sql and modify the file it can be imported into mysql. thanks for any tips martin -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
mysql-server install script defective
The script couldn't install because it doesn't know what to do with the --skip-federated option being passed. Apparently a new option being used by mysql. -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
mysql-server-5.0 installation scripts
Appear to be broken and prevent the installation of mysql-server. -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Re: trying to pin down a php mysql error
I resolved this, it seemed to be an issue with boxes using php4 and apache2. Basically, for the boxes which reported the mysql error, I installed libapache2-mod-php5, which replaced all of php4*, it needed some extra php5 packages, just copy the ones that were removed, change the 4 to 5 :) I also did an apt-get remove --purge phpmyadmin and re-installed it, which then asked me which webserver I use, chose the correct one, and presto, all working. I'm sure it's had something to do with the upgrades from apache1 to apache2 and php4 to php5, somewhere along the line, it got sad and broke :) Anyway, all good. Hope this helps someone. Regards, Ross. >>Hi all, >> >>Over the last few days a lot of my Debian boxes are giving me errors via >>the phpmyadmin login page. >> DISCLAIMER: This e-mail and any files transmitted with it may be privileged and confidential, and are intended only for the use of the intended recipient. If you are not the intended recipient or responsible for delivering this e-mail to the intended recipient, any use, dissemination, forwarding, printing or copying of this e-mail and any attachments is strictly prohibited. If you have received this e-mail in error, please REPLY TO the SENDER to advise the error AND then DELETE the e-mail from your system. Any views expressed in this e-mail and any files transmitted with it are those of the individual sender, except where the sender specifically states them to be the views of our organisation. Our organisation does not represent or warrant that the attached files are free from computer viruses or other defects. 26/6/2009 The user assumes all responsibility for any loss or damage resulting directly or indirectly from the use of the attached files. In any event, the liability to our organisation is limited to either the resupply of the attached files or the cost of having the attached files resupplied. -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
trying to pin down a php mysql error
Hi all, Over the last few days a lot of my Debian boxes are giving me errors via the phpmyadmin login page. == Error MySQL said: Documentation #1045 - Access denied for user 'root'@'localhost' (using password: NO) Invalid hostname for server 1. Please review your configuration. Cannot load mysqli extension. Please check your PHP configuration. - Documentation == Some are reporting the above errors, others are reporting just the hostname errors below. == MySQL said: Documentation #1045 - Access denied for user 'root'@'localhost' (using password: NO) Invalid hostname for server 1. Please review your configuration. == I cannot login via phpmyadmin anymore, only command line. It has to be a recent update, the only one I can think of "that may be related" is the Apache2 updates released on the 17th; Package : apache2 Vulnerability : insufficient security check Problem type : local Debian-specific: no CVE Id(s) : CVE-2009-1195 It doesn't look to be affecting Apache1 boxes (I haven't checked them all yet). It is quite broad, across both Etch and Lenny Servers, php4 and php5. Anyone else getting these ? I checked the list but don't see anything related, I may have missed something. Thanks in advance. Regards, Ross DISCLAIMER: This e-mail and any files transmitted with it may be privileged and confidential, and are intended only for the use of the intended recipient. If you are not the intended recipient or responsible for delivering this e-mail to the intended recipient, any use, dissemination, forwarding, printing or copying of this e-mail and any attachments is strictly prohibited. If you have received this e-mail in error, please REPLY TO the SENDER to advise the error AND then DELETE the e-mail from your system. Any views expressed in this e-mail and any files transmitted with it are those of the individual sender, except where the sender specifically states them to be the views of our organisation. Our organisation does not represent or warrant that the attached files are free from computer viruses or other defects. 25/6/2009 The user assumes all responsibility for any loss or damage resulting directly or indirectly from the use of the attached files. In any event, the liability to our organisation is limited to either the resupply of the attached files or the cost of having the attached files resupplied. -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Akonadi giving mysql warning
I'm getting the following warning from akonadi as part of the new kde4: 090612 20:40:43 InnoDB: Started; log sequence number 0 134323 090612 20:40:44 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them Obviously it's a warning and not a fatal error, but what can I do to make it go away? -- "Oh, look: rocks!" -- Doctor Who, "Destiny of the Daleks" -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Re: MySQL admin qref? [Solved]
deb...@waysoft.com :
> On Sat, 6 Jun 2009 18:41:10 -0600 "s. keeling" wrote:
> > Incoming from Robert Baron:
> > > On Sat, Jun 6, 2009 at 5:13 PM, s. keeling
> > > wrote:
> > > >
> > > > (0) [root] infidel /root_ mysql
> > > > ERROR 1045 (28000): Access denied for user
> > > > 'root'@'localhost' (using password: NO)
> > >
> > > have you tried the following?
> > >
> > > mysqladmin -u root password NEWPASSWORD
> >
> > (0) [root] infidel /root_ mysqladmin -u root password '.'
> > mysqladmin: connect to server at 'localhost' failed
> > error: 'Access denied for user 'root'@'localhost' (using password:
> > NO)'
>
> Looks like root already has a password set. If so, and you know what
> it is, try...
>mysqladmin -u root -p password NEWPASSWORD
> and you will be prompted for the old password.
>
> If you don't think there is an old password, or you forgot it, try one
> of the sites that explain how to reset a mysql root password, e.g:
> <http://blog.dotkam.com/2007/04/10/mysql-reset-lost-root-password/>
Much appreciated. I wouldn't trust everything on that page (kill -9
mysqld?!?), but this works:
/etc/init.d/mysql stop
mysqld_safe --skip-grant-tables &
mysql -u root
mysql> update user set password=PASSWORD("...") where user="root";
mysql> flush privileges;
mysql> quit;
then:
pkill mysqld_safe
/etc/init.d/mysql start
mysql -u root -p
and that asks for and accepts the new password. Thanks for your help. :-)
And yes, I'm well aware that mysql's root user should not be confused
with system root.
This is lenny, fwiw.
--
Any technology distinguishable from magic is insufficiently advanced.
(*)http://blinkynet.net/comp/uip5.html Linux Counter #80292
- -http://www.faqs.org/rfcs/rfc1855.htmlPlease, don't Cc: me.
--
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Re: MySQL admin qref?
On Sat, 6 Jun 2009 18:41:10 -0600 "s. keeling" wrote: > Incoming from Robert Baron: > > On Sat, Jun 6, 2009 at 5:13 PM, s. keeling > > wrote: > > > > > > Hi. I'm trying to config mysql. I've done this before, and it > > > worked well, and I took notes, but they're not helping at the > > > moment. I haven't tried everything yet, and I'd rather come up > > > with a plan than work from flawed notes. > > > > > > On Debian, how do you set the mysql root user pword? I've tried > > > mysql-admin, but I don't know what I'm doing. dpkg-reconfigure > > > was no help. > > > > > > Once I can get in, I can create a user and work from there. > > > > > > (0) [root] infidel /root_ mysql > > > ERROR 1045 (28000): Access denied for user > > > 'root'@'localhost' (using password: NO) > > > > > > Once I'm in, I can: > > > > > > update mysql.user set password=password(...) where user='root'; > > > > > > How's this supposed to be done? > > > > have you tried the following? > > > > mysqladmin -u root password NEWPASSWORD > > Thanks man. I've spent hours hunting my notes and history for that. > I remember doing that. Now: > > (0) [root] infidel /root_ mysqladmin -u root password '.' > mysqladmin: connect to server at 'localhost' failed > error: 'Access denied for user 'root'@'localhost' (using password: > NO)' > > mysqld is running, but this is the first time I've been anywhere near > this mysql install (and I really hate being a dba. :-) > > Looks like root already has a password set. If so, and you know what it is, try... mysqladmin -u root -p password NEWPASSWORD and you will be prompted for the old password. If you don't think there is an old password, or you forgot it, try one of the sites that explain how to reset a mysql root password, e.g: <http://blog.dotkam.com/2007/04/10/mysql-reset-lost-root-password/> jeff BTW, mysql root is not the same as Unix root (i.e. superuser). I do all mysql configuration and tweaks (including mysql root) from my (Linux) user (not root) account. You can try that (although your system may be set up differently and require (Linux) root???) -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Re: MySQL admin qref?
Incoming from Robert Baron:
> On Sat, Jun 6, 2009 at 5:13 PM, s. keeling wrote:
> >
> > Hi. I'm trying to config mysql. I've done this before, and it worked
> > well, and I took notes, but they're not helping at the moment. I
> > haven't tried everything yet, and I'd rather come up with a plan than
> > work from flawed notes.
> >
> > On Debian, how do you set the mysql root user pword? I've tried
> > mysql-admin, but I don't know what I'm doing. dpkg-reconfigure was no
> > help.
> >
> > Once I can get in, I can create a user and work from there.
> >
> > (0) [root] infidel /root_ mysql
> > ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
> > password: NO)
> >
> > Once I'm in, I can:
> >
> > update mysql.user set password=password(...) where user='root';
> >
> > How's this supposed to be done?
>
> have you tried the following?
>
> mysqladmin -u root password NEWPASSWORD
Thanks man. I've spent hours hunting my notes and history for that.
I remember doing that. Now:
(0) [root] infidel /root_ mysqladmin -u root password '.'
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
mysqld is running, but this is the first time I've been anywhere near
this mysql install (and I really hate being a dba. :-)
--
Any technology distinguishable from magic is insufficiently advanced.
(*) :(){ :|:& };:
- -
--
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
MySQL admin qref?
Hi. I'm trying to config mysql. I've done this before, and it worked well, and I took notes, but they're not helping at the moment. I haven't tried everything yet, and I'd rather come up with a plan than work from flawed notes. On Debian, how do you set the mysql root user pword? I've tried mysql-admin, but I don't know what I'm doing. dpkg-reconfigure was no help. Once I can get in, I can create a user and work from there. (0) [root] infidel /root_ mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Once I'm in, I can: update mysql.user set password=password(...) where user='root'; How's this supposed to be done? -- Any technology distinguishable from magic is insufficiently advanced. (*)http://blinkynet.net/comp/uip5.html Linux Counter #80292 - -http://www.faqs.org/rfcs/rfc1855.htmlPlease, don't Cc: me. -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Fwd: Access denied for user 'root'@'localhost' in mysql
False alarm!!!
I forgot to remove the skip-grant-tables and restart mysql.
When I try to login with mysql -u "r...@beryllium -p", I receive the
following:
ERROR 1045 (28000): Access denied for user 'r...@beryllium'@'localhost'
(using password: YES)
I guess I should add r...@localhost in mysql.user...
Bern
On Wed, Jun 3, 2009 at 7:48 PM, Bernard Fay wrote:
> As fas as I understand it, there is no need to say "update mysql.user set
> ..." because we have to say "use mysql" first.
> So the update command should know the table user is part of mysql. Right?
>
> I really believe the problem comes from the fact there is know
> r...@localhost in mysql.user. I have only r...@beryllium and
> debian-sys-ma...@localhost.
>
> I update the password of r...@beryllium and I can login with mysql -u
> r...@beryllium -p .
>
> Is it a normal situation or I should have r...@localhost?
>
> Thanks for the help
> Bern
>
>
>
> On Wed, Jun 3, 2009 at 5:13 PM, Stackpole, Chris
> wrote:
>
>> *>From:* Bernard Fay [mailto:bernard@gmail.com]
>> >*Sent:* Wednesday, June 03, 2009 2:59 PM
>> >*Subject:* Access denied for user 'root'@'localhost' in mysql
>>
>> >
>>
>> >Hi,
>> >
>> >I installed MySQL in Lenny.
>> >When I try to login in with mysql -u root -p, I receive :
>> >
>> >ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
>> password: YES)
>> >
>> >I tried to reset the password of root by adding skip-grant-tables in
>> my.cnf then restart mysql.
>> >I could login in with mysql -u root then I ran the following commands:
>> >
>> >mysql> update user set password=password('password') where user='root';
>> >mysql> flush privileges;
>> >
>> >I removed skip-grant-tables from my.cnf and restarted mysqld. I still
>> have:
>> >ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
>> password: YES)
>> >
>> >Any idea or clues about how to solve this issue?
>> >
>> >Thanks,
>> >Bernard
>>
>> Two methods on the same topic.
>>
>> 1) What database are you using when you login? If I remember correctly (it
>> has been a while)
>>
>> you need to declare the user table like “update mysql.user set….” And not
>> just “update user set…”
>> That may be the problem if it is trying to update the wrong
>> table/database.
>>
>>
>>
>> 2) Maybe this is one of those multiple-ways-of-completing-the-same-task
>> kind of scenarios but I reset passwords like so:
>> SET PASSWORD FOR r...@localhost=password('MyNewPassword');
>>
>> I don’t seem to have problems with it.
>>
>>
>>
>> Other then the password reset, your methods seem right to me as long as
>> you are on the localhost.
>>
>>
>>
>> Hope this helps.
>>
>>
>>
>> Have fun!
>>
>> ~Stack~
>>
>
>
Fwd: Access denied for user 'root'@'localhost' in mysql
`
As fas as I understand it, there is no need to say "update mysql.user set
..." because we have to say "use mysql" first.
So the update command should know the table user is part of mysql. Right?
I really believe the problem comes from the fact there is know
r...@localhost in mysql.user. I have only r...@beryllium and
debian-sys-ma...@localhost.
I update the password of r...@beryllium and I can login with mysql -u
r...@beryllium -p .
Is it a normal situation or I should have r...@localhost?
Thanks for the help
Bern
On Wed, Jun 3, 2009 at 5:13 PM, Stackpole, Chris wrote:
> *>From:* Bernard Fay [mailto:bernard@gmail.com]
> >*Sent:* Wednesday, June 03, 2009 2:59 PM
> >*Subject:* Access denied for user 'root'@'localhost' in mysql
>
> >
>
> >Hi,
> >
> >I installed MySQL in Lenny.
> >When I try to login in with mysql -u root -p, I receive :
> >
> >ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
> password: YES)
> >
> >I tried to reset the password of root by adding skip-grant-tables in
> my.cnf then restart mysql.
> >I could login in with mysql -u root then I ran the following commands:
> >
> >mysql> update user set password=password('password') where user='root';
> >mysql> flush privileges;
> >
> >I removed skip-grant-tables from my.cnf and restarted mysqld. I still
> have:
> >ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
> password: YES)
> >
> >Any idea or clues about how to solve this issue?
> >
> >Thanks,
> >Bernard
>
> Two methods on the same topic.
>
> 1) What database are you using when you login? If I remember correctly (it
> has been a while)
>
> you need to declare the user table like “update mysql.user set….” And not
> just “update user set…”
> That may be the problem if it is trying to update the wrong table/database.
>
>
>
> 2) Maybe this is one of those multiple-ways-of-completing-the-same-task
> kind of scenarios but I reset passwords like so:
> SET PASSWORD FOR r...@localhost=password('MyNewPassword');
>
> I don’t seem to have problems with it.
>
>
>
> Other then the password reset, your methods seem right to me as long as you
> are on the localhost.
>
>
>
> Hope this helps.
>
>
>
> Have fun!
>
> ~Stack~
>
Fwd: Access denied for user 'root'@'localhost' in mysql
-- Forwarded message -- From: Bernard Fay Date: Wed, Jun 3, 2009 at 5:00 PM Subject: Re: Access denied for user 'root'@'localhost' in mysql To: paul.le...@quadensemble.co.uk Thanks for your reply, Paul. Yes, I tried without the -p switch and it didn't work. Also, I just found that in mysql.user there is no host:localhost and user:root but I have host:beryllium and user:root; beryllium being my hostname. Maybe we have something here. Bern On Wed, Jun 3, 2009 at 4:45 PM, Paul Lewis wrote: > On 03/06/09 20:58:45, Bernard Fay wrote: > >> Hi, >> >> I installed MySQL in Lenny. >> When I try to login in with mysql -u root -p, I receive : >> >> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using >> password: YES) >> > > I wonder if there is a password defined before you set the root password in > mysql yourself? I think not. Try connecting without th -p switch. > > >> Any idea or clues about how to solve this issue? >> >> Thanks, >> Bernard >> >> > Otherwise, have a look here. > > http://dev.mysql.com/doc/refman/5.1/en/connection-access.html > > > > -- > To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.orgwith a > subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org > >
RE: Access denied for user 'root'@'localhost' in mysql
>From: Bernard Fay [mailto:bernard@gmail.com]
>Sent: Wednesday, June 03, 2009 2:59 PM
>Subject: Access denied for user 'root'@'localhost' in mysql
>
>Hi,
>
>I installed MySQL in Lenny.
>When I try to login in with mysql -u root -p, I receive :
>
>ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES)
>
>I tried to reset the password of root by adding skip-grant-tables in
my.cnf then restart mysql.
>I could login in with mysql -u root then I ran the following commands:
>
>mysql> update user set password=password('password') where user='root';
>mysql> flush privileges;
>
>I removed skip-grant-tables from my.cnf and restarted mysqld. I still
have:
>ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES)
>
>Any idea or clues about how to solve this issue?
>
>Thanks,
>Bernard
Two methods on the same topic.
1) What database are you using when you login? If I remember correctly
(it has been a while)
you need to declare the user table like "update mysql.user set" And
not just "update user set..."
That may be the problem if it is trying to update the wrong
table/database.
2) Maybe this is one of those multiple-ways-of-completing-the-same-task
kind of scenarios but I reset passwords like so:
SET PASSWORD FOR r...@localhost=password('MyNewPassword');
I don't seem to have problems with it.
Other then the password reset, your methods seem right to me as long as
you are on the localhost.
Hope this helps.
Have fun!
~Stack~
Re: Access denied for user 'root'@'localhost' in mysql
On 03/06/09 21:45:15, Paul Lewis wrote: Hi, I installed MySQL in Lenny. When I try to login in with mysql -u root -p, I receive : ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) I wonder if there is a password defined before you set the root password in mysql yourself? I think not. Try connecting without th -p switch. Any idea or clues about how to solve this issue? Thanks, Bernard Otherwise, have a look here. http://dev.mysql.com/doc/refman/5.1/en/connection-access.html --To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.orgwith a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Re: Access denied for user 'root'@'localhost' in mysql
On 03/06/09 20:58:45, Bernard Fay wrote: Hi, I installed MySQL in Lenny. When I try to login in with mysql -u root -p, I receive : ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) I wonder if there is a password defined before you set the root password in mysql yourself? I think not. Try connecting without th -p switch. Any idea or clues about how to solve this issue? Thanks, Bernard Otherwise, have a look here. http://dev.mysql.com/doc/refman/5.1/en/connection-access.html -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Access denied for user 'root'@'localhost' in mysql
Hi,
I installed MySQL in Lenny.
When I try to login in with mysql -u root -p, I receive :
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES)
I tried to reset the password of root by adding skip-grant-tables in my.cnf
then restart mysql.
I could login in with mysql -u root then I ran the following commands:
mysql> update user set password=password('password') where user='root';
mysql> flush privileges;
I removed skip-grant-tables from my.cnf and restarted mysqld. I still have:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES)
Any idea or clues about how to solve this issue?
Thanks,
Bernard
Re: mysql server to remote client
2009/6/4 Umarzuki Mochlis > > > 2009/6/3 abdelkader belahcene > > Hi, >> I installed mysql, locally on the same machine, i use it, via teminal or >> thru apache/php. >> The problem is when I try to access from a remote machine, the following >> command fails: >> mysql -h 192.168.10.10 -u root -p >> >> Where 192.168.10.10 is the address of the server running mysql. >> thanks for help >> best regards >> bela >> > i remembered on the remote server you had to enable your IP to access the > db as user root, at least from a mysql class i had attended, not from what i > had done. > refer http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html > > > > -- > Regards, > > Umarzuki Mochlis > http://gameornot.net > -- Regards, Umarzuki Mochlis http://gameornot.net
Re: mysql server to remote client
2009/6/3 abdelkader belahcene > Hi, > I installed mysql, locally on the same machine, i use it, via teminal or > thru apache/php. > The problem is when I try to access from a remote machine, the following > command fails: > mysql -h 192.168.10.10 -u root -p > > Where 192.168.10.10 is the address of the server running mysql. > thanks for help > best regards > bela > i remembered on the remote server you had to enable your IP to access the db as user root, at least from a mysql class i had attended, not from what i had done. -- Regards, Umarzuki Mochlis http://gameornot.net
mysql server to remote client
Hi, I installed mysql, locally on the same machine, i use it, via teminal or thru apache/php. The problem is when I try to access from a remote machine, the following command fails: mysql -h 192.168.10.10 -u root -p Where 192.168.10.10 is the address of the server running mysql. thanks for help best regards bela
mysql and openoffice
I seldom have need for openoffice but I'm thinking I'll be wanting to do some mailmerging. So I fire up openoffice and select New-Database and try to establish a jbdc connection to an existing mysql database. When I click on 'Test class' I get a requester 'The JDBC driver could not be loaded.' Is there some additional package I need to install? openoffice.org: Installed: 1:3.0.1-9 Candidate: 1:3.0.1-9 Version table: 1:3.1.0-1 0 200 ftp://ftp.debian.org unstable/main Packages *** 1:3.0.1-9 0 990 ftp://debian.uchicago.edu testing/main Packages 100 /var/lib/dpkg/status -- "Shoot for the moon. Even if you miss, you'll land among the stars - Les Brown Rick Pasottor...@niof.nethttp://www.niof.net -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Re: mysql server stopped and i cannot restart
B-Fly wrote: > Any luck in resolving this issue? I just rebooted by computer, and guess > what... mysql refuses to start now. > [...] > > It does complain about logfiles not being there, but they are, and > readible by mysql user. > > I am starting to get a bit puzzled. Any helps? > > Ronald Replying to myself... Apparently my MySQL problem is just a consequence of another problem. It seems I am not able to use any non-root users. Since MySQL uses the mysql user, that is probably the cause. r...@warthog:/# su user1 Cannot execute /bin/bash: Permission denied r...@warthog:/# ls /bin/bash -alF -rwxr-xr-x 1 root root 725100 2009-03-01 10:31 /bin/bash* So probably there is some authentification issue somewhere. Keep on looking. Ronald -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Re: mysql server stopped and i cannot restart
Any luck in resolving this issue? I just rebooted by computer, and guess what... mysql refuses to start now. Mar 22 16:54:05 warthog mysqld_safe[2740]: started Mar 22 16:54:05 warthog mysqld[2744]: 090322 16:54:05 [Warning] option 'net_buffer_length': unsigned value 8388608 adjusted to 1048576 Mar 22 16:54:05 warthog mysqld[2744]: ^G/usr/sbin/mysqld: File '/var/log/mysql/mysql-slow.log' not found (Errcode: 13) Mar 22 16:54:05 warthog mysqld[2744]: 090322 16:54:05 [ERROR] Could not use /var/log/mysql/mysql-slow.log for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it. Mar 22 16:54:05 warthog mysqld[2744]: ^G/usr/sbin/mysqld: File '/var/log/mysql/mysql-bin.index' not found (Errcode: 13) Mar 22 16:54:05 warthog mysqld[2744]: 090322 16:54:05 [ERROR] Aborting Mar 22 16:54:05 warthog mysqld[2744]: Mar 22 16:54:05 warthog mysqld[2744]: 090322 16:54:05 [Note] /usr/sbin/mysqld: Shutdown complete Mar 22 16:54:05 warthog mysqld[2744]: Mar 22 16:54:05 warthog mysqld_safe[2746]: ended Mar 22 16:54:19 warthog /etc/init.d/mysql[2896]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Mar 22 16:54:19 warthog /etc/init.d/mysql[2896]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed Mar 22 16:54:19 warthog /etc/init.d/mysql[2896]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Mar 22 16:54:19 warthog /etc/init.d/mysql[2896]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Mar 22 16:54:19 warthog /etc/init.d/mysql[2896]: It does complain about logfiles not being there, but they are, and readible by mysql user. I am starting to get a bit puzzled. Any helps? Ronald harland christofferson wrote: > I am running 2.6.18-5-amd64 > > For some reason, the mysql server stopped and I cannot restart it. I > have not upgraded and the machine was running nominally otherwise for > 120+ days. > > $cat /var/log/messages | grep mysql > > Mar 21 12:04:57 localhost mysqld_safe[7775]: started > Mar 21 12:04:57 localhost mysqld[7778]: ^G/usr/sbin/mysqld: File > '/var/log/mysql/mysql-bin.index' not found (Errcode: 13) > Mar 21 12:04:57 localhost mysqld[7778]: 090321 12:04:57 [ERROR] Aborting > Mar 21 12:04:57 localhost mysqld[7778]: > Mar 21 12:04:57 localhost mysqld[7778]: 090321 12:04:57 [Note] > /usr/sbin/ mysqld: Shutdown complete > Mar 21 12:04:57 localhost mysqld[7778]: > Mar 21 12:04:57 localhost mysqld_safe[7780]: ended > Mar 21 12:05:12 localhost /etc/init.d/mysql[7915]: 0 processes alive and > '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in > Mar 21 12:05:12 localhost /etc/init.d/mysql[7915]: > ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed > Mar 21 12:05:12 localhost /etc/init.d/mysql[7915]: error: 'Can't connect > to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' > Mar 21 12:05:12 localhost /etc/init.d/mysql[7915]: Check that mysqld is > running and that the socket: '/var/run/mysqld/mysqld.sock' exists! > Mar 21 12:05:12 localhost /etc/init.d/mysql[7915]: > > > I created a /var/log/mysql/mysql-bin.index file and gave ownership > mysql:mysql. I have no idea if this previously existed or not, or, what > information should be in this file. > > Does anyone have sugg estions? I've been reading all morning but haven't > found anything helpful yet. > > Harland > > > > > > -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Re: mysql server stopped and i cannot restart
Quoth harland christofferson at 2009-03-22 02:39... > For some reason, the mysql server stopped and I cannot restart it. I > have not upgraded and the machine was running nominally otherwise for > 120+ days. ... > Does anyone have suggestions? I've been reading all morning but haven't > found anything helpful yet. You might want to look at the MySQL error log - should give you something more meaningful than the system log. Note sure of the location of this in a default Debian installation as I always use my own highly customised LAMP stack. Look in the MySQL data directory (wherever that might be - /var/lib/mysql is MySQL AB's own default) and have a look in the log file there which will be based on your host name with a .err suffix. The .err file has always got me out of trouble before. Hope this helps. Cheers M -- Matthew Smith Smiffytech - Technology Consulting & Web Application Development Business: http://www.smiffytech.com/ Blog/personal: http://www.smiffysplace.com/ LinkedIn: http://www.linkedin.com/in/smiffy Skype: msmiffy Twitter: @smiffytech -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
mysql server stopped and i cannot restart
I am running 2.6.18-5-amd64 For some reason, the mysql server stopped and I cannot restart it. I have not upgraded and the machine was running nominally otherwise for 120+ days. $cat /var/log/messages | grep mysql Mar 21 12:04:57 localhost mysqld_safe[7775]: started Mar 21 12:04:57 localhost mysqld[7778]: ^G/usr/sbin/mysqld: File '/var/log/mysql/mysql-bin.index' not found (Errcode: 13) Mar 21 12:04:57 localhost mysqld[7778]: 090321 12:04:57 [ERROR] Aborting Mar 21 12:04:57 localhost mysqld[7778]: Mar 21 12:04:57 localhost mysqld[7778]: 090321 12:04:57 [Note] /usr/sbin/mysqld: Shutdown complete Mar 21 12:04:57 localhost mysqld[7778]: Mar 21 12:04:57 localhost mysqld_safe[7780]: ended Mar 21 12:05:12 localhost /etc/init.d/mysql[7915]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Mar 21 12:05:12 localhost /etc/init.d/mysql[7915]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed Mar 21 12:05:12 localhost /etc/init.d/mysql[7915]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Mar 21 12:05:12 localhost /etc/init.d/mysql[7915]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Mar 21 12:05:12 localhost /etc/init.d/mysql[7915]: I created a /var/log/mysql/mysql-bin.index file and gave ownership mysql:mysql. I have no idea if this previously existed or not, or, what information should be in this file. Does anyone have suggestions? I've been reading all morning but haven't found anything helpful yet. Harland
[SOLVED] MySQL Clustering; Load balancing is not working.
The problem I was having is now fixed. I started Googling (<- sp?? Meh, oh well.) for other guides to see if I could spot some difference. It took me a while, but I found a guide where others were having the same problem I did. Eventually the answer was linked to from yet another location. I won't bother linking to all the various places of discussion, but here is the post with the final solution. http://www.howtoforge.com/forums/showpost.php?p=60388&postcount=5 So now everything appears to be working. Hooray! Now to go beat it up to see if I can break it again and learn something valuable* from it :-D. Thanks for the help! ~Stack~ * If you have suggestions/ideas of something I could do to further educate myself in these matters, please post! -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
RE: MySQL Clustering; Load balancing is not working.
My apologies everyone. My mail client is ultra-failing at posting this email for some reason. I don't think it liked the hash signs. > From: Jeff D [mailto:fixedo...@gmail.com] > Sent: Thursday, February 19, 2009 10:43 PM > Subject: Re: MySQL Clustering; Load balancing is not working. [snip] > > your config looks ok. The one other thing I would check is the entries in > your /etc/sysctl.conf to turn off arp. That sounds like that may be the > main issue here What I was trying to say in my other emails, which came out in jibberish with lines crunched together, was that for my arp settings I just copied and pasted from the article. Are those the correct settings I should be using? It is at the bottom of the page in section 6.5. http://www.howtoforge.com/setting-up-a-loadbalanced-mysql-cluster-with-m ysql5.1-p3 Thanks! ~Stack~ -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
RE: MySQL Clustering; Load balancing is not working.
Trying my post again. The formatting came out all weird for some unknown reason. > From: Jeff D [mailto:fixedo...@gmail.com] > Sent: Thursday, February 19, 2009 10:43 PM > Subject: Re: MySQL Clustering; Load balancing is not working. > [snip] > your config looks ok. The one other thing I would check is the entries in > your /etc/sysctl.conf to turn off arp. That sounds like that may be the > main issue here I used the entries that were in the tutorial[1] for arp. I just did a straight cut and paste. Is there something else I should have done? # Enable configuration of arp_ignore option net.ipv4.conf.all.arp_ignore = 1 # When an arp request is received on eth0, only respond if that address is # configured on eth0. In particular, do not respond if the address is # configured on lo net.ipv4.conf.eth0.arp_ignore = 1 # Ditto for eth1, add for all ARPing interfaces #net.ipv4.conf.eth1.arp_ignore = 1 # Enable configuration of arp_announce option net.ipv4.conf.all.arp_announce = 2 # When making an ARP request sent through eth0 Always use an address that # is configured on eth0 as the source address of the ARP request. If this # is not set, and packets are being sent out eth0 for an address that is on # lo, and an arp request is required, then the address on lo will be used. # As the source IP address of arp requests is entered into the ARP cache on # the destination, it has the effect of announcing this address. This is # not desirable in this case as adresses on lo on the real-servers should # be announced only by the linux-director. net.ipv4.conf.eth0.arp_announce = 2 # Ditto for eth1, add for all ARPing interfaces #net.ipv4.conf.eth1.arp_announce = 2 Thanks for the help! ~Stack~ [1] http://www.howtoforge.com/setting-up-a-loadbalanced-mysql-cluster-with-m ysql5.1-p3 -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
RE: MySQL Clustering; Load balancing is not working.
Sorry for the long delay. Just how weekends go sometimes... > From: Jeff D [mailto:fixedo...@gmail.com] > Sent: Thursday, February 19, 2009 10:43 PM > Subject: Re: MySQL Clustering; Load balancing is not working. > [snip] > your config looks ok. The one other thing I would check is the entries in > your /etc/sysctl.conf to turn off arp. That sounds like that may be the > main issue here I used the entries that were in the tutorial[1] for arp. I just did a straight cut and paste. Is there something else I should have done? # Enable configuration of arp_ignore option net.ipv4.conf.all.arp_ignore = 1 # When an arp request is received on eth0, only respond if that address is # configured on eth0. In particular, do not respond if the address is # configured on lo net.ipv4.conf.eth0.arp_ignore = 1 # Ditto for eth1, add for all ARPing interfaces #net.ipv4.conf.eth1.arp_ignore = 1 # Enable configuration of arp_announce option net.ipv4.conf.all.arp_announce = 2 # When making an ARP request sent through eth0 Always use an address that # is configured on eth0 as the source address of the ARP request. If this # is not set, and packets are being sent out eth0 for an address that is on # lo, and an arp request is required, then the address on lo will be used. # As the source IP address of arp requests is entered into the ARP cache on # the destination, it has the effect of announcing this address. This is # not desirable in this case as adresses on lo on the real-servers should # be announced only by the linux-director. net.ipv4.conf.eth0.arp_announce = 2 # Ditto for eth1, add for all ARPing interfaces #net.ipv4.conf.eth1.arp_announce = 2 Thanks for the help! ~Stack~ [1] http://www.howtoforge.com/setting-up-a-loadbalanced-mysql-cluster-with-m ysql5.1-p3 -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Re: MySQL Clustering; Load balancing is not working.
On Thu, 19 Feb 2009, Stackpole, Chris wrote: > I wanted to learn more about MySQL clustering so I looked around and > found this guide [1]. It was the newest guide I found (8 months old), so > I decided to give it a shot. I went through the guide with a little > deviation and I end up with mostly the same results as the author. Data > written to one node, shows up real quick on the other node. The > management interface all gives the same results as the author too. > However, the big problem (and reason for my post) is the virtual IP for > the load balancing doesn't work right. > > When I try connect to the virtual IP: > $ mysql -h 10.0.1.10 -u ldirector -p > Enter password: > It will sit here for a really long time before giving: > ERROR 2003 (HY000): Can't connect to MySQL server on '10.0.1.10' (111) > For most of this, you don't need to follow the instructions there to a tee, where ever possible I just use what ever is in apt, most of it version agnostic. The real important thing, it just the methods. > Step 2) Author uses MySQL 5.1.24 compiled from source. I used apt (I am > not afraid to compile but I didn't because apt is awesome :). > $ apt-cache show mysql-server | grep -i version > Version: 5.0.51a-24 > > Well, I guess I can see the versioning being a problem. Maybe I should > update and compile a newer version. ?? > > Step 6.1) For whatever reason, I can't update the GPG key for > ultramonkey, but I just hit y to install anyway on apt. Also, he > installs libdbd-mysql-perl from a download he gives from CPAN. I had > errors with his commands. Turns out you have to install > libmysqlclient15-dev (not 14) and you have to install make too! Then his > link to the DBD-mysql-3.0002.tar.gz didn't work for me. However, the > link to the newest (I believe) DBD-mysql-3.0008.tar.gz, _did_ work. So I > installed that one. So again, versioning issues? > >From what I remember, ultramonkey is kind of dead. All you really need to install is ldirectord for the load balancing and heartbeat for failover, both of which are in debians repositories. So, I would just uninstall everything you installed from ultramonkey, remove them from your sources list and just install heartbeat and ldirector debians rep. for the DBD-mysql, you can just install libdbd-mysql-perl, that will provide what you need. > Step 6.2 - 7) Everything works exactly as the author suggests it should, > /except/ for the last line of: > `mysql -h 10.0.1.10 -u ldirector -p` > > As stated before, this fails. I can ping 10.0.1.10. I can even ssh into > 10.0.1.10. They both redirect me to the (current) primary load balancer. > If I turn off the primary, I go to the secondary. Also, if I run > `ipvsadm -L -n` I can see the connections show up, even though they time > out. So I don't think it is the virtual part. I think it is the > redirection to the MySQL session. > > The only thing I have found in the log files that doesn't look right, is > every once in a while this line is put into the /var/log/ldirectord.log: > Exiting with exit_status 2: configu_error: Configuration Error > The thing is, from everything I can find, it is correct. I posted at the > end of the email. > > I would appreciate any feedback people may have. > > Thanks! > ~Stack~ > > [1] > http://www.howtoforge.com/setting-up-a-loadbalanced-mysql-cluster-with-m > ysql5.1 > > $cat /etc/ha.d/ldirector.cf > # Global Directives > checktimeout=10 > checkinterval=2 > autoreload=no > logfile="local0" > quiescent=yes > virtual=10.0.1.10:3306 > service=mysql > real=10.0.1.33:3306 gate > real=10.0.1.34:3306 gate > checktype=negotiate > login="ldirector" > passwd="ldirectorpassword" > database="ldirectordb" > request="SELECT * FROM connectioncheck" > scheduler=wrr your config looks ok. The one other thing I would check is the entries in your /etc/sysctl.conf to turn off arp. That sounds like that may be the main issue here -- 8 out of 10 Owners who Expressed a Preference said Their Cats Preferred Techno. -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
MySQL Clustering; Load balancing is not working.
This is a project of personal experimentation and learning; in other words, if I goof something up real bad, oh well. I can reinstall. I wanted to learn more about MySQL clustering so I looked around and found this guide [1]. It was the newest guide I found (8 months old), so I decided to give it a shot. I went through the guide with a little deviation and I end up with mostly the same results as the author. Data written to one node, shows up real quick on the other node. The management interface all gives the same results as the author too. However, the big problem (and reason for my post) is the virtual IP for the load balancing doesn't work right. When I try connect to the virtual IP: $ mysql -h 10.0.1.10 -u ldirector -p Enter password: It will sit here for a really long time before giving: ERROR 2003 (HY000): Can't connect to MySQL server on '10.0.1.10' (111) Which, if I understand right, means the client isn't getting data back from the MySQL server. However, if I try to connect directly to one of the nodes, I get success! So I started to think about it. What gives? What did I do wrong? Then I went back step by step to see where I went different from the author. Step 1) I obviously have different hardware, and the author uses Etch while I used Lenny (fresh net-install today so it is current stable). Step 2) Author uses MySQL 5.1.24 compiled from source. I used apt (I am not afraid to compile but I didn't because apt is awesome :). $ apt-cache show mysql-server | grep -i version Version: 5.0.51a-24 Well, I guess I can see the versioning being a problem. Maybe I should update and compile a newer version. ?? Step 3, 4, & 5) I get the exact same results as author with exception of trivial things (like our PID's don't match. Whoop-de-do. Of course they won't. Doesn't affect the outcome.) Step 6.1) For whatever reason, I can't update the GPG key for ultramonkey, but I just hit y to install anyway on apt. Also, he installs libdbd-mysql-perl from a download he gives from CPAN. I had errors with his commands. Turns out you have to install libmysqlclient15-dev (not 14) and you have to install make too! Then his link to the DBD-mysql-3.0002.tar.gz didn't work for me. However, the link to the newest (I believe) DBD-mysql-3.0008.tar.gz, _did_ work. So I installed that one. So again, versioning issues? Step 6.2 - 7) Everything works exactly as the author suggests it should, /except/ for the last line of: `mysql -h 10.0.1.10 -u ldirector -p` As stated before, this fails. I can ping 10.0.1.10. I can even ssh into 10.0.1.10. They both redirect me to the (current) primary load balancer. If I turn off the primary, I go to the secondary. Also, if I run `ipvsadm -L -n` I can see the connections show up, even though they time out. So I don't think it is the virtual part. I think it is the redirection to the MySQL session. The only thing I have found in the log files that doesn't look right, is every once in a while this line is put into the /var/log/ldirectord.log: Exiting with exit_status 2: configu_error: Configuration Error The thing is, from everything I can find, it is correct. I posted at the end of the email. I would appreciate any feedback people may have. Thanks! ~Stack~ [1] http://www.howtoforge.com/setting-up-a-loadbalanced-mysql-cluster-with-m ysql5.1 $cat /etc/ha.d/ldirector.cf # Global Directives checktimeout=10 checkinterval=2 autoreload=no logfile="local0" quiescent=yes virtual=10.0.1.10:3306 service=mysql real=10.0.1.33:3306 gate real=10.0.1.34:3306 gate checktype=negotiate login="ldirector" passwd="ldirectorpassword" database="ldirectordb" request="SELECT * FROM connectioncheck" scheduler=wrr -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Re: [OT] Server for Debian + MySQL
On Wednesday 2008 December 17 15:11:39 Chris Bannister wrote: > On Sun, Dec 14, 2008 at 02:33:30PM -0600, Boyd Stephen Smith Jr. wrote: > > "to noun" v. 1. To use a word as a noun rather than its standard > > grammatical role. Most often applied to verbs and adjectives. When a > > word is used this way, the implied meaning is "someone or something > > filling the role of or having the quality of". > > Is that in the dictionary? Wow! No, no, no. Sorry, I didn't even mean to *imply* that. I was trying to define it based on my usage. Again, sorry. > > "to verb" v. 1. To use a word as a verb rather than its standard > > grammatical role. Most ofthen applied to nouns. When a word is use this > > way, the impled means is "to act or exist in a manner that evokes > > comparisons to". > > > > *Very* colloquial, particularly "to noun" which I haven't seen in media, > > yet. "to verb" has certainly been used on TV, and may have made it into > > print media by now. And I did mean *both* are *very* colloquial. > Oddly enough, I've found the media to be among the worst offenders, esp. > postings on the Internet by so called MSM Journalists. By media, I don't mean the lazyweb. I mean professional news on national TV or any national print media. -- Boyd Stephen Smith Jr. ,= ,-_-. =. b...@iguanasuicide.net ((_/)o o(\_)) ICQ: 514984 YM/AIM: DaTwinkDaddy `-'(. .)`-' http://iguanasuicide.net/ \_/ signature.asc Description: This is a digitally signed message part.
Re: [OT] Server for Debian + MySQL
On Sun, Dec 14, 2008 at 02:33:30PM -0600, Boyd Stephen Smith Jr. wrote: > "to noun" v. 1. To use a word as a noun rather than its standard grammatical > role. Most often applied to verbs and adjectives. When a word is used this > way, the implied meaning is "someone or something filling the role of or > having the quality of". Is that in the dictionary? Wow! > "to verb" v. 1. To use a word as a verb rather than its standard grammatical > role. Most ofthen applied to nouns. When a word is use this way, the impled > means is "to act or exist in a manner that evokes comparisons to". > > *Very* colloquial, particularly "to noun" which I haven't seen in media, > yet. "to verb" has certainly been used on TV, and may have made it into > print media by now. Oddly enough, I've found the media to be among the worst offenders, esp. postings on the Internet by so called MSM Journalists. -- Chris. == I contend that we are both atheists. I just believe in one fewer god than you do. When you understand why you dismiss all the other possible gods, you will understand why I dismiss yours. -- Stephen F Roberts -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Re: [OT] Server for Debian + MySQL
--- On Sun, 12/14/08, Chris Bannister wrote:
From: Chris Bannister
Subject: Re: [OT] Server for Debian + MySQL
To: debian-user@lists.debian.org
Date: Sunday, December 14, 2008, 6:32 AM
On Fri, Dec 12, 2008 at 10:02:14AM -0600, Boyd Stephen Smith Jr. wrote:
> http://en.wiktionary.org/wiki/disconnect
>
> I don't know how long the noun usage has been around, but I remember
hearing
> it as a child (20 years ago), so I'd say you just need to update your
> dictionary. (1913 Websters, really?)
According to merriam webster (m-w.com), which by the way helps greatly non
english speakers because provides sound to words, disconnect as a verb goes
back to 1770; as a noun to 1976
I've never heard of "a disconnect". It is the opposite of
connect.
(Yep, some people still say incorrectly - "unmount" when it should be
"dismount")
>AIUI, the education system 20 years ago had some flaws which have
>shown themselves in the last few years.
One example is that according to modern rules the classics of the language
would get F's in standard language tests, because they used long sentences, not
bullets, etc. Modern education doesn't realize that complex thoughts require
complex sentences (hence the use of symbols in mathematics to compress ideas).
I think I read a comment on Obama and MacCain talking at 7-9th grade levels in
their speeches, which tells much.
> Also, particularly where I come from (U.S.; specifically "The
South"), English
> speakers don't follow the formal rules of grammar well. So, nouns get
>IOW, " they make up your own rules".
> verbed, and verbs get nouned, words and phrases get abbreviated, mangled,
>and
> misunderstood, and the language evolves. (There are probably some more
>Yeah, apparently "awful" originally meant "full of awe".
>According to "The Pocket Oxford Dictionary" Compiled by F. G. Fowler
>&
>H. W. Fowler; (1st ed 1924 Reprinted with corrections 1947, 1949, 1952,
>1953, 1955, 1957, 1959, 1960):
>awe. 1. n. Reverential fear (stand in a. of).
> 2. v.t. (-wable). Inspire with a.
> ...
>awful a. Inspiring, worthy of a.; (colloq.) notable in its kind (an
>awful bore, relief).
>awfully adv., (esp., colloq) very (awfully good of you). [E]
> serious errors in a 1913 dictionary than not having the noun form of some
> verbs.)
>Are the errors in the dictionary or is it that a high percentage of the
>population are misusing/abusing the {words,rules} of english?
The confusion of verbs and nouns shows the confusion in the mind of the
speakers (in other historically and culturally connected languages the
distinction remains).
If we divide the pie in two pieces we can see the divide. When we then proceed
to disconnect the two pieces we observe the disconnect, and if we try to
reverse the process and attempt to connect the pieces, will obtain a connect.
After thinking a little our think wanders, so we decide that whatever decide
has been previously made may not have been right.
We could continue this chain of thoughts, and after a while we will realize (or
come to the realize) that something is not right.
--
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Re: [OT] Server for Debian + MySQL
On Sunday 2008 December 14 05:32:16 Chris Bannister wrote:
>On Fri, Dec 12, 2008 at 10:02:14AM -0600, Boyd Stephen Smith Jr. wrote:
>> http://en.wiktionary.org/wiki/disconnect
>>
>> I don't know how long the noun usage has been around, but I remember
>> hearing it as a child (20 years ago), so I'd say you just need to update
>> your dictionary. (1913 Websters, really?)
>
>I've never heard of "a disconnect". It is the opposite of connect.
It's definitely used around here, and by English-speakers that I work with
from Australia and Maryland.
http://www.googlefight.com/index.php?lang=en_GB&word1="a+disconnect"&word2="a+disconnection";
likes "a disconnection" better.
However, 3 dictionaries all (c) 2006 have a noun form.
http://dictionary.reference.com/browse/disconnect (references in tiny text).
>AIUI, the education system 20 years ago had some flaws which have
>shown themselves in the last few years.
I'll admit my education could have been better, but I'm not saying it was
taught to me in school, but rather, that it was common usage in my area
decades ago.
>> Also, particularly where I come from (U.S.; specifically "The South"),
>> English speakers don't follow the formal rules of grammar well. So, nouns
>> get
>
>IOW, " they make up your own rules".
Not entirely. I find a lot of it is "lazy tongue syndrome" where or phrases
acquire more, generally contextual, meaning while reducing in length to save
the speaker effort.
Also, lack of good, formal grammar education among the populace causes errors
in common speech (or media) not to have attention called to them, and
eventually become completely accepted because the don't "sound wrong" or
even "sound right".
>> verbed, and verbs get nouned,
>
> ^^^^
> Huh?
"to noun" v. 1. To use a word as a noun rather than its standard grammatical
role. Most often applied to verbs and adjectives. When a word is used this
way, the implied meaning is "someone or something filling the role of or
having the quality of".
"to verb" v. 1. To use a word as a verb rather than its standard grammatical
role. Most ofthen applied to nouns. When a word is use this way, the impled
means is "to act or exist in a manner that evokes comparisons to".
*Very* colloquial, particularly "to noun" which I haven't seen in media,
yet. "to verb" has certainly been used on TV, and may have made it into
print media by now.
>Are the errors in the dictionary or is it that a high percentage of the
>population are misusing/abusing the {words,rules} of english?
AIUI, there is no central controlling authority that establishes the rules of
English in any geographical area, unlike French (in France) and German (in
Germany).
So, at best, English-language dictionaries and grammatical guide are
descriptive, not proscriptive, and correct usage follows common usage. As
society as large accepts misuses or abuses they become correct usage.
--
Boyd Stephen Smith Jr. ,= ,-_-. =.
bs...@volumehost.net ((_/)o o(\_))
ICQ: 514984 YM/AIM: DaTwinkDaddy `-'(. .)`-'
http://iguanasuicide.org/ \_/
signature.asc
Description: This is a digitally signed message part.
Re: [OT] Server for Debian + MySQL
On 12/14/08 05:32, Chris Bannister wrote: On Fri, Dec 12, 2008 at 10:02:14AM -0600, Boyd Stephen Smith Jr. wrote: http://en.wiktionary.org/wiki/disconnect I don't know how long the noun usage has been around, but I remember hearing it as a child (20 years ago), so I'd say you just need to update your dictionary. (1913 Websters, really?) I've never heard of "a disconnect". It is the opposite of connect. Here's an example of how it's used: There's a disconnect between reality and political theory. (Yep, some people still say incorrectly - "unmount" when it should be "dismount") Then shame on those who wrote Unix, then, for the umount command. (The same command for OpenVMS is DISMOUNT.) -- Ron Johnson, Jr. Jefferson LA USA How does being physically handicapped make me Differently-Abled? What different abilities do I have? -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Re: [OT] Server for Debian + MySQL
Chris Bannister wrote:
On Fri, Dec 12, 2008 at 10:02:14AM -0600, Boyd Stephen Smith Jr. wrote:
http://en.wiktionary.org/wiki/disconnect
I don't know how long the noun usage has been around, but I remember hearing
it as a child (20 years ago), so I'd say you just need to update your
dictionary. (1913 Websters, really?)
I've never heard of "a disconnect". It is the opposite of connect.
(Yep, some people still say incorrectly - "unmount" when it should be
"dismount")
AIUI, the education system 20 years ago had some flaws which have
shown themselves in the last few years.
Also, particularly where I come from (U.S.; specifically "The South"), English
speakers don't follow the formal rules of grammar well. So, nouns get
IOW, " they make up your own rules".
verbed, and verbs get nouned, words and phrases get abbreviated, mangled, and
^^^^
Huh?
misunderstood, and the language evolves. (There are probably some more
Yeah, apparently "awful" originally meant "full of awe".
According to "The Pocket Oxford Dictionary" Compiled by F. G. Fowler &
H. W. Fowler; (1st ed 1924 Reprinted with corrections 1947, 1949, 1952,
1953, 1955, 1957, 1959, 1960):
awe. 1. n. Reverential fear (stand in a. of).
2. v.t. (-wable). Inspire with a.
...
awful a. Inspiring, worthy of a.; (colloq.) notable in its kind (an
awful bore, relief).
awfully adv., (esp., colloq) very (awfully good of you). [E]
serious errors in a 1913 dictionary than not having the noun form of some
verbs.)
Are the errors in the dictionary or is it that a high percentage of the
population are misusing/abusing the {words,rules} of english?
It's just the meanings of words change over time. That's a big reason
why dictionaries get updated.
For instance, "Hello" was originally an explanation of surprise, not a
greeting.
--
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Re: [OT] Server for Debian + MySQL
Chris Bannister wrote: > Yeah, apparently "awful" originally meant "full of awe" > This is the perfect time for a Terry Pratchett quote: Elves are wonderful. They provoke wonder. Elves are marvellous. They cause marvels. Elves are fantastic. They create fantasies. Elves are glamorous. They project glamour. Elves are enchanting. They weave enchantment. Elves are terrific. They beget terror. The thing about words is that meanings can twist just like a snake, and if you want to find snakes look for them behind words that have changed their meaning. Nobody said elves were nice. Elves are bad." From "Lords and Ladies" -- Tehee quod she, and clapte the wyndow to. -- Geoffrey Chaucer Eduardo M KALINOWSKI edua...@kalinowski.com.br http://move.to/hpkb -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Re: [OT] Server for Debian + MySQL
On Fri, Dec 12, 2008 at 10:02:14AM -0600, Boyd Stephen Smith Jr. wrote:
> http://en.wiktionary.org/wiki/disconnect
>
> I don't know how long the noun usage has been around, but I remember hearing
> it as a child (20 years ago), so I'd say you just need to update your
> dictionary. (1913 Websters, really?)
I've never heard of "a disconnect". It is the opposite of connect.
(Yep, some people still say incorrectly - "unmount" when it should be
"dismount")
AIUI, the education system 20 years ago had some flaws which have
shown themselves in the last few years.
> Also, particularly where I come from (U.S.; specifically "The South"),
> English
> speakers don't follow the formal rules of grammar well. So, nouns get
IOW, " they make up your own rules".
> verbed, and verbs get nouned, words and phrases get abbreviated, mangled, and
^^^^
Huh?
> misunderstood, and the language evolves. (There are probably some more
Yeah, apparently "awful" originally meant "full of awe".
According to "The Pocket Oxford Dictionary" Compiled by F. G. Fowler &
H. W. Fowler; (1st ed 1924 Reprinted with corrections 1947, 1949, 1952,
1953, 1955, 1957, 1959, 1960):
awe. 1. n. Reverential fear (stand in a. of).
2. v.t. (-wable). Inspire with a.
...
awful a. Inspiring, worthy of a.; (colloq.) notable in its kind (an
awful bore, relief).
awfully adv., (esp., colloq) very (awfully good of you). [E]
> serious errors in a 1913 dictionary than not having the noun form of some
> verbs.)
Are the errors in the dictionary or is it that a high percentage of the
population are misusing/abusing the {words,rules} of english?
--
Chris.
==
I contend that we are both atheists. I just believe in one fewer god
than you do. When you understand why you dismiss all the other
possible gods, you will understand why I dismiss yours.
-- Stephen F Roberts
--
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Re: [OT] Server for Debian + MySQL
On 12/12/08 10:02, Boyd Stephen Smith Jr. wrote: [snip] Also, particularly where I come from (U.S.; specifically "The South"), English speakers don't follow the formal rules of grammar well. But at least we know that gals aren't guys -- or sheep -- and that counts for a whole lot! So, nouns get verbed, and verbs get nouned, words and phrases get abbreviated, mangled, and misunderstood, and the language evolves. (There are probably some more serious errors in a 1913 dictionary than not having the noun form of some verbs.) -- Ron Johnson, Jr. Jefferson LA USA How does being physically handicapped make me Differently-Abled? What different abilities do I have? -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Re: [OT] Server for Debian + MySQL
On Friday 2008 December 12 09:08:15 Arc Roca wrote: >I think that the disconnect here is when one compares two different > > >Disconnect Dis`con*nect", v. t. [imp. & p. p. Disconnected; > p. pr. & vb. n. Disconnecting.] > To dissolve the union or connection of; to disunite; to > sever; to separate; to disperse. > [1913 Webster] >etc > >I have seen lately the use of verbs in place of nouns: >disconnect in place of disconnection >resolve in place of resolution >etc >I myself am not a native English speaker, but this usage sounds strange. http://en.wiktionary.org/wiki/disconnect I don't know how long the noun usage has been around, but I remember hearing it as a child (20 years ago), so I'd say you just need to update your dictionary. (1913 Websters, really?) http://en.wiktionary.org/wiki/resolve When this is used as a noun, it doesn't mean "place of resolution" or at least not "place where resolving occurs". Also, particularly where I come from (U.S.; specifically "The South"), English speakers don't follow the formal rules of grammar well. So, nouns get verbed, and verbs get nouned, words and phrases get abbreviated, mangled, and misunderstood, and the language evolves. (There are probably some more serious errors in a 1913 dictionary than not having the noun form of some verbs.) -- Boyd Stephen Smith Jr. ,= ,-_-. =. bs...@volumehost.net ((_/)o o(\_)) ICQ: 514984 YM/AIM: DaTwinkDaddy `-'(. .)`-' http://iguanasuicide.org/ \_/ signature.asc Description: This is a digitally signed message part.
Re: [OT] Server for Debian + MySQL
I think that the disconnect here is when one compares two different types of computer based only on a comparision of their computational power. Sure, the 1980-vintage 1.6 MIPS machine only had 6 MB ram (and a...@tosh:~$ apt-cache show gnome-utils | grep dictionary - gnome-dictionary, a program which can look up the definition of words Disconnect Dis`con*nect", v. t. [imp. & p. p. Disconnected; p. pr. & vb. n. Disconnecting.] To dissolve the union or connection of; to disunite; to sever; to separate; to disperse. [1913 Webster] etc I have seen lately the use of verbs in place of nouns: disconnect in place of disconnection resolve in place of resolution etc I myself am not a native English speaker, but this usage sounds strange. Please help me understand.
Re: [OT] Server for Debian + MySQL
On Thu, Dec 11, 2008 at 07:10:52AM -0600, Ron Johnson wrote: > On 12/11/08 02:02, Adrian Chapela wrote: > >Ron Johnson escribi?: > >>On 12/10/08 20:09, kj wrote: > >>>Ron Johnson wrote: > >>>>"Large systems" (meaning mainframes and "traditional" minicomputers > >>>>running legacy OSs) are never dedicated. They run application > >>>>software as well as RDBMSs. > >>>And it can. If it couldn't, Plesk would not be selling. In my job I > >>>admin servers that do web, mail, and db for anything from a handful > >>>to 1200+ domains on a single box. No problem there (mostly). But > >>>the load on the server's resources are, in the end, down to to what > >>>your application does. > >>The grumpy geezer in me says you make a dedicated DB server only if > >>your hardware and/or OS isn't up to snuff, or your RDBMS is a horrible > >>pig, and that any modern desktop PC should have enough juice to > >>support an RDBMS, dozens applications and 10,000 OLTP users. > >It depends on many things. I have a intensive applications and I need a > >server with separate RDBMS. I have a +200GB database size and need to > >increase to a minimum of 1000GB (to save more old data to report purposes). > > > >You need to think on many different architechtures and needs because for > >many web sites you don't need a big machine, with a PC you should run > >web server + rdbms without problems (even to many domains on this single > >machine...) but there are many companies that can't run web server and > >rdbms on same machine, even have many RDBMS servers and a lot of web > >servers, to achieve a good performance and high availability. > > We supported 70 on-line users *plus* ran batch jobs on a > pathetically slow 1980-vintage 1.6 MIPS machine with only 6MB RAM. > > >MySQL runs on commodity hardware but if you are doing 1000 statements > >executions per second, you need to think on a good hardware if you want > >a reasonable performance. I think that the disconnect here is when one compares two different types of computer based only on a comparision of their computational power. Sure, the 1980-vintage 1.6 MIPS machine only had 6 MB ram (and was only 1.6 MIPS), but look at what hardware it had to support that slow CPU and memory. What was the disk subsystem like? What about bus(es)? What about secondary processors to offload the system-grunt-work to allow the CPU to just deal with the application? Look at the i386 (and amd64) architecture and look at everything the CPU has to do. Look at everything that interrupts it and causes it to do a context switch. Nowadays, it seems like people are making BIG IRON out of tiny iron, with multiple dedicated 1U servers with separate storage servers/controllers/SANs/whatevers all to capture the reliability and performance of the large systems without the propriatary cost of a monolithic large system. Doug. -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Re: [OT] Server for Debian + MySQL
Ron Johnson wrote: The grumpy geezer in me says you make a dedicated DB server only if your hardware and/or OS isn't up to snuff, or your RDBMS is a horrible pig, and that any modern desktop PC should have enough juice to support an RDBMS, dozens applications and 10,000 OLTP users. Like I said before: it depends on the demands of the client. Many of the servers I administer run in the 5-6000 queries per second range on low-end (by today's standard) PC hardware - 1.8GHz Athlon64, 1GB RAM and a single IDE or SATA disc. But at the other end of the spectrum, I'm working on a box right now which has 8 cores, 16GB RAM and an 8x 15krpm SCSI RAID-10. MySQL is configured as tightly as possible, and still this box is barely doing 25 qps. The difference between this box and the aforementioned on is the queries run on the server. And even with the query optimizations I have suggested to the client, they'll still need to split some of this off onto a second box. --kj -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: [OT] Server for Debian + MySQL
Ron Johnson escribió: On 12/11/08 02:02, Adrian Chapela wrote: Ron Johnson escribió: On 12/10/08 20:09, kj wrote: Ron Johnson wrote: "Large systems" (meaning mainframes and "traditional" minicomputers running legacy OSs) are never dedicated. They run application software as well as RDBMSs. OK, we're talking about two different things. Translating that into "modern times", a Linux box *should* be able to competently run MySQL and Apache at the same time. And it can. If it couldn't, Plesk would not be selling. In my job I admin servers that do web, mail, and db for anything from a handful to 1200+ domains on a single box. No problem there (mostly). But the load on the server's resources are, in the end, down to to what your application does. There are several good reasons why you might want to put your DB on a separate server. The grumpy geezer in me says you make a dedicated DB server only if your hardware and/or OS isn't up to snuff, or your RDBMS is a horrible pig, and that any modern desktop PC should have enough juice to support an RDBMS, dozens applications and 10,000 OLTP users. It depends on many things. I have a intensive applications and I need a server with separate RDBMS. I have a +200GB database size and need to increase to a minimum of 1000GB (to save more old data to report purposes). You need to think on many different architechtures and needs because for many web sites you don't need a big machine, with a PC you should run web server + rdbms without problems (even to many domains on this single machine...) but there are many companies that can't run web server and rdbms on same machine, even have many RDBMS servers and a lot of web servers, to achieve a good performance and high availability. Bah humbug. We supported 70 on-line users *plus* ran batch jobs on a pathetically slow 1980-vintage 1.6 MIPS machine with only 6MB RAM. I didn't say that it isn't possible but it could be slower than a powerful new server (In my humble opinion). Could I try this service ? Are you supporting 70 on-line users with only 6MB RAM now ? What are doing these 70 users ? MySQL runs on commodity hardware but if you are doing 1000 statements executions per second, you need to think on a good hardware if you want a reasonable performance. You young whippersnappers in your fancy cars! In my day, sonny, we walked uphill to school both ways, AND LIKED IT! -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: [OT] Server for Debian + MySQL
On 12/11/08 02:02, Adrian Chapela wrote: Ron Johnson escribió: On 12/10/08 20:09, kj wrote: Ron Johnson wrote: "Large systems" (meaning mainframes and "traditional" minicomputers running legacy OSs) are never dedicated. They run application software as well as RDBMSs. OK, we're talking about two different things. Translating that into "modern times", a Linux box *should* be able to competently run MySQL and Apache at the same time. And it can. If it couldn't, Plesk would not be selling. In my job I admin servers that do web, mail, and db for anything from a handful to 1200+ domains on a single box. No problem there (mostly). But the load on the server's resources are, in the end, down to to what your application does. There are several good reasons why you might want to put your DB on a separate server. The grumpy geezer in me says you make a dedicated DB server only if your hardware and/or OS isn't up to snuff, or your RDBMS is a horrible pig, and that any modern desktop PC should have enough juice to support an RDBMS, dozens applications and 10,000 OLTP users. It depends on many things. I have a intensive applications and I need a server with separate RDBMS. I have a +200GB database size and need to increase to a minimum of 1000GB (to save more old data to report purposes). You need to think on many different architechtures and needs because for many web sites you don't need a big machine, with a PC you should run web server + rdbms without problems (even to many domains on this single machine...) but there are many companies that can't run web server and rdbms on same machine, even have many RDBMS servers and a lot of web servers, to achieve a good performance and high availability. Bah humbug. We supported 70 on-line users *plus* ran batch jobs on a pathetically slow 1980-vintage 1.6 MIPS machine with only 6MB RAM. MySQL runs on commodity hardware but if you are doing 1000 statements executions per second, you need to think on a good hardware if you want a reasonable performance. You young whippersnappers in your fancy cars! In my day, sonny, we walked uphill to school both ways, AND LIKED IT! -- Ron Johnson, Jr. Jefferson LA USA How does being physically handicapped make me Differently-Abled? What different abilities do I have? -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: [OT] Server for Debian + MySQL
Ron Johnson escribió: On 12/10/08 20:09, kj wrote: Ron Johnson wrote: "Large systems" (meaning mainframes and "traditional" minicomputers running legacy OSs) are never dedicated. They run application software as well as RDBMSs. OK, we're talking about two different things. Translating that into "modern times", a Linux box *should* be able to competently run MySQL and Apache at the same time. And it can. If it couldn't, Plesk would not be selling. In my job I admin servers that do web, mail, and db for anything from a handful to 1200+ domains on a single box. No problem there (mostly). But the load on the server's resources are, in the end, down to to what your application does. There are several good reasons why you might want to put your DB on a separate server. The grumpy geezer in me says you make a dedicated DB server only if your hardware and/or OS isn't up to snuff, or your RDBMS is a horrible pig, and that any modern desktop PC should have enough juice to support an RDBMS, dozens applications and 10,000 OLTP users. It depends on many things. I have a intensive applications and I need a server with separate RDBMS. I have a +200GB database size and need to increase to a minimum of 1000GB (to save more old data to report purposes). You need to think on many different architechtures and needs because for many web sites you don't need a big machine, with a PC you should run web server + rdbms without problems (even to many domains on this single machine...) but there are many companies that can't run web server and rdbms on same machine, even have many RDBMS servers and a lot of web servers, to achieve a good performance and high availability. MySQL runs on commodity hardware but if you are doing 1000 statements executions per second, you need to think on a good hardware if you want a reasonable performance. Regards, -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: [OT] Server for Debian + MySQL
On 12/10/08 20:09, kj wrote: Ron Johnson wrote: "Large systems" (meaning mainframes and "traditional" minicomputers running legacy OSs) are never dedicated. They run application software as well as RDBMSs. OK, we're talking about two different things. Translating that into "modern times", a Linux box *should* be able to competently run MySQL and Apache at the same time. And it can. If it couldn't, Plesk would not be selling. In my job I admin servers that do web, mail, and db for anything from a handful to 1200+ domains on a single box. No problem there (mostly). But the load on the server's resources are, in the end, down to to what your application does. There are several good reasons why you might want to put your DB on a separate server. The grumpy geezer in me says you make a dedicated DB server only if your hardware and/or OS isn't up to snuff, or your RDBMS is a horrible pig, and that any modern desktop PC should have enough juice to support an RDBMS, dozens applications and 10,000 OLTP users. -- Ron Johnson, Jr. Jefferson LA USA How does being physically handicapped make me Differently-Abled? What different abilities do I have? -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: [OT] Server for Debian + MySQL
Ron Johnson wrote: "Large systems" (meaning mainframes and "traditional" minicomputers running legacy OSs) are never dedicated. They run application software as well as RDBMSs. OK, we're talking about two different things. Translating that into "modern times", a Linux box *should* be able to competently run MySQL and Apache at the same time. And it can. If it couldn't, Plesk would not be selling. In my job I admin servers that do web, mail, and db for anything from a handful to 1200+ domains on a single box. No problem there (mostly). But the load on the server's resources are, in the end, down to to what your application does. There are several good reasons why you might want to put your DB on a separate server. --kj -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: [OT] Server for Debian + MySQL
On 12/10/08 10:20, kj wrote: Ron Johnson wrote: If the box is a dedicated DB server, then there aren't (shouldn't be) any other applications running other than the essentials. As a "large systems" developer, this (pervasive) attitude really distresses me. Why? Maybe I should have said "presumably, there won't be much else running on the server." But still, if a box is doing more than one thing, then I don't see it as dedicated to one thing anymore. "Large systems" (meaning mainframes and "traditional" minicomputers running legacy OSs) are never dedicated. They run application software as well as RDBMSs. Translating that into "modern times", a Linux box *should* be able to competently run MySQL and Apache at the same time. -- Ron Johnson, Jr. Jefferson LA USA How does being physically handicapped make me Differently-Abled? What different abilities do I have? -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: [OT] Server for Debian + MySQL
Ron Johnson wrote: If the box is a dedicated DB server, then there aren't (shouldn't be) any other applications running other than the essentials. As a "large systems" developer, this (pervasive) attitude really distresses me. Why? Maybe I should have said "presumably, there won't be much else running on the server." But still, if a box is doing more than one thing, then I don't see it as dedicated to one thing anymore. --kj -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: [OT] Server for Debian + MySQL
On 12/10/08 05:34, kj wrote: Ron Johnson wrote: On 12/09/08 03:49, kj wrote: Anoop Aryal wrote: Just curious, how big of a difference (indeed, what difference) does 64bit make? It will make all the difference on a box with 16GB. On a 32bit machine, you can use a PAE enabled kernel to allow the operating system to address all the memory, but you're still stuck with a 4GB per-process limit, which means if this will be a dedicated MySQL server, you're wasting 12GB of memory. Why wouldn't Linux use that 12GB for applications and (more importantly) as a really big read cache? If the box is a dedicated DB server, then there aren't (shouldn't be) any other applications running other than the essentials. As a "large systems" developer, this (pervasive) attitude really distresses me. Of curse the kernel would do what the kernel does, but it makes more sense to have MySQL use that memory for caches/buffers dedicated to its own purposes, for example, caching query results. Well, yes, eliminating an intermediate layer between MySQL and the disk drive is always good. So again, the per-process memory limit is a disadvantage. -- Ron Johnson, Jr. Jefferson LA USA How does being physically handicapped make me Differently-Abled? What different abilities do I have? -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: [OT] Server for Debian + MySQL
Ron Johnson wrote: On 12/09/08 03:49, kj wrote: Anoop Aryal wrote: Just curious, how big of a difference (indeed, what difference) does 64bit make? It will make all the difference on a box with 16GB. On a 32bit machine, you can use a PAE enabled kernel to allow the operating system to address all the memory, but you're still stuck with a 4GB per-process limit, which means if this will be a dedicated MySQL server, you're wasting 12GB of memory. Why wouldn't Linux use that 12GB for applications and (more importantly) as a really big read cache? If the box is a dedicated DB server, then there aren't (shouldn't be) any other applications running other than the essentials. Of curse the kernel would do what the kernel does, but it makes more sense to have MySQL use that memory for caches/buffers dedicated to its own purposes, for example, caching query results. So again, the per-process memory limit is a disadvantage. -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: [OT] Server for Debian + MySQL
Ron Johnson escribió: On 12/09/08 03:49, kj wrote: Anoop Aryal wrote: Just curious, how big of a difference (indeed, what difference) does 64bit make? It will make all the difference on a box with 16GB. On a 32bit machine, you can use a PAE enabled kernel to allow the operating system to address all the memory, but you're still stuck with a 4GB per-process limit, which means if this will be a dedicated MySQL server, you're wasting 12GB of memory. Why wouldn't Linux use that 12GB for applications and (more importantly) as a really big read cache? Hardware and Software limitation. MySQL 32bits version can't use more than 2 GB of memory. It can't use 4 GB even using PAE. -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: [OT] Server for Debian + MySQL
On 12/09/08 03:49, kj wrote: Anoop Aryal wrote: Just curious, how big of a difference (indeed, what difference) does 64bit make? It will make all the difference on a box with 16GB. On a 32bit machine, you can use a PAE enabled kernel to allow the operating system to address all the memory, but you're still stuck with a 4GB per-process limit, which means if this will be a dedicated MySQL server, you're wasting 12GB of memory. Why wouldn't Linux use that 12GB for applications and (more importantly) as a really big read cache? -- Ron Johnson, Jr. Jefferson LA USA How does being physically handicapped make me Differently-Abled? What different abilities do I have? -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: [OT] Server for Debian + MySQL
Adrian Chapela wrote: kj escribió: Anoop Aryal wrote: Just curious, how big of a difference (indeed, what difference) does 64bit make? It will make all the difference on a box with 16GB. On a 32bit machine, you can use a PAE enabled kernel to allow the operating system to address all the memory, but you're still stuck with a 4GB per-process limit, which means if this will be a dedicated MySQL server, you're wasting 12GB of memory. No, you are wasting 14 GB. The 2 GB limitation is a limitation of MySQL server. You're right. PAE is good but it has a lower performance than a 64 bit platform. PAE is a workaround if you can't have a 64 bit machine if your application is only 32 bits and need too much memory. PAE is useful but it still won't allow any single process to access more than 4GB of memory. So no use in this case. --kj -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: [OT] Server for Debian + MySQL
kj escribió: Anoop Aryal wrote: Just curious, how big of a difference (indeed, what difference) does 64bit make? It will make all the difference on a box with 16GB. On a 32bit machine, you can use a PAE enabled kernel to allow the operating system to address all the memory, but you're still stuck with a 4GB per-process limit, which means if this will be a dedicated MySQL server, you're wasting 12GB of memory. No, you are wasting 14 GB. The 2 GB limitation is a limitation of MySQL server. PAE is good but it has a lower performance than a 64 bit platform. PAE is a workaround if you can't have a 64 bit machine if your application is only 32 bits and need too much memory. We were looking at 64bit for running some of our Java stuff on since the JVM on 32bit can only address so much memory. 64bit was actually slower, at least for Java despite the JVM being able to allocate more memory before being forced to GC. I am not a programmer, so my understanding of why this happens is basic at best. But I belive this has to do with the increased overhead of 64bit. From what I've seen/read, 64bit applications will often use a little bit more memory. How does something like MySQL behave on a 64bit vs a 32bit platform? Fantastic. --kj -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: [OT] Server for Debian + MySQL
Anoop Aryal wrote: Just curious, how big of a difference (indeed, what difference) does 64bit make? It will make all the difference on a box with 16GB. On a 32bit machine, you can use a PAE enabled kernel to allow the operating system to address all the memory, but you're still stuck with a 4GB per-process limit, which means if this will be a dedicated MySQL server, you're wasting 12GB of memory. We were looking at 64bit for running some of our Java stuff on since the JVM on 32bit can only address so much memory. 64bit was actually slower, at least for Java despite the JVM being able to allocate more memory before being forced to GC. I am not a programmer, so my understanding of why this happens is basic at best. But I belive this has to do with the increased overhead of 64bit. From what I've seen/read, 64bit applications will often use a little bit more memory. How does something like MySQL behave on a 64bit vs a 32bit platform? Fantastic. --kj -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
