Changes between Version 5 and Version 6 of ChefNotes

Timestamp:

May 15, 2014 3:27:16 PM (10 years ago)

Author:

Geoff Lawler

Comment:

--

ChefNotes

@@ -32 +32 @@
              * Options passed to mysql: "--pid-file=/var/db/mysql/mysqld.pid --skip-grant-tables --skip-networking --user=mysql --log=/usr/testbed/log/mysql/base --log-bin=/usr/testbed/log/mysql/update --log-slow-queries=/usr/testbed/log/mysql/slowqueries --max_connections=500"
              * That --skip-networking is troubling. Yeah, we need to change that: {{{Do not listen for TCP/IP connections at all. All interaction with mysqld must be made using named pipes or shared memory (on Windows) or Unix socket files (on Unix). This option is highly recommended for systems where only local clients are permitted.}}}
-             * I'll restart mysql on myboss without that argument, then I'll investigate secure remote access. 
+             * I'll restart mysql on myboss without that argument, then I'll investigate secure remote access.
+             * edited {{{/usr/local/etc/rc.d/2.mysql-server.sh}}}
+             * killed mysql (mysqld_watchdog should restart it.)
+                * sudo kill  97362 97535 ; tail -F mysqld_watchdog.log
+                * seems to have worked.
+                * I can now connect remotely using mysql client: {{{mysql -h myboss -P 3306}}}. So yay! We'll need to secure the connection somehow though inthe future. Back to script testing.
+       * running test ruby script. Runs to error (yay!) after making sure the paths are correct.
+     d. Connect to database and print account information as test of mysql code. After that put it in a recipe and try it on the test nodes.
+       * OK! I can query for account information from a test node. The test script is:
+{{{
+#!ruby
+#!/usr/bin/env ruby                                                                             
+                                                                                                
+require 'rubygems'                                                                              
+require 'mysql2'                                                                                
+                                                                                                
+client = Mysql2::Client.new(:host => "myboss", :username => "mysql", :database => "tbdb")       
+                                                                                                
+stmt = "select distinct "                                                                       
+stmt << "  u.uid,u.usr_pswd,u.unix_uid,u.usr_name, "                                            
+stmt << "  p.trust,g.pid,g.gid,g.unix_gid,u.admin, "                                            
+stmt << "  u.emulab_pubkey,u.home_pubkey, "                                                     
+stmt << "  UNIX_TIMESTAMP(u.usr_modified), "                                                    
+stmt << "  u.usr_email,u.usr_shell, "                                                           
+stmt << "  u.widearearoot,u.wideareajailroot, "                                                 
+stmt << "  u.usr_w_pswd,u.uid_idx "                                                             
+stmt << "from group_membership as p "                                                           
+stmt << "join users as u on p.uid_idx=u.uid_idx "                                               
+stmt << "join groups as g on "                                                                  
+stmt << "     p.pid=g.pid and p.gid=g.gid "                                                     
+stmt << "where ((p.pid='Deter')) and p.trust!='none' "                                          
+stmt << "      and u.status='active' "                                                          
+stmt << "      and u.webonly=0 "                                                                
+stmt << "      and g.unix_gid is not NULL "                                                     
+stmt << "order by u.uid limit 2"                                                                
+                                                                                                
+results = client.query(stmt)                                                                    
+results.each do |row|                                                                           
+    printf "%s\n", row                                                                                   
+end                                                                                             
+}}}
+
+This outputs:
+{{{
+#!sh
+./mysql_test.rb 
+{"uid"=>"adititat", "usr_pswd"=>"$1$13954353$MRXeRMUxPc2t4hxFe7o3k0", "unix_uid"=>14427, "usr_name"=>"Aditi Tatti", "trust"=>"local_root", "pid"=>"Deter", "gid"=>"Deter", "unix_gid"=>6004, "admin"=>0, "emulab_pubkey"=>nil, "home_pubkey"=>nil, "UNIX_TIMESTAMP(u.usr_modified)"=>1398879458, "usr_email"=>"tatti@usc.edu", "usr_shell"=>"bash", "widearearoot"=>0, "wideareajailroot"=>0, "usr_w_pswd"=>"03b%5m*g", "uid_idx"=>14536}
+{"uid"=>"alba", "usr_pswd"=>"$1$12831943$YeNdFr60Aj79NiddzObMQ/", "unix_uid"=>11615, "usr_name"=>"Alba Palacios", "trust"=>"local_root", "pid"=>"Deter", "gid"=>"Deter", "unix_gid"=>6004, "admin"=>1, "emulab_pubkey"=>nil, "home_pubkey"=>nil, "UNIX_TIMESTAMP(u.usr_modified)"=>1398879433, "usr_email"=>"alba@isi.edu", "usr_shell"=>"tcsh", "widearearoot"=>0, "wideareajailroot"=>0, "usr_w_pswd"=>"%!<0fsKo", "uid_idx"=>11681}
+}}}
+
+    e. So now all I need to do is learn Ruby.
 
 === Scratch ===