def pool(name, user, pwd, url):
print("Create pool {}".format(name))
asadmin(
"create-jdbc-connection-pool", "--restype", "java.sql.Driver",
"--driverclassname", "com.mysql.jdbc.Driver", "--property",
"user={}:password={}:URL={}".format(user, pwd,
url.replace(":", "\:")), name)
print("Pool created")
DBUSER = getenv("MYSQL_DBUSR", "root")
DBPASSWD = getenv("MYSQL_DBPASSWORD", "toor")
DBHOST = getenv("MYSQL_HOST", "db")
DBPORT = getenv("MYSQL_PORT", "3306")
text = ""
with open("/etc/default/rss/database.properties") as f:
text = f.read()
text = text.replace("database.url=jdbc:mysql://localhost:3306/RSS", "database.url=jdbc:mysql://{}:{}/RSS".format(DBHOST, DBPORT))\
.replace("database.username=root", "database.username={}".format(DBUSER))\
.replace("database.password=root", "database.password={}".format(DBPASSWD))
with open("/etc/default/rss/database.properties", "w") as f:
f.write(text)
for i in range(20):
try:
time.sleep(1)
print("Trying to connect to the database:.... ")
sock = socket.socket(socket.AF_INET, socket.SOCK_STREAM)
sock.connect((DBHOST, int(DBPORT)))
sock.close()
print("Successfully connected")
break
except:
continue
print("\nstarted\n")
asadmin("deploy", "--force", "false", "--contextroot", rss.get('root'),
"--name", rss.get('root'), rss.get('war'))
def deploy(war, root, force=False):
asadmin("deploy", "--force", "true" if force else "false", "--contextroot",
root, "--name", root, war)
def resource(name, pool):
asadmin("create-jdbc-resource", "--connectionpoolid", pool, name)
DBUSER = getenv("MYSQL_DBUSR", "root")
DBPASSWD = getenv("MYSQL_DBPASSWORD", "toor")
DBHOST = getenv("MYSQL_HOST", "db")
DBPORT = getenv("MYSQL_PORT", "3306")
text = ""
with open("/etc/default/rss/database.properties") as f:
text = f.read()
text = text.replace("database.url=jdbc:mysql://localhost:3306/RSS", "database.url=jdbc:mysql://{}:{}/RSS".format(DBHOST, DBPORT))\
.replace("database.username=root", "database.username={}".format(DBUSER))\
.replace("database.password=root", "database.password={}".format(DBPASSWD))
with open("/etc/default/rss/database.properties", "w") as f:
f.write(text)
for i in range(20):
try:
time.sleep(1)
print("Trying to connect to the database:.... ")
sock = socket.socket(socket.AF_INET, socket.SOCK_STREAM)
sock.connect((DBHOST, int(DBPORT)))
sock.close()
print("Successfully connected")
break
except:
continue
print("\nstarted\n")
asadmin("deploy", "--force", "false", "--contextroot", rss.get('root'), "--name", rss.get('root'), rss.get('war'))
