def main():
ex("sudo ln -s /usr/local/mysql/lib/libmysqlclient.18.dylib /usr/lib/libmysqlclient.18.dylib")
ex("mysql -u root --execute \"create user '%s'@'localhost'\""%user)
_createDb(nlt)
_createDb(researchbroker)
_createDb(surveysidekick)
_createDb(vialogues)
_createDb(cas)
def mySqlToDownloadsDir():
chdir(DOWNLOAD_DIR)
url = MYSQL_32_URL
if is64Bit():
url = MYSQL_64_URL
ex("curl -o mysql-5.5.25-osx10.6-x86_64.tar.gz -L %s"%url)
ex("sudo tar xvzf mysql-5.5.25-osx10.6-x86_64.tar.gz -C %s"%USR_LOCAL)
ex("sudo ln -s %s/mysql-5.5.25-osx10.6-x86_64.tar.gz %s/mysql"%(USR_LOCAL, USR_LOCAL))
ex('echo "export PATH=\\$PATH:%s" >> ~/.profile'%(join(USR_LOCAL, "mysql", "bin")))
ex('echo "export DYLD_LIBRARY_PATH=%s/mysql/lib/" >> ~/.profile'%USR_LOCAL)
def is64Bit():
out = ex("uname -a")[0]
for line in out:
if re.match(".*RELEASE_X86_64 x86_64$", line) is not None:
return True
elif re.match(".*RELEASE_I386 i386$", line) is not None:
return False
else:
raise Exception("Cant detect if cpu is 32 bit or 64 bit")
def _createDb(project):
ex("mysqladmin --user=root drop %s"%project)
ex("mysqladmin --user=root create %s"%project)
ex("mysql -u root --execute \"GRANT ALL ON %s.* TO '%s'@'localhost';\""%(project, user))
pass
def _createUser():
for line in ex("whoami")[0]:
user = strip(line)
ex('echo "export PATH=%s:\\$PATH" >> ~/.profile'%(join(USR_LOCAL, "mysql", "bin")))
ex("sudo ln -s /usr/local/mysql/lib/libmysqlclient.18.dylib /usr/lib/libmysqlclient.18.dylib")
ex('echo "export DYLD_LIBRARY_PATH=%s/mysql/lib/" >> ~/.profile'%USR_LOCAL)
ex("mysql -u root --execute \"create user '%s'@'localhost'\""%user)
ex("mysqladmin --user=root create vialogues")
ex("mysql -u root --execute \"GRANT ALL ON vialogues.* TO '%s'@'localhost';\""%user)
pass
