[12:50] <nemster> hi! anyone knows how i can do an online resize of my ext3 / fs?
[12:56] <gpd> when you say 'online' do you mean 'currently mounted as /' - not sure if that is possible/advised - a LiveCD and Parted is the normal method
[12:57] <gpd> if you have no other choice / partitions you could create a small boot image in your swap partition, boot into that and then resize the other partition
[12:59] <nemster> yup i mean a mounted /
[12:59] <nemster> it IS possible and worked fine when i tried fedora core 5
[12:59] <nemster> since what i read i need to apply a patch for my kernel
[01:00] <nemster> i never compiled a kernel in ubuntu,it seems to be somewhat different from what i am used from gentoo ;)
[01:50] <usual> is it possible that having acpi enabled during an install that nics may be identified but not function properly?
[02:43] <TTT_Travis> how do I downgrade from mysql-server-5.0 to mysql-server-4.1?
[02:43] <TTT_Travis> it keeps failing when I try
[02:44] <TTT_Travis> Aborting downgrade from (at least) 5.0 to 4.1.
[02:47] <gpd> do you have data in the tables?
[02:47] <gpd> you could mysqldump the data out --- purge the mysql-server package and reinstall the lower one
[05:04] <Linuturk> hey fellas
[05:04] <Linuturk> i got caught on something
[05:04] <Linuturk> http://superb-east.dl.sourceforge.net/sourceforge/epayroll/INSTALL.txt << step 3
[05:04] <Linuturk> that line doesn't work
[05:04] <Linuturk> can someone help?
[05:06] <Linuturk> basically, they provide a .sql file to configure the new mysql database I've created
[05:06] <Linuturk> and I need to tell mysql to use that file
[05:06] <Linuturk> but, it won't :(
[05:10] <kermitX_> Linuturk, change this: /usr/local/mysql/bin/mysql payrolldb -uusernamae -ppassword<payroll.sql
[05:10] <kermitX_> to just: mysql payrolldb -uusernamae -ppassword<payroll.sql
[05:11] <kermitX_> Linuturk, mysql is not located in /usr/local/mysql/bin/ it's in your path
[05:13] <kermitX_> Linuturk, aka /usr/bin/ so just using mysql will run it.
[05:13] <Linuturk> i get error 1067
[05:13] <Linuturk> when I ran that line
[05:14] <kermitX_> use mysqladmin not mysql, sorry.
[05:15] <kermitX_> Linuturk, or do you have the db created?
[05:15] <Linuturk> unknown command 'payrolldb'
[05:15] <Linuturk> i already created the database
[05:16] <Linuturk> mysqladmin payrolldb -uusernamae -ppassword<payroll.sql
[05:16] <Linuturk> produced
[05:16] <Linuturk> unknown command 'payrolldb'
[05:16] <Linuturk> and, the database is pre-existing
[05:17] <kermitX_> Linuturk, mysql payrolldb -uusername -ppassword < payroll.sql
[05:17] <kermitX_> Linuturk, there is a -u and a -p before the user and pass, respectively. try a space after your password like above.
[05:17] <Linuturk> tried that
[05:18] <kermitX_> Linuturk, does username have privs on the db?
[05:18] <Linuturk> i get error 1067 (42000) at line 18: Invalid default value for 'bonusid'
[05:18] <Linuturk> kermitX, using root
[05:18] <kermitX_> Linuturk, and you're using mysql 5?
[05:18] <Linuturk> yep
[05:18] <kermitX_> how big is that sql file?
[05:18] <Linuturk> auto LAMP server
[05:19] <kermitX_> Linuturk, can you pastebin it?
[05:19] <Linuturk> 11.7 kB
[05:19] <Linuturk> uhhh, hold on
[05:21] <Linuturk> !paste
[05:21] <Linuturk> where is pastebin again?
[05:21] <kermitX_> ubuntu.pastebin.com works.
[05:22] <Linuturk> http://ubuntu.pastebin.com/769016
[05:24] <Linuturk> think there is something wrong with their .sql file?
[05:26] <kermitX_> Linuturk, get the same thing on mysql 4.1 -- hang on gonna try phpmyadmin, since that's what they dumped it from.
[05:26] <Linuturk> mmk
[05:30] <Linuturk> wierd it doesn't work, don't you think?
[05:34] <kermitX_> Linuturk, it's a little lacking in documentation, don't you think?
[05:35] <Linuturk> yeah, i'd say so
[05:35] <Linuturk> do you know of a better time clock thing? i'd really like to see this working though
[05:36] <kermitX_> Linuturk, trying mysql 4.0 on sarge
[05:37] <Linuturk> :-/, i'm running ubuntu 6.06 LAMP install though. crap.
[05:41] <kermitX_> Linuturk, worked in mysql 4.0.24
[05:41] <Linuturk> ok, anyway to export that to mysql 5.0?
[05:41] <kermitX_> Linuturk, as far as timeclock keepers go.. this was the most recent project you found on sourceforge? it's 4 years old.
[05:41] <Linuturk> yeah :-/
[05:42] <Linuturk> well, the first on the list
[05:43] <Linuturk> can you find a more recent one?
[05:44] <Linuturk> wait, i found one
[05:44] <Linuturk> let me play with this one
[05:45] <Linuturk> how do I remove a database from mysql?
[05:46] <infinity> drop databsase foo
[05:46] <kermitX_> Linuturk, is this the error you got? ERROR 1067 (42000) at line 18: Invalid default value for 'bonusid'
[05:46] <Linuturk> yeah
[05:46] <kermitX_> infinity, do you know why that would happen on a import of a < 4.1 dump into v5 mysql?
[05:46] <kermitX_> scroll up for the paste
[05:47] <kermitX_> infinity, it imports fine on my sarge box with 4.0, but not on dapper w/ 4.1 or Linuturk's 5
[05:49] <infinity> Because that SQL is broken?
[05:49] <kermitX_> infinity, it's a phpmyadmin dump out of mysql 3.22.32
[05:50] <kermitX_> infinity, perhaps just not compatible? or maybe even the php  script he was trying wont be?
[05:51] <infinity> You can't have a default value for an auto_increment column.  By definition, auto_increment columns are UNIQUE.
[05:51] <Linuturk> is there a quick reference for mysql commands? i found a different, better documented time clock application
[05:51] <infinity> (And generally, unless you explicitely say otherwise, they get set up as the primary key)
[05:51] <Linuturk> i need to add a database again, and grant a user access to that database
[05:52] <kermitX_> infinity, they're all like that.. would be some code cleanup on mysql's part rejecting that syntax now?
[05:52] <Linuturk> well, i remembered how to add a database
[05:52] <infinity> "create database foo; grant all on foo.* to user@localhost identified by 'mynewpassword';"
[05:52] <infinity> kermitX_: yeah, 4.1 and 5.0 are more strict about accepting broken SQL.
[05:53] <kermitX_> infinity, that would explain why i've had to edit some dumps like that in the past. i just couldn't remember *what*
[05:53] <infinity> kermitX_: I wouldn't call that a bug, per se. :)  If phpmyadmin is still creating such broken syntax, that's a bug.
[05:53] <infinity> (mysqldump certainly wouldn't)
[05:53] <kermitX_> infinity, well, it *is* an equally old version of phpmyadmin that was used. ;)
[05:54] <kermitX_> infinity, thx for the help.
[05:55] <infinity> Linuturk: The mysql.com website has a comprehensive manual.
[05:55] <infinity> Linuturk: http://www.mysql.com/doc
[05:55] <kermitX_> extremely comprehensive ;)
[05:56] <kermitX_> Linuturk, meet me in #ubuntu-offtopic if you want to discuss other timeclock scripts.
[01:52] <edneymatias> morning!
[08:20] <adri> anyone awake in here?
[08:20] <adri> how do I make my default home, /home/ubotu
[08:20] <adri> because whenver I log in, the dir I'm at is /
[08:20] <adri> but it's okay i guess
[08:20] <gpd> etc /etc/passwd
[08:20] <gpd> edit even
[08:22] <adri> gpd, okay thanks
[08:33] <kermitX_> adri, use sudo vipw
[08:33] <kermitX_> adri, to edit that file.
[08:33] <adri> okay, thanks
[08:33] <adri> sudo vipw /etc/passwd ?
[08:34] <kermitX_> adri, no, just:   sudo vipw
[08:34] <adri> kermitX_, oh okay
[08:36] <kermitX_> adri, you'd be looking for a line like this: username:x:1000:1000:Full Name,,,:/home/username:/bin/bash
[08:36] <adri> oh okay thanks kermitX_ !
[08:37] <kermitX_> adri, by default, users' homes are already set. but if you're logged in as 'username' you won't see 'username' at a console prompt. you see ~ which is a shortcut to your homedir.
[08:38] <adri> kermitX_, ah okay
[09:14] <timmower_> Hi there, my samba file sharing is refusing to work.
[09:14] <timmower_> I have tried a config that I know worked with gentoo, I have switched to a static IP and I have tried with encrypted and normal passwords
[09:14] <timmower_> can anyone help?
[09:21] <ubotu_> what's up
[09:21] <blanky> heh
[09:21] <blanky> named my server ubotu :)
[09:38] <blanky> whatever!