if it's possible to use ODBC to connect to a Windows box from a Linux cPanel server. We have attempted connections from PHP (both as CGI as well as Apache module) and we get:
Fatal error: Call to undefined function odbc_pconnect() in...
and
Fatal error: Call to undefined function odbc_connect() in...
Is ODBC possible on cPanel servers?
I had a small question about ODBC. I created a new connection to a MySQL database with the 'ODBC Data Source Administrator' on my Win 2008 / IIS 7 webserver.
In this administration panel the ODBC data source works just fine. When I fill in the required values I receive the list of available databases and pressing the "test" button results in a successful connection.
But when I want to use this connection in other software, a C++ application and a PHP application, they supply me with errors "Couldn't connect to database", etc.
So the ODBC connection is correct (so are the credentials in the software 100% sure of that), but software can't use the connection. Because the software worked perfectly on an older server I think I'm missing out on some sort of setting which enables applications to use the connection (or something like that).
I am using user authentication with the following components:
Apache/2.4.10 (Win32) + mod_auth_basic + mod_authn_dbd + mod_dbd + ODBC Driver + Microsoft SQL Server 2008(SP3).
It works fine except when I do not provide any username when browser asks for username and password. In this case I receive the "Internal Server Error" as the response instead of "Unauthorized" response.
The most interesting part of the error.log is:
[Sat Sep 27 21:23:17.639860 2014] [authn_dbd:error] [pid 1208:tid 1636] [client 127.0.0.1:1363] AH01656: Query execution error looking up '' in database [[dbd_odbc] SQLBindParameter returned SQL_ERROR (-1) at apr_dbd_odbc.c:604 [Microsoft][ODBC SQL Server Driver]Invalid precision value HY104 ]
The AuthDBDUserPWQuery directive in my httpd.conf is:
AuthDBDUserPWQuery "SELECT password FROM member WHERE CONVERT(VARCHAR(10), member_Index) = %s"
And the member_Index column in the database is smallint.
I just configured the plesk server to only allow ftps connections.
When I try to access with a ftp account on the server itself it works well, however when I try to access it from a client PC it get these errors :
(...)
Response: 200 Type set to I.
Command: PASV
Response: 227 Entering Passive Mode (XXX,XXX,XX,XX,XXX,XX).
Command: LIST
Response: 150 Opening BINARY mode data connection.
Error: The data connection could not be established: ECONNREFUSED - Connection refused by server
On the client PC I configured Filezilla in Passive mode with "Require explicit FTP over TLS".
Normally for the firewall only the port 21 is needed or am I wrong (with explicit FTP and passif configured)?
WINDOWS SERVER Plesk Panel version 12.0.18
Error: Test the database server connection failed:
mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD('your_existing_password'). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file
I suddenly started to get the following error
Windows 2008 server 64 bits 24 gigs ram sql express php plesk 11.5.30 latest update passed the latest self test with no problem
Internal error: ODBC error #42S02: [MySQL][ODBC 3.51 Driver][mysqld-5.5.31]Table 'apsc.aps_package' doesn't existODBC error #42S02:
Message ODBC error #42S02: [MySQL][ODBC 3.51 Driver][mysqld-5.5.31]Table 'apsc.aps_package' doesn't existODBC error #42S02:
File aps_php.php
Line 11933
Type Exception
Go To Previous Page
As far as I know.. It seems that my web server is connecting to another IP (84.20.6.132).. it have lot of lines like this: ....
View 5 Replies View Relatedi been getting these errors do not what they mean sinse i have never seen them
Error connecting to IMAP server: localhost.
111 : Connection refused
Sending' reported error (0x800CCC0F) : 'The connection to the server was interrupted. If this problem continues, contact your server administrator or Internet service provider (ISP).'
i tried restarting my server and restarting my httpd but nothing still budges still the same any way of fixing this?
Do any one have the updates when the Cpanel is going to release its control panel for windows servers 2008, I heard it was supposed to be released in last year but seems yet to come.
View 5 Replies View Relatedmy server sql keeps loss db connection during 'cpbackup' in progresss.
below are my.cnf settings. can someone suggest me how to tweak to optimize?
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
query_cache_limit=1M
query_cache_size=128M
query_cache_type=1
max_user_connections=200
max_connections=500
interactive_timeout=10
wait_timeout=20
connect_timeout=20
thread_cache_size=128
key_buffer=512M
join_buffer=1M
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=4M
read_buffer_size=4M
max_connect_errors=10
thread_concurrency=8
myisam_sort_buffer_size=64M
server-id=1
I have a dedicated server, but i dont know how i can measure the bandwidth at specific time, the problem that i feal that my bandwidth is below what i requested...
what i mean with Bandwidth is not trfic, it is the connection speed at a moment
(i.e. 50Mbps)
I bought a VPS to run a part of a application I have and it needs to connect to my database in cpanel. I have set everything up properly and allowed the remote server to connect to my server, I updated the DB connect file with the correct mysql server username and password. But when I try and run the script I get this error.
Quote:
Client does not support authentication protocol requested by server; consider upgrading MySQL client in
I'm not 100% sure what to do. I don't understand why it wouldn't work because it works perfectly on the main server with my scripts. But I get that error message on the remote server.
I rented a server from VD a month ago and hosted some of my websites. But I'm constantly noticing that my websites are loading very slow. How can I check if other users are experiencing the same problem, or if the problem lies with my Internet connection?
View 4 Replies View RelatedCan you conduct me to check the server speed by commands ( linux fedora )?
How to check connection speed of the server. i.e. 100 Mbps , 10 Mbps, etc.
I saw an message like this : " NIC Link is Up 10 Mbps Full Duplex", according to my knowledge, this is my server connection speed/ bandwidth is 10 Mbps, isn't it?
Server down after start apache! Too many connection!
When im start apache on server, its crashed.
I am see following error, in access log:
Where is issue and how can fix it?
-bash-3.1# tail -f /var/log/httpd/access_log
::1 - - [16/Nov/2008:20:54:23 +0330] "GET / HTTP/1.0" 403 5043 "-" "Apache/2.2.3 (CentOS) (internal dummy connection)"
::1 - - [16/Nov/2008:20:54:24 +0330] "GET / HTTP/1.0" 403 5043 "-" "Apache/2.2.3 (CentOS) (internal dummy connection)" ....
I have had major problems with connecting to my shared hosting space from my home. Sometimes I can only view one page before it times out and other times I can not view any pages.
I have tried tracert, which seemed fine and there is no problem accessing the IP from any other location, only my house.
Has anyone got any ideas of what I could do? If I can not figure it out I am either going to have to get another ISP or move all my web sites.
some vBulletin customers facing to that error message, with session table with attachment only. Other just work fine. It's not because of server load. The load is just around 0 - 0.1
I have increased wait_timeout to 200 and max_allowed_packet to 64MB. Each attachment file in those vBulletin is just around 1-3MB.
Is there any idea why and how to fix?
I need a backup server
main tasks
- Download/Upload files from/to my other servers very fast.
- 1 GBps Port
- Storage no more 250 GB .
- 600 GB Traffic
- access the server from the IP no domain
- Cheaper always better : )
What offers / recommendation do you have for me?
I am using Putty to connect to my server via ssh.
When opening a direct connection, i can login quickly without any problem
Quote:
login as: gracie
gracie@server1's password:
Last login: Thu May 7 07:31:26 2009 from 192.168.0.5
gracie@server1 [~]# sudo su -
Password:
root@server1 [~]#
When I open a connection FROM ANOTHER SERVER, I have to wait more than 20 seconds
Quote:
login as: tech2
tech2@server2's password:
Last login: Thu May 7 07:32:07 2009 from 192.168.0.5
tech2@server2 [~]# ssh gracie@192.168.0.222
Password:
After I enter the password, I waited 20 seconds before I am logged in.
I have just started studying to get my MCSE certification; however, I have hit a road block early on. I am trying to start an internet connection to so i can use "configure Your Server Wizard". The internet connection is live ( I tested it on my vista tower).
Here is a some information of my setup. I am running 2 towers with server 2003 ( both are stuck with no internet) one tower with vista. I have a cable modem to a router. The router is supplying 3 ethernet cords to my 3 towers. I am using comcast for internet.
All I need right now is a basic connection to the internet so i can go further with training book one.
Here is my ipconfig/all dump from the vista tower that can connect to the internet:
C:Usersjosh>ipconfig/all
Windows IP Configuration
Host Name . . . . . . . . . . . . : josh-PC
Primary Dns Suffix . . . . . . . :
Node Type . . . . . . . . . . . . : Hybrid
IP Routing Enabled. . . . . . . . : No
WINS Proxy Enabled. . . . . . . . : No
DNS Suffix Search List. . . . . . : hsd1.fl.comcast.net.
Wireless LAN adapter Wireless Network Connection:
Connection-specific DNS Suffix . : hsd1.fl.comcast.net.
Description . . . . . . . . . . . : Intel(R) PRO/Wireless 3945ABG Network Con
nection
Physical Address. . . . . . . . . : 00-1B-77-3F-EA-8F
DHCP Enabled. . . . . . . . . . . : Yes
Autoconfiguration Enabled . . . . : Yes
Link-local IPv6 Address . . . . . : fe80::3c82:e8e0:dce4:c0df%9(Preferred)
IPv4 Address. . . . . . . . . . . : 192.168.1.100(Preferred)
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Lease Obtained. . . . . . . . . . : Saturday, June 14, 2008 12:11:36 AM
Lease Expires . . . . . . . . . . : Sunday, June 15, 2008 12:11:32 AM
Default Gateway . . . . . . . . . : 192.168.1.1
DHCP Server . . . . . . . . . . . : 192.168.1.1
DNS Servers . . . . . . . . . . . : 68.87.74.162
68.87.68.162
NetBIOS over Tcpip. . . . . . . . : Enabled
Ethernet adapter Local Area Connection:
Connection-specific DNS Suffix . : hsd1.fl.comcast.net.
Description . . . . . . . . . . . : Realtek RTL8101 Family PCI-E Fast Etherne
t NIC (NDIS 6.0)
Physical Address. . . . . . . . . : 00-03-25-4A-08-92
DHCP Enabled. . . . . . . . . . . : Yes
Autoconfiguration Enabled . . . . : Yes
Link-local IPv6 Address . . . . . : fe80::ac28:70f6:f7e1:47b0%8(Preferred)
IPv4 Address. . . . . . . . . . . : 192.168.0.100(Preferred)
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Lease Obtained. . . . . . . . . . : Saturday, June 14, 2008 2:43:16 PM
Lease Expires . . . . . . . . . . : Saturday, June 14, 2008 6:17:29 PM
Default Gateway . . . . . . . . . : 192.168.0.1
DHCP Server . . . . . . . . . . . : 192.168.0.1
DNS Servers . . . . . . . . . . . : 192.168.0.1
NetBIOS over Tcpip. . . . . . . . : Enabled
anyone can recommend a dedi svr with good connection to arg/malaysia base on ping
my current best choice is www.pacificrack.com
but still looking for better one
