I've received three cold emails about this project. I haven't signed up for anything and I do not appreciate being spammed. All the emails have been reported as spam and will be reported as abuse to the mail servers.

https://github.com/leo-yuriev/libfpta

@topilski, please assign this issue to me.
regards.

are there any beginner tutorials out there on how to use fastonosql? I am trying to open a lmdb file (data.mdb+lock.mdb) which is password-protected, in ubuntu.

when I try connecting, I get the below, how do I pass login parameters?
16:32:29.097: Fail open database: Permission denied

I tried running command INFO and got:
16:30:55.818: Invalid input argument for command: 'INFO', passed 0 arguments, must be in range 1 - 1.

Discussed in #9

installed latest version on ubuntu, and got the error:

QFactoryLoader::QFactoryLoader() checking directory path "/opt/fastonosql/lib/platforms" ...
QFactoryLoader::QFactoryLoader() looking at "/opt/fastonosql/lib/platforms/libqxcb.so"
Found metadata in lib /opt/fastonosql/lib/platforms/libqxcb.so, metadata=
{
    "IID": "org.qt-project.Qt.QPA.QPlatformIntegrationFactoryInterface.5.3",
    "MetaData": {
        "Keys": [
            "xcb"
        ]
    },
    "className": "QXcbIntegrationPlugin",
    "debug": false,
    "version": 329472
}


Got keys from plugin meta data ("xcb")
QFactoryLoader::QFactoryLoader() checking directory path "/opt/fastonosql/bin/platforms" ...
loaded library "/opt/fastonosql/lib/platforms/libqxcb.so"
QLibraryPrivate::loadPlugin failed on "/opt/fastonosql/lib/platforms/libqxcb.so" : "Cannot load library /opt/fastonosql/lib/platforms/libqxcb.so: (/usr/lib/x86_64-linux-gnu/libQt5DBus.so.5: version `Qt_5' not found (required by /opt/fastonosql/bin/../lib/libQt5XcbQpa.so.5))"
This application failed to start because it could not find or load the Qt platform plugin "xcb"
in "".

Available platform plugins are: xcb.

Reinstalling the application may fix this problem.
/usr/bin/fastonosql: line 14: 10492 Aborted                 (core dumped) "$SOURCE_DIR/FastoNoSQL"

thank you very much for this software. I like this software very much. I hope it will be better

As shown in the attachment below Android distro doesn't work!
http://www.fastonosql.com/download_p?platform=android&filename=fastonosql-1.5.0-armeabi-v7a.apk

BTW, Did you build Fastonsql for Android using QtWidget or QtQuick GUI?

As of recently, Mac OS prevents me from opening FastoNoSQL.app with the following message:

"FastoNoSQL" can't be opened because it is from an unidentified developer. Your security preferences allow installation of only apps from the Mac App Stroe and identified developers.

This happens on Mac OS X El Capitan (10.11.6) with fastonosql-1.8.0-x86_64.dmg. There is a work-around (https://support.apple.com/kb/PH25088?locale=en_US) but it would be great to be able to use the app without jumping through hoops.

add more support of appearance
eg, font-size, color, ...

Hi! I'm using FastoNoSQL 1.5.0 for x64 on Windows 10 Home version 1607 (build 14393.953).

Every time I start FastoNoSQL, it crashes silently, even before it creates a fastonosql.log file.

So there are two problems.

A) It crashes silently when it really should show a Windows Error Reporting dialog box. This is bug #28.
B) It crashes, even though it shouldn't crash at all. This is the current bug. Let me explain.

WinDbg reports:

FAILED_INSTRUCTION_ADDRESS:
FastoNoSQL!unqlite_util_random_num+5f8a4d
00000000`00e57bad c5fb1045b8 vmovsd xmm0,qword ptr [rbp-48h]

Well, VMOVSD is an AVX (Advanced Vector Extensions) instruction. I'm using a cheap entry-level CPU: a quad-core Intel Pentium N3540. It doesn't support AVX instructions.

What compiler command line was used to compile unqlite?

Thanks for reading!

The same issue as with fastoredis
fastogt/fastoredis#62

application crashes on Windows x64 when creating Sentinel Connection and pushing "Discovery" button.

Please ask for details that I can provide for you.

Regards, Taras.

Hi.

My log says ...

12:03:19.155: INFO function error: A BAD KEY WAS PROVIDED/CHARACTERS OUT OF RANGE
12:03:33.535: INFO function error: A BAD KEY WAS PROVIDED/CHARACTERS OUT OF RANGE

My command history is ...

[MEMCACHED] 12:03:19.155: STATS
[MEMCACHED] 12:03:33.534: STATS
[MEMCACHED] 12:03:45.094: SCAN 0 MATCH * COUNT 1000
[MEMCACHED] 12:03:45.106: TTL [DT:categoryController:tickets:670:9522][1]
[MEMCACHED] 12:03:45.108: TTL [DT:ticketsController:cats:264][1]
[MEMCACHED] 12:03:45.112: TTL [DT:ticketsController:cats:670][1]
[MEMCACHED] 12:04:20.984: SCAN 0 MATCH * COUNT 1000
[MEMCACHED] 12:04:20.997: TTL [DT:categoryController:tickets:670:9522][1]
[MEMCACHED] 12:04:21.001: TTL [DT:ticketsController:cats:264][1]
[MEMCACHED] 12:04:21.006: TTL [DT:ticketsController:cats:670][1]
[MEMCACHED] 12:10:16.805: SCAN 0 MATCH * COUNT 1000
[MEMCACHED] 12:10:16.828: TTL [DT:categoryController:tickets:670:9522][1]
[MEMCACHED] 12:10:16.828: TTL [DT:ticketsController:cats:264][1]
[MEMCACHED] 12:10:16.828: TTL [DT:ticketsController:cats:670][1]

I'm using DoctrineCache, so the format of [xxxx][n] is their's. I only supply the xxxx part.

The UI shows ...

What's missing is the expansion of the remainder of the keys.

It would be nice to be able to extend the key splitting with known key generators.

DoctrineCache's structure is %s[%s][%d], where the 3 parts are namespace (optional), key (user supplied and if multi part can have any sort of separation, and version (a number).

I'm guessing other systems generate keys in a different way. Maybe having a UI in Fastonosql that allows multiple splitters as well as ignore string sequences.

So, : and ][ are splitters, but [ and ] are ignored. Hmm. Obviously doing the split then ignore works for this pattern. May not work for all though.

Happy to help in any way I can on this.

You use the mdb_dbi_open() function to open a database inside an
environment. It is documented here:
http://www.lmdb.tech/doc/group__internal.html#gac08cad5b096925642ca359a6d6f0562a
To be a bit more clear, named databases are stored as keys in the un-named
database. To get a list of the named databases, just retrieve all the keys
in the un-named database, you can then open the named databases by using
the key value as the name parameter to the mdb_dbi_open function. Please
note that you must call mdb_env_set_maxdbs() before opening the
environment to be able to open sub-databases. In my use case I set the max
number to 1024.

System: Mac OS X 10.11.1
Version: FastoNoSQL 0.5.5
memcached 1.4.24 (installed via homebrew)

When trying to create/test connection to with parameters -h 127.0.0.1 -p 11211 -d \n I get the following error:

Connection state: Couldn't ping server: UKNOWN READ

I can talk to the server just fine using nc 127.0.0.1 11211.

After installing the linux version there seems to be no RocksDB entry in the connections list.

I am trying to connect to LevelDB with -f '/home/nico/.config/chromium/Default/Local\ Extension\ Settings/ncdlagniojmheiklojdcpdaeepochckl/000100.ldb' -d \n -ns :

I get: Fail connect to server: IO error: /home/nico/.config/chromium/Default/Local/ Extension/ Settings/ncdlagniojmheiklojdcpdaeepochckl//LOCK: No such file or directory!

Even though /home/nico/.config/chromium/Default/Local Extension Settings/ncdlagniojmheiklojdcpdaeepochckl/LOCK exists.
Am I doing something wrong?
Levelup (the Nodejs library) has no problem connecting to the same path.

-f '/home/nico/.config/chromium/Default/Local\ Extension\ Settings/ncdlagniojmheiklojdcpdaeepochckl' -d \n -ns : does not work either and says Fail connect to server: IO error: /home/nico/.config/chromium/Default/Local/ Extension/ Settings//LOCK: No such file or directory!

It can show the keys but when trying to load keys which is object data the logs says:
15:24:37.426: Get function error: NOT FOUND

related issue
Version : 1.5.1.0 Revision : fbde4f4

I can't save connection setting for memcached.
This is reproduce procedure.

1. add connection for memcached
2. modify host name and port
   localhost:11211 => foo.com:11212
3. push save button
4. push open button and connect to memcached(foo.com:11212)
5. close FastoNoSQL
   6 open FastoNoSQL again.
   7 file->open open connection
   setting is back to localhost:11211

Regards

That makes impossible to proceed with using your tool without building it:)

config get * fails: "ERR wrong number of arguments for 'GET' command" - probably tries to parse it as a GET command, not as CONFIG GET.

Using FastoNoSQL 1.8.0.0 from deb on Ubuntu 16.04

I am trying to build this, to not much avail.
What are the steps required to build this?

Currently, this is what I'm doing:

git clone ssh://[email protected]/fastogt/fastonosql
cd fastonosql
git submodule init
git submodule update
cd src/third-party/json-c
git submodule init
git submodule update
cd ~/fastonosql
cd build
cmake ..
make

I'm currently trying to build by adding an additional clone and submodule init step of fastogt/common in the src/ directory.

I have achieved to connect to my memcached server but there seems to be no contents. My PHP code uses a key-value pair from the memcached so this pair has to appear on the FastoNoSql interface, shouldn't it?

Hostname that this doesn't make any modifications.

Hi!Is there any reason why FastoNoSQL has very old LMDB version compiled in?About states: 0.9.70. I think this is 0.9.7 which was released about 4 years ago.https://github.com/LMDB/lmdb/releases/tag/LMDB_0.9.7Current version is 0.9.21 and FastoNoSQL has problems reading new databases.Even connection test fails. Shows message:Fail open database: MDB_INVALID. File is not an LMDB file.Also it's seems that FastoNoSQL supports opening by dir only.LMDB provides option to pass full path to MDB file, so in single dir there can be more databases.http://www.lmdb.tech/doc/group__mdb.htmlmdb_env_open()MDB_NOSUBDIR By default, LMDB creates its environment in a directory whose pathname is given in path, and creates its data and lock files under that directory.With this option, path is used as-is for the database main data file. The database lock file is the path with "-lock" appended.

https://github.com/leo-yuriev/libmdbx

@topilski, please assign this issue to me.
regards.

I tried to run a simple transaction on my Redis server:

MULTI
INCR a
EXEC

and the program crashed with Segmentation fault.
Using FastoNoSql 1.7.1.0 ( 64 BIT DEBIAN/UBUNTU 1.7.1 PACKAGE (.DEB) ) on Ubuntu 16.04.
I don't know where to find error logs.

On Ubuntu 2016.04 with 1.0.0.0

• CTRL-V does not work
• Right-click -> "Paste" does not work
• Middle-click does not work

On the opposite, pasting into the connection name or command line parameters field works perfectly.

Hi! I'm using FastoNoSQL 1.5.0 on Windows 10 Home version 1607 (build 14393.953).

Every time I start it, it crashes silently, even before it creates a fastonosql.log file.

Expected results

I was expecting to see this dialog box:

FastoNoSQL has stopped working.
Windows can check online for a solution to the problem.
[ -> Check online for a solution and close the program ]
[ -> Close the program ]

Actual results

Nothing. Windows Error Reporting doesn't show any dialog box, and Windows in fact gives no hint that FastoNoSQL crashed at all. The only thing that happens is that a new problem report appears under "FastoNoSQL" in the Problem Reports control panel.

More details

Sysinternals Process Monitor reports that something starts "C:\WINDOWS\system32\WerFault.exe", and that WerFault.exe does write a minidump to my AppData\Local folder. But still, no Windows Error Reporting dialog box appears.

Thanks for reading this!

Hi,

I tried to use this to open some leveldb files used by Chrome's indexedb. I get this error when I try to "connect" to the leveldb folder:

13:06:09.747: Fail connect to server: Invalid argument: idb_cmp1 does not match existing comparator : leveldb.BytewiseComparator!

Anyway to fix that?

everytime reopen soft ,conenctions info will be reset!

try" file->open " then open connecitons dialog ,you will find the every connection address will be reset locahost .

The search under the explorer tree seems to be not working (as intended).
I try to seach one ore more keys with a specific part of a name but the search/filter isn't even matching the simple rules like searching for "category" (see screenshot) would be filter any results. even starting with "kv:" will filter anything. The filter should be a regexp ('/category/') search or a like ("%category%") search on any keys in any open storage.

When I type the path of the database (any) I can only type 2 slashes in the path:

after the second / I'm not able to type any other character. I'm on MacOSX 10.10.5

FastoNoSQL 0.7.3.0
Revision:dac05fb

such as title

I'm trying to connect a Redis instance through ssh tunnel and Public/Private key.

The app quits unexpectedly in below situations:

• I fill all the data for creating a new connection then I click "Test".
  or
• I fill all the data, save the connection and then try to connect to the newly created connection.

So, basically, when it tries to connect.

Mac OS X 10.11.4 - MacBook Pro (Retina, 13-inch, Mid 2014)

Any plans to support MS Extensible Storage Engine / Extensible Storage Engine Reference

Hi, i like this tool much, but it could be improved in some ways.

In a default use case i connect to an existing instance, select a database and filter with the search the available keys.

For that i have currenty use the submenu "Recent connections" under file, it would be slightly easier if the recent connections would be a list direct (eg. 5-10 recent connections and the "clear recent connections" button under file (and maybe you sould call the "file" entry "connection" instead).

After i select a connection the connection currently has to be manual by right click on the entry with ("connect/disconnect). It would be better if the selected connection (opened via recent connections/connection manager) connected automatically - this could be an global option or an choice on the connection entry. An double-click on the entry should do be open the connection as well.

The next step is to load an available database. Currently you need to click "Load content of the database". It would be better if the content is loaded completely by default on an double-click on the entry. If it is an huge database you can use the current process with the "Load content of the database" dialog.

For the current format for "json" you seem to be using QJsonDocument::Compact but it would be more readable if you using QJsonDocument::Indented

see: http://doc.qt.io/qt-5/qjsondocument.html#JsonFormat-enum

On windows 10 64bit

I hide the share toolbar, but after I restart the program, the share toolbar is redisplayed.

Hi,

Is building from source not supported any more?
build_env.py asks for https://github.com/fastogt/common.git
which is not found

Hi,
I just found your interesting project and I'm playing around a bit. I'm trying to connect to locally-installed memcached instance on Windows.

When I create a new connection with -h localhost -p 11211 -d \n it tests ok but then, when I select Connect/disconnect I get:

Not connected to server, impossible to get discovery info!

The service runs ok:

telnet 127.0.0.1 11211
stats

STAT pid 1500
STAT uptime 10563
STAT time 1459244697
STAT version 1.4.5_4_gaa7839e
STAT pointer_size 32
STAT curr_connections 31
STAT total_connections 39
STAT connection_structures 33
STAT cmd_get 283
STAT cmd_set 29
STAT cmd_flush 0
STAT get_hits 256
STAT get_misses 27
STAT delete_misses 0
STAT delete_hits 0
STAT incr_misses 0
STAT incr_hits 0
STAT decr_misses 0
STAT decr_hits 0
STAT cas_misses 0
STAT cas_hits 0
STAT cas_badval 0
STAT auth_cmds 0
STAT auth_errors 0
STAT bytes_read 64803
STAT bytes_written 444631
STAT limit_maxbytes 67108864
STAT accepting_conns 1
STAT listen_disabled_num 0
STAT threads 4
STAT conn_yields 0
STAT bytes 51888
STAT curr_items 28
STAT total_items 29
STAT evictions 0
STAT reclaimed 0
END

what am I missing?

Thanks!

On Ubuntu 2016.04 with 1.0.0.0
Steps to reproduce:

1. Create a new Leveldb connection
2. Go to the command line parameters field
3. Enter -f /home/nico/.config/chromium/Default/Local\ Extension\ Settings/ncdlagniojmheiklojdcpdaeepochckl -d \n -ns :
4. Save and close
5. Reopen
6. The field's value has become -f /home/nico/.config/chromium/Default/Local -d \n -ns :

The path also gets corrupted when using " quotes instead of backslashes.

fastonosql.exe is running for ~1s and silently shuts down on my W10 Pro N 64bit machine.

Happens with both the installed and the portable version.

Could not find any output or logs, unfortunately.

This is the same bug as mentioned raygray's comment on bug#29; I'm opening a new issue since this is not really related to issue #29.

This is for version 1.8.1 on Windows 7 x64. My processor is a mobile Ivy Bridge one (you'll see why it matters).

So starting FastoNoSQL.exe gets me an Invalid Instruction exception (c000001d) at 00000000-00856533. Loaded modules are irrelevant since the exception occurs within FastoNoSQL.exe's code segment.

Re-running it within WinDbg*, I get:

[..]
ModLoad: 000007fe`ff080000 000007fe`ff0ae000   C:\Windows\system32\IMM32.DLL
ModLoad: 000007fe`fe9f0000 000007fe`feaf9000   C:\Windows\system32\MSCTF.dll
(2dd14.2b8f4): Illegal instruction - code c000001d (first chance)
(2dd14.2b8f4): Illegal instruction - code c000001d (!!! second chance !!!)
*** WARNING: Unable to verify timestamp for FastoNoSQL.exe
*** ERROR: Symbol file could not be found.  Defaulted to export symbols for FastoNoSQL.exe - 
FastoNoSQL+0x456533:
00000000`00856533 c4c261f7c7      shlx    eax,r15d,ebx

*I actually had to update my debugging tools for WinDbg to be able to disassemble that instruction

Looking that up, I find that SHLX is part of the BMI2 instructions introduced (for Intel) with the Haswell line (~june 2013), which means my T430 is just one generation short of running the code.

Anyway, if downgrading the compiler's target or implementing a shim for older CPUs is not possible/desirable, either a support statement on the download page mentioning the minimum CPU architecture required *or* a detection & warning routine within the application itself (e.g.
Detecting BMI2 support at runtime) would be appreciated; at least people will know it's not your application that is at fault.

For my part, I can still run the application under Intel's Software Development Emulator, although having a native build supporting an older architecture would be best.

How to support redis cluster?

I opened a LevelDB folder that contains data for sure.

PROBLEM: No data is shown:

I clicked on all buttons/options, nothing show any data.

pika nosql use redis protocol.

It appears that the server hosting http://fastonosql.com is down, or misconfigured. It's throwing a 500 server error.

Please consider hosting the release on GitHub as well, so if your server goes down, people can still download it.

Thanks!