Author Archives: TimL

How to reset PostgreSQL password on Windows:

0) Kill java from the task manager
1) Update your

%PROGRAMFILES%\PostgreSQL\9.0\data\pg_hba.conf

to "trust" for local connections.
2) Restart the PostgreSQL service
3) Connect as user postgres with PGAdmin
4) Set your password:

ALTER USER postgres WITH PASSWORD 'Pgsq1p@ssword';

5) Undo your changes to pg_hba.conf
6) Restart the PostgreSQL service
7) Restart the Noodle service

You need custom scripts enabled.

var doc=top.noodle.headWindow().document;
var el=doc.getElementById("status");
el.style.display="none";
el=doc.getElementById("currentUserId");
el.style.display="none";
el=doc.getElementById("currentUser");
el.style.margin="20px";
el=doc.getElementById("currentUserName").parentNode;
el.style.display="block";

--Restore from file or on attach

---------------------------------------------------------
DECLARE tabcurs CURSOR
FOR
    SELECT 'intranet.' + [name]
      FROM sysobjects
     WHERE xtype = 'u'

OPEN tabcurs
DECLARE @tname NVARCHAR(517)
FETCH NEXT FROM tabcurs INTO @tname

WHILE @@fetch_status = 0
BEGIN

    EXEC sp_changeobjectowner @tname, 'intranet2'

    FETCH NEXT FROM tabcurs INTO @tname
END
CLOSE tabcurs
DEALLOCATE tabcurs
---------------------------------------------------------
--?--EXEC sp_changeobjectowner 'intranet.AllocObjectId', 'intranet2';
---------------------------------------------------------

Edit server.xml and add the following to the Engine tag;

<Valve className="org.apache.catalina.valves.AccessLogValve" directory="${catalina.base}/logs" prefix="access." fileDateFormat="yyyy-MM-dd" suffix=".log" pattern="%{YYYY-MM-dd HH:mm:ss}t,%a,%v,%r,%s,%p,%{user}r,%X,%{c}L" />

Restart Noodle.

Further options here.

You need custom scripts enabled.

var doc=top.noodle.headWindow().document;
var newNode =doc.getElementById("logo");
doc.body.insertBefore(newNode, doc.body.firstChild);
top.document.getElementById("body").rows="110,0,*";
newNode.style.position="inherit";
newNode.style.height="55px";
newNode.style.width="100%";

or you can use an image hosted elsewhere:

var doc=top.noodle.headWindow().document;
doc.getElementById("logo").style.display="none";
var newNode = doc.createElement('img');
newNode.src="https://vialect.com/wp-content/themes/quadro/images/logo.png";
newNode.style.height="55px";
newNode.style.width="100%";
doc.body.insertBefore(newNode, doc.body.firstChild);
top.document.getElementById("body").rows="110,0,*";

function email(){
	var email=document.getElementsByName("val19238147")[0].value;
	top.location.href="mailto:"+email+"?subject=subject&body=body";
	document.mainform.submit();
}

function changeButton(name){
	var el=document.getElementById(name);
	if(el){
		el.type="button";
		top.noodle.cbc.addEventListener(el,"click",email);
	}
}

function doit(){
	changeButton("add");
	changeButton("addAnother");
	changeButton("update");
	top.noodle.core.logout_on_200=false;
}
setTimeout("doit();", 2000);

Moving Noodle from one environment to another can be done in a few ways:

  • Copy the files (linux only).
  • Install Noodle on the new box and reconfigure or copy the conf files over.

Migrating your RDBMS data from one environment to another can be done in a few ways:

Various applications have there own Import/Export tools that use stranded formats.

The Noodle Import Export archives nearly all of the data to a zip file for backup or migration purposes.

Only the last edit per user for item history is exported

Export:

0) Prepare:

Backup, vacuum, and lo_manage your database.
Upgrade Noodle, and empty the Noodle trash bin.
Backup your Noodle install directory.
Make sure you have disk space.
obtain a new license key if the IP will differ

1) Export:

login as the admin.
System Tools>Settings>import>Site>Download.

2) Verify:

Check the log file for warnings/errors if it worked you will see "Completed SiteExport"

Import:

0) Prepare:

Make a new installation/site with the same version of Noodle as the export with no sample content.
Input an appropriate license key(make sure the IP and number of users match).

1) Import:

login as the admin
System Tools>Settings>import>Site>Replace

2) Optional:

you may want to disable the smtp server and revert the siteName before the import completes.(people will get subscription emails otherwise) (or do it on the old site)
rename the sites If you want the domain name on the new server...don't try to have 2 sites using the same domain

3) Check the log file for warnings/errors if it worked you will see "Completed SiteImport"

Use a case sensitive file system (connected to Windows, Mac, Linux, etc) if you want to extract the zip file.