SERP Hacker support forum - serposcope

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

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.

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

takraw

Member

Registered: 2016-02-04

Posts: 6

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

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

serphacker

Administrator

Registered: 2014-06-13

Posts: 411

Re: Connecting to MySQL using .deb on Debian?

https://serposcope.serphacker.com/en/doc/install.html "advanced configuration"