text:
Q: Unable to connect to Mysql via JDBC but works fine with Mysql I have a mysql server running locally to which I am able to connect using
mysql -h localhost -u root

It does not require a password. But when I try to connect with the same attributes (jdbcurl = "jdbc:mysql://localhost:3306/mysql", user = root) via JDBC, I get this weird exception
he last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
    at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
    at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
    at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
    at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
    at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
    at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:91)
    at com.mysql.cj.NativeSession.connect(NativeSession.java:144)
    at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:956)
    at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:826)
    ... 33 more
Caused by: java.net.ConnectException: Connection refused (Connection refused)
    at java.base/java.net.PlainSocketImpl.socketConnect(Native Method)
    at java.base/java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:399)
    at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:242)
    at java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:224)
    at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:403)
    at java.base/java.net.Socket.connect(Socket.java:591)
    at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:155)
    at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:65)
    ... 36 more

What could be the issue here?
EDIT
Tried out the suggestion given in the comments to try to connect to mysql database via mysql as being done in java.
mysql -h localhost -u root mysql

This works and I get connected to the mysql db.

A: Case 1 - JDBC connects as root@127.0.0.1 but privilege is not granted:
It is possible that your mysql CLI is connecting via Unix domain socket (as root@localhost) while your Java application attempts to connect via TCP (as root@127.0.0.1) but privilege is not granted.
To verify, run status command in the mysql client:
mysql -h localhost -u root -e 'status'

The Connection field should show if you are connecting to Localhost via UNIX socket or 127.0.0.1 via TCP/IP
If you are connecting via UNIX socket, you may try forcing the client to use TCP instead:
mysql -h localhost -u root --protocol TCP -e 'status'

If it fails, you may check if you have the user allowed from the host 127.0.0.1:
SELECT * FROM mysql.user WHERE Host = '127.0.0.1'\G

An empty result set indicates that you don't have that user root@127.0.0.1 yet. You may create it with:
CREATE USER 'root'@'127.0.0.1' IDENTIFIED BY '';
GRANT ALL ON *.* TO 'root'@'127.0.0.1' WITH GRANT OPTION;

You may then retry the TCP and Java application.
Case 2 - localhost translated to IPv6
If you have no problem connecting via TCP as described above, then another possibility is that the localhost string is translated by your Java application to the IPv6 ::1 while your MySQL server isn't configured to listen to the IPv6 interface.
You may try using 127.0.0.1 in your jdbcurl, e.g.: jdbc:mysql://127.0.0.1:3306/mysql.
If for some reasons you cannot change jdbcurl, you may try launching your Java application with the -Djava.net.preferIPv4Stack=true option, e.g.:
java -Djava.net.preferIPv4Stack=true -jar myapp.jar

A: Which MySQL Version you are using ?
You won't be able to use root user I guess.
Create new application user and use that user for application.
CREATE USER appuser@'%' identified by 'PASSWORD';
Grant SELECT on *.* to appuser@'%';
flush privileges;

redpajama_set_name: RedPajamaStackExchange


This is a guest post from Mercedes Tune of the California Partnership to End Domestic Violence.
I envision a world where everyone is respected, accepted, and celebrated... the bridge between my aspiration and the reality seems very dark today.
And today, I want to offer a glimpse into my personal journey and the opportunities I've had to examine my own privilege and oppression. This has come as a result of serendipity, which for me has been the point where my personal and organizational values have coalesced.
I have been living in the U.S. for the past eighteen years, but I grew up with a different rhythm and flavor in the Yucatan Peninsula, Mexico. My development was influenced by the Mayan culture, the tropics, and the social movements happening at the time in my region.
For years I worked supporting refugees that came to Mexico fleeing from the civil war in Guatemala, believing I was working towards healing the community. However, I was like the proverbial "fish in water;" I did not examine my own privilege. When I first moved to the U.S. nearly two decades ago, I was suddenly placed on the opposite side of an imaginary spectrum with effects that were very real and tangible.
I became anonymous, and I was seen through the lens of a larger group of people, which came with not particularly flattering labels attached. Just like that, my individuality was gone. My identity felt buried under those labels.
Slowly, I have reinvented myself over the years and I have discovered and examined my identities and my own bias, which has spanned the spectrum of oppression and privilege. Oppressed, on account of attributes that are not considered the "norm," and privileged on account of others.
This journey has led me to what I do best these days: to impact the world around me, which is systemically informed and supported by a culture based on white supremacy.
It is exhausting to live in a world that functions to sustain systemic oppression and keep privilege in its place. No one is immune to the ideas and beliefs that permeate our culture.
The Cultural Responsiveness Organizational Self-assessment is a unique online program designed and validated for the social services field that takes organizations through a journey of self-reflection, interpersonal exploration, and systemic analysis with a framework that takes into account that cultural/culture is not neutral and that different cultural groups are ascribed differential status and power.
We are grateful for Jara Dean-Coffey and Jill Casey of Luminare Group for their vision and expertise in the development of the tool as well as for the support of Blue Shield of California Foundation and many other individuals and organizations that participated along the way.
Many organizations have used the CROS tool and they have shared their stories of transformation. A constant encouragement from them is for everyone to consider the importance of exploring implicit bias within themselves and continue learning to serve the underserved. It is an ongoing collective journey that at times seems darker than ever as we unlearn and dismantle the old world.
Darkness predicts dawn as we build up new knowledge with a brave spirit and daring mind. Onward.
You can learn more about the tool and the inspiring journey of organizations that have used it here.


