"Your very own ccTiddly server" - continued - Help wanted

[Måns]

Hi ccTiddlyWizards

Inspired by a thread on this group
(http://groups.google.dk/group/ccTiddly/browse_thread/thread/
eb9cfe8e67de387a/6db0a95db13e1a68?
hl=da&lnk=gst&q=mowes#6db0a95db13e1a68)
started by mattyc -
I have installed
Mowes(http://www.chsoftware.net/en/useware/mowes/mowes.htm) on an
usbstick.

I wanted to test cctiddly. But I can't figure out how to set it up...
However I managed to setup several other variants of serverside wikis
and sites (MediaWiki,Elgg, Moodle and Zikula) - including TiddlyHome
by BidiX and TiddlySpeck by Simon and Daniel Baird (http://
groups.google.com/group/TiddlyWiki/browse_thread/thread/
b0e28aa6a318c7c1/d61c1d25cee6c4fc?hl=en&q=tiddlyspot#d61c1d25cee6c4fc)
MediaWiki, Moodle and Zikula were prepackaged from chsoftware - but in
TiddlyHome, Elgg and TiddlySpeck I have been able to run successfully
- maybe because they solely depend on store.php-files to work.

I coulden't make the mowes mixer package_creator work -
http://moweswiki.chsoftware.net/index.php/How_to_create_a_package_for_MoWeS_Portable_II
- so I have just copied the directories into the www-directory on the
usbstick - and changed the mowes.ini and packages.ini files to reflect
the new sites.
I also made a costumized TW to work as index.html in mowes' www-
directory with an iframe to the php-file. I even put iframes of all
installed sites + the admin php file from TiddlyHome into it .

I'd love to try out cctiddly in this environment too - and I'd like
some advice on how to set it up .

I found this information:
// Initial Database Setup

$tiddlyCfg['db']['type'] = "mysql"; //sql type
$tiddlyCfg['db']['host'] = "dbserver"; //sql host
$tiddlyCfg['db']['login'] = "dbuser"; //login name
$tiddlyCfg['db']['pass'] = "dbpasswort"; //login password
$tiddlyCfg['db']['name'] = "dbname"; //db name
$tiddlyCfg['db']['port'] = "3306"; // db port

In mediawiki i found this in the Localesettingsfile:

## For a detailed description of the following switches see
## http://meta.wikimedia.org/Enotif and http://meta.wikimedia.org/Eauthent
## There are many more options for fine tuning available see
## /includes/DefaultSettings.php
## UPO means: this is also a user preference option
$wgEnotifUserTalk = true; # UPO
$wgEnotifWatchlist = true; # UPO
$wgEmailAuthentication = true;

$wgDBtype = "mysql";
$wgDBserver = "localhost";
$wgDBname = "mediawiki";
$wgDBuser = "root";
$wgDBpassword = "";
$wgDBport = "5432";
$wgDBprefix = "";

# MySQL table options to use during installation or update
$wgDBTableOptions = "TYPE=InnoDB";

Should I just copy these options into cctiddlys config.php (except for
"mediawiki" ofcourse..) to make it work??

YS Måns Mårtensson

[Måns]

I've done this so far:
<?php

// Initial Database Setup

$tiddlyCfg['db']['type'] = "mysql";

//sql type

$tiddlyCfg['db']['host'] = "localhost"; //sql

host
$tiddlyCfg['db']['login'] = "root"; //login name

$tiddlyCfg['db']['pass'] = ""; //login password
$tiddlyCfg['db']['name'] = "cctiddly"; //db name

$tiddlyCfg['db']['port'] = "3306"; // db port

AND made a directory : \mysql\data\cctiddly

Now I need a table/workspace called cctiddly:
"Table 'cctiddly.workspace' doesn't exist"

Is it the sqldatabase, which hasn't been made yet - or do I have to
create the workspace myself?
If the latter - how do I do that?

YS Måns Mårtensson

On May 13, 6:39 pm, Måns <humam...@gmail.com> wrote:
> Hi ccTiddlyWizards
>
> Inspired by a thread on this group
> (http://groups.google.dk/group/ccTiddly/browse_thread/thread/
> eb9cfe8e67de387a/6db0a95db13e1a68?
> hl=da&lnk=gst&q=mowes#6db0a95db13e1a68)
> started by mattyc -
> I have installed
> Mowes(http://www.chsoftware.net/en/useware/mowes/mowes.htm) on an
> usbstick.
>
> I wanted to test cctiddly. But I can't figure out how to set it up...
> However I managed to setup several other variants of serverside wikis
> and sites (MediaWiki,Elgg, Moodle and Zikula) - including TiddlyHome
> by BidiX and TiddlySpeck by Simon and Daniel Baird (http://
> groups.google.com/group/TiddlyWiki/browse_thread/thread/
> b0e28aa6a318c7c1/d61c1d25cee6c4fc?hl=en&q=tiddlyspot#d61c1d25cee6c4fc)
> MediaWiki, Moodle and Zikula were prepackaged from chsoftware - but in
> TiddlyHome, Elgg and TiddlySpeck I have been able to run successfully
> - maybe because they solely depend on store.php-files to work.
>

> I coulden't make the mowes mixer package_creator work -http://moweswiki.chsoftware.net/index.php/How_to_create_a_package_for...

> - so I have just copied the directories into the www-directory on the
> usbstick - and changed the mowes.ini and packages.ini files to reflect
> the new sites.
> I also made a costumized TW to work as index.html in mowes' www-
> directory with an iframe to the php-file. I even put iframes of all
> installed sites + the admin php file from TiddlyHome into it .
>
> I'd love to try out cctiddly in this environment too - and I'd like
> some advice on how to set it up .
>
> I found this information:
> // Initial Database Setup
>
> $tiddlyCfg['db']['type'] = "mysql";             //sql type
> $tiddlyCfg['db']['host'] = "dbserver";         //sql host
> $tiddlyCfg['db']['login'] = "dbuser";             //login name
> $tiddlyCfg['db']['pass'] = "dbpasswort";          //login password
> $tiddlyCfg['db']['name'] = "dbname";             //db name
> $tiddlyCfg['db']['port'] = "3306"; // db port
>
> In mediawiki i found this in the Localesettingsfile:
>
> ## For a detailed description of the following switches see

> ##http://meta.wikimedia.org/Enotifandhttp://meta.wikimedia.org/Eauthent

[simon mcmanus]

2009/5/13 Måns <huma...@gmail.com>

I've done this so far:
<?php

// Initial Database Setup

$tiddlyCfg['db']['type'] = "mysql";

       //sql type

$tiddlyCfg['db']['host'] = "localhost";         //sql

host
$tiddlyCfg['db']['login'] = "root";             //login name

$tiddlyCfg['db']['pass'] = "";          //login password
$tiddlyCfg['db']['name'] = "cctiddly";          //db name

$tiddlyCfg['db']['port'] = "3306"; // db port

AND made a directory : \mysql\data\cctiddly

Now I need a table/workspace called cctiddly:
"Table 'cctiddly.workspace' doesn't exist"

Is it the sqldatabase, which hasn't been made yet - or do I have to
create the workspace myself?
If the latter - how do I do that?

Hi,

I think you just need to create the database and then run the install.sql file in the ccTiddly root directory.

If you have command line access it would look something like this :

mysql -u root

create database cctiddly;
use cctiddly;
 
Then just copy the content of install.sql

hope that helps.

Thanks

Simon

--
Simon McManus

blog : http://simonmcmanus.com

[Måns]

Hi Simon

Thanks for answering.
I don't have a "real" installation of sql - but I use sql from mowes
portable compilation.
In the sql directory I have four files:
1. libmySQL.dll
2. mysql.exe
3. mysqladmin.exe
4. mysqld-nt.exe

When I cd to mysqladmin.exe and write: 'create database cctiddly' I
get:
mysqladmin.exe: CREATE DATABASE failed; error access denied for user
''@'localhost' to database 'cctiddly;''

However, when I use mysql.exe and write: create database cctiddly; use
cctiddly;
It seems to do something and stops. It doesn't produce any folder in
the mysql datafolder (I've tried to delete the one I made maually
earlier - to make sure)

There was an install.sql in the cctiddly directory from the start. I
don't know what you mean by "Then just copy the content of
install.sql" ... Where am I supposed to copy what to where?
Should I run the install.sql file from cmd as well? -
I don't know what to expect - as I have never tried anything like this
before...

YS Måns Mårtensson


On 14 Maj, 16:42, simon mcmanus <mcmanus.si...@gmail.com> wrote:
> 2009/5/13 Måns <humam...@gmail.com>

[simon mcmanus]

2009/5/14 Måns <huma...@gmail.com>

Hi Simon

Thanks for answering.
I don't have a "real" installation of sql - but I use sql from mowes
portable compilation.
In the sql directory I have four files:
1. libmySQL.dll
2. mysql.exe
3. mysqladmin.exe
4. mysqld-nt.exe

When I cd to mysqladmin.exe and write: 'create database cctiddly' I
get:
mysqladmin.exe: CREATE DATABASE failed; error access denied for user
''@'localhost' to database 'cctiddly;''

However, when I use mysql.exe and write: create database cctiddly; use
cctiddly;
It seems to do something and stops. It doesn't produce any folder in
the mysql datafolder (I've tried to delete the one I made maually
earlier - to make sure)

Hi,
Im not familiar with the Mowes setup so its hard to give advice with regard to Mowes, it may be worth asking on their forums.

There was an install.sql in the cctiddly directory from the start. I
don't know what you mean by "Then just copy the content of
install.sql" ... Where am I supposed to copy what to where?

In a normal SQL environment when you have issued the "use database" command you should be able to paste the content of install.sql into the command line window.  Each of the sql commands in the install.sql file will be run in turn which will result in your tables being created.

Alternatively you can specify the name of the file in the command line.

 

Should I run the install.sql file from cmd as well? -

yes.
 

I don't know what to expect - as I have never tried anything like this
before...

Does the above help at all? I hope soo.

Thanks

Simon