Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > linux.debian.user > #227143 > unrolled thread

Linphone contacts.

Back to article view | Back to linux.debian.user

Contents

  Linphone contacts. peter@easthope.ca - 2020-09-20 04:20 +0200
    Re: Linphone contacts. Reco <recoverym4n@enotuniq.net> - 2020-09-20 10:00 +0200
      Re: Linphone contacts. peter@easthope.ca - 2020-09-20 18:30 +0200
    Re: Linphone contacts. Cousin Stanley <cousinstanley@gmail.com> - 2020-09-21 16:00 +0200
      Re: Linphone contacts. Greg Wooledge <wooledg@eeg.ccf.org> - 2020-09-21 16:30 +0200

#227143 — Linphone contacts.

Hi,

In Debian 10, linphone contacts are likely stored in 
~/.linphone-friends.db. Documentation that I've found doesn't explain.

Can some other application extract the contacts as plain text? SQlite?  
What packages are required?

Thanks,              ... Peter E.



-- 
https://en.wikibooks.org/wiki/Medical_Machines
https://en.wikibooks.org/wiki/Oberon
Tel: +1 604 670 0140            Bcc: peter at easthope. ca

[toc] | [next] | [standalone]

#227154

	Hi.

On Sat, Sep 19, 2020 at 06:01:58PM -0700, peter@easthope.ca wrote:
> Hi,
> 
> In Debian 10, linphone contacts are likely stored in 
> ~/.linphone-friends.db. Documentation that I've found doesn't explain.

A quick look at linphone's source reveals that it should be sqlite,
version 3. BTW there's file(1) that could tell you the same:

file -sL ~/.linphone-friends.db


> Can some other application extract the contacts as plain text?

An "application"? Do not know and do not care.
A "program"?
Install sqlite3, point it to your .linphone-friends.db, execute:

select * from friends;

Reco

[toc] | [prev] | [next] | [standalone]

#227174

From: Reco <recoverym4n@...uniq.net>
Date: Sun, 20 Sep 2020 10:49:52 +0300
> A quick look at linphone's source reveals that it should be sqlite,
> version 3. BTW there's file(1) that could tell you the same:
> 
> file -sL ~/.linphone-friends.db

OK, thanks.

> Install sqlite3, point it to your .linphone-friends.db, execute:
> 
> select * from friends;

Thanks for that also.  

For others who might be interested, a few observations.

https://sqlite.org/cli.html is more complete than the manual.  =8~)

"man sqlite3" and the Web page list meta-commands, also referred to as 
dot-commands. Statements are mentioned but not listed.  

>From the manual,
.schema ?PATTERN?  Show the CREATE statements matching PATTERN

.schema seems to list statements.  ".schema main.*" gives some 
unformatted output. I don't get the question marks.  Delimiters?  
Regular expressionese?

Found all I need from linphone contacts.  Thanks,             ... P.
                       



-- 
https://en.wikibooks.org/wiki/Medical_Machines
https://en.wikibooks.org/wiki/Oberon
Tel: +1 604 670 0140            Bcc: peter at easthope. ca

[toc] | [prev] | [next] | [standalone]

#227207

peter@easthope.ca wrote:

> In Debian 10, linphone contacts are likely
> stored in  ~/.linphone-friends.db. 
> 
> Documentation that I've found doesn't explain.
> 
> Can some other application extract the contacts as plain text? 
> 
> SQlite?

  I don't have  linphone installed
  but  sqlite  is listed among 
  its dependencies .... 

    $ apt-cache depends linphone | grep sql
      Depends: libsqlite3-0 

 
-- 
Stanley C. Kitching
Human Being
Phoenix, Arizona

[toc] | [prev] | [next] | [standalone]

#227208

> peter@easthope.ca wrote:
> 
> > In Debian 10, linphone contacts are likely
> > stored in  ~/.linphone-friends.db. 
> > 
> > Documentation that I've found doesn't explain.
> > 
> > Can some other application extract the contacts as plain text? 
> > 
> > SQlite?

Start by using file(1) to see what kind of data might be in the file.

For example:

unicorn:~/.mozilla/firefox/0uik3i3z.default$ file cert8.db 
cert8.db: Berkeley DB 1.85 (Hash, version 2, native byte-order)

unicorn:~/.mozilla/firefox/0uik3i3z.default$ file permissions.sqlite 
permissions.sqlite: SQLite 3.x database, user version 10, last written using SQLite version 3028000

If file(1) claims that it's an SQLite database, then you can use the
sqlite3 package to probe it from a shell, or use your favorite programming
language's sqlite3 bindings to open it up.

unicorn:~/.mozilla/firefox/0uik3i3z.default$ sqlite3 permissions.sqlite .schema
Error: database is locked
unicorn:~/.mozilla/firefox/0uik3i3z.default$ cp permissions.sqlite ~/x
unicorn:~/.mozilla/firefox/0uik3i3z.default$ sqlite3 ~/x .schema
CREATE TABLE moz_hosts ( id INTEGER PRIMARY KEY,host TEXT,type TEXT,permission INTEGER,expireType INTEGER,expireTime INTEGER,appId INTEGER,isInBrowserElement INTEGER, modificationTime INTEGER);
CREATE TABLE IF NOT EXISTS "moz_perms" ( id INTEGER PRIMARY KEY,origin TEXT,type TEXT,permission INTEGER,expireType INTEGER,expireTime INTEGER,modificationTime INTEGER);

And so on.  If file(1) claims that it's someting else, like a Berkeley DB,
then you'd need to use different tools.

[toc] | [prev] | [standalone]

Back to top | Article view | linux.debian.user

csiph-web