text:
You are here: Home / Sports / Mass. ADs to honor Sue Moss: W-H alum takes the photos that keep memories
Mass. ADs to honor Sue Moss: W-H alum takes the photos that keep memories
January 26, 2017 By Nate Rollins, Express Sports Correspondent
Whitman-Hanson Express volunteer photographer Sue Moss is being honored.
From student to teacher to coach to memory maker, Sue Moss' role has transformed over the years at Whitman-Hanson, but her love for the Panthers has not. Now, she is being rewarded for her lifelong dedication to the school.
Moss has been selected by the Massachusetts Secondary School Athletic Directors Association as this year's District C Joao Rodrigues Distinguished Service Award recipient. She has appeared at thousands of Panthers athletic events with camera in hand, snapping countless photos, where they soon appear on her Flickr, which fittingly features the panther statue as her profile picture, before they are used on the Whitman-Hanson athletic site and the Whitman-Hanson Express. Moss, who also takes pictures for the yearbook, said she's the type of person who likes to fly under the radar.
"I just want to make things happen," Moss said. "I'm very flattered and I'm very honored."
The award will be presented to Moss March 30 by the MSSADA at their annual awards dinner held at the Resort and Conference Center in Hyannis.
The Joao Rodrigues Distinguished Service Award is assigned to one nonpaid individual chosen from 61 nominees put forth by the District C schools based on their continued involvement with high school activities at the local level.
Whitman-Hanson athletic director Bob Rodgers put Moss' name forward and she was selected as the Patriot League representative in June before being tabbed as the district winner.
"This award not only recognized people who devote their time and energy to their communities, but I feel the best candidates are the people who inspire others to want to give back," Rodgers said. "I think every student who has come in contact with Sue realizes how community service is something we should all aspire to make part of our lives."
Moss' time in Whitman dates to her childhood as she worked her way through the public school system. She said it was in her backend years as a student at Whitman-Hanson when she began to ascertain the true power behind giving back to her town.
"My loyalty is always there," Moss said. "I believe in paying it forward. There were a lot of good people when I was in high school who did a lot of good things for us that they didn't have to. But back when I was a student, there wasn't anyone around capturing all the games so that you'd have a souvenir as you graduated from high school and went onto the rest of your life."
Moss jumped into teaching at Whitman-Hanson in 1971 and spent 35 years as a physical education and then technology educator.
While there, she played an integral role in the athletics of the school. Moss helped to create the first girls' cross country team and first girls' outdoor track team in the early '70s.
"Back in those days, Kevin Black and I used to take slides," Moss said. "When we put a banquet on at the end of the season, we'd have those pictures to share with the parents and everybody else. I had a habit at the end of the year, after the banquet, I would pull out all the senior slides and I would give them to them."
None of Moss' images have ever been for purchase and that's something on which she prides herself.
"All my images are up there in cyberspace, as the saying goes," Moss said. "They can go get them anytime they want. The parents can go find the ones that they want so it's good and they don't have to pay for them. You shouldn't have to pay for all that stuff. None are mine are for sale, even for the visiting team that might get an occasional shot. I just tell them where to find them and they can download them for free."
Moss, who retired in '06, said she has always and will continue to strive for the perfect image that can last a lifetime.
"I keep looking for that 'wow' photo," Moss said. "Every once in a while, you get one, not every year, but you get one. It's the joy that the kids take seeing themselves captured, whether I shoot a funny one or I shoot one where they don't know that I'm shooting, which I try to do a lot. Those are the ones that they'll remember for the rest of their lives."
Filed Under: News, Sports Tagged With: 2016-17 Coverage, Bob Rodgers, District C Joao Rodrigues Distinguished Service Award, Feature/Profile, Sports, Sue Moss, Whitman-Hanson Regional High, Whitman-Hanson Regional High Cross Country

