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 2016-10-16 04:33:16

rex88
Member
Registered: 2016-09-23
Posts: 9

Connecting to MySQL using .deb on Debian?

Hi,

I can get Serposcope to work fine using default H2 database, however for the life of me can not connect to MySQL.

I have installed mysql-server added a user 'serposcope' and created a database 'serposcope'. Granted user privileges.

In /etc/default/serposcope

I have commeted out old DATADIR and replaced with:

DATADIR=jdbc:mysql://localhost/serposcope?user=serposcope&pass=serposcope&allowMultiQueries=true

then

service serposcope restart

Restarts fine, however not table have been created in data base.

Any ideas.

Using .deb install

Thanks

Offline

#2 2016-10-16 12:02:06

rex88
Member
Registered: 2016-09-23
Posts: 9

Re: Connecting to MySQL using .deb on Debian?

Ok so I figured out that I had to make my changes in /etc/serposcop.conf

e.g.

serposcope.datadir=jdbc:mysql://localhost/serposcope?user=serposcope&password=serposcope&allowMultiQueries=true

and leave /etc/default/serposcope as

DATADIR=/var/lib/serposcope

However, I can not find any new data put into MySQL. It appears to be working using MySQL though just nothing in the db.

Offline

#3 2016-10-20 09:42:15

Davide
Member
From: CH
Registered: 2016-03-24
Posts: 80
Website

Re: Connecting to MySQL using .deb on Debian?

you should run serposcope with advanced option:

https://serposcope.serphacker.com/en/doc/install.html

example of this link works fine for me:

java -Dserposcope.conf=/path/to/serposcope.conf -jar serposcope.jar

easy-develope.ch ¦ kontakt@easy-develope.ch

Offline

#4 2016-10-28 12:05:56

takraw
Member
Registered: 2016-02-04
Posts: 6

Re: Connecting to MySQL using .deb on Debian?

Davide wrote:

you should run serposcope with advanced option:

https://serposcope.serphacker.com/en/doc/install.html

example of this link works fine for me:

java -Dserposcope.conf=/path/to/serposcope.conf -jar serposcope.jar

can we create empty serposcope.conf and run the jar file? i can seems to find the conf file anywhere

Offline

#5 2016-10-28 14:57:45

serphacker
Administrator
Registered: 2014-06-13
Posts: 411

Re: Connecting to MySQL using .deb on Debian?

Offline

Board footer