| === 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 | ||
| nemster | hi! anyone knows how i can do an online resize of my ext3 / fs? | 12:50 |
|---|---|---|
| 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:56 |
| 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:57 |
| 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 | 12:59 |
| nemster | i never compiled a kernel in ubuntu,it seems to be somewhat different from what i am used from gentoo ;) | 01:00 |
| === 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 | ||
| usual | is it possible that having acpi enabled during an install that nics may be identified but not function properly? | 01:50 |
| === TTT_Travis [n=mythtv@bal-bb-cable-1-366.dsl.airstreamcomm.net] has joined #ubuntu-server | ||
| 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:43 |
| TTT_Travis | Aborting downgrade from (at least) 5.0 to 4.1. | 02:44 |
| 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 | 02:47 |
| === 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 | ||
| 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:04 |
| 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:06 |
| 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:10 |
| kermitX_ | Linuturk, mysql is not located in /usr/local/mysql/bin/ it's in your path | 05:11 |
| 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:13 |
| kermitX_ | use mysqladmin not mysql, sorry. | 05:14 |
| kermitX_ | Linuturk, or do you have the db created? | 05:15 |
| Linuturk | unknown command 'payrolldb' | 05:15 |
| Linuturk | i already created the database | 05:15 |
| 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:16 |
| 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:17 |
| 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:18 |
| kermitX_ | Linuturk, can you pastebin it? | 05:19 |
| Linuturk | 11.7 kB | 05:19 |
| Linuturk | uhhh, hold on | 05:19 |
| Linuturk | !paste | 05:21 |
| Linuturk | where is pastebin again? | 05:21 |
| kermitX_ | ubuntu.pastebin.com works. | 05:21 |
| Linuturk | http://ubuntu.pastebin.com/769016 | 05:22 |
| Linuturk | think there is something wrong with their .sql file? | 05:24 |
| 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:26 |
| Linuturk | wierd it doesn't work, don't you think? | 05:30 |
| kermitX_ | Linuturk, it's a little lacking in documentation, don't you think? | 05:34 |
| 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:35 |
| kermitX_ | Linuturk, trying mysql 4.0 on sarge | 05:36 |
| Linuturk | :-/, i'm running ubuntu 6.06 LAMP install though. crap. | 05:37 |
| 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:41 |
| Linuturk | well, the first on the list | 05:42 |
| Linuturk | can you find a more recent one? | 05:43 |
| Linuturk | wait, i found one | 05:44 |
| Linuturk | let me play with this one | 05:44 |
| Linuturk | how do I remove a database from mysql? | 05:45 |
| 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:46 |
| kermitX_ | infinity, it imports fine on my sarge box with 4.0, but not on dapper w/ 4.1 or Linuturk's 5 | 05:47 |
| infinity | Because that SQL is broken? | 05:49 |
| kermitX_ | infinity, it's a phpmyadmin dump out of mysql 3.22.32 | 05:49 |
| kermitX_ | infinity, perhaps just not compatible? or maybe even the php script he was trying wont be? | 05:50 |
| 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:51 |
| 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:52 |
| 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:53 |
| kermitX_ | infinity, thx for the help. | 05:54 |
| 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:55 |
| kermitX_ | Linuturk, meet me in #ubuntu-offtopic if you want to discuss other timeclock scripts. | 05:56 |
| === 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 | ||
| edneymatias | morning! | 01:52 |
| === 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 | ||
| 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:20 |
| adri | gpd, okay thanks | 08:22 |
| 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:33 |
| kermitX_ | adri, no, just: sudo vipw | 08:34 |
| adri | kermitX_, oh okay | 08:34 |
| 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:36 |
| 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:37 |
| adri | kermitX_, ah okay | 08:38 |
| === timmower_ [n=timmow@host-87-74-121-36.bulldogdsl.com] has joined #ubuntu-server | ||
| 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:14 |
| === 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 | ||
| ubotu_ | what's up | 09:21 |
| === ubotu_ is now known as blanky | ||
| blanky | heh | 09:21 |
| blanky | named my server ubotu :) | 09:21 |
| === aurel [n=aurel@APoitiers-155-1-107-107.w86-201.abo.wanadoo.fr] has joined #ubuntu-server | ||
| blanky | whatever! | 09:38 |
| === 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 | ||
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!