[00:01] New bug: #394043 in nagios3 (main) "Sync nagios3 3.0.6-5 (main) from Debian unstable (main)." [Wishlist,Confirmed] https://launchpad.net/bugs/394043 [00:04] http://www.iana.org/assignments/port-numbers [00:11] can anyone suggest a good command line tool to view network throughput? [00:26] iftop dude [00:27] that's a nice app, I think it's what you want [00:35] ghostlines: iftop wont graph network throughtput unless you generate trafic [00:36] incorrect: for network throughput you can use iperf [00:36] or simply rsync, or scp [00:36] I really like vnstat :) [00:54] i know this might sound ridiculous, but is there any way to restart my server from a webpage? [01:00] cmwslw: i've never used one, but you might want to look at web-based server managers like: http://www.webmin.com/ [01:04] I love webmin [01:08] MianoSM, tried ebox? [01:09] cmwslw, you might want to check out ebox as well [01:11] i already have that installed, but it is a security risk if it is enabled for the whole internet to access [01:12] firewall it? [01:12] i do have a login protected admin page though which i would like a simple restart button [01:14] i might need to reboot while on vacation - that's why i need a reboot button [01:14] don't want to ssh in and reboot? [01:14] i can't really firewall webmin because i don't know what the ip address is [01:15] can i use an ipod touch to ssh - mine's jailbroken and ssh installed [01:15] idk if it is the ssh client or just server [01:15] foxbuntu: I did, it wasn't my cup of tea (to be honest I have liked using webmin for too long) [01:16] cmwslw: you should be able to use that. just do a test before leaving [01:17] wait, my ssh is enabled for lan only, like webmin [01:18] i always thought that enabling services like these for the internet were huge security hazards - is it not the case? [01:19] cmwslw, while they can be, you just need to take proper precautions to secure them [01:24] cmwslw, I have a few servers with ssh out to the web, but I use RSA key authentication not passwords [01:25] i just tried sshing into my server via my ipod touch, and everything worked [01:25] i'm going to see if i can get rsa keys to work on it [01:25] I have a mysql server running on one machine, but cannot access from another even with the same username/pswd (root) [01:26] JorgeJorgesson: JorgeJorgesson probably because mysqld only listen on the loopback interface [01:26] check /etc/mysql/my.cnf for the bind-address option [01:27] Ah, if I change that, then I cannot access it on the same local machine, correct? [01:29] Now I see my problem. [01:29] I cannot use the mysql database server from a local machine and a remote machine at the same time, correct? [01:30] just comment the line and restart mysql [01:30] check [01:30] netstat -pltn | grep mysqld [01:31] that will show you the socket mysql is listening [01:31] jmedina: comment what line? how do I get mysqld to listen on both remote and local? [01:31] bind-interfaces [01:32] bind-address [01:32] Do I bind both? [01:32] or something, im telling you from memmory [01:32] Ok, nevermind. Thanks for the tip though! [01:32] you can just comment the line, and mysql will listen on every network interfaces [01:33] I tried that. [01:33] Local access works, remote does not [01:35] You forwarded the port, and tried connecting to the local and external IP? === obstriege is now known as obst [01:36] MianoSM: even internal (LAN) connection need to connect via WAN? [01:37] JorgeJorgesson: did you create a mysql account allowd to connect from remote hosts? [01:37] the defualt root account only allows to connect from localhost root@localhost [01:38] I don't understand....I've had all this working before [01:39] JorgeJorgesson: show the evidence.... [01:39] show your logs [01:39] show your config files [01:39] show output from netstat -pltn | grep mysql [01:43] ok, something is wrong here [01:43] I think two servers are running [01:43] show the evidence [01:43] use pastebin [01:44] My remote account shows no databases, my local shows all [01:44] I had this all working just the other day....no proof required. I was using it. [01:44] I don't understand what went wrong here [01:45] well, if you dont show us the output, all we can do is guess [01:46] What do you want to see? Do you too want ssh? [01:46] JorgeJorgesson: your config file [01:46] output from netstat [01:46] :) [01:46] config what [01:46] the one we were just taking about [01:46] my.cnf [01:48] http://pastebin.ca/1480210 [01:49] now from netstat -pltn | grep mysql [01:50] tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 3912/mysqld [01:50] ok [01:50] and what about the account? [01:50] This stuff is going to give me a heart attack soon or later [01:50] can you connect to mysql with root? [01:50] :) [01:50] local yes, remote no [01:51] ok [01:51] use mysql; [01:51] yes [01:51] select host,user,password from user; [01:51] yes [01:51] I get a connection with no databases remotely [01:51] local I see all my databases [01:52] show the output [01:52] What log can I show you that it worked just a couple of days ago [01:52] I was using the remote to study for my exam [01:53] Output: [01:53] Database information_schema [01:54] 1 row in 0.00 sec [01:54] mm [01:54] Yeah, same problem as before [01:55] It all worked just two days ago [01:55] remote, local [01:55] all good [01:56] The mysql guys called me a moron (more or less) the ubuntu-us-fl guys got me running local....great job! [01:56] JorgeJorgesson: use pastebin [01:56] I coulnt see your output [01:56] :) [01:57] pastevin.ca/1480214 [01:57] pastebin.ca/1480214 [01:58] JorgeJorgesson: spanish? [01:58] mmm [01:58] yeah, pretty much!!! [01:58] tocayo [01:58] lets try in english :) [01:58] ciau baby [01:58] ok, did you get it? [01:59] yeap [01:59] ok but... [01:59] I never ask for the output from show databases; [01:59] Oh crap.... [01:59] Ok, reset [01:59] What did you want again? [01:59] use mysql; [01:59] yes [01:59] On the remote? [01:59] select host,user,password from user; [01:59] not [01:59] from local [02:00] root at local [02:00] mysql [02:00] not sure what you want [02:00] use mysql; [02:00] ? [02:00] I want to get a mysql user list [02:00] I want the optput from selec.. [02:01] ok, exact commands [02:01] scroll up [02:02] I did [02:02] No database selected [02:02] what? [02:03] did you type: use mysql;? [02:03] I guess I'm just not smart enough to get this stuff. [02:03] yess [02:03] ¬¬ [02:03] again [02:03] use mysql; [02:03] you should get something like: database changed... [02:03] then type the select command.. [02:03] and show me the output [02:03] so are you takina mysql exam? [02:03] taking [02:04] yes and I've run a website for a year [02:04] this is making no sense to me [02:04] ERROR 1046 (3D000): No database selected [02:04] mmm [02:04] how did you connecto to mysql? [02:04] from remote or local? [02:05] I can write select queries galore [02:05] I am local [02:05] ok [02:05] show databases; [02:05] you should get a list of databases; [02:05] I told you before, no problem [02:06] Remote is the problem [02:06] ok, but we need to type some commands from local to debug this [02:06] ok [02:06] I understand what you want to do [02:06] show users, show permissions [02:06] right? [02:07] yeap [02:07] Ok, I'm not that far yet in my studies! [02:07] I'm at select, create and such...up to chpt. 10 [02:08] ok again [02:08] show the output from show databases; [02:08] from where? [02:08] from local!!!!! [02:09] I want to know if you have a root account with remote access [02:10] I told you ......all my databases.....http://pastebin.ca/1480222 [02:10] Sorry, I'm being a smartass again....you are helping. [02:10] Just frustration [02:11] ok [02:12] now [02:12] use mysql; [02:12] and [02:12] wharer [02:12] where [02:12] LOCAL!!!!!!!!!!!!!!! [02:12] ok [02:13] ok [02:13] and then type [02:13] select host,user,password from user; [02:13] and show me tht output [02:13] that will give you a mysql users list and the host they are allowed to coonnect from [02:13] ERROR 1046 (3D000): No database selected [02:13] damn [02:14] that would be in information_schema [02:14] please show me the full output from use mysql to that error [02:14] I did [02:15] again [02:15] I want to see everything [02:15] not only that line [02:15] That is it. [02:15] *use mysql;* [02:15] One line [02:15] :) [02:15] I did [02:15] I can make stuff up if you want :) [02:15] JorgeJorgesson: just paste full output [02:16] I did....not sure what you want here [02:16] That is the exact output [02:16] use your mouse, click in the line that starts with mysql> use mysql, and drag it down until the line with ERROR [02:16] :) [02:16] exit [02:16] sorry [02:16] :D [02:17] does anybody know how to enable ssh access over the internet, but only w/ rsa keys? [02:17] mysql> select host,user,password from user; [02:17] ERROR 1046 (3D000): No database selected [02:17] i got rsa keys to work on my ipod [02:17] I want to see full output for every command you type and for every message mysql [02:18] can we do this all together? [02:18] JorgeJorgesson: you haven't switched to the mysql DB :( [02:18] ah, use mysql [02:18] yep, 'use ;', where in this instance is mysql [02:19] cmwslw: edit /etc/ssh/sshd_config and add PasswordAuthentication no [02:19] mattt, i understand [02:19] JorgeJorgesson: otherwise, you can do: 'select host,user,password from mysql.user;' [02:19] jmedina: thanks a ton! [02:20] http://pastebin.ca/1480228 [02:21] cmwslw: I think that option was in the config file with yes [02:21] mattt, understood now [02:21] probably ubuntu guys remoted it [02:24] JorgeJorgesson: now [02:24] select host,db,user from db where user='root'; [02:25] matt thanks for remind me about db.table [02:25] empty [02:27] so how do I logon as local root [02:28] so, your root@% dont have accees to any database [02:28] you mean remote [02:28] so how do I logon as local root [02:28] as local? [02:28] you are doing this as local. [02:28] I still don't understand....this worked just days ago [02:29] JorgeJorgesson: well something changed, and someone did it [02:29] But I am right here [02:30] I own these machines [02:30] I had it all working [02:30] I cannot now access my "server" from my "local" machines [02:30] Machines in the same network [02:31] grant all privileges on *.* to 'root'@'%'; [02:31] and then [02:31] flush privileges; [02:31] and there you go :) [02:33] I just don't get what happened. [02:33] My website is running just fine.......and has been for a year [02:34] and your website is on which computer? [02:34] yes! i can now ssh with an rsa key from my iphone [02:35] this is awesome [02:36] cmwslw: good, you should write a howto :) [02:36] i was planning on doing that [02:36] Im going to by a hiphone :) [02:36] on my blog [02:36] 200 dollars :) [02:37] it was actually not very different from a normal computer [02:37] i hope jorge gets back on [02:37] i just realized i had the same problem as him and fixed it [02:38] I have some servesr configured to allow password auth for normal users and only allow root using rsa [02:38] jmedina: all is well now, thanks again [02:39] jorge: did you try rebooting? [02:39] yup [02:39] that fixed the problem for me [02:39] Works great [02:39] JorgeJorgesson: you are welcome [02:39] haha [02:39] reboot? [02:39] what? [02:39] i had the same problem [02:39] this is not windows [02:39] :) [02:39] jmedina: he had problems with mysqld apparantly not running after a reboot earlier [02:39] server was down for a week until i rebooted [02:40] could have fixed it sooner but i was on vacation [02:40] now i can use my IPHONE! woot [03:12] Hi, All. I should be the happy owner of three new baby servers, but something has gone a miss [03:12] Island_Swimmer: ? [03:14] Well, when I go to create a new Mediawiki page, I get: [03:14] Error Text: [03:14] Fatal error: Allowed memory size of 20971520 bytes exhausted (tried to allocate 7680 bytes) in /var/www/technology/wiki/includes/AutoLoader.php on line 582 [03:15] idk why mediawiki would use that much [03:15] What could be wrong? Any help is appreciated. Please [03:15] cmwslw: 20MB isn't much [03:15] i thought 20mb was the default? [03:15] Island_Swimmer: change the memory limit in the php.ini file [03:15] cmwslw: it's still not a lot of memory :) [03:15] I tried, but since I can't get VIM-full installed, I can't edit the files [03:16] nano? [03:16] I am not comfortable with Nano, since it broke my php in the first place [03:16] Island_Swimmer: sed -i ? :) [03:16] well if that's the case, i would reinstall php then [03:17] I did. That is why my limit is back to 16 MB [03:17] i don't see how nano could be more complicated than vim [03:17] Island_Swimmer: ok, so then you know what the problem is ... but the problem is that you can't use nano? [03:18] and why not vi? [03:18] I'm blind. Learning a new Text Editor on a production system is not really an option in the time crunch. Unfortunately that is the case [03:18] ok, that certainly complicates things a bit :/ [03:18] I wasn't sure if that was the problem, but rather I suspected it. I also needed to confirm this [03:19] Island_Swimmer: copy the file to your local machine, edit it, and upload it again :) [03:19] sed -i it is then [03:19] :) [03:19] or ed [03:19] :) [03:19] I didn't think of that [03:19] jmedina: that's cruel [03:19] I'll be back. What is the file exactly I'm editing again [03:20] ajmitch: well if he is unable to use vi then will be hard to use sed [03:20] ? [03:20] Please [03:20] the file in /etc/php5/apache2/php.ini [03:20] jmedina: you don't need to navigate around anything with sed, it's a single command to run [03:21] ajmitch: I know [03:21] he just can't learn sed right now, so I just give a solution, I would use sed [03:22] * jmedina loves sed [03:22] :) [03:22] php5's debian/rules uses sed to change the memory limit [03:24] ajmitch: share the line [03:24] cat php.ini-dist | tr "\t" " " | sed -e'/memory_limit =/ s/128M/32M/g' > debian/php5-common/usr/share/php5/php.ini-dist.cli [03:25] is what's in debian/rules, of course it'd need to be changed for the installed file [03:28] Ok. I upped the limit and still get the same error after Apache2 Force-reload [03:28] I upped it to 32M [03:29] I appreciate all solutions, no matter how big or how small [03:30] Island_Swimmer: restart apache [03:30] not just reload [03:31] * ajmitch would suggest it being much higher than 32M, depending on how much RAM your servers have [03:31] I got a slightly different error [03:31] Error text: [03:31] Fatal error: Allowed memory size of 20971520 bytes exhausted (tried to allocate 8192 bytes) in /var/www/technology/wiki/includes/SpecialPage.php on line 1 [03:31] certain PHP apps gobble up the memory [03:32] Yeah, but Mediawiki is recomended at 32M [03:32] 32M [03:32] as a bare minimum? [03:32] Hmm. I'll be back [03:33] looking at the mediawiki site, you should also increase the memory limit in LocalSettings.php [03:34] http://www.mediawiki.org/wiki/Manual:Errors_and_Symptoms#Fatal_error:_Allowed_memory_size_of_nnnnnnn_bytes_exhausted_.28tried_to_allocate_nnnnnnnn_bytes.29 [04:09] Thanks [04:09] That fixed it [04:12] It was in Localsettings.php [04:12] !Webadmin [04:12] Sorry, I don't know anything about Webadmin [04:12] !Webmin [04:12] webmin is no longer supported in Debian and Ubuntu. It is not compatible with the way that Ubuntu packages handle configuration files, and is likely to cause unexpected issues with your system. See !ebox instead. [04:13] !ebox [04:13] ebox is a web-based GUI interface for administering a server. It is designed to work with Ubuntu/Debian style configuration management. See https://help.ubuntu.com/community/eBox [04:15] Why is VIM-full not in my repository? [04:15] Please [04:16] !Packages [04:16] You can browse and search for Ubuntu packages using !Synaptic, !Adept, "apt-cache search ", or online at http://packages.ubuntu.com - Ubuntu has about 20000 packages available, so please *search* for an official package before installing things in awkward ways! [04:16] !Repositories [04:16] The packages in Ubuntu are divided into several sections. More information at https://help.ubuntu.com/community/Repositories and http://www.ubuntu.com/ubuntu/components - See https://wiki.ubuntu.com/RecommendedSources for the recommended way to set up your repositories [04:18] Island_Swimmer: vim is (I suspect) vim-full. [04:37] I know that, but unfortunately it is not in my repository. Neither is Ebox [04:38] It is odd. It is a minimal install of Ubuntu 8.04 Hardy === smultron_ is now known as smultron [07:46] I'm wondering if PHP 5.3 will make it into Hardy? If so I need to start doing some testing... [07:47] does anyone know? [07:53] how do i fix this: for apache? Directory index forbidden by Options directive: /mnt/app/current/public/ [08:05] arooni: somewhere in /etc/apache2/sites-available/ there's a line that forbids directory listing. Normally that's exactly what you want to do [08:05] thats what i want right [08:05] to forbid direcotry indexing [08:15] arooni: check the Apache documentation or just Google it, I don't remember exactly what you're supposed to write. But the file you should put ut in is the one I mentioned, that's for sure [08:15] got it working [08:15] good [08:25] hi [08:27] I need some advise: I want to migrate my old mail server and I was thinking that maybe is time for a change. We're using POSTFIX and COURIER as MTA/MDA with LDAP as backend. I've been researching a little bit, and maybe DOVECOT or QMAIL could do the job better and easier. What do you think? Thanks! [08:29] acalvo: do the job better how? [08:30] acalvo: are you having problems w/ postfix/courier? [08:30] mattt, no, but it was a pain to set it up and it lacks some administration tools [08:31] acalvo: i don't even see a qmail package on hardy :/ [08:33] mattt, damn, my test machine is Jaunty... [08:33] don't see one for jaunty either :) [08:34] iirc, there is some packing issues w/ qmail which is why ubuntu/red hat, etc. don't distribute it [08:34] some historic licensing issues at least [08:34] oh, ok [08:34] but, what do you think about DOVECOT? [08:35] dovecot & postfix are the recommended tools for ubuntu [08:35] well, I think I'll give it a try [08:35] hope the LDAP integration works fine [08:36] have you tried with such a configuration (LDAP, quotas, ...)? [08:36] I haven't tried it, but I believe there's some good documentation on dovecot & ubuntu [08:36] oh, well [08:36] * ajmitch uses exim4 & dovecot [08:36] uhmmm [08:36] exim! [08:36] another one I've heard about [08:40] i like postfix ... the standard install works nicely w/out much (if any) hacking [08:40] but it's really configurable if you want to do wacky stuff [08:40] I agree [08:40] but it seems that exim is more powerful and customizable [08:41] i thought exim's selling point was simplicity [08:43] yes, but it achieves that by having several plugins [08:52] hey can you guys help [08:53] how do u apt-get install including config files if I deleted the directory [08:53] !u [08:53] U is the 21st letter of the modern latin alphabet. Neither 'U' or 'Ur' are words in the English language. Nor are 'R', 'Y', 'l8', 'Ne1' or 'Bcuz'. Mangled English is hard for non-native English speakers. Please see http://geekosophical.net/random/abbreviations/ for more information. [08:54]