Problème de maintenance après connexion à la BDD Postgres sur mon hébergeur
Bonjour, j'essaie actuellement de créer une application web.
En fait, je vous explique mon problème, j'ai un formulaire d'authentification banal, qui va checker dans la BDD si l'utilisateur existe et si le mot de passe concorde.
Le problème c'est que, dès que j'appuie sur connecter et que j'essaie de me connecter à la base de données, le serveur me renvoie
Citation:
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator,
webmaster@compagnonvoyage.4java.ca and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
Additionally, a 503 Service Temporarily Unavailable error was encountered while trying to use an ErrorDocument to handle the request.
Voici mon code me permettant de me connecter à la base de données :
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
| package dataaccess.jpa;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import org.postgresql.Driver;
public class JdbcConnection {
private static String host = "174.136.152.13:5432";
private static String base = "compagno_m1ps";
private static String user = "compagno_postgres";
private static String password = "xxxxxxxx";
private static String url = "jdbc:postgresql://" + host + "/" + base;
/* Declare private variables */
private static Connection con;
private static Driver PgsqlDriver;
public JdbcConnection() throws SQLException, ClassNotFoundException,
InstantiationException {
}
public synchronized static Connection getCon() throws SQLException,
ClassNotFoundException, IllegalAccessException,
InstantiationException {
if (con == null)
setCon();
return con;
}
public synchronized static void setCon() throws SQLException,
ClassNotFoundException, IllegalAccessException,
InstantiationException {
/* Set up JDBC */
if (con != null)
return;
PgsqlDriver = (Driver) Class.forName("org.postgresql.Driver")
.newInstance();
con = DriverManager.getConnection(url, user, password);
/* Done connecting to DB */;
}
public synchronized void setCon(Connection connect) throws SQLException,
ClassNotFoundException, IllegalAccessException,
InstantiationException {
con = connect;
}
/**
* @return statement
* @throws InstantiationException
* @throws IllegalAccessException
* @throws ClassNotFoundException
*/
public static Statement getStatement() throws ClassNotFoundException,
IllegalAccessException, InstantiationException {
try {
return JdbcConnection.getCon().createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY,
ResultSet.HOLD_CURSORS_OVER_COMMIT);
} catch (SQLException e) {
System.err.println(e.getMessage());
System.exit(-1);
}
return null;
}
} |
Dans les logs, je peux retrouver une ligne qui me dit :
Citation:
FATAL: no pg_hba.conf entry for host "174.136.152.13", user "compagno_postgres", database "compagno_m1ps", SSL off
Auriez-vous une idée de ce qui se trame là-dessous ?
Merci d'avance en tout cas ! :)