redpajama_set_name: RedPajamaCommonCrawl


text:
Evil Sequence
Daniyal Zahid finds another sequel that did not cut it
by Daniyal Zahid
in Features, Film
Sequels can be hard to nail. That much we've learnt from ages of failures of varying scale, even by the biggest Hollywood banners, a prominent example of which was reviewed last week in the shape of It: Chapter II.
Seemingly, the art of retaining what the audiences liked about the prequel while offering something sufficiently new to sustainably pique their interest is one that remains hard to master. Maleficent is its latest prey.
Five years after the film based on the antagonist of Disney classic Sleeping Beauty was released to worldwide success, its sequel Maleficent: Mistress of Evil didn't quite manage to attract interest even on its opening weekend.
The $36 million opening on the weekend of the 18th of October generated little over a sixth of the basic production cost of the film. Soon after, the film began to muster almost universal mixed reviews across the board.
Perhaps the biggest drawback for the viewers of the film was the sheer lack of evil in a film billed on, and entitled with, it. Turns out, the only evil in Maleficent: Mistress of Evil is the abovementioned adversary that the follow-up to a successful movie is.
A large chunk of Maleficent's success owed itself to the fact that unlike many frame-to-frame remakes of old classics – animated or otherwise – the film depicted the storyline from a contrasting viewpoint, in turn adding to the universe that the original had created. However, in Mistress of Evil that very tangent that Maleficient had taken seems to diverge from the core of the plot to such an extent that it is hard to relate it to Sleeping Beauty itself.
In fact, the film's making conveys from the onset that it is going to explore the dimensions of Maleficient that aren't bound to the storyline in which the character was created. That could've sold well with the audience that became familiar with Sleeping Beauty through Maleficent – and not the other way around – but it still required a much better storyline to keep the viewers engaged.
Princess Aurora (Elle Fanning) is the reigning Queen of The Moors and is engaged to Prince Phillip (Harris Dickinson). Aurora hopes that she'd be able to unite the fairy and human kingdoms with her marriage to Prince Phillip.
That plan hits a stumbling block in the shape of Maleficent (Angelina Jolie) clashing with Phillip's mother Queen Ingrith (Michelle Pfeiffer). What follows is personality clashes evolving into an inter-species war between kingdoms that are simultaneously being pushed away and pulled together.
Without revealing too much of the plot, one can safely say that the storyline itself is hardly the greatest selling point of Mistress of Evil. Clearly, the film's highlights belong to the visual department, with costumes, makeup and overall cinematography being absolutely top-drawer.
Another self-evident strength of the film is the acting prowess. Jolie aces as expected, and is backed with formidable performances from Fanning and Pfeiffer as well.
However, again, where the film is likely to alienate the audience is the screenplay and script which is too densely woven with themes that one wouldn't necessarily affiliate with the franchise – most definitely not with Sleeping Beauty.
In that sense, again, Mistress of Evil is likely to enjoy following among the fans of Maleficent more so than the fans of Sleeping Beauty. Therefore, how one finds Mistress of Evil is likely to be determined by how one approaches the franchise to begin with.
For the oldies, or suckers for nostalgia, perhaps Maleficent should've been the end of the foray into the character. For others, Sleeping Beauty might be known as the predated offshoot of Maleficent – and not the other way around.
Masood Sharif Khan Khattak, Former Chief Of Intelligence Bureau, Dies At 72
Field Notes From The Floods In Sindh: A Mumbai-Born Volunteer Doctor's Perspective
Tags: Film
Vicious circle
Picturesque Punial
Daniyal Zahid


Scent: Basil and bergamot with a touch of fire.
Purposes: Draws the energy of wealth, wards off poverty and attracts customers.
Directions: Dab on your wallet, purse, cash register or lottery tickets. Wear on your hands when gambling. Be thankful for the results!
Click the button below to add the Anointing Oil - Prosperity to your wish list.


The Ramaz Parents of Alumni Circle is an annual program designed to build upon your relationship with Ramaz by answering the call of support with HINENI. Thank you for being here - HINENI - and making a gift to the Ramaz Annual Campaign.
Your gift demonstrates what it means to answer the call, and enables our school to provide our students with a high-quality Jewish education, like your children had, and exemplifies what it means to answer the call.
As a member of the Parents of Alumni Circle, you will receive The Ram Connection newsletter, filled with updates and photos of current student programming and Alumni events, as well as learn about opportunities for future involvement.


That Council move in camera to discuss the Integrity Commissioner Appointment in accordance with the provisions of Section 17 (disclosure harmful to personal privacy) and Section 24 (advice from officials) of the Freedom of Information and Protection of Privacy Act.
That the Confidential Administrative Report and details of the in-camera discussion remain confidential pursuant to Section 153(e) of the Municipal Government Act.
Council approved a recommendation that up to $15,000 from the Stabilization Reserve fund be used to support the public participation activity necessary to gain public input into Council's decision-making as it relates to potential future amendments to the Smoking Bylaw.
That Bylaw 44/2018, being amendment 165 to Land Use Bylaw 9/2005, be read a first time.
That the Public Hearing on Bylaw 44/2018 be scheduled for December 3, 2018.
Council supported a motion that Council direct Administration to complete background technical studies for the proposed Area Structure Plan area that encompasses both the City owned portion of the Lakeview Business District and the Badger Lands, with $110,000 funded from Capital Funding reserves.
Council supported a motion that Administration initiate the closure of Coalmine Road at Eastgate Way N and have this completed by January 31, 2019, subject to Council passing the required road closure bylaw.
Council went in camera to have confidential discussions about Ray Gibbon Drive, Collective Bargaining and Dialogue with the City Manager.


text:
Q: Combining quantile regression with binning I'm trying to employ a framework where I uncover the marginal effects of the quantiles of one continuous variable on another continuous variable - something analogous to the Quantile-on-quantile (QQR) approach used in Sims and Zhou (2015) and others. Unfortunately, I fear my coding skills are insufficient to code up this approach myself, and packages to implement the QQR approach don't seem to exist yet on many of the major statistical programs.
Instead, to overcome this limitation, I'm thinking of an alternative technique where I:

*

*Take "bins" of my independent variable around certain quantiles of that variable.

*Create interaction terms which take the value = X(i) if X(i) is within the corresponding bin, and 0 otherwise.

*Regress the interaction terms on the dependent variable in standard quantile regressions.

*Repeat steps 1-3 with alternative plausible bin specifications.

*Average over the results.

The intuition of what's seemingly achieved here seems to be fairly similar to the intuition of the original QQR approach, and I'm hopeful that steps 4-5 would remove some of the dependence of the results on binning assumptions.
Is the above technique likely to yield results that are useful, or should I give this up and start reading about splines?
Thanks in advance.
References:
Sim, N. and Zhou, H., 2015. Oil prices, US stock return, and the dependence between their quantiles. Journal of Banking & Finance, 55, pp.1-8.

A: Quantile regression estimates conditional quantiles. You would need to bin the conditional distribution, so you would need to solve a much harder problem first of finding the full conditional distribution. If you knew the conditional distribution, you wouldn't need to do any binning, but just calculate quantities directly. So no, this is not a good idea.

A: If your predictor is continuous and your interest is in modeling quantiles of the outcome variable, then you should be able to do quantile regression with appropriately flexible modeling of the continuous predictor. The paper you cite (based on a quick look) evidently uses local linear regression, like loess modeling. Regression splines for predictors are useful approaches, as are generalized additive models.
In R, for example, the rq() function of the quantreg package, with restricted cubic spline modeling of the predictor via the standard ns() function  or the rcs() function of the rms package, could do what you need. Thereafter, you can get outcome quantile estimates based on any desired quantile or binning of your predictor.
The point is not to throw away continuous information, particularly early in the modeling process. See this page for extensive discussion.


