SERP Hacker support forum - serposcope

Support forum for open-source softwares built by serphacker.com : serposcope the rank checker.

You are not logged in.

#1 2018-09-20 23:19:39

ZenImagine
Member
Registered: 2017-04-10
Posts: 9

Impossible de lancer SERPOSCOPE avec un BDD MySQL

[2018-09-20 22:51:24,216] [NinjaJetty] WARN  c.Ninja - initial database creation
[2018-09-20 22:51:25,415] [NinjaJetty] ERROR c.Ninja - fatal error
java.sql.SQLSyntaxErrorException: (conn:29) REFERENCES command denied to user 'serp_domaine_com'@'localhost' for table 'GROUP'
Query is : SET FOREIGN_KEY_CHECKS=0;
drop table if exists `CONFIG`;
create table `CONFIG` (
    name varchar(255) primary key,
    value text
) engine = innodb default charset=utf8 /*! collate utf8_bin */;

drop table if exists `USER`;
create table `USER` (
    id int primary key auto_increment,
    email varchar(255),
    password_hash tinyblob,
    password_salt tinyblob,
    admin boolean,
    logout datetime
) engine = innodb default charset=utf8 /*! collate utf8_bin */;

drop table if exists `GROUP`;
create table `GROUP` (
    id int primary key auto_increment,
    module_id int,
    name varchar(255)
) engine = innodb default charset=utf8 /*! collate utf8_bin */;

drop table if exists `EVENT`;
create table `EVENT` (
    group_id int,
    day date,
    title varchar(255),
    description text,
    primary key(group_id,day),
    foreign key (group_id) references `GROUP`(id)
) engine = innodb default charset=utf8 /*! collate utf8_bin */;


drop table if exists `USER_GROUP`;
create table `USER_GROUP` (
    user_id ...
    at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:139) ~[serposcope.jar:na]
    at org.mariadb.jdbc.internal.util.ExceptionMapper.getException(ExceptionMapper.java:101) ~[serposcope.jar:na]
    at org.mariadb.jdbc.internal.util.ExceptionMapper.throwAndLogException(ExceptionMapper.java:77) ~[serposcope.jar:na]
    at org.mariadb.jdbc.MariaDbStatement.executeQueryEpilog(MariaDbStatement.java:226) ~[serposcope.jar:na]
    at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:256) ~[serposcope.jar:na]
    at org.mariadb.jdbc.MariaDbStatement.executeUpdate(MariaDbStatement.java:418) ~[serposcope.jar:na]
    at com.zaxxer.hikari.pool.ProxyStatement.executeUpdate(ProxyStatement.java:117) ~[serposcope.jar:na]
    at com.zaxxer.hikari.pool.HikariProxyStatement.executeUpdate(HikariProxyStatement.java) ~[serposcope.jar:na]
    at com.serphacker.serposcope.db.base.MigrationDB.recreateDb(MigrationDB.java:72) ~[serposcope.jar:na]
    at com.serphacker.serposcope.db.base.MigrationDB.recreateDb(MigrationDB.java:57) ~[serposcope.jar:na]
    at conf.Ninja.onFrameworkStart(Ninja.java:81) ~[serposcope.jar:na]
    at ninja.Bootstrap.boot(Bootstrap.java:116) [serposcope.jar:na]
    at ninja.servlet.NinjaServletListener.createNinjaBootstrap(NinjaServletListener.java:131) [serposcope.jar:na]
    at ninja.servlet.NinjaServletListener.getInjector(NinjaServletListener.java:109) [serposcope.jar:na]
    at com.google.inject.servlet.GuiceServletContextListener.contextInitialized(GuiceServletContextListener.java:47) [serposcope.jar:na]
    at ninja.servlet.NinjaServletListener.contextInitialized(NinjaServletListener.java:61) [serposcope.jar:na]
    at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:800) [serposcope.jar:na]
    at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:444) [serposcope.jar:na]
    at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:791) [serposcope.jar:na]
    at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:294) [serposcope.jar:na]
    at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:741) [serposcope.jar:na]
    at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) [serposcope.jar:na]
    at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:132) [serposcope.jar:na]
    at org.eclipse.jetty.server.Server.start(Server.java:387) [serposcope.jar:na]
    at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:114) [serposcope.jar:na]
    at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:61) [serposcope.jar:na]
    at org.eclipse.jetty.server.Server.doStart(Server.java:354) [serposcope.jar:na]
    at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) [serposcope.jar:na]
    at ninja.standalone.NinjaJetty.doStart(NinjaJetty.java:161) [serposcope.jar:na]
    at ninja.standalone.AbstractStandalone.start(AbstractStandalone.java:197) [serposcope.jar:na]
    at ninja.standalone.AbstractStandalone.run(AbstractStandalone.java:94) [serposcope.jar:na]
    at serposcope.lifecycle.Daemon.start(Daemon.java:19) [serposcope.jar:na]
    at serposcope.lifecycle.Daemon.main(Daemon.java:15) [serposcope.jar:na]
Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: REFERENCES command denied to user 'serp_domaine_com'@'localhost' for table 'GROUP'
Query is : SET FOREIGN_KEY_CHECKS=0;
drop table if exists `CONFIG`;
create table `CONFIG` (
    name varchar(255) primary key,
    value text
) engine = innodb default charset=utf8 /*! collate utf8_bin */;

Offline

Board footer