=== joerlend_ is now known as XiXaQ [00:29] hey all - does anyone know any good visual designers for mysql that work under linux at all? something like mysql workbench for linux ? [00:33] okay answered my own question: http://ondras.zarovi.cz/sql/ :-) [01:40] tesla4 Great! [02:53] hey guys [02:53] hey jetole [02:54] if I don't specify a route/gateway in my /etc/networks/interfaces then ubuntu seems to choose one for me automatically, can I disable this? [02:54] or do I have to write my own f$!#ing network startup script? [02:54] jetole what is the purpose? [02:56] got a basic server and would like to have dual hd's one for backup. program suggestions?? [02:56] I have a machine with three public routes on three seperate interfaces and only one is supposed to be the gateway so I set the nic to manual and or static and apply the ip and netmask and then setup the expensive static routes and I could not figure out why I had multi default routes until I took all routing off and they were still there and when I didn't start 3 of the nic and set it up verbatim from the pre-up I used and the ... [02:56] ... ip command in interfaces it came up properly [02:56] hellspawn cron rsync [02:56] hellspawn: yes, network based backup [02:57] k that should start me in the right direction [02:57] also rdiff-backup works better then rsync for backup [02:57] excellent [02:57] hellspawn I use cron rsync over ssh [02:58] rsync is really not where you want to look for backups but is a great tool for replicating data offsite [02:58] rdiff-backup provides more backup specific options [02:58] just a basic duplicate of files to the other hd on the server [02:58] read about it in "backup and recovery" from o'reilly [02:59] hellspawn I swear if you use rsync you'll be happy [02:59] hellspawn: maybe rsync then, rdiff backup only copies changes keeps date info so I can pull how file looked since backup on X day etc etc [02:59] you might be [03:00] like I said, rdiff-backup is really designed for the backup process and rsync isn't but that makes rsync simpler and stupider for the task [03:00] i am not bad mouthing rsync, stupid for the task sounds like what you might want [03:00] but I would do it to another computer [03:01] having backups to the hard drive is great till the computer crashes [03:01] a quick and dirty backup is rsync over ssh with self signing ssh [03:01] Kerberized NFSv4 doesn't love me. [03:01] while it may be "dumb" for the job I can make it a weekly task and save important data [03:01] I use self signing for mine as well [03:01] hellspawn: absolutly, I use rdiff-backup nightly [03:02] hellspawn: so you don't know how I can disable routing in interfaces? [03:02] hellspawn rsync -vaz /path/to/data server:/path/to/backup [03:02] or anyone know how routing can be disabled in interfaces? [03:03] joebob777as7 seems easy enough [03:04] jetole I think you need to look at your net.eth0 script.. but that may be gentoo [03:04] too many distros.. so little time [03:06] yeah thats gentoo alone [03:06] screw it, I am writting an rc script for these interfaces [03:06] jetole /etc/network/interfaces [03:07] jetole: that may have been the smartest thing I'vev written all day [03:08] hellspawn: come again [03:09] jetole: check out /etc/network/interfaces [03:09] hellspawn: thanks for the advice [03:09] 22:56 < jetole> I have a machine with three public routes on three seperate interfaces and only one is supposed to be the gateway so I set the nic to manual and or static and apply the ip and netmask and then setup the expensive static routes and I could not figure out why I had multi default [03:09] routes until I took all roting off and they were still there and when I didn't start 3 of the nic and sedt it up verbatim from the pre-up I used and the ... [03:09] 22:56 < jetole> ... ip command in interfaces it came up properly [03:10] 22:54 < jetole> if I don't specify a route/gateway in my /etc/networks/interfaces then ubuntu seems to choose one for me automatically, can I disable this? [03:10] notice the time gaps [03:10] jetole: why don't you just give me your address and I'll send you my extra router [03:12] why do I need another router? [03:12] why are you using a computer as a router?? [03:12] I have a linux IDS here with 11 NIC [03:12] I may be misunderstanding [03:12] hellspawn: static routes for an inline IDS [03:13] not that I don't think a computer cannot perform as an excellent router but I am deffinitly having issues at the moment with it [03:13] I could tell you a solution but it would be a gentoo one not a debian one [03:14] well I am already writting the rc script and taking it out of interfaces all together [03:15] /etc/network/interfaces [04:13] [04:15] I'm testing out 8.04 beta as a guest under vmware workstation with the goal of running under vm ware server. I need to run vmware tools to enable clean shutdown/startup. [04:16] I installed the virtual kernal and the vmware tools install complains about the supplied vm kernel modules [04:17] what is the one-true-way of installing vmware tools? [04:18] 8.04 has pre-compiled vmware tools in the repositories IIRC [04:18] any idea of the name? [04:18] openvm* or somthing like that [04:20] only find the x11 video drivers [04:20] open-vm-tools [04:20] http://packages.ubuntu.com/hardy/open-vm-tools [04:20] got it [04:21] thanks [04:22] np ツ [04:23] hmm selecting the gui version installs a *boat load* of packages :-) [04:23] oooh, unicode smiley [04:23] it is the future man.. [04:24] what's the keycode for that one? [04:24] don't know. fumble fingert it into existance. [04:25] must be using multinational keyset [04:25] © [04:26] copyright?? [04:26] £ [04:26] pound [04:26] ¢¡Ÿ₧¥œœ›š™ [04:27] cool [04:27] the joys of alt+numpad [04:43] ugh. the open vm tools don't do the clean shutdown it seems [05:17] JaxxMaxx: I remember back in the windows 95 days and even windows 98, alt+255 created a hard space and you could make a folder in dos that windows didn't know how to open [05:24] Nice place to stash the goods === \sh_away is now known as \sh === jords_ is now known as jords === kaii is now known as juliux_ === juliux_ is now known as kaii [11:06] hello.. what's the correct permission to module directory? is it www-data? [11:07] what modules [11:09] sorry.. wrong entry.. [11:10] Kamping_Kaiser, if ssh server can be accessed in the internet.. is it safe? [11:10] that is a nonsense question [11:10] okay.. sorry for the nonsence question then. [11:11] its as safe as the weakest password on the system [11:11] how about having a password if 15letters plus 2 digits.. that format is safe? [11:12] * Kamping_Kaiser shrug [11:16] if you are going to put a server up with ssh, then passwords can always be guessed, regardless of length [11:16] afk. sleep [11:16] you should be looking at additional measures [11:17] such as restricting the hosts which can ssh to the server via iptables [11:17] or installing and configuring fail2ban [11:17] or both ;) [11:17] hosts.allow/deny is a nicely crude way of doing it [11:17] * Kamping_Kaiser really gone [11:18] but I'm using a dynamic IP to access server back in the office.. how would I do that? how about using private key file? [11:20] The safe choice is to disable password logins altogether and only do pubkey authentication. [11:20] that's another option as well [11:21] uhuh.. please advise me the safest way to do it? [11:21] I... er... just did? [11:21] I mean. which is the safest way to secure the box with ssh server... [11:21] WEll, that's not entirely true. [11:22] The safe choice is to turn the thing off or not plug it into the network. [11:22] at least.. the safest [11:22] soren, that's an excellent one. but I guess.. it's the only avenue for me to send files to server with the use of ssh server by winscp [11:24] we've presented you with a number of options, it is up to you to decide which you feel meets your requirements for security [11:24] I guess I would choose pubkey auth [11:25] Ok. Do that then. [11:25] now.. may I ask you guys here..how to change the username administrator into something else I want.. the administrator was the one I set when I set-up the box [11:26] rhineheart_m: There's no tool to do that. You need to change /etc/{passwd,group,gshadow,shadow} manually. [11:27] okay.. so how to do it? [11:28] if you are only changing the person who has sudo ability [11:29] yeah.. I want to change the username with sudo ability [11:29] rhineheart_m: You open those files and change the name whereever you see it. [11:29] add the new account you want to be able to sudo to the admin group and remove the old account [11:29] Yeah, that's much easier. [11:30] how to list down the usernames with sudo ability? [11:30] check /etc/group and see who is in the admin group [11:33] how to read the file? [11:34] I tried cat /etc/group <<< I notice the apache conf file doesn't have LoadModule but does refer to a mods-enabled dir. Do I just move stuff from mods-available to mods-enabled and restart to add a mod? [12:26] sigger: a2enmod [12:27] thx. (gees, not much on its man page tho!) [12:27] guess theres not much to say. [12:28] rhineheart_m: getent group admin [12:28] sigger: similarly you have a2ensite [12:31] soren, thanks.. do you use winscp? [12:32] I don't run windows. [12:32] ...and that sounds like a windows application? [12:33] soren, okay.. how about scp? [12:33] Sure [12:34] do you know how to allow it to write files in the directory? [12:35] scp isn't special w.r.t. filesystem permissions. If the user has write access, that's it. [12:37] okay.. how to make a user to have write access? I guess the user m using doesn't have it.. but it is the user with sudo power.. I just don't know why the server won't allow to write [12:38] Try over in #ubuntu. [12:39] rhineheart_m: "For general (not server specific) support visit #ubuntu" [13:16] I know this isn't only Ubuntu but I've noticed when I run top on my server, I see a ton of Apache running. I have 11 sites on this server, would each one be requesting an instance of apache? Right now my bandwidth is limiting even myself to get into my server, but I've got top running is how come I'm asking. [13:30] apache forks, but not for every website [13:30] one website could also produce 100 apache processes [13:31] Okay, it just seems like it is really running a lot .. [13:31] no biggie, I think my current bandwidth hogging is coming from one of my other boxes (just don't know which one) .. [13:33] apt-get install iptraf vnstat [13:34] and of course: read themanuals ;-) [13:54] the number of apache children or workers is generally configurable, however the issue sounds more like one related to actual traffic rather than procecsses [13:59] yep, i really like things like munin to monitor my servers ;-) [14:06] <_MMA_> Hi all. I'm trying to switch from SAMBA to NFS. Here's the issue: http://ubuntuforums.org/showthread.php?t=738086 Any ideas? [14:11] _MMA_: are the permissions correct? [14:12] <_MMA_> Yep. I think I have it actually. Looks like I might need to define the subfolders in exports with the "nohide" option. [14:12] _MMA_: these are the options I use: (rw,sync,no_root_squash) [14:18] <_MMA_> sommer: How does "no_root_squash" effect things? [14:18] <_MMA_> I see the definition of the option, but an unsure what that means. [14:19] <_MMA_> s/an/am [14:23] _MMA_: there's a good explanation here: http://www.freeos.com/articles/3421/ [14:23] <_MMA_> sommer: Thanx [14:24] _MMA_: not strictly necessar, but on a LAN I'm okay with it :) [14:24] necssary even [14:25] <_MMA_> Ahh... Yeah. I get it now. [15:05] boo [15:37] i have problem with enabling eth0 on ubuntu 7.10 jeos. I already edited the vmx file to ethernet address static but wont help [15:37] my error is NOT_IMPLEMENTED /build/mts/release/bora-44356/pompeii2005/bora/devices/net/vlance.c:1802 [15:38] I'd appreciate if a few people could take a look at this https://wiki.ubuntu.com/ConfigSave-ConfigLoad and tell me files that would need to be saved off a server that I might have missed. Not a long read. [15:38] Trying to get some more feedback before putting in front of the Ubuntu gods [15:47] sigger: are you wanting a list of config file? [15:51] well, configs that people would find useful to have backed up if they were migrating, etc. [15:51] you consider passwd a config file? if not (I don't think of it that way) then stuff like that too [15:52] and of course welcoming a comment like "hey dopey, this already exists... its called xyz" [15:52] sigger: just wondering, because I think the list is going to vary person to person [15:52] I think what you have is a good explanation of what you're trying to accomplish [15:53] sommer: it is. thats why I suggest a cleartext file where folks can drop in the names of files they'd like to have backed. but some just need to be. e.g. passwd/groups [15:54] oh, I see what you mean [15:54] the defaults [15:54] probably add /etc/hosts if you don't have it [15:54] the feature rec pages suggest seeking user feedback, so just trying to do what they ask so I have the best shot at getting someone to pay attention to it. I'm personally not the biggest lin expert in the world [15:54] got that [15:55] maybe cron stuff? [15:55] I would think that would vary too much [15:56] seems like it oughta be optional. maybe its all in cleartext with no defaults, but the file starts off with some entrys to give folks a head start or some ideas. [15:56] I never like unseen defaults personally [15:56] maybe look at files that don't get modified depending on which packages are installed [15:57] er, sorry, not followign [15:57] I think hosts, passwd, and groups are a good start [15:57] shadows, hosts [15:58] well I was thikning of nsswitch.conf, but that can be modified depending on ldap, nic, etc [15:58] er nis not nic :) [15:58] hehe, I don't even know what that is.... sounds like a line in cleartext ;) [15:59] it determines the resolv order for host names [15:59] ah [15:59] I'd stick with the three you have, those seem pretty sane to me, but either way [16:00] so much stuff potentially, iface stuff. but all that is up to sysadmin to spec in the cleartext. [16:00] k, cool. maybe I'll just tweak and leave that for the experts. I don't even think this should be that hard in bash, as I think it through [16:02] sigger: yep, you might also try and track down that dsl script you mention and maybe attach it to the page [16:02] in the DSL chan right now asking for it. thx [16:16] setting up 8.04 Beta under VM Ware server. Switched to the virtual kerneland now I'm trying to figure out how to force a clean shutdown when the host machine goes down. === \sh is now known as \sh_away [16:39] i'm installing 6.06 on a ms virtual server 2005 r2 sp1 host, and its been sitting at the "installing core packages" for over an hour [16:39] and there's 0 CPU usage [17:59] hey all, I just received this: udev hook script requires at least kernel version 2.6.17 [17:59] when doing a test upgrade from fiesty to hardy [17:59] wondering if anyone else has had this issue? [18:00] sommer: I'd file a bug on that if there isn't one already. Sounds like a sequencing issue. [18:01] ScottK: ya, I did some searching and couldn't find a similar bug, but thought maybe someone else may have had the same issue [18:01] I'll file one, thanks [18:02] just to double check, the procedure I did was to: apt-get install network-manager-core, then do-release-upgrade -d [18:02] does that sound right? [18:03] Yes. [18:03] cool [18:08] any suggestions on how to get a clean shutdown of an 8.04 guest under vmware server or workstation? [19:02] does anyone know, offhand, how to enable innodb table support in mysql? It seems to be off in 5.0.45-1ubuntu3.3 [19:09] Its on, just create a new table using it as the storage engine [19:11] No, it's not on, it won't let me make tables with innodb support. [19:12] it went away with an upgrade. It's enabled in 3.1, but not there in 3.3 [19:16] hmm, well, it looks like request-tracker is confused about innodb support [19:21] ok, this is bizarre. SHOW VARIABLES LIKE 'have_innodb'; shows DISABLED, but I can create InnoDB tables; [19:23] aah, interesting, if you specify innodb, it creates the tables as myisam [19:23] any of you using gfs? [19:23] so, it seems 5.0.45-1ubuntu3.3 is missing innodb support. [19:25] for bug #208411 if we dont do inetd default anymore then why dont we just remove it from the init script [19:25] Launchpad bug 208411 in dovecot "Please guard the inetd.conf checks" [Undecided,New] https://launchpad.net/bugs/208411 [19:25] is there a way to pull the config options to see what's happening? I think it's being compiled with '--skip-innodb' [19:31] hi can I start programs on my ubuntu server just like my ubuntu desktop? [19:32] ^^'' [19:37] FreeNod1 no mate - it has no GUI so you need issue commands yourself to start apps. [19:38] mrpoundsign - get the source and build from scratch mate with the options you want - best way for a server deployment. [19:43] soren: *whine* [19:43] soren: Fix my dovecot bugs so I don't have to do it myself! [19:44] mutabi: oh yikes... not even with a terminal client? [19:46] mutabi: is there a doc on that? [19:47] mutabi: Are you sure you don't want to be in #slackware? [19:48] infinity: whats wrong with dovecot? [19:48] mutabi: (It's not considered best practice in an Ubuntu support channel to tell people that they should go compile their own stuff when we happen to provide thousands of packages, specifically so they don't have to...) [19:48] mrpoundsign: Oh, nothing terribly, just grumpy about init spew to stdout, and too busy to upload it myself. ;) [19:48] infinity: how about telling me how to tell what the compile options are for ubuntu-server-5.0.45-1ubuntu3.3 [19:49] :) at lease mutabi is helping. though I would much rather use a package, or get someone to confirm the problem. [19:49] and I will file a bug if I can get someone to confirm the issue. [19:49] mrpoundsign: Err, "ubuntu-server" isn't a package... [19:50] mysql-server, sorry [19:50] zul: Don't remove inetd junk from the init script. It's there to guard against people who DO have it installed. It's correct, it's just not correct to do it blindly. [19:50] zul: Sorry, completely missed you commenting on it. [19:51] infinity: yeah it was just a rhetorical question [19:51] like, if someone can tell me how to get the source package, I can see if the innodb option is disabled upon compile :) [19:51] mrpoundsign: I could be smoking something, but I don't see us shipping 5.0.45 binaries at all... We ship 5.0.51a-3ubuntu5 [19:52] gutsy-updates [19:52] mrpoundsign: Source packages can be snagged with "apt-get source ${package}", assuming you have "deb-src" lines in your sources.list that match your "deb" lines. [19:52] mrpoundsign: Ahh, and here I am assuming hardy's more recent than gutsy. :) [19:53] and where would it put this source when I am done downloading? [19:53] mrpoundsign: In CWD. [19:53] keen. [19:53] with all the patches, etc? [19:54] mrpoundsign: Yup. [19:54] infinity: and 5.0.51 > 5.0.45 ;) [19:55] mrpoundsign: It'll download foo.orig.tar.gz (upstream), foo.diff.gz (patches), foo.dsc (manifest of the previous two), and then helpfulling apply B to A and dump it in a foo-$ver/ directory. [19:55] and where do I see the config options? [19:55] s/helfulling/helpfully/ [19:55] mrpoundsign: foo-$ver/debian/rules would be your best best. [19:55] keen. [19:55] (In gerneral... In the specific case of MySQL, that's definitely where they're defined, unless someone's mangled it severely since I used to maintain it) [19:56] infinity: are you running .51a? Does "SHOW VARIABLES LIKE 'have_innodb';" show enabled to you? [19:57] | have_innodb | YES | [19:58] 5.0.51a-3ubuntu4 [19:58] ok, this is nor infinitely frustrating. It looks like the package source should have it enabled. grr. [20:00] ok, ok... there's nothing in the startup script relating to innodb. skip-innodb is not enabled in /etc/mysql/my.cnf -- anything else I should look at? Any ideas what so ever? [20:02] I'm short on ideas right now, due to trying frantically (and failing miserably) to multitask. [20:05] mrpoundsign: You should at the very least file a bug at https://bugs.edge.launchpad.net/ubuntu/+source/mysql-dfsg-5.0 [20:05] thanks for all the help. This is even worse -- I updated another machine, and it's enabled. copied the my.cnf from that machine to the non-working machine, and it's still disabled. [20:05] yeah, now I am not sure if it's a bug or a misconfiguration. [20:06] mrpoundsign: Oh, that's bizarre. [20:06] both 1686 arch, both 2.6.22-14 [20:06] i686 [20:07] is there a way to force a re-download and install of the package without losing my databases? [20:07] apt-get --reinstall install mysql-server-5.0 [20:08] ok, how about getting it to re-download as well? [20:08] seems to be using the already downloaded package. [20:08] infinity: what do you see without the if then in the dovecot init script? [20:08] "apt-get clean" first. [20:09] root@loki:~# /etc/init.d/dovecot restart [20:09] sed: can't read /etc/inetd.conf: No such file or directory [20:09] * Restarting IMAP/POP3 mail server dovecot [ OK ] [20:09] there we go. Where does it put the packages so I can md5sum them to compare, if I need to? :) [20:09] mrpoundsign: /var/cache/apt/archives [20:09] infinity: gotcha [20:10] zul: Thankfully, that part of the script isn't set -e, so it doesn't fail, but it's still fugly. ;) [20:10] infinity: awesome, thanks. :) will let you know what I find, if anything. [20:12] infinity: uploaded [20:13] zul: You're a champ. [20:14] infinity: np [20:14] found shortcoming open-vm-tools package on 8.04. It's missing all of the default scripts for power up, powerdown, suspend, restart. Yes, I filed a bug [20:15] infinity: md5 summaries match; same problem. Is there a file that specifies start-up options for mysql? Nothing in /var/mysql (or it's sub directories) seems to be mismathed between the two machines === linuxba is now known as penguim [20:16] mrpoundsign: Everything in /etc/mysql, the init script itseld and, there's always the slim chance that the user starting it has something setup in ~/.my.cnf [20:18] infinity: they are all identical across the two machines. [20:18] (at least, as far a md5 can tell) [20:19] mrpoundsign: Of course, some variables can be set in the mysql DB itself.. Not sure if have_innodb is one of them (seems like an odd one to allow people to set). [20:24] infinity: Are just whining or do you have a bug number? :) [20:25] infinity: and I definitely didn't set it. :) where can I dump those options? [20:26] soren: Not only do I have a bug number, but zul already fixed it. [20:27] infinity: Oh :) [20:27] hi [20:28] soren: Yeah, you totally missed out on your chance for free booze as compensation, sorry. [20:28] infinity: What if I threaten to break it again? [20:30] hi! i got a question. i tried to setup a crypted debian server, but the installer is buggy. now i wanna try ubuntu server. i have 2 hdd, want to run them on raid1 and encrypt this. does ubuntu server installer offer all of this? [20:31] does the installer offer cryptsetup during installation? and will there be any bug, like in debian etch? [20:41] That should work. [20:44] ok, then i will download and have atry [21:02] do I need to untar a program in specific place to use it? [21:02] ^^'' [21:05] infinity: I think I found it; somehow my /tmp directory permissions got munged. Do you know how to set the correct permissions? [21:05] mrpoundsign: chmod 1777 /tmp [21:06] infinity: zomg. [21:06] how the *** did /tmp get changed to 700? [21:07] infinity: nothing in mysql.err, it was in syslog. [21:07] * mrpoundsign cries [21:36] infinity: wohoo...free booze [21:41] zul: I made no such promises to YOU, just saying that soren missed out. ;) [21:41] infinity: fine then :P [21:42] im going to go watch family guy then [21:42] You tease. [21:42] But I knew that. [22:19] i put in the wrong dns entries when i was installing my server how do i change them to ones that work? [22:21] good_dana: do you mean the hostname? [22:21] mrpoundsign: no i mean where it looks to resolve hostnames, i figured it out though [22:22] good_dana: /etc/resolv.conf -- if that's not the answer you already had :) [22:22] the other question i had was how can i force it to load 640x480x32 on boot like i had to do for the install? [22:22] mrpoundsign: thanks, that is the answer i had :) [23:36] Hello. Just had a power failure... I need to check my server for hard disk issues. How do I do that? [23:36] sudo fsck [23:37] sorry sudo fsck /dev/xxx,where xxx is the name of your harddrive [23:37] donsmouse: "WARNING!!! Running efsck on a mounted filesystem may cause SEVERE dammage" [23:37] yeah,i read that on a post in the forums [23:38] has anyone tried the new ubuntu 8.04 beta? [23:39] I have, it seems stable (the server version) enough for my forum site [23:39] yeah i tried it and it seems to work ok,but still in the testing stage [23:41] well i'll talk to you guys later,have to go to work