[00:02] <Lcawte> hmm, next problem
[00:03] <RoyK> Lcawte: why didn't you just start it without grant tables?
[00:03] <Lcawte> RoyK: because that just hung
[00:05] <RoyK> no, it did't, it just didn't fork into the background
[00:05]  * RoyK labels Lcawte NOOB
[00:05]  * Lcawte takes off the duplicate label
[00:06] <Lcawte> Hmm, now, I can't seem to mount my other disk thats attached to the server (its my 80GB desktop 11.10 disk) but I can't take it out because its needed for grub... I need to grab my sql databases from that one, but I can't seem to mount it...
[00:07] <RoyK> Lcawte: grub isn't needed to mount anything
[00:08] <RoyK> Lcawte: pastebin your /proc/partitions, please
[00:08] <RoyK> !pastebin
[00:08] <Lcawte> RoyK: I know that... and I know about pastebining :P  But I meant, I can't take the disk out and put it in another machine to get the stuff because if I do, I break booting on the server, and have to spend another week fixing it
[00:09] <Lcawte> hmm, whats the output of /proc/partitions supposed to look like?
[00:09] <Lcawte> or, what command do I run to get the inteded output
[00:10] <RoyK> you may want to dump the db on that machine, then
[00:10] <RoyK> mysqldump etc
[00:11] <Lcawte> ok, but I still can't mount that disk
[00:11] <Lcawte> "mount: can't find /dev/sdb1 in /etc/fstab or /etc/mtab" (it shows up in fdisk -l though)
[00:13] <RoyK> Lcawte: man mount
[00:15] <Lcawte> RoyK: ah, thanks ... mount -t ext4 is the command :D
[00:18] <Lcawte> RoyK: I probably want to dump all the databases with all the info right? Then would it be "mysqldump -A"?
[00:19] <RoyK> mysqldump --all-databases
[00:20] <RoyK> which is -A, yes
[00:20] <RoyK> same thing
[00:22] <Lcawte> Where does it get dumped to & in what format?
[00:22] <RoyK> that dumps to standard output in SQL format
[00:23] <RoyK> just dump every database you need
[00:23] <RoyK> mysqldump mydb > mydb.sql
[00:23] <RoyK> the mysql database (system db) may be moved as well, but if you don't have too much grants etc, you might want to add those manually to the new system db
[00:26] <Lcawte> v
[00:27] <Lcawte> "mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) when trying to connect" and "service mysql start" gives me a job failed to start message
[00:29] <strickly> whats the job error message you get when starting the daemon?
[00:35] <pdtpatrick1> Question .. why does schroot fail to recognize that a path exists?
[00:35] <pdtpatrick1> http://paste.pocoo.org/show/0jlqgcqNoJthJxjnvYUW/
[00:36] <Lcawte> root@lcserv:/# service mysql start
[00:36] <Lcawte> start: Job failed to start
[00:36] <Lcawte> (chrooted into the disk right?)
[00:43] <strickly> try this
[00:43] <strickly> cd /usr/local/
[00:43] <strickly> cd /usr/local/mysql
[00:43] <strickly> ./bin/mysqld_safe --user=mysql &
[00:44] <strickly> or /usr/local/mysql/bin/mysqld_safe --user=mysql &
[00:44] <strickly> directly
[00:46] <Lcawte> strickly: hmm, theres no mysql in /usr/local
[00:46] <strickly> did you install it manually?
[00:46] <strickly> or via a package manager?
[00:46] <strickly> the mysql app
[00:46] <Lcawte> tasksel or aptitude
[00:47] <Lcawte> may of been in an earlier version of ubuntu though, can't remember
[00:49] <strickly> did you try a
[00:49] <strickly> sudo aptitude reinstall
[00:49] <strickly> maybe its the fastest way to get it corrected
[00:49] <strickly> it shouldnt be such big deal to restart the daemon
[00:50] <strickly> so maybe something wrong in the install/config process
[00:50] <RoyK> wtf is wrong with people? reinstalling things normally doesn't help - fixing things does
[00:50] <Lcawte> Well I am chrooted into the disk remember
[00:51] <Lcawte> which, either means I don't chroot properly or..
[00:51] <RoyK> Lcawte: move the db files away, copy the old ones in, start the db
[00:51] <strickly> well it's about making things easy at times
[00:51] <strickly> not spending hours and more hours figuring it out, when theres no need
[00:51] <RoyK> Lcawte: dump the db, move the old ones away, move the originals back, start dbms, restore
[00:52] <Lcawte> RoyK: problem is, can't dump the old stuff because the old db won't start in chroot :)
[00:52] <RoyK> Lcawte: did you try to read what I just wrote?
[00:52] <strickly> RoyK easy
[00:52] <strickly> :)
[00:52] <Lcawte> ok, I think I've got you...
[00:53] <Lcawte> Old database files... hmm...
[00:53]  * Lcawte goes hunting
[01:29] <MTecknology> hm... So if you have your home directory encrypted using ecryptfs, how can you ssh into that system with shared keys?... you're ~/.ssh/authorized_keys is encrypted until you log in...
[01:37] <MTecknology> heh... that was an easy solution... sorry for not thinking through it before asking
[01:46] <Lcawte> Where exactly is the data for mysql stored, I'm trying to copy the databases from a disk, but my first attempt seems to have left me with an empty database with the correct name
[02:01] <Lcawte> got it, just had to chown the files
[04:12] <squidly> yep../wib
[04:21] <Zanzacar> exit
[04:21] <Zanzacar> exit
[04:22] <Zanzacar> whoops
[04:38] <koolhead17> hi all
[09:58] <lalagirl> hi everyone
[09:58] <lalagirl> !hi
[09:58] <lalagirl> !hello
[13:08] <Guest21672> hello oratedq
[16:06] <codeflux> stupid question: I added a rule to iptables to drop all traffic after the rules for 443, 80 and 22. If I now add a rule for port 21, will it work or does it have to be before the "drop all traffic" rule?
[16:33] <magicblaze007> I'm trying to set some headers on my webserver, and for some reason, cant get the header out to the link at all, had anyone had this problem before?
[16:40] <patdk-wk> magicblaze007, nope
[23:08] <fishscene> Greetings
[23:09] <fishscene> We use gmail for our corporate e-mail, and as such, some applications that depend on a local e-mail server can not use our e-mail system. I would like to set up an internal e-mail server that these applications can use that ties into our gmail system. What would be the best way to do this?
[23:11] <fishscene> I have looked in to postfix, but it is absolutely horrid to set up with many features and options I don't understand, nor do they seem necessary for what I am looking to do.
[23:13] <matoc> What do you mean by tie-in?
[23:15] <fishscene> Essentially, the internal e-mail server would receive messages, and forward them to gmail to the approrpiate address. For example, if I received an e-mail, it would be from "noreply@mydomain.net" going to "fishscene@mydomain.net"
[23:16] <matoc> Not sure about automating this, but a postfix server with PostfixAdmin for web administration could work well for you.
[23:16] <fishscene> hmmm I haven't run across PostfixAdmin yet.
[23:20] <matoc> fishscene: I believe this howto worked for me on 10.04 http://postfixmail.com/blog/index.php/postfixadmin-on-ubuntu-9-10/
[23:20] <fishscene> Thanks matoc
[23:22] <iBaer> Hello
[23:23] <fishscene> Hi
[23:25] <iBaer> I want to access my Samba server from outside my home network, is that possible?
[23:26] <fishscene> iBaer: By connecting to the samba shares directly? I normally use SSH to gain access to my home directory.
[23:26] <matoc> Yes. There are a few different ways. I would use OpenVPN to setup a secure VPN to you home network.
[23:27] <matoc> I have found that many home ISP block port 22 for SSH which makes it a problem. If it's just me and SSH work though, that what I use too.
[23:27] <fishscene> My ISP blocks port 22 as well, so I changed the port :) But yea.
[23:28] <matoc> I've never tried Samba directly over the internet, I'm a little curious how well this works actually.
[23:28] <iBaer> I can access the server via OpenSSH just fine from outside the home, but I can not access the samba
[23:29] <fishscene> Sounds like a DNS/IP routing issue
[23:29] <fishscene> Exposing your samba server to the Internet is not advised.
[23:29] <iBaer> When I'm at home, behind the router, all I have to do is open Windows explorer and the Server box is listed with the samba shares available
[23:30] <matoc> iBaer: I think what was meant about using SSH was that it is used instead (with SSHFS perhaps?) or SMB.
[23:30] <fishscene> iBaer: Have you tried connecting to your samba server over OpenSSH by going to (Windows) start > run > \\(ipaddress of your samba server)
[23:31] <matoc> fishscene: how are you establishing the OpenSSH session in windows first? Does Putty do this?
[23:32] <iBaer> Fishscene: I've tried the \\IP thing, doesnt seem to work
[23:32] <fishscene> wait. I'm an airhead. I was reading openssh as openvpn. I'll shutup now :P
[23:32] <iBaer> I use Putty to connect through SSH
[23:32] <matoc> that's because SMB would need to be piped over SSH first, which I've never done.
[23:33] <iBaer> OpenVPN, I havent tried that, is that trouble to setup
[23:33] <iBaer> any tutorials site for it?
[23:34] <patdk-lap> thousands
[23:34] <patdk-lap> piping smb over ssh? is that possible?
[23:34] <matoc> I believe the official ubuntu wiki serverguide has a tutorial
[23:34] <iBaer> Yes, but are those thousands aimed towards newbies
[23:35] <patdk-lap> ibear, atleast 98% of them are
[23:35] <fishscene> patdk-lap: Only if you pipe openvpn over your SSH connection, which begs the question again, is that possible?
[23:35] <patdk-lap> I can never find ones doing strange things like I do with it
[23:35] <patdk-lap> fishscene, sure
[23:35] <patdk-lap> but I was thinking of ppp over ssh, since poeple love that
[23:35] <fishscene> ah
[23:36] <iBaer> okay now im getting lost with all this piping, ppp, ssh, qqq stuff
[23:36] <qman__> running samba over the internet is unlikely to work and ill-advised
[23:36] <iBaer> Will OpenVPN allow me to access the samba shares?
[23:36] <qman__> most ISPs block it
[23:36] <patdk-lap> openvpn lets you access networks
[23:36] <patdk-lap> samba runs on networks
[23:36] <qman__> yes, openvpn will allow access to samba
[23:37] <patdk-lap> therefor, openvpn lets you access samba :)
[23:37] <fishscene> VPN = virtual private networking (It's as if you're physically plugged in to your remote network)
[23:37] <patdk-lap> and here I thought it was virtual public networking
[23:38] <iBaer> I can access my samba shares via FTP too, but inorder to use the files, the have to be downloaded to the computer I'm accessing the server from.
[23:38] <iBaer> OpenVPN doesn work the same way does it?
[23:38] <iBaer> ?
[23:38] <matoc> SMB over SSH: http://www.blisstonia.com/eolson/notes/smboverssh.php
[23:39] <matoc> I wonder if "ssh -D 445 myserver.com" would work...
[23:39] <iBaer> OKay, well thank you everyone for the suggestions. I'm going to go research all this now.
[23:42] <iBaer> Oh, wait, one last question sorry. I have a dynamic IP, using OpenVPN require the use of ddclient to set a staticip/or domain address?
[23:44] <patdk-lap> depends on how you do i
[23:44] <patdk-lap> it
[23:44] <patdk-lap> but probably yes
[23:45] <patdk-lap> I personally run it at a colo, and my home system vpn's into the colo, so not needed
[23:46] <iBaer> OpenVPN is a paid service?
[23:46] <matoc> there is a community version
[23:46] <patdk-lap> if you want to pay them, sure
[23:55] <fishscene> ok. This e-mail stuff isn't working out very well.
[23:57] <fishscene> I need a simple email server that can bounce messages to gmail.