Name: PivotalMySQLWeb
Owner: Pivotal Cloud Foundry
Description: PivotalMySQL*Web is a free Pivotal open source project, intended to handle the administration of a Pivotal MySQL Service Instance over the Web
Created: 2016-07-03 07:15:05.0
Updated: 2018-05-23 18:27:14.0
Pushed: 2018-05-01 09:11:58.0
Size: 983
Language: JavaScript
GitHub Committers
User | Most Recent Commit | # Commits |
---|
Other Committers
User | Most Recent Commit | # Commits |
---|
PivotalMySQLWeb is a free Pivotal open source project, intended to handle the administration of a Pivotal MySQL Service Instance over the Web. PivotalMySQLWeb supports a wide range of operations on a Pivotal MySQL Service Instance such as managing tables, views, indexes which can all be performed via the user interface, while you still have the ability to directly execute any number of SQL statements
It includes the following capabilities:
cella@papicella:~/pivotal/DemoProjects/spring-starter/pivotal/PivotalMySQLWeb$ java -jar ./target/PivotalMySQLWeb-0.0.1-SNAPSHOT.jar
____ _ __ _ _
/ ___'_ __ _ _(_)_ __ __ _ \ \ \ \
)\___ | '_ | '_| | '_ \/ _` | \ \ \ \
___)| |_)| | | | | || (_| | ) ) ) )
|____| .__|_| |_|_| |_\__, | / / / /
======|_|==============|___/=/_/_/_/
Spring Boot :: (v1.3.5.RELEASE)
-07-03 17:13:44.164 INFO 19664 --- [ main] .m.m.a.ExceptionHandlerExceptionResolver : Detected @ExceptionHandler methods in repositoryRestExceptionHandler
-07-03 17:13:44.225 INFO 19664 --- [ main] o.s.j.e.a.AnnotationMBeanExporter : Registering beans for JMX exposure on startup
-07-03 17:13:44.291 INFO 19664 --- [ main] s.b.c.e.t.TomcatEmbeddedServletContainer : Tomcat started on port(s): 8080 (http)
-07-03 17:13:44.294 INFO 19664 --- [ main] c.p.p.m.PivotalMySqlWebApplication : Started PivotalMySqlWebApplication in 3.4 seconds (JVM running for 3.761)
Default username = admin
Default password = cfmysqlweb
://localhost:8080/
Note: When connecting to a MySQL database instance ensure you JDBC URL includes a database name as shown below which targets the “employees” database
:mysql://localhost:3306/employees
To deploy to Pivotal Cloud Foundry it's best to bind the application to a Pivotal MySQL service instance so it automatically connects to the MySQL instance as shown in the sample manifest below. If you don't bind to a MySQL instance it will simply ask you to login to a MySQL instance itself.
ications:
me: pivotal-mysqlweb
mory: 1024M
stances: 1
ndom-route: true
th: ./target/PivotalMySQLWeb-0.0.1-SNAPSHOT.jar
rvices:
- pas-mysql-dedicated-v2
v:
JAVA_OPTS: -Djava.security.egd=file:///dev/urandom
Push to PCF using
push -f manifest.yml
You can control the number of records to display in the “SQL Worksheet” using the “Preferences” page. To do that follow these steps:
Alternatively you can also set that at deployment to use a default value by editing “main/resources/preferences.properties” and setting the property below.
ecordsinSQLQueryWindow=500
By default this application is using HTTP Basic Authentication to protect every end point. The username/password is set in “main/resources/application-cloud.yml” and “main/resources/application.yml” files and can be altered here prior to deploying. Be sure to repackage to pick up your new username/password you wish to use for HTTP Basic Authentication
Default username = admin
Default password = cfmysqlweb
rity:
er:
name: admin
password: cfmysqlweb
sic:
enabled: true
ssions: never
Pas Apicella [papicella at pivotal.io] is a Senior Platform Architect at Pivotal Australia