[00:29] heya dendrobates [00:40] How would I get mysql to show me all the information in a given table? I think I need to brush up on my MySQL syntax... [00:42] JaxxMaxx_: do you want the contents of the table, or the structure? [00:42] structure, I guess. I want to make sure this schema import worked [00:43] it was complaining about a create table statement, didn't like a DEFAULT declaration in an AUTO_INCREMENT value [00:43] show create table, or show table create... will give you the creation statement [00:43] that is show create table table_name [00:43] or the other way around :) [00:44] how would one show the content, then? [00:44] select * from table_name [00:44] I don't trust this damned Dialup-Admin interface to FreeRadius anymore... =] [00:45] heh, ya freeradius is kind of a monster to setup [00:45] doesn't look like anyone's updated the Wikis or HOWTOs since they came out with version 2.0.0 [00:45] Finally I got 2.0.3 package made and installed [00:45] basic auths worked [00:45] now to integrate MySQL support [00:46] have any recommended tools for MySQL administration, sommer ? [00:47] now it wants me to create some d ummy data, but I haven't a clue for that. Always used the Windows version of MySQL before [00:47] mysqlclient, is usually what I use cli [00:47] it's the same thing :) [00:48] no, there were Windows .exe GUI things =] [00:48] the good thing about mysql is that it has great documentation, if you run into an issue you can just google "mysql issue" [00:48] I suppose I'll be running in to MySQL more often, should get a primer book or something... [00:48] mysqladmin runs on Linux as well, should be in the repos I'd think [00:48] yeah, been using that one [00:49] it's commands are pretty basic [00:49] compared to the regular 'mysql' CLI [00:50] I think any gui isn't going to be quite as feature full as the cli utilities [00:51] GUI helps when you dunno the syntaxes. =] [00:51] I just wanna put some dummy rows into certain tables to follow the testing documentation [00:52] you'll want to look into the insert statement for that [00:55] will a package manager tell me what the Base install directory of a package would be? [00:56] one of these .conf files wants the base directory of radiusd and I'm not sure which of the 3 it wants [00:56] you can find all the files in a package with dpkg -L package_name [00:57] I think "base directory" would only relate to specific packages, or could mean different things for different packages [01:05] well, gave it the right folder far as I can figure [01:05] now to see if the page renders proper [01:08] well, the daemon came back up, no errors reported... [01:11] this web interface is still spouting errors in several places, grr [01:51] * dthacker is still hungry [05:25] does have general knowledge on how to setup a backend server for sql? so that the backend machine is conected only though the frontend but can still get updates [05:26] would it be to set the frontend's 2nic and backends nic to a seprate network and then use iptables to route? [05:27] i only can have 1 incoming line but # of servers isnt limited (to a resonable amount) [05:28] Jester45: Don't use iptables to route [05:29] use ip to route [05:29] ok [05:29] You can use iptables to NAT [05:29] If that's what you mean [05:29] i dont have the 2nd machine yet but im trying to learn about this before i have to set it up [05:29] It's quite easy [05:29] well im not really sure what one i want [05:30] i just need the backend to be able to get updates (use apt) and for me to have ssh access [05:31] Jester45: Direct ssh-access? Or via the frontend, and use it like a hop [05:31] and be able to use sql on it [05:31] direct would be prefered... 1 less step [05:32] but it doesnt matter that much [05:33] Than why wouldn't you just connect it as an frontend :) [05:34] because sql access is high on the machine [05:35] ever used torrentflux before? [05:37] well its a pretty complex webui that accesses sql for everything [05:38] this is for school my teacher is trying to teach me load balancing i guess [05:39] i have 5 machines and i need to keep the pages loading quick without the users knowing the difference [05:39] ok [05:40] But why wouldn't you want to connect the sql-box in the same external network as the frontends [05:40] i only get 1 external port [05:41] lol hes making it hard on me... no hubs/switches [05:41] but i do get all the network cards the machines can fit [05:42] thats the first thing i tried was connecting the 1 port to a switch [05:43] he said that would be to easy and wants to see what i can do [05:43] Ah yes [05:44] * Jester45 bragged that linux would bet his windows boxes [05:44] It will [05:44] now i have to prove it [05:44] But if you don't have a switch, it's not very usefull [05:44] why not [05:45] the frontend machine can have 4 nics [05:45] 1 to the internet 1 to sql and i have 2 for storage if i need it [05:46] <\sh> but it won't have the bandwidth for pushing all the data between the 4 nics...even when you have a HP box with 4 133MHz slots for your GigE [05:46] \sh: Hmm. That will be ok [05:46] It will just be a hell to route the stuff [05:46] its not going to be used for anything other than loading pages... just lots of them [05:46] You're network will become a mess [05:46] Jester45: How may webservers do you have? [05:47] i have 5 machines i can use [05:47] <\sh> Jeeves_, regarding traffic and pushing it e.g. from NIC1 Slot1 to NIC2 Slot2 it's not a good idea inside a single server... [05:47] right now i just have 1 running everything they are all p4@2.7ghz 512mb ddr [05:47] 1 machine has 1gb in it [05:48] Anyone have insight into getting MSSQL support in PHP via PEAR on Gutsy. (Phew.. that was a mouthful) [05:48] <\sh> sgrover, it 6:48am in germany..you scare the devil out of me ;) [05:48] \sh, but i cant use a switch [05:48] \sh: You have a few hundred mbits available between those nics :) [05:48] \sh: :) sry.. 10:48 pm here... [05:49] im not sure it would help but i could transfer between the backends [05:49] if needed [05:49] Found some docs in the forums for Feisty, but they fail with libsnmp10-dev [05:49] Jester45: It can be done, but it would be stupid [05:50] (Coming from someone who builds these kind of platforms, tell your teacher the assignment makes no sense) [05:50] <\sh> Jeeves_, shared mbits yes..or you use a e.g. dl585 with 4 cores and separated bridges to those pci slots but IO traffic is sometimes more then you think about a good switch is a better solution.. [05:50] <\sh> sgrover, apt-get install php5-sybase [05:51] \sh: Off course, a switch is a better solution :) [05:51] <\sh> sgrover, I don't know any PEAR solution for that :) [05:51] \sh - I don't think that'll fix the PEAR part though. [05:51] \sh, i cant use a switch part of his "lets make it fun" thing [05:51] guess there's no harm in trying (working in a testing VM) [05:52] <\sh> sgrover, well, I only know that sybase part...because imho there is no scripted interface for it (inside pear) [05:52] sgrover: There were issues to get MSSQL support in PHP [05:52] php-db says it supports mssql - if the drivers are installed [05:52] (or maybe if they are enabled at compile time) [05:53] http://packages.ubuntu.com/hardy/web/php-db [05:53] <\sh> sgrover, the driver is php5-sybase...php-db is just an object model for your php scripts to have a simple interface to any SQL stuff which php-db is supporting [05:53] so.. php-db is an abstraction layer similar in concept to PearDB? [05:53] <\sh> sgrover, yes [05:54] Thank you. I really don't want to write platform specific code.. :) [05:54] <\sh> sgrover, and you need the binary drivers for the rest...(e.g. connecting to the mssql) which is done by the php5-sybase package, just because mssql is a sybase fork ,-) [05:55] <\sh> so...now something for the real life work... [05:56] <\sh> shutting down hellside 7TB storage server [05:57] Thanks \sh - now I need to learn ANOTHER abstraction layer.. :) [05:58] looks like php-db is superceeding Pear-DB? [05:59] thanks for the help i guess i will google a lot more [06:00] hello people [06:01] <\sh> sgrover, well, you have the luck not to deal with the mssql jdbc driver on linux ;) [06:11] \sh: jdbc (when working on PHP), and mssql would be a bad combination. [06:11] I don't mind mssql itself, but the connection issues from FOSS platforms is a pain. [07:29] <_ruben> Jeeves_: ping [07:44] _ruben: Sorry, no time today [07:44] Gotta run [07:58] <_ruben> Jeeves_: sure, no problem [08:58] moin === ewook_ is now known as ewook [10:00] is there anyway to point a source.list config into a local ISO file ? [10:01] yes. [10:01] try using apt-cd to add the cd (not sure if the tool exists anymore) [10:01] no it's not [10:02] you can try addding a line with correct syntax using deb cdrom: or using deb file:/// [10:02] cdrom looks like this: [10:02] # deb cdrom:[Debian GNU/Linux 4.0 r0 _Etch_ - Official Multi-architecture i386/amd64/powerpc NETINST #1 20070407-13:10]/ etch contrib main [10:03] file looks like this: [10:03] deb file:///home/kgoetz/Desktop/ToPng/Debian/DebianMirror/ etch main [10:03] (i'm running debian, obviously enough :)) [10:06] lovely, thanks :-) [10:06] rsync with DVD image is useful now :D [10:07] :D glad it helps [10:07] It's called "apt-cdrom" [10:07] ubotu, find apt-cd [10:07] No packages matching 'apt-cd' could be found [10:07] aah. [10:07] !info apt-cdrom [10:07] Package apt-cdrom does not exist in gutsy [10:07] It's in apt. [10:07] so its still been removed ;) [10:08] !apt-file apt-cdrom [10:08] *shrug* It was worth a try. [10:08] It is in apt. [10:08] lol [10:09] Debian Search of 'apt-cdrom' (4): (/usr/bin/apt-cdrom) in admin/apt ;; (/usr/share/fish/completions/apt-cdrom.fish) in shells/fish ;; (/usr/lib/update-notifier/apt-cdrom-check) in gnome/update-notifier ;; (/usr/share/doc/dahb-html/html/apt-cdrom.html) in non-free/doc/dahb-html. [10:09] this way is easier. [10:09] ubotu wont find anything [10:09] * Kamping_Kaiser larts ubotu for complaing about referring to him === ikonia_ is now known as ikonia [13:22] how would I get this installed: linux-restricted-modules-2.6.22-14-server [14:25] jdstrand: Could you make a clear recommendation for me on how we should proceed with Bug #203948 [14:25] Launchpad bug 203948 in zaptel "zaptel 1.4.8~dfsg-1 fails to compile under kernel 2.6.24" [Medium,Confirmed] https://launchpad.net/bugs/203948 [14:26] ScottK: as shipped, it is utterly broken [14:27] OK. So just grab the latest from unstable and go with it? [14:27] ScottK: so we need to update the package. I am currently using 1:1.4.9.2~dfsg-1 [14:27] ScottK: let me try 1.4.10~dfsg with my updated kernel [14:27] ScottK: give my a minute [14:27] me [14:28] Sure. === starbuck is now known as dantalizing [14:39] ScottK: 1.4.10~dfsg works fine here for me (ztdummy and zaptel modules load fine, and good sound quality w/ my recompiled kernel) [14:39] Would you please mark in the bug that you recommend we sync that. [14:41] ummm... [14:41] we have two portmap and nfs-common start scripts in hardy [14:41] ScottK: done [14:41] in rcS.d and rc2.d [14:41] jdstrand: Thanks. [14:48] np [14:49] Hi. Does anyone know of a CDP backup solution? I've had several services on the backup server, but none of them supports CDP. [14:58] gouki: you mean having an full time copy of your data from one dc SAN to another? [14:59] nijaba: Not sure I understand what you mean. I'm looking for a backup solution that doesnt' rely on schedules. Everytime there is a change to a file, the backup server does an incremental backup. [15:01] gouki: IIRC some file systems provides that, but I do not know of any OSS backup tool that does it [15:01] gouki: that's easy to script [15:03] you need python-pynotify and tar [15:03] pynotify keeps record of changed files and with tar you can do incremental backup [15:04] maybe i should start selling my solution and earn big money :D [15:05] gouki: could SVN your entire file system? [15:05] or that [15:05] set a cronjob to svn commit every minute [15:06] bit hacky, result in massive duplication of files, halving your total available disk space, and could result in a fair amount of load each time it tries to commit [15:06] so probably not a great idea, heh. [15:07] Deeps: imho, it's better to use kernel internal notify system [15:07] and c, python or some else binding [15:11] or you could use a netapp filer [15:11] jdstrand: Sync'ed. [15:12] ScottK: thanks! [15:13] aye [15:13] the cronjob approach is probably the worst, heh [15:36] sorry everyone, I was having breakfast [15:38] The thing is ... The server would be running GNU/Linux and the clients MS Windows. [15:39] ivoks: I liked your solution. [15:39] pynotify can keep records of an entire filesystem? How would tar be activated when a changed occured? [15:42] * gouki loves the solutions coming out of #ubuntu- channels. [15:58] gouki: well, on file change you can start tar from python [15:58] gouki: altough, if files change frequently, your disk will die very soon :) [16:00] gouki: cp would be better than tar... cp /orig/filename /backup/filename.$DATE [16:00] ivoks: I was actually thinking of limiting continuous data protection to a smaller part of the disk, say c:\cdp [16:00] c:? [16:00] ubuntu doesn't have C: :) [16:00] ivoks: yes ... Like I said, clients are running MS Windows. [16:01] i missed that part... you can't use python pynotify on windows [16:01] but you could set up ubuntu server [16:02] which would mount windows shares and then track changes on those shares [16:02] how do i back up my server?. im running webmin and would like to back up my system , it says :directory /etc/bacula was not found. what should i install to back up ? [16:02] binarical-ap1: bacula is enterprise-like backup solution [16:02] persepctivly , how can i setup the bacj up system [16:03] if you don't know what is it, you probably don't need it [16:03] binarical-ap1: I would recommend restore-ee (restore-backup.com) [16:03] ivoks: good idea! [16:03] thanks gouki [16:03] binarical-ap1: If you want to back up more than one computer and you are a sysadmin, I recommend backuppc [16:03] ivoks: Actually, great idea. More centralized and more easy to administer. [16:04] id like to back up my system so as to avoid massive reinstallations once i upgrade my storage media [16:04] aka .image backup or something [16:05] binarical-ap1: Look into clonezilla [16:05] binarical-ap1: Free ghost like solution [16:05] thanks guys [16:05] is there a simple ubuntu .....apt-get option? [16:06] gouki: Restore-backup.com looks a lot like backuppc (features are similar) from the website. Do you have much experience using this software? [16:07] MatthewMetzger: Yes, I've been using it for a while now. Anything I can help you with? [16:08] gouki: nothing in particular, I've implemented backuppc for our organization and it works well, but I'm always looking for good software (best practices). [16:09] MatthewMetzger: I have restore-ee (livecd version, actually) running on our quality datacenter. working with 30 clients (windows), 12 mysql, and 6 sftp [16:09] MatthewMetzger: Has been working OK so far. [16:09] gouki: Do you know if it handles OS X resource forks well? [16:09] MatthewMetzger: No idea. [16:10] gouki: It looks like a good solution, especially in backing up windows clients. Almost all our computers are OS X [16:10] MatthewMetzger: Do you guys have anything similar to Continuous Data Protection? [16:11] MatthewMetzger: It works pretty good with Windows clients. Since we don't have a single OS X running, I haven't had the chance. [16:11] gouki: No we don't . We have automatic network backups made once a day. [16:12] MatthewMetzger: Yeah, we too. The 'problem' is that for some WEIRD reason, they don't want schedules now. Not even a full every 5 minutes :) [16:14] gouki: I've been browsing the restore website and I can't find out if it pools the files. backuppc only stores one file, even if that file exists on 100 computers. It uses hard links to accomplish this. That saves an enormous amount of disk space. Our entire school is backed up using about 275 GB right now (because of pooling). [16:16] MatthewMetzger: Good question. But I don't believe it does that. [16:17] gouki: thanks. I don't see any mention of that on the website. It's a killer feature of backuppc as it saves tons of money on storage media. [16:17] MatthewMetzger: No doubt! [16:17] * gouki looks into backuppc :) [16:18] gouki: I like how restore uses webDAV, but I'm not sure if it makes restores easier yet. I'll have to do more research. [16:24] backuppc does that? [16:24] oh, and i did my own script to do that... it's 10 lines long :) [16:24] take care.. [16:44] _ruben: I'm back. What's up? [16:45] <_ruben> Jeeves_: noticed an error in my nightly scheduled debmirror cronjob .. but then realised it was most likely due to the (expected) peak around the default cron.daily time ;-) [16:45] <_ruben> stale nfs thingie [16:45] Hmm [16:46] <_ruben> rsync: readlink "/dists/gutsy-security/Release.gpg" (in ubuntu) failed: Stale NFS file handle (70) [16:47] Hmm [16:47] i'll try to think of something.. [16:48] <_ruben> changed schedule to every 6hrs to avoid that peak time and have a slightly more up-to-date local mirror .. will know in the morning how the next few syncs will go/have gone ;-) [16:49] <_ruben> (might reduce it once a day again, once all quircks are worked out) [16:52] can anybody recommend me some supplier for server racks and especially shelters beside rittal and lampertz? [16:53] * _ruben loves his dell racks [16:53] APC [16:53] especially for american and asien market, as those big racks are expensive to carry around ... ;) [16:53] <_ruben> too bad we're forced to use rital ones as well (no free dell racks at that colo) :( [16:53] ah, apc ... i forgot about those. [17:06] aquo: are you in need of cabinets with wheels or actual 42u racks? [17:07] good_dana: not sure, i think i need both types. [17:08] startech makes some pretty inexpensive small racks [17:08] and i like the cable management features that come with ortronics rack [17:10] i think the main thing is not about racks, but about physical security ... [17:11] in the moment the company buys products from lampertz, but as transportation of those safes from europe to asia is expensive it would be nice to know some other suppliers. [17:22] nijaba: around? [17:22] nxvl: hello [17:23] nijaba: did you know why is iso.qa closed? [17:23] nxvl: certainly preparing for final release testing I would think [17:24] nxvl: heno in #ubuntu-devel would have an authoritative answer [17:24] so, later today or tomorow the final isos will be there maybe [17:24] * nxvl HUGS nijaba [17:24] :D [17:56] j0, how do I output a list of all groups on a ubuntu server? [17:57] <_ruben> cat /etc/groups [17:58] thanks _ruben, do you by any chance have any experience with syslog-ng also? [17:59] <_ruben> nope, been meaning to look into it, but havent gotten around to do so yet [18:00] ok, to genpub then: When restarting syslog-ng it says I have an error in this line: "group(log);" in the options section of the .conf file ... any thoughts on that? [18:02] <_ruben> i think its a syslog-ng internal group thing, not related to user groups [18:02] aha [18:02] Ok, I'll try and look more into it then [18:04] hey guys, what's the linux command to display the users and groups on the machine (not just currently connected, all)? google fails me. [18:11] finger? [18:15] getent [18:15] getent passwd [18:15] getent group\ [18:15] sorry no \ [18:16] and for a specific entry just put the username or group at the end of those commands [18:37] mathiaz: I might have a fix for that php5 and recode bug that I need to test first [18:37] zul: great - it seems that the upstream commit didn't fix it [18:38] mathiaz: yep we have the upstream "fix" ill let you know [18:38] http://iso.qa.ubuntu.com/ -> testing time! [18:42] nxvl: not quite yet :) [18:43] anyone else get a chuckle out of how WinXP SP3 is supposedly "released" just a couple days before 8.04 is pushed out? === joerlend_ is now known as XiXaQ [21:00] JaxxMaxx_, SP3 has been available since December if you know where to look [21:01] I can just imagine all those MS managers congratulating themselves on beating that pesky Linux thing out the door :) [21:08] JaxxMaxx: i dont think there's as much hardy/sp3 rivalry as you think [21:09] SP3 is mostly just bug fixes and some very lovely performance increases for an ageing OS that the public prefer over the lumbering behamoth of an OS that Vista is [21:11] It's been years since I cared about Windows, myself. === Syntux_ is now known as Syntux [21:28] i support windows desktops, windows servers, and linux servers. i run *nix only at home, sp3 has 0 effect on my thoughts on linux or windows [21:29] hardy coming out is great but, i dont really even see the two as competing products [22:00] Hi! I am a new subscriber on the Ubuntu SErver Mailing Iist. Have to go to doctor, before meeting starts I would like to mention that with the netfront fix the Xen source for Ubuntu 2.6.24 looks like it is fully functional. Have been running dom0 for over a week now, and domU is wrking well too. This is on a single box thoiugh, not a cluster. [22:05] hi people, does any one know of "programming languages" with "free teaching resources"...... or if anyone knows of any good solid books on php or c++, and may have the heart to share their digital copies with me ....... could you send them to r2d2@crapperbox.dnsalias.com ........... id really appreciate that. thanks [22:06] Dive Into Python is Free. It's even packaged for Debian/Ubuntu IIRC. [22:07] ill look into that , thanks ScottK