=== Mussi [n=Mussi@unaffiliated/mussi] has joined #ubuntu-server === edneymatias [n=edney@prognus.com.br] has left #ubuntu-server ["Konversation] === nemster [i=nemster@rakim.vseth.ethz.ch] has joined #ubuntu-server [12:50] hi! anyone knows how i can do an online resize of my ext3 / fs? [12:56] 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] 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] yup i mean a mounted / [12:59] it IS possible and worked fine when i tried fedora core 5 [12:59] since what i read i need to apply a patch for my kernel [01:00] i never compiled a kernel in ubuntu,it seems to be somewhat different from what i am used from gentoo ;) === jtgoguen [n=jgoguen@CPE0050bab05c75-CM000a73a17dba.cpe.net.cable.rogers.com] has joined #ubuntu-server === J_P [n=jp@200.146.37.219] has left #ubuntu-server [] === usual [n=usual@cpe-72-231-137-206.nycap.res.rr.com] has joined #ubuntu-server [01:50] is it possible that having acpi enabled during an install that nics may be identified but not function properly? === TTT_Travis [n=mythtv@bal-bb-cable-1-366.dsl.airstreamcomm.net] has joined #ubuntu-server [02:43] how do I downgrade from mysql-server-5.0 to mysql-server-4.1? [02:43] it keeps failing when I try [02:44] Aborting downgrade from (at least) 5.0 to 4.1. [02:47] do you have data in the tables? [02:47] you could mysqldump the data out --- purge the mysql-server package and reinstall the lower one === idimmu_ [n=idimmu@fu.tenshu.net] has joined #ubuntu-server === RemoteVi1wer [n=555@stan.physik.fu-berlin.de] has joined #ubuntu-server === nnonix_ [n=brad@xeon.bkjohnson.com] has joined #ubuntu-server === nemster_ [i=nemster@rakim.vseth.ethz.ch] has joined #ubuntu-server === Linuturk [n=linuturk@wsip-70-168-102-136.ga.at.cox.net] has joined #ubuntu-server [05:04] hey fellas [05:04] i got caught on something [05:04] http://superb-east.dl.sourceforge.net/sourceforge/epayroll/INSTALL.txt << step 3 [05:04] that line doesn't work [05:04] can someone help? [05:06] basically, they provide a .sql file to configure the new mysql database I've created [05:06] and I need to tell mysql to use that file [05:06] but, it won't :( [05:10] Linuturk, change this: /usr/local/mysql/bin/mysql payrolldb -uusernamae -ppassword to just: mysql payrolldb -uusernamae -ppassword Linuturk, mysql is not located in /usr/local/mysql/bin/ it's in your path [05:13] Linuturk, aka /usr/bin/ so just using mysql will run it. [05:13] i get error 1067 [05:13] when I ran that line [05:14] use mysqladmin not mysql, sorry. [05:15] Linuturk, or do you have the db created? [05:15] unknown command 'payrolldb' [05:15] i already created the database [05:16] mysqladmin payrolldb -uusernamae -ppassword produced [05:16] unknown command 'payrolldb' [05:16] and, the database is pre-existing [05:17] Linuturk, mysql payrolldb -uusername -ppassword < payroll.sql [05:17] Linuturk, there is a -u and a -p before the user and pass, respectively. try a space after your password like above. [05:17] tried that [05:18] Linuturk, does username have privs on the db? [05:18] i get error 1067 (42000) at line 18: Invalid default value for 'bonusid' [05:18] kermitX, using root [05:18] Linuturk, and you're using mysql 5? [05:18] yep [05:18] how big is that sql file? [05:18] auto LAMP server [05:19] Linuturk, can you pastebin it? [05:19] 11.7 kB [05:19] uhhh, hold on [05:21] !paste [05:21] where is pastebin again? [05:21] ubuntu.pastebin.com works. [05:22] http://ubuntu.pastebin.com/769016 [05:24] think there is something wrong with their .sql file? [05:26] Linuturk, get the same thing on mysql 4.1 -- hang on gonna try phpmyadmin, since that's what they dumped it from. [05:26] mmk [05:30] wierd it doesn't work, don't you think? [05:34] Linuturk, it's a little lacking in documentation, don't you think? [05:35] yeah, i'd say so [05:35] do you know of a better time clock thing? i'd really like to see this working though [05:36] Linuturk, trying mysql 4.0 on sarge [05:37] :-/, i'm running ubuntu 6.06 LAMP install though. crap. [05:41] Linuturk, worked in mysql 4.0.24 [05:41] ok, anyway to export that to mysql 5.0? [05:41] Linuturk, as far as timeclock keepers go.. this was the most recent project you found on sourceforge? it's 4 years old. [05:41] yeah :-/ [05:42] well, the first on the list [05:43] can you find a more recent one? [05:44] wait, i found one [05:44] let me play with this one [05:45] how do I remove a database from mysql? [05:46] drop databsase foo [05:46] Linuturk, is this the error you got? ERROR 1067 (42000) at line 18: Invalid default value for 'bonusid' [05:46] yeah [05:46] infinity, do you know why that would happen on a import of a < 4.1 dump into v5 mysql? [05:46] scroll up for the paste [05:47] infinity, it imports fine on my sarge box with 4.0, but not on dapper w/ 4.1 or Linuturk's 5 [05:49] Because that SQL is broken? [05:49] infinity, it's a phpmyadmin dump out of mysql 3.22.32 [05:50] infinity, perhaps just not compatible? or maybe even the php script he was trying wont be? [05:51] You can't have a default value for an auto_increment column. By definition, auto_increment columns are UNIQUE. [05:51] is there a quick reference for mysql commands? i found a different, better documented time clock application [05:51] (And generally, unless you explicitely say otherwise, they get set up as the primary key) [05:51] i need to add a database again, and grant a user access to that database [05:52] infinity, they're all like that.. would be some code cleanup on mysql's part rejecting that syntax now? [05:52] well, i remembered how to add a database [05:52] "create database foo; grant all on foo.* to user@localhost identified by 'mynewpassword';" [05:52] kermitX_: yeah, 4.1 and 5.0 are more strict about accepting broken SQL. [05:53] 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] kermitX_: I wouldn't call that a bug, per se. :) If phpmyadmin is still creating such broken syntax, that's a bug. [05:53] (mysqldump certainly wouldn't) [05:53] infinity, well, it *is* an equally old version of phpmyadmin that was used. ;) [05:54] infinity, thx for the help. [05:55] Linuturk: The mysql.com website has a comprehensive manual. [05:55] Linuturk: http://www.mysql.com/doc [05:55] extremely comprehensive ;) [05:56] Linuturk, meet me in #ubuntu-offtopic if you want to discuss other timeclock scripts. === fishhead [n=jeremy@24-176-210-127.dhcp.lnbh.ca.charter.com] has joined #ubuntu-server === fishhead [n=jeremy@24-176-210-127.dhcp.lnbh.ca.charter.com] has left #ubuntu-server ["Ex-Chat"] === jackc [n=jack@84-72-164-170.dclient.hispeed.ch] has joined #ubuntu-server === jsgotangco [n=jsg123@ubuntu/member/jsgotangco] has joined #ubuntu-server === jsgotangco [n=jsg123@ubuntu/member/jsgotangco] has joined #ubuntu-server === fabbione [i=fabbione@gordian.fabbione.net] has joined #ubuntu-server === nemster_ [i=nemster@rakim.vseth.ethz.ch] has left #ubuntu-server [] === Lukketto [n=Lukketto@host147-92.pool8261.interbusiness.it] has joined #ubuntu-server === fabbione [i=fabbione@gordian.fabbione.net] has joined #ubuntu-server === Lukketto [n=Lukketto@host147-92.pool8261.interbusiness.it] has left #ubuntu-server [] === edneymatias [n=edney@prognus.com.br] has joined #ubuntu-server [01:52] morning! === truz_`24 [n=truz_`24@74.129.166.232] has joined #ubuntu-server === mgalvin [n=mgalvin@ubuntu/member/mgalvin] has joined #ubuntu-server === jsgotangco [n=jsg123@ubuntu/member/jsgotangco] has joined #ubuntu-server === lbm [n=lbm@0x555298ca.adsl.cybercity.dk] has joined #ubuntu-server === jsgotangco [n=jsg123@ubuntu/member/jsgotangco] has joined #ubuntu-server === Lukketto [n=Lukketto@host147-92.pool8261.interbusiness.it] has joined #ubuntu-server === Lukketto [n=Lukketto@host147-92.pool8261.interbusiness.it] has left #ubuntu-server [] === blynch [n=mauror@host70-136.pool80183.interbusiness.it] has joined #ubuntu-server === kermitX_ [n=kermit@unaffiliated/cxg] has joined #ubuntu-server === adri [n=adri@pool-71-104-117-215.lsanca.dsl-w.verizon.net] has joined #ubuntu-server [08:20] anyone awake in here? [08:20] how do I make my default home, /home/ubotu [08:20] because whenver I log in, the dir I'm at is / [08:20] but it's okay i guess [08:20] etc /etc/passwd [08:20] edit even [08:22] gpd, okay thanks [08:33] adri, use sudo vipw [08:33] adri, to edit that file. [08:33] okay, thanks [08:33] sudo vipw /etc/passwd ? [08:34] adri, no, just: sudo vipw [08:34] kermitX_, oh okay [08:36] adri, you'd be looking for a line like this: username:x:1000:1000:Full Name,,,:/home/username:/bin/bash [08:36] oh okay thanks kermitX_ ! [08:37] 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] kermitX_, ah okay === timmower_ [n=timmow@host-87-74-121-36.bulldogdsl.com] has joined #ubuntu-server [09:14] Hi there, my samba file sharing is refusing to work. [09:14] 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] can anyone help? === blynch [n=mauror@host70-136.pool80183.interbusiness.it] has left #ubuntu-server [] === ubotu_ [n=ubotu@pool-71-104-117-215.lsanca.dsl-w.verizon.net] has joined #ubuntu-server [09:21] what's up === ubotu_ is now known as blanky [09:21] heh [09:21] named my server ubotu :) === aurel [n=aurel@APoitiers-155-1-107-107.w86-201.abo.wanadoo.fr] has joined #ubuntu-server [09:38] whatever! === jackc [n=jack@84-72-104-26.dclient.hispeed.ch] has joined #ubuntu-server === jackc [n=jack@84-72-104-26.dclient.hispeed.ch] has left #ubuntu-server ["Leaving"] === JulienH [i=kvirc@jem75-2-82-233-232-223.fbx.proxad.net] has joined #ubuntu-server === zebedi [n=pedro@84.90.96.70] has joined #ubuntu-server === Lukketto [n=Lukketto@host147-92.pool8261.interbusiness.it] has joined #ubuntu-server