2006 Dodge Grand Caravan wheel stud/rear assembly replacement

Rear Assembly with Replacement stud The wife’s van had a flat tire, and while taking the lug nuts off one of them decided to get stuck and break off the wheel stud. Once I got the caliper, drum, parking break, etc. all off I at first was going to try just replacing the wheel studs, but this process was very slow, and in the end I decided to just replace the entire rear assembly.

I could not have done it without the links below, and a few other things to keep in mind:

  • use a sledge hammer to get the roter off if it is tough to get off (but only hit near the studs. If replacing just one or two of the studs (and not the whole assembly), put lug nuts over the good studs to help protect them from errant hits with the sledge hammer
  • if replacing studs, use a stack of washers to pull the stud into the assembly, and a screwdriver against other studs, or through the holes of open holes of the assembly to stabilize the assembly while tightening the stud
  • do NOT put the rear assembly on before doing the parking brakes first. Put a couple of the rear assembly bolts in and zip ties in the other holes to hold the backing plate on, assemble the parking brakes, carefully cut the zip ties, then put the rear assembly on
  • to put the bottom parking brake spring on, grab the center of the spring with some pliers and pull it to the other hole
  • when putting the spacer on the rear brakes in, grab both sides of the parking brake with pliers, pull apart while someone else places the spacer in the bottom of the brakes

How to change rear brakes and rotors 2006 DGC – DodgeForum.com

install 2005 dodge caravan rear wheel bearing and parking brake pads – YouTube

install 2005 dodge caravan rear wheel bearing and parking brake pads – YouTube

install 2005 dodge caravan rear wheel bearing and parking brake pads – YouTube

Mysql connects via command line, but not through client

I thought I had installed MySql so that it was available to the outside world (at least locally), but I kept getting the exception through SquirrelQL:

java.util.concurrent.ExecutionException: java.lang.RuntimeException: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.util.concurrent.FutureTask.get(FutureTask.java:202)

at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.RuntimeException: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:171)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$000(OpenConnectionCommand.java:45)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$1.run(OpenConnectionCommand.java:104)
… 5 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)

at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:325)
at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:167)
… 7 more
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
… 21 more

I knew I had to of done something wrong in the install (probably forgot to check the allow remote connection option). The original mysql.ini (which was wrong) looked like this:

[client]

pipe
socket=mysql

[mysql]

default-character-set=latin1

# SERVER SECTION
# ———————————————————————-
#
# The following options will be read by the MySQL Server. Make sure that
# you have installed the server correctly (see above) so it reads this
# file.
#
[mysqld]

skip-networking
enable-named-pipe

# The Pipe the MySQL Server will use
socket=mysql

#Path to installation directory. All paths are usually resolved relative to this.
basedir=”C:/Program Files (x86)/MySQL/MySQL Server 5.1/”

#Path to the database root
datadir=”C:/ProgramData/MySQL/MySQL Server 5.1/Data/”

I changed the section to the following, and then my clients were able to connect to the localhost db:

[client]

port=3306

[mysql]

default-character-set=latin1

# SERVER SECTION
# ———————————————————————-
#
# The following options will be read by the MySQL Server. Make sure that
# you have installed the server correctly (see above) so it reads this
# file.
#
[mysqld]

# The TCP/IP Port the MySQL Server will listen on
port=3306

#Path to installation directory. All paths are usually resolved relative to this.
basedir=”C:/Program Files (x86)/MySQL/MySQL Server 5.1/”

#Path to the database root
datadir=”C:/ProgramData/MySQL/MySQL Server 5.1/Data/”

Git failure due to http vs. https

Somehow I either saved the URL wrong, or the URL changed (more likely), and caused git to fail when the URL should have been secure:

C:\dev\git\myCode>git push origin master
fatal: unable to access 'http://sean@dev1.company.com/stash/scm/inf/myCoolApp.git/': Empty reply from server

update .git/config to be https URL

[core]
	repositoryformatversion = 0
	filemode = false
	bare = false
	logallrefupdates = true
	symlinks = false
	ignorecase = true
	hideDotFiles = dotGitOnly
[remote "origin"]
	url = https://sean@dev1.company.com/stash/scm/inf/myCoolApp.git/
	fetch = +refs/heads/*:refs/remotes/origin/*