In addition to our traditional cremation packages, Daniel F. O'Riley Funeral Home is pleased to offer a new option for cremation services through Simple Cremation Online. This affordable option includes cremation services only. This might be a good option for those wishing to have a memorial service in the distant future or out-of-state, or for those who have requested no formal service at all.
Arrangements must be made online only – there is no in-house consultation available. Payment in full at the time of online arrangement is required to take advantage of this package. Visit Simple Cremation Online for more information and to fully arrange for cremation.
If you prefer a traditional cremation option with a funeral ceremony, visitation or other services from Daniel F. O'Riley, please contact us to plan a funeral service or learn more on our Funeral Services page.


text:
Home » Music & Entertainment » Music » An Imperfect Day: Lou Reed
An Imperfect Day: Lou Reed
Music, Music & Entertainment
As one of music most iconic artists dies at the age of 71, Sophie Seddon reflects back on the life of the man and the legend.
Lou Reed, lead singer of the Velvet Underground and a talented solo artist in his own right, has died at the age of 71. The cause of his death was confirmed on Sunday by his literary and UK agent was due to problems following liver failure after he had a transplant earlier this year.
The music world flocked to social media to express their sadness over his death, including David Bowie, Iggy Pop, Ricky Gervais, Stephen Fry and others, even more unusual Miley Cyrus. Writer Neil Gaiman's gave a touching and thoughtful memoir, which he has written for the Guardian, reflecting back upon a man who was blunt, often dismissive and quite rude… except that this was Lou Reed the persona, not Lou Reed the man.
The Velvet Underground, which Reed formed with friend John Cale, surprisingly did not actually achieve much commercial success during their time. The band's harsh rhythms of the guitars, blended with the smooth, husky, dry vocals, produce a devastating effect. It creates an atmosphere of lament, suffering, longing. 'Heroin' for example, designed to be anti-drugs in meaning, is mistaken for being pro, something Reed couldn't quite get his head around. Alongside the drug-induced music of the Beatles, The Velvet Underground was dark and a bit versatile in comparison. However, Reed could write stunning ballads, such as 'Pale Blue Eyes'. It is beautiful, gentle, full of want and desire, yet total perseverance. For those of you who have seen 'Adventureland', you'll know that it is used when Jesse Eisenberg is admiring a pre-Twilight Kirsten Stewart in the car, gazing at her longingly, thinking only 'what if'.
After being a part of Andy Warhol's Factory scene during the 60s, his own solo career kicked off in the 70s, which developed the successful 'Transformer' and 'Berlin', which were alongside Bowie and Iggy Pop. 'Satellite of Love', obscure and yet a real treat for the ears, and mirrors this era beautifully.
After being severely ill earlier this year, Reed appeared to make a rapid recovery, looking forward to performing again, and finding time to criticize the modern music industry, as well as continuing his controversial impatience towards the press, something Gaiman mentions his admiration for him for. His true Rock n' Roll spirit and suave attitude, it is what made Reed an icon, not just an artist.
That's exactly why Lou Reed's music will be with us past his death, and why he will be greatly missed. His songs were stories, he the narrator. Distant, and yet ever-present, he was the omnipresent figure overlooking these songs and bringing them a life, but without getting too close: The man who to the public looked rude and cocky, a drug and alcohol abuser, a man who hated the press, and quite a persona to his audience as not to the let them in. Yet behind the scenes, through his music and talent, demonstrated a thoughtful, smart, interesting and opinionated man who gave the people something that is lost to us in most of our modern music: true artistry.
His music is incredible, because it is so close to the core of what makes human beings tick. It fuels itself on powerful emotions and experiences; loss, longing and addictions, sadness, happiness. The masterful way in which he balances the human emotion in his songs reflects that which we experience every day. I for one will use his music to make me realise that not everyday is a good one, but it doesn't mean that I'll never be happy. 'Perfect Day' and 'Pale Blue Eyes' make me cry everytime I hear them, because I associate them with a memory that I love, and despair over, at the same time. One that makes me realise how stupid we as people can be, but that it doesn't mean we should regret it. Something Lou Reed probably knew plenty about. He'd probably read this and tell me to stop moaning and go bungee jumping, or prove myself to the world (hey, I very well may do). He will always be, in my mind, a man of two halves. I hope that never changes.
Lou Reed: March 2nd 1942- October 27th 2013.
Top tracks to remember him by:
Pale Blue Eyes
Satellite of Love
Interview with "The Cribs"
Dirty Rotten Scoundrels Review
Blackpool's sweetheart: Rae Morris plays Bristol