Perl 6 - the future is here, just unevenly distributed

IRC log for #webwork, 2012-06-03

| Channels | #webwork index | Today | | Search | Google Search | Plain-Text | summary

All times shown according to UTC.

Time Nick Message
00:11 JohnTravis hey
00:35 JohnTravis joined #webwork
02:07 JohnTravis joined #webwork
02:08 mgage_ hi
02:08 JohnTravis hey
02:08 mgage_ did you get the preference pane going?
02:09 JohnTravis nope.  Going to take a screenshot if I can just remember the right keystrokes
02:09 mgage_ ok -- try logging out and back in   or rebooting -- I don't think that will make a difference but it's better to be safe
02:10 mgage_ rebooting is a good thing to do whenever you are stuck and you are not sure what state things are in
02:10 JohnTravis Already done that twice.
02:11 mgage_ ok -- then that is not the problem   Command-3 takes screen shots I think
02:11 JohnTravis Looking at finder and now I don't have mysql mounted
02:12 JohnTravis Aha...it finally showed up.  It must take a while to start up.
02:13 mgage_ what showed up? the pane?
02:15 JohnTravis incoming email...
02:16 JohnTravis mysql mounted in finder
02:21 mgage_ your page is covered up by the terminal but I think I see the mySQL.prefPane three lines from the last in the upper right hand corner.  You need to drag that to travis/Library/PreferencePanes
02:21 JohnTravis Just opened your 8:22 email...dragged to Library/PrefPanes...nothing yet but that may require rebooting.
02:21 mgage_ could be
02:22 JohnTravis voila!
02:22 mgage_ ok -- this will tell you whether the mysqld daemon is running
02:23 mgage_ you can also use sudo mysql_safe (or safe_mysql I can never remember which ) to start it from the command line -- but for now just use the prefPane.  when the daemon is running the mysql command from the command line should work
02:23 JohnTravis Opened the app.  It said stopped.  Clicked on Start... and it nothing changes.
02:24 JohnTravis Did a png file come across in your irc client?
02:25 mgage_ no -- you have to mail those
02:25 JohnTravis ok.  Just wondering.
02:27 mgage_ if the prefPane doesn't allow you to start the mysql installation then there is something wrong with the installation -- one possibility is that you already have a different version of mysql running -- set in motion by macports or such like
02:28 mgage_ ps -aux | grep mysql will tell you whether something msql like is running
02:30 JohnTravis Was browsing https://discussions.apple.com/thread/2556342?start=0&tstart=0
02:31 mgage_ I don't think you are using php
02:31 JohnTravis ps -aux give me "no user named x"
02:32 mgage_ you sure you didn't put an extra space  in there?
02:33 JohnTravis ps -aux | grep mysql
02:33 mgage_ no clue -- it works fine for me
02:34 mgage_ take out the x and see what happens
02:35 JohnTravis ps -a gives
02:35 JohnTravis 1711 ttys000    0:00.02 login -pf john
02:35 JohnTravis 1712 ttys000    0:00.03 -bash
02:35 JohnTravis 1768 ttys000    0:00.02 sudo /usr/local/mysql/bin/mysqld_safe
02:35 JohnTravis 2811 ttys000    0:00.00 ps -a
02:37 mgage_ so it looks like you already have a mysqld  running  -- first that probably means that mysql should work (assuming that mysql is also in /usr/local/mysql
02:38 mgage_ secondly you should stop this process and try restarting it with the prefPane since that will probably be less error prone for now
02:38 JohnTravis john$ ps -ax | grep mysql
02:38 JohnTravis 83 ??         0:00.03 /opt/local/bin/daemondo --label=mysql5 --start-cmd /opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper start ; --stop-cmd /opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper stop ; --restart-cmd /opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper restart ; --pid=none
02:38 JohnTravis 102 ??         0:00.05 /bin/sh /opt/local/lib/mysql5/bin/mysqld_safe --datadir=/opt/local/var/db/mysql5 --pid-file=/opt/local/var/db/mysql5/localhost.pid
02:38 JohnTravis 179 ??         0:01.19 /opt/local/libexec/mysqld --basedir=/opt/local --datadir=/opt/local/var/db/mysql5 --user=_mysql --log-error=/opt/local/var/db/mysql5/Johns-MacBook-Pro.local.err --pid-file=/opt/local/var/db/mysql5/localhost.pid
02:38 JohnTravis 1768 ttys000    0:00.02 sudo /usr/local/mysql/bin/mysqld_safe
02:38 JohnTravis 2921 ttys000    0:00.00 grep mysql
02:39 JohnTravis MacPorts!
02:39 mgage_ yep you have a mysql process running -- who knows?
02:39 mgage_ probably not since those usually live under the /opt directory
02:40 JohnTravis see above though.  Ran ps -ax | grep mysql
02:41 JohnTravis process 83
02:41 mgage_ you have a mysqld process running
02:41 mgage_ already
02:41 JohnTravis but will macports conflict perhpas with this version
02:41 mgage_ yes -- but you are not using macports
02:42 JohnTravis 83 ??         0:00.03 /opt/local/bin/daemondo --label=mysql5 --start-cmd /opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper start ; --stop-cmd
02:43 JohnTravis Still irritated that I can't run ps -aux
02:43 mgage_ yes -- that is macports -- and it will cause trouble -- move daemondo up to the /opt directory   -- and then restart.    daemondo starts up mysqld when ever the computer reboots
02:44 JohnTravis where is daemondo now?
02:45 mgage_ /opt/local/bin
02:47 JohnTravis Check email screenshot
02:47 mgage_ yep -- you need to be root -- use sudo
02:48 mgage_ looks ok
02:48 mgage_ now reboot
02:48 JohnTravis ttfn
02:48 mgage_ since daemondo is not in the bin directory it won't actvate on restart
02:50 JohnTravis joined #webwork
02:50 mgage_ since daemondo is not in the bin directory it won't actvate on restart
02:51 JohnTravis running!
02:53 JohnTravis progress.  Incomingf
02:55 mgage_ ok -- try sudo cpan DBD::mysql   it will probably build but will fail the tests because you need to
02:56 mgage_ grant privileges to the test user -- the failing error message will tell you this -- it's not right at the end of the fail -- you have to scroll back
02:57 JohnTravis learning.  So, if I want to run something that uses macports mysql, I can move daemondo back to bin and restart and it will win.  If I want to do WebWork, I can pull it back out.
02:57 mgage_ for GD   first install libgd      brew install libgd
02:57 mgage_ then sudo cpan GD
02:57 mgage_ yes
02:58 mgage_ or you can just start the macports version of mysqld_safe directly (but then use the macports version of mysql )
03:00 JohnTravis this?   mysql> grant all privileges on test.* to 'root'@'localhost' identified by 's3kr1t';
03:01 mgage_ yes
03:01 mgage_ you need to type this into the mysql prompt.   -- the read me on themysql dmg should tell you how to do this
03:02 mgage_ mysql -u root
03:02 mgage_ might work
03:03 JohnTravis yep.  Failed by just logging in...
03:03 JohnTravis mysql> grant all privileges on test.* to 'root'@'localhost' identified by 's3kr1t';
03:03 JohnTravis ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'test'
03:03 JohnTravis mysql>
03:04 mgage_ try quit and then just mysql
03:04 mgage_ to get the mysql prompt
03:04 JohnTravis Query OK, 0 rows affected (0.04 sec)
03:04 mgage_ read toward the end of the readme on the mysql dmg
03:04 JohnTravis I logged into mysql using -u root
03:05 mgage_ if that is the response to adding the test user that is good
03:05 mgage_ actually I would want to see 1 row affected
03:07 JohnTravis tried to do cpan install and same error
03:07 mgage_ probably because test still doesn't have the privileges that it needs -- were the only errors one on the test files?
03:08 JohnTravis mysql -u root
03:08 JohnTravis ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
03:09 mgage_ try just       mysql    like it says in the readme
03:10 mgage_ or /usr/local/bin/mysql/mysql   to make sure you are getting the right version
03:10 JohnTravis did that too
03:10 mgage_ sorry only one mysql
03:11 mgage_ let me try again  to copy out of the readme:
03:11 mgage_ /usr/local/mysql/bin/mysql
03:12 JohnTravis mine is thre
03:12 JohnTravis there at /usr/local/mysql/bin/mysql
03:12 mgage_ and if you type that command does it open up the mysql app?
03:13 JohnTravis mysql> grant all privileges on test.* to 'root'@'localhost' identified by 's3kr1t';
03:13 JohnTravis ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'test'
03:13 JohnTravis mysql>
03:13 JohnTravis mysql> grant all privileges on test.* to 'root'@'localhost' identified by 's3kr1t';
03:13 JohnTravis ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'test'
03:13 JohnTravis mysql>
03:13 mgage_ what happens when just type  /usr/local/mysql/bin/mysql to the command line ?
03:13 JohnTravis this is what I keep getting when I enter just using mysql or john$ /usr/local/mysql/bin/mysql
03:14 mgage_ the response should just be    mysql>
03:14 mgage_ there should be no "grant al privileges "  etc. etc.
03:17 JohnTravis That's what I am doing and getting.
03:17 JohnTravis I am typing the grant privileges since I thought that was what I was supposed to do!  :)
03:18 JohnTravis THat's what the perl install error message said to type
03:19 mgage_ hmm -- ok -- it things you are addressing a database test which can't be right -- you are however logging in to mysql successfully
03:19 mgage_ to the mysql prompt do       show databases;
03:20 JohnTravis will do .  Am instaling libgd right now
03:21 JohnTravis ok.  /usr/local/Cellar/gd/2.0.36RC1: 30 files, 844K, built in 24 seconds
03:21 mgage_ now    sudo cpan GD should work
03:21 JohnTravis information_schema and test
03:22 mgage_ ok -- this means that the way you logged in you don't have the privileges to grant others privileges
03:22 mgage_ you should be seeing a database called mysql
03:25 JohnTravis How is a mere mortal expected to get this to work?!
03:25 mgage_ ask the mysql folks
03:26 JohnTravis Just noticed the time.  Do you normally stay up this late?
03:27 mgage_ I'm not sure what your initial user and password have been set to for your mysql database if you were using it before then it might still be the same..   the only instructios I see are here: http://dev.mysql.com/doc/refman//5.5/en/resetting-permissions.html
03:27 mgage_ yes
03:27 mgage_ usually much later
03:28 mgage_ I still have a bunch of blurbs to write -- and some software stuff to get rebuilt on github.com/mgage
03:28 mgage_ it's coming in pretty fast
03:28 JohnTravis Wow.
03:28 JohnTravis Thanks for your help with this.  This is the reason I gave up last time.
03:29 JohnTravis Will try to spelunk mysql site tomorrow afternoon or so.
03:30 mgage_ jason may be the one to get you past this password block -- I had a previous mysql database so I just used the old user and password to get root access.  You'll have to figure this out from the web and from guessing I think
03:30 mgage_ the page above might help
03:30 JohnTravis THanks.  I'll go through resetting and start from there.
03:30 mgage_ did GD work?
03:31 JohnTravis no
03:31 mgage_ what was the error?
03:34 JohnTravis incominbg
03:35 mgage_ probably move the file /usr/local/includegd.h  to somewhere else
03:35 JohnTravis saw that.
03:37 JohnTravis sudo mv /usr/local/include/gd.h /usr/local/Cellar/gd/2.0.36RC1/include/gd.h
03:37 JohnTravis now much worse
03:38 mgage_ yes -- you just moved the bad file on top of the good one and and I think it's includegd.h  no /
03:39 mgage_ you want the build to find the good includegd.h file in the Cellar
03:40 mgage_ I'm also wondering if you have the necessary png files installed since the test that fails in on png support
03:41 mgage_ you may have to redo installing libgd to get the good version of gd.h back
03:42 mgage_ move other versions of gd.h to places where the compilers won't look for them (e.g. your desktop)
03:43 mgage_ I see it -- at the top of your check_module list you still have a bunch of ** apps. you can skip tth
03:43 mgage_ we don't use that anymore
03:44 mgage_ but you need to install the others    brew install netpnm will install most of them --
03:44 mgage_ jason said that it didn't install pnmtops -- so you'll have to ask him how he finally installed that.
03:46 JohnTravis Egad.
03:47 mgage_ does this work to set the initial password for mysql?
03:47 mgage_ mysqladmin -u root password NEWPASSWORD
03:48 mgage_ supply your own password for root
03:48 mgage_ supply your own NEWPASSWORD for root
03:53 JohnTravis no
03:54 mgage_ so I guess the password for root was already set on mysql
03:54 JohnTravis Error: No available formula for netpnm
03:54 mgage_ ok -- you'll have to wait for  jason on that one then
03:55 mgage_ homebrew doesn't handle that library apparently
03:56 JohnTravis I'm hanging it up to try again some other day.
03:56 JohnTravis Thanks again.
03:56 mgage_ kk   ttyl
03:56 JohnTravis ttfn
21:25 aubreyja joined #webwork
21:25 aubreyja joined #webwork

| Channels | #webwork index | Today | | Search | Google Search | Plain-Text | summary