Dear experts,
I just purchased a dedicated server and i need to setup for hosting my website.
Please help me how do i setup the server step by step.
server details :
Windows 2008 STD EN
SQL Server Web 2008
Core2 Quad 2.4GHz
6GB RAM
Single-Power
150GB Velociraptor 10K RPM
Please help me for :
1.Setting up server and hosting website
2.Email settings
3.How to set DNS as domain is from another host.
regards,
Sunny
My authentication fails with
java.sql.SQLException: no such table: credentials
where credentials is the name of the user/password table. I have checked the db file and the table is there. I think you also get this error when sqlite jdbc can't even find the file.
I am specifying my realm in a META-INF/context.xml file. Is there any trick to getting the path right? I have tried just about everything I can think of.
I have a MySQL server sitting behind a bastion server that I wish to connect to from my local machine.
Ideally I want to port-forward the MySQL port (3316 in this case) to a local port on my machine.
I've tried plink -ssh -L 3306:my.sql.ip.address:3316 my.bastion.server
,but this is not working.
I've got one ssh login for the bastion server and another login for the machine mysql server is running on.
I am a webdeveloper and my current working tools are:
Terminal (ssh, tailing logs, grep, git, etc)
Eclipse (PDT, Javascript, etc)
Firefox (Developer Toolbar + Firebug)
The problem is that I hate using the eclipse navigation tree. For me it is a lot easier to go to the Terminal and do something like this:
$ eclipse /var/www/myproject/long/path/lib/Driver/Sql.php
The annoying part is that the eclipse window is not focused after this command.
I have to manually click on the eclipse window (using mouse... :@ grrr)
Anyway to force eclipse to be focused?
I could not decide on which configuration below gives better performance for developers on a notebook(running VS.NET, SQL Server, no gaming);
(A) i5 540M + SSD (Intel)
or
(B) i7 720M + 7200 RPM HDD (Western Digital)
Since these two configurations(A, B) costs nearly same $ for me, I would like to buy the fastest one for my job environment.
Please do not comment just buy this or that, if you can give an inference about your choice I would be appreciated.
Thank you,
cas
ACID properties are important for the RDMS applications.There are many relational database services offered by the cloud providers such as AMAZON RDS and Microsoft SQL Azure.
i'm curious about if the ACID properties are provided or not ?
thanks.
I am working on a large SharePoint farm, mainly with the backend SQL Servers. We have always used stsadm -o for all stsadm functions, but no one seems to know why. I can't seem to find the info specific for stsadm, would it be general Windows command-line sytax?
Hi,
I followed the steps in oracle documentation on creation of a physical standby database.
The link to the configuration steps,
http://download.oracle.com/docs/cd/B28359_01/server.111/b28294/create_ps.htm#i63561
When I perform "Step 4 Verfiy that received redo has been applied." my query result is not as expected, following is the result,
SQL SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;
SEQUENCE# APP
5 NO
6 NO
7 NO
8 NO
4 rows selected.
Appreciate any advice on how to proceed, thanks.
"I tried to make this easy to read through"
I am using Ubuntu 12.04 LTS for Magento and installed these commands onto the system:
sudo apt-get install apache2
sudo apt-get install php5 libapache2-mod-php5
sudo apt-get install php5-mysql
sudo apt-get install php5-curl php5-mcrypt php5-gd php5-common
sudo apt-get install php5-gd
I used Windows Server 2008 R2 August 2012 for Mysql Server
For a reference, I used http://www.windowsazure.com/en-us/manage/windows/common-tasks/install-mysql/
When the server was setup, I added an empty disk to it
Then, I added endpoints 3306
Next I accessed the server remotely
After that, I formatted the empty disk and was inserted as F:
Next I downloaded Mysql from http://*.mysql.com version Windows (x86, 64-bit), MSI Installer 5.5.28
In the installation process, I used these settings:
Typical Setup - Clicked Next, install, next
Chose Detailed Configuration - Clicked next
Chose Dedicated MySQL Server Machine - Clicked Next
Chose Transactional Database Only - Clicked Next
Chose the "F:" Drive - Clicked Next
Chose Online Transactional Processing (OLTP) - Clicked Next
For Networking Options, I checkmarked 'Enable TCP/IP Networking" 'Add firewall exception for this port' 'Enable Strict Mode' - Clicked Next
Chose Standard Character Set - Clicked Next
For Windows Options, I checkedmarked 'Install as Window Service" 'Launch the MySQL Server automatically' 'Include Bin Directory in Windows PATH - Clicked Next
For Security Options, I checkmarked 'Modify Security Settings' and set root password - Clicked Next
Finally clicked Execute and Finish
These are the Firewall Setting that I set
I clicked inbound rules
Properties
Scope
Allow IP Address and used the internal Address for Magento Server
Clicked Apply and exited
Next, I opened up MySQL 5.x Command Line Client
Entered Root Password
Then entered these commands
mysql create database magento;
mysql Create user magentouser identified by 'password';
mysql Grant select, insert, create, alter, update, delete, lock tables on magento.* to magentouser
mysql exit
Finally, I opened up the Magento Downloader
Magento validation has approved all
PHP version is right. Your version is 5.3.10-1ubuntu3.4.
PHP Extension curl is loaded
PHP Extension dom is loaded
PHP Extension gd is loaded
PHP Extension hash is loaded
PHP Extension iconv is loaded
PHP Extension mcrypt is loaded
PHP Extension pcre is loaded
PHP Extension pdo is loaded
PHP Extension pdo_mysql is loaded
PHP Extension simplexml is loaded
These are all installed on Magento Server
For the Database Connection, I used:
The Database server only has MySQL 5.5 Server installed on it
Host - Internal IP address
User Name - The User I created when setting up database
Password - The Password I created when setting up database
For the password, I did some research and found out that Magento only accepts alphanumeric, so I went and set it up again and used only alphanumeric for the User password
Now, I am still getting Accessed denied for database Connection.
Also, I have tryed to setup mysql on independant Linux Server but kept getting errors. When, I found the solution. Wouldn't work, so I decided to try Windows.
These is the questions, I have been asking and researching to debug this issue
Is it because I am using Linux for magento and Windows for Database. I have had no luck in finding a reason why this wouldn't work
There must be something, I am missing
I also researched the difference between linux sql databases and windows sql databases but have not come to conclusion, if installing Mysql on windows would make a difference in syntax and coding.
I have spent a lot of time looking into this and need some help with direction on how to complete my project. Any type of help would be appreciated.
I am running windows server with asp.net websites and sql server 2008 and IIS 6.
It is working fine.
Now I need to move my asp.net websites to another windows server and I have hard time setting correct file security for the new server.
Is there any way to compare or move or see difference file security between two servers?
I figured I would post this here, since it may be related more to the server configuration than the SharePoint configuration or a combination of both? I'm open for ideas to try, or even feedback on things that maybe have been configured incorrectly as far as performance is concerned.
We have a medium MOSS 2007 install prepped and ready for receiving the WSS 2003 data to upgrade. The environment was originally architected by a previous coworker, and I have since added a few configuration modifications to assist with performance before we finally performed the install. When testing the new site collections & SharePoint install (no actual data yet), things seemed a bit slow. I had assumed that it was because I was accessing it remotely. Apparently the client is still experiencing this and it is unacceptably slow.
1 SQL Server running SQL Server 2008
2x SharePoint WFEs - hosting queries (no index)
1x SharePoint Index - hosting index (no queries)
MOSS 2007 installed and patched up through December '09 on WFEs & Index
All 4 servers are VMs, should have more than sufficient disk space & RAM (don't recall at the moment), and are running Windows Server 2008 - everything is 64-bit.
The WFEs have Windows NLB configured, with a DNS name & IP for the NLB cluster. Single NIC on each server (virtual, since VMWare).
The Index server is configured as a WFE (outside of the NLB cluster) so that it can index itself and replicate the indexes to the WFEs that will serve the queries.
Everything is configured & working properly - it just takes a minute or two to load a page on the local LAN. The client is still using their old portal (we haven't started the migration/upgrade just yet) so there's virtually no data or users. We need to either further tune the configuration, or fix anything that may have been configured incorrectly which is causing this slowness?
I've already reviewed & taken into account everything that I could find that was relevant before we even started the install. Does anyone have ideas or pointers? Perhaps there's something that I've missed?
I need to spell check documents about SQL Server applications. These will often mention "database..table". How do I get Word to ignore the double full stops?
looking for recommendations on ESX4 OS - VMFS version3:
RAID-5 : matching the stripe size with VMFS block size? (64K, 128K etc)
RAID controller options: "adaptive read ahead, write-back" on PERC 6i
90% VMs on server are Windows (2008, 2003, Vista etc, SQL 2005 etc)
i have read that smaller stipes are good for writes and larger for reads. Since this is virtual env, not sure whats good.
Hello. My host is WinXP and my guest (on VPC 2007) is also WinXP. Both have SP2. I am unable to ping either from one another. However, I am able to connect to the Internet from the guest. My intention is to be able to connect the SQL Server on the host from the Management Studio installed on the guest. Right now I am using Shared Networking (NAT) on the guest's settings.
Hello;
I am using Tomcat 6 as application server, Struts-Hibernate and MyEclipse 6.0.
My application uses JDBC driver but I should modify it to use JNDI Datasource. I followed steps as described in tomcat 6.0 howto tutorial.
I defined my resource in tomcatconf:
<Resource name="jdbc/ats" global="jdbc/ats" auth="Container"
type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@//localhost:1521/MISDEV"
username="TEST" password="TEST" maxActive="20" maxIdle="10"
maxWait="-1" validationQuery="SELECT 1 from dual"
removeAbandoned="true"
removeAbandonedTimeout="30"
logAbandoned="false"/>
I gave reference in my application web.xml:
<resource-ref>
<description>Oracle Datasource example</description>
<res-ref-name>jdbc/ats</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
And I defined datasource-dialect in my hibernate-cfg.xml
<property name="connection.datasource">java:comp/env/jdbc/ats</property>
<property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
But when I create hibernate session, it can not open the connection:
09:18:11,322 ERROR JDBCExceptionReporter:72 - Connections could not be acquired from the underlying database!
org.hibernate.exception.GenericJDBCException: Cannot open connection
I also tried to set the properties at runtime:
Configuration configuration = new Configuration();
configuration.setProperty("hibernate.dialect", "org.hibernate.dialect.Oracle9Dialect");
//configuration.setProperty("hibernate.connection.datasource", "java:comp/env/jdbc/ats");
configuration.setProperty("hibernate.current_session_context_class", "thread");
configuration.setProperty("hibernate.connection.provider_class", "org.hibernate.connection.C3P0ConnectionProvider");
configuration.setProperty("hibernate.show_sql", "true");
sessionFactory = configuration.configure().buildSessionFactory();
It does not open connection again.
But, when I use JDBC driver it works:
Configuration configuration = new Configuration();
configuration.setProperty("hibernate.dialect", "org.hibernate.dialect.Oracle9Dialect");
//configuration.setProperty("hibernate.connection.datasource", "java:comp/env/jdbc/ats");
configuration.setProperty("hibernate.connection.url", "jdbc:oracle:thin:@//localhost:1521/MISDEV");
configuration.setProperty("hibernate.connection.username", "test");
configuration.setProperty("hibernate.connection.password", "test");
configuration.setProperty("hibernate.connection.driver_class", "oracle.jdbc.OracleDriver");
configuration.setProperty("hibernate.transaction.factory_class", "org.hibernate.transaction.JDBCTransactionFactory");
configuration.setProperty("hibernate.current_session_context_class", "thread");
configuration.setProperty("hibernate.connection.provider_class", "org.hibernate.connection.C3P0ConnectionProvider");
configuration.setProperty("hibernate.show_sql", "true");
sessionFactory = configuration.configure().buildSessionFactory();
I have been searching for 3 days and no success. What may be de problem?
Solaris Korn Shell
I am writing sql reports to an oracle database, spooling them to a file and emailing them with mailx. I use the syntax below. The reports do not format properly, unless I use the Courier New font. How do I set this with mailx?
mailx -s "MY REPORT, date +'%D %r " -r "REPORTING SYSTEM" [email protected]< /mydir/mysql.log /dev/null
Hi
I am beginner for SSH stuff but i want to dump a big sql file and for that i need to be able to navigate to the appropriate path in my hosting account. I managed to login to SSH and i typed pwdbut it gave me a shared hosting pathway like /home/content/r/o/s/roshanjonah
How Can i go to the path where i upload my files to...i use FTP but in FTP path it just shows / so i cannot go any further back than that...so using SSH how can i come to this path in ftp...
Thanks
Roshan
I have a database backup located in my Windows 7 Documents folder (c:\Users\Aaron\Documents...), and I'm trying to restore it using SQL Server Management Studio. However, the program is unable to access anything within the Users\Aaron directory using its non-standard file selection dialog, even when run as an Administrator.
I'm brand new to Windows 7... Is there some sort of security setting that I need to trigger to give programs access to these files?
recommendations for ESX4 OS - VMFS version3:
matching: RAID-5 stripe size with VMFS block size? (64K, 128K etc)
enabled "adaptive read ahead, write-back" on PERC 6i
90% VMs on server are Windows (2008, 2003, Vista etc, SQL 2005 etc)
i have read that smaller stipes are good for writes and larger for reads. Since this is virtual env, not sure whats good.
We've struggled with the RAID controller in our database server, a Lenovo ThinkServer RD120. It is a rebranded Adaptec that Lenovo / IBM dubs the ServeRAID 8k.
We have patched this ServeRAID 8k up to the very latest and greatest:
RAID bios version
RAID backplane bios version
Windows Server 2008 driver
This RAID controller has had multiple critical BIOS updates even in the short 4 month time we've owned it, and the change history is just.. well, scary.
We've tried both write-back and write-through strategies on the logical RAID drives. We still get intermittent I/O errors under heavy disk activity. They are not common, but serious when they happen, as they cause SQL Server 2008 I/O timeouts and sometimes failure of SQL connection pools.
We were at the end of our rope troubleshooting this problem. Short of hardcore stuff like replacing the entire server, or replacing the RAID hardware, we were getting desperate.
When I first got the server, I had a problem where drive bay #6 wasn't recognized. Switching out hard drives to a different brand, strangely, fixed this -- and updating the RAID BIOS (for the first of many times) fixed it permanently, so I was able to use the original "incompatible" drive in bay 6. On a hunch, I began to assume that the Western Digital SATA hard drives I chose were somehow incompatible with the ServeRAID 8k controller.
Buying 6 new hard drives was one of the cheaper options on the table, so I went for 6 Hitachi (aka IBM, aka Lenovo) hard drives under the theory that an IBM/Lenovo RAID controller is more likely to work with the drives it's typically sold with.
Looks like that hunch paid off -- we've been through three of our heaviest load days (mon,tue,wed) without a single I/O error of any kind. Prior to this we regularly had at least one I/O "event" in this time frame. It sure looks like switching brands of hard drive has fixed our intermittent RAID I/O problems!
While I understand that IBM/Lenovo probably tests their RAID controller exclusively with their own brand of hard drives, I'm disturbed that a RAID controller would have such subtle I/O problems with particular brands of hard drives.
So my question is, is this sort of SATA drive incompatibility common with RAID controllers? Are there some brands of drives that work better than others, or are "validated" against particular RAID controller? I had sort of assumed that all commodity SATA hard drives were alike and would work reasonably well in any given RAID controller (of sufficient quality).
I recently duplicated my XP "C" drive, using Retrospect.
When it finished, there were 6 errors. I checked the log and the 1st error referred to
Microsoft Security Essentials\Support\Applications.etl: Appears incomplete.
The other 5 errors referred to the Microsoft SQL Server.....\MSSQL\log_...trc: Appears incomplete.
Is this a problem that can be solved by reinstalling Microsoft Security Essentials? Or wht else? Any help appreciated, Regards,
Good afternoon.
I liked to ask for aid ..
I have a SQL query too long to process. So I remembered to share in some stored procedures.
Now my doubt is as follows:
***Is there a way to attach the result of several stored procedures?***
Already a thank