Default sqlite password?

[Marisa Giancarla]

I am trying to make a status utility to display the logged in users in a html form but I don't know what the encryption password for the sqlite database is. Does anyone know it?

[Stephen Dennis]

If you mean netmux.pag/netmux.dir, then that isn't a SQLlite database, and it isn't encrypted. It's just an extendible hashing file scheme implemented in svdhash.cpp and svdhash.h with fixed-sized pages. It holds key/value pairs but does not hold everything in the database or any running state. A complete database is netmux.pag, netmux.dir, mail.db, netmux.db, and comsys.db. You can remove mail.db and comsys.db and still have a database, but netmux.db.*, netmux.pag, and netmux.dir go together.

To get a list of logged-in users, you would need to do something else. I'm not sure what, but something else.

On Thu, Oct 6, 2016 at 8:20 AM, Marisa Giancarla <pulpfict...@gmail.com> wrote:

I am trying to make a status utility to display the logged in users in a html form but I don't know what the encryption password for the sqlite database is. Does anyone know it?

--

---
You received this message because you are subscribed to the Google Groups "tinymux-dev" group.
To unsubscribe from this group and stop receiving emails from it, send an email to tinymux-dev+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Marisa Giancarla]

I have just a netmux.db file, and when i load it in my mac's sqlite manager it says it is a encrypted sqlite db... Or are there ways to convert my mux to mysql instead?

Marisa

----

-sized pages. It holds key/value pairs but does not hold everything in the database or any running state. A complete database is netmux.pag, netmux.dir, mail.db, netmux.db, and comsys.db. You can remove mail.db and comsys.db and still have a database, but netmux.db.*, netmux.pag, and netmux.dir go together.

To get a list of logged-in users, you would need to do something else. I'm not sure what, but something else.

On Thu, Oct 6, 2016 at 8:20 AM, Marisa Giancarla <pulpfict...@gmail.com> wrote:

I am trying to make a status utility to display the logged in users in a html form but I don't know what the encryption password for the sqlite database is. Does anyone know it?

--

---
You received this message because you are subscribed to the Google Groups "tinymux-dev" group.
To unsubscribe from this group and stop receiving emails from it, send an email to tinymux-dev+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

---
You received this message because you are subscribed to the Google Groups "tinymux-dev" group.

To unsubscribe from this group and stop receiving emails from it, send an email to tinymux-dev...@googlegroups.com.

[Stephen Dennis]

Hopefully, your netmux.db is what is called a 'flatfile', that is it contains all the key/value pairs. But, whether that is true or not, your SQLLite Manager is confused about the file. It assumes it is a SQLLite file because you are giving it to it, and because it can't make any sense of it, it assumes it is encrypted. But, there's no encryption. You can open the file in any text editor and see all the text.

[Marisa Giancarla]

Yes, i can see the data, you're right. Is there a way to switch to using mysql? That is what i would prefer anyway...

[Stephen Dennis]

Not so much. The game's database is its own thing in its own format. Some have looked at using some sort of off-the-shelf SQL database as a backing database, but the performance isn't enough to run a game. Perhaps, things have changed, but I suspect the database is still made for the game and visa-versa.

You can however, connect to a mysql database and interact with it. But, that is only a connection where softcode can send and receive with an external MySQL database. The game's database remains in its own format.

On Thu, Oct 6, 2016 at 10:08 AM, Marisa Giancarla <pulpfict...@gmail.com> wrote:

Yes, i can see the data, you're right. Is there a way to switch to using mysql?  That is what i would prefer anyway...

[Marisa Giancarla]

> To unsubscribe from this group and stop receiving emails from it, send an email to tinymux-dev...@googlegroups.com.

>
> For more options, visit https://groups.google.com/d/optout.

That might work. Do you have example code for connecting scode to a mysql db?

[Stephen Dennis]

Look at the SQL readme file in the distribution. It will talk about the sqlslave module, compiling the game with --enable-stubslave, and the MUXcode needed to interact with MySQL.

To unsubscribe from this group and stop receiving emails from it, send an email to tinymux-dev+unsubscribe@googlegroups.com.