Cara merubah default http & https port untuk layanan zimbra webmail sbb :
zmprov ms zimbraMailPort zimbraMailSSLPort

Setelah selesai coba restart Zimbra dgn zmcontrol stop / zmcontrol start

Di beberapa artikel saya membaca seperti ada kecenderungan rekayasa layout web dengan  penggunaan div layer di combine dengan CSS dari pada menggunakan Table layout, Adakah teman - teman yang ingin berbagi di sini ?

Posted Jun 9th 2004 2:34PM by Peter Rojas
Filed under: Desktops, Features, Laptops

We’ve got a bonus how-to for you this week. After becoming obsessed with a story on Wired News from last month about people getting their Windows PCs to have the same look and feel of Mac OS X, we convinced Aqua-Soft.org staff member Kurt Williams to give us the lowdown on how we could do it ourselves:

So, you wanna make your ugly Windows XP interface look like Mac OS X, huh? It’s really not all that difficult to do, and with a little luck, you’ll be able to convince all but the most die-hard Mac users that you run an Apple computer. First, here’s a list of the programs you’ll need:

• StyleXP or WindowBlinds (skins the Graphical User Interface of your operating system)
• ObjectBar (the white Finder bar on the top of Macs; has File, Edit, View, etc. on it.)
• ObjectDock, YzDock (discontinued), or MobyDock (The dock on the bottom of a Mac that contains icons and shortcuts to programs)
• Trillian (chat program that can be skinned to resemble iChat)
• YzToolbar (skins the toolbar icons in your Windows windows)
• YzShadow (puts a lovely drop shadow under your windows á la Mac OS X)
• Rainlendar (popular skinable desktop calendar)
• Rainmeter (skinnable desktop system statistics)
• Samurize (like Konfabulator for the Mac; can display just about anything, such as clocks, uptime, and the weather)
• iTunes for Windows (self-explanatory)
• Icons (The pretty little pictures on your desktop that point you somewhere. There are millions out there, but try the link provided for over a 1,000 lifted from Mac OS X 10.3 aka Panther)

That’s pretty much what you’ll want for starters. You don’t need all of these, and in fact, you really only need a few to get a reasonably good looking OS X facsimile, but if you’re gonna do this you might as well do it right. Now on to the guide.

This guide assumes that you have either downloaded/purchased the programs listed and 0that you know your way around a computer, at least to a reasonable extent.

1) I use StyleXP for my visual style, so that’s what I’ll detail here. WindowBlinds isn’t that different, but if you prefer it, be my guest. The first thing you’ll need to do is download a skin. I recommend Kol’s website, StudioTwentyEight for some excellent skins, but feel free to look around for any others that might interest you. Download your ZIP, and extract it to C:\WINDOWS\Resources\Themes. Open up StyleXP and load up that baby. Your windows should now look like the skin you downloaded. If you chose Panther (an excellent choice) then they should look somewhat like this:

2) Time to find a good ObjectBar skin. I’d suggest crni’s website for some excellent themes. Download the one you like best and extract it to your ObjectBar folder. Open the new folder in there (named something like the theme you downloaded) and double-click the .OBTHEME icon. The top of your screen should now look something like this, depending on your theme (Milk for me):

3) Next up is the dock. Open up whichever version you settled on downloading. This is pretty easy to set up. Basically all you need to do is drag shortcuts or executables to the dock and ta da, you have a shortcut. To change it’s icon, right-click and select “change icon” or some variation. To get new icons to select, make sure you put them in the icons subfolder (for YzDock) or the main dock folder (for ObjectDock). Easy as pie. When you have the icons and programs you like, it should look something like this:

4) For those that don’t know, Trillian is a nifty chat program that sticks AIM, MSN, ICQ, and IRC into one program. If you don’t use it, you should if for no other reason that it can look a lot like iChat. You may or may not need the Pro version to get the skin to work. I’ve heard mixed reports, but if it doesn’t work right, I’d say you need the Pro version. An excellent choice for skins are Danimator’s iChat skins. Extract it to your Trillian skin directory, open up Trillian’s preferences, go to skins, and select the new skin you want to use. You can follow the readme for some more precise directions to get it looking perfect. When you’re done, it should look like this:

5) YzToolbar and YzShadow are pretty self-explanatory. Just install ‘em and run ‘em. You can find good YzToolbar skins on the net: I’d recommend Aqua-Soft or AquaXP. Depending on skin (Milk, for me) and settings, it should look something like this:

6) Rainlendar and Rainmeter are also pretty easy to install and set-up. Just run the installer, and find a good skin. Again, there’s many to choose from. I’d suggest searching the forums at the aforementioned Aqua-Soft and AquaXP. Here’s the Rainlender skin I use.

7) Samurize is a bit complicated, so if you’re going to try and use it, be forewarned that it can be a very big hassle, if it works at all. I’m not even going to try and explain it in this brief overview, but if you are serious about it, check out the Samurize forums at Aqua-Soft and AquaXP. Here’s an example of what it can do:
If you listen to music on your computer, no Aqua-fication can be complete without the authentic iTunes for Windows. Apple provides plenty of documentation on how to install and use it, so I’ll leave that part to them. If you want to make it look more like iTunes for Macintosh, check out localhost’s multi-plugin.

And the final result:

So that’s pretty much all there is to it. Good luck!

Kurt Williams

Proses penginputan hampir rampung, tugas mendatang adalah membuat laporan - laporan dan pastikan error handler telah ditangani dengan baik utk semua form input

This assumes you already have Apache2 and PHP5 set up properly on your system. My efforts to get this connection working were compiled from information found at www.unixodbc.org and www.freetds.org. These steps worked for me with an Apache2 web server with php5 running on Debian Etch stable in October of 2007. The SQL server is running Microsoft SQL 2005 on a Windows 2003 Server OS.In these instructions I assume you’ve su’d to a root account. I also use joe as my editor so replace that with your editor of choice.

First install the necessary packages:

#apt-get install tdsodbc libct3 unixodbc php5-odbc

This should download and install unixODBC, FreeTDS, and the odbc extentions for php5.

Next we create templates to register the ODBC Driver for FreeTDS and for creating the ODBC DSN for FreeTDS. You can put these files wherever you like as you’ll be using “odbcinst” to actually configure the system. I chose to house them in /etc/freetds where the tds configuration files live.

ODBC Driver registration:

#joe /etc/freetds/tds.driver.template

Then paste this into the editor:

[TDS]
Description     = FreeTDS Driver for Linux & MSSQL on Win32
Driver          = /usr/lib/odbc/libtdsodbc.so
Setup           = /usr/lib/odbc/libtdsS.so

Now the DSN:

#joe /etc/freetds/tds.dsn.template

Then paste this into the editor:

[DSN_NAME]
Description     = Test to freeTDS
Driver          = TDS
Trace           = No
Database        = DefaultDatabase [replace with your database name]
Server          = mysqlserver.inter.net [replace with your SQL server's host]
Port            = 5050 [replace with the port that SQL is listening on]

Ok, now you need to get these templates inserted into the unixODBC system:

#odbcinst -i -d -f /etc/freetds/tds.driver.template

#odbcinst -i -s -f /etc/freetds/tds.dsn.template

A problem I had at this point is that the DSN got installed to the root account’s personal odbc settings. Since I can’t log in as www-data to run the dsn installation command I simply copied the root’s .odbc file to /etc/odbc.ini which is the system wide DSN file that all users can reference.

#mv /etc/odbc.ini /etc/odbc.ini.bak [in case you had others]

#cp /root/.odbc.ini /etc/odbc.ini

Now you need to enable the odbc extension in php by editing your php.ini file. Unless you made some sort of custom build or install the php ini file should be in the /etc/php5/apache2/ directory, so:

#joe /etc/php5/apache2/php.ini

Best practice is to add this to the extensions section of the php.ini file:

extension = odbc.so

Now you need to restart Apache as to get the php changes into the system.

#/etc/init.d/apache2 restart

That should be it. Assuming you have connectivity to the MSSQL machine you should be able to test this setup using isql. Using the above settings and a username of Bob with a password of Marley here’s the test:

#isql -v DSN_NAME Bob Marley

You should get the SQL> prompt and you can run any select or other commands you like. Now onto the PHP portion. All you need to do (again assuming the above exmamples) is add the conenction info to your php file and get to coding. The following is a basic example that you will of course need to bend to your will.

<?php

# connect to a DSN "DSN_NAME" with a user "Bob" and password "Marley"
$connect = odbc_connect("DSN_NAME", "Bob", "Marley");

# query the users table for all fields
$query = "SELECT * FROM users";

# perform the query
$result = odbc_exec($connect, $query);

# fetch the data from the database
while(odbc_fetch_row($result)) {
$field1 = odbc_result($result, 1);
$field2 = odbc_result($result, 2);
print("$field1 $field2\n");
}

# close the connection
odbc_close($connect);

?>

If you have problems start with basic network troubleshooting. Make sure you can ping the server from your debian box. Try telneting to the server and port that MSSQL is listening on. If it’s working you should get a blank screen that you need to break out of. After that if the isql example works but your php connection doesn’t, I’m not sure where to point you.

Good luck!

Copyright © 2007 Kevin K
All Rights Reserved.

Trackbacks

 

Par Pierrick, lundi 22 octobre 2007 à 22:09 / categorie: GNU/linux / tags: / #104 / rss

We’re using Debian Etch (with GNU/Linux) as a server at Talend office. We need to reach a remote Microsoft SQL Server database. The first step is to perform a select query in the command line.

We need to install FreeTDS: FreeTDS is a set of libraries for Unix and Linux that allows your programs to natively talk to Microsoft SQL Server and Sybase databases.. We have to define an “interface” for the Microsoft SQL Server in the FreeTDS “interfaces” file. At the end of the line,w use sqsh, a command line client for Sybase and Microsoft SQL Server.

 

$ sudo apt-get install freetds-dev sqsh
$ vi /etc/freetds/freetds.conf

 # talend alias is bound to a MS SQL Server 2000
 [talend]
        host = talend-dbms
        port = 1433
        tds version = 8.0

$ sqsh -Uroot -P******* -Stalend
[...]
1> select count(*) from sales;
2> \go

 -----------
        1000

(1 row affected)
1> quit

• FreeTDS
• SQSH

Aucun trackback.

Les trackbacks pour ce billet sont fermés.

Commentaires

Aucun commentaire pour le moment.

Ajouter un commentaire