Category Archives: Database

FATAL: invalid value for parameter “TimeZone”: “America/Los_Angeles” with DBeaver

I got that message when trying to use DBeaver to connect to a PostgreSQL DB. FATAL: invalid value for parameter “TimeZone”: “America/Los_Angeles” I found the fix here. The first thing to check is the timezone you have set on the … Continue reading

Posted in Computers & Technology, Database | Tagged , , , , | Leave a comment

WordPress stuck on “Briefly Unavailable for Scheduled Maintenance”

This was interesting … Logged into WordPress and found that I had a few plugins that could be upgraded. I clicked to “upgrade all” and clicked away like I normally do – it usually just finishes upgrading with no big … Continue reading

Posted in Computers & Technology, Database | Tagged | Leave a comment

SQL 2005 setup notes for VirtualCenter 2.5

create user: http://msdn2.microsoft.com/en-us/library/aa337562.aspx (add sysadmin under security) as stated here: http://kb.vmware.com/kb/1003346 create db and make the user the owner consideration on recovery mode of DB: http://kb.vmware.com/kb/1001046 how to make changes: http://msdn2.microsoft.com/en-us/library/ms190203.aspx install native client on VC server http://www.microsoft.com/downloads/deta … n#filelist … Continue reading

Posted in Computers & Technology, Database, VMware | Tagged , , , , | Leave a comment

Zimbra – postfix transport

Instead of using the /etc/postfix/transport flat file for routing, Zimbra allows you to set this via the command line: ./zmprov cd excite.com zimbraMailTransport smtp:xmxatip.excite.com zimbraDomainType transport In this case here, the mail domain we’re changing the MTA to is xmxatip.excite.com … Continue reading

Posted in Computers & Technology, Database, Unix/Linux | Tagged , , | Leave a comment

mysql commands – create database / set permissions

/usr/bin/mysqladmin -u root password ‘new-password’ /usr/bin/mysqladmin -u root -h chunli.shocknetwork.com password ‘new-password’ mysql -u root -p -e “create database <dbname>” mysql -u root -p -e “grant all on <dbname>.* to <user>@localhost identified by ‘<password>’”

Posted in Computers & Technology, Database | Tagged | Leave a comment