w3hello.com logo
Home PHP C# C++ Android Java Javascript Python IOS SQL HTML videos Categories
Java Service Wrapper server socket creation failed
An invalid argument was supplied. That is your answer - check the values you are using to create/open the socket. One of those values is invalid. Without knowing exactly how your socket code looks and what values you are using, I can't help any more than that...

Categories : Java

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' when accessing sql server from a wcf service with impersonation
The error that you are getting is likely because the IIS Application Pool that your web application is using is running under an account that doesn't have SQL Server privileges. Change the Application Pool Account to one that can access SQL Server and the problem should go away.

Categories : Asp Net

Let a WCF service know that a SQL Server Service Broker message has arrived
I'm curious - what made you decide to move away from NServiceBus? Also, have you looked at possibly using the SQL Server transport (new in v4) for handling this integration scenario? Finally, I'd suggest looking at this thread from the discussion group for some pointers: http://groups.yahoo.com/neo/groups/nservicebus/conversations/topics/17931

Categories : C#

Unable to login to MYSQL getting error ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
It seems like a permission issue, try disabling selinuza by using setenforce 0, then restart the mysql service, also check if mysql has the right permissions on the mounted device (assuming you mounted as root or a sudo user that mysql cannot access)

Categories : Mysql

Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) Fedora Linux
What i can think right now if you've already tried the solutions in your link, is that SELinux (Fedora's) is blocking service. try sudo setenforce 0 and then sudo service mysqld start let me know if it helped please

Categories : Mysql

Be aware that the Local Service account is not supported for the SQL Server or SQL Server Agent services
That generally means (used to work for MSFT many moons ago) that any problem or issue that you may call Microsoft about when the service runs under the Local Service account will not be answered or handled by their support staff. Long story short, you're on your own when it comes to errors or other challenges. You're best off running the services under a domain account.

Categories : SQL

how to export or import sql server database from sql server to mysql server through network
Try to use this script, which allows you to import data. You must specify the table name and run the generated code on your MySQL server. DDL: CREATE TABLE Labour.Employee ( EmployeeID INT IDENTITY (1, 1) PRIMARY KEY NOT NULL , IsMainWorkPlace BIT NOT NULL , TabelNumber VARCHAR(6) NULL , PersonID INT NOT NULL , DepartmentUID UNIQUEIDENTIFIER NOT NULL , DateIn DATETIME NOT NULL , DateOut DATETIME NULL , PositionID INT NULL , DatePension DATETIME NULL , IsLabourUnionMember BIT NOT NULL , FiringReasonID INT NULL ) Query: DECLARE @Table NVARCHAR(50) , @Schema NVARCHAR(50) , @ObjectID INT , @IsImportIdentity BIT = 1 , @IsCreateTable BIT = 1 DECLARE [tables] CURSOR READ_ONLY FAST_FORWARD LOCAL FOR SELECT t.name

Categories : Mysql

mysql: Java api to call mysql metadata service
The best source for getting table metadata is MySQL itself. Use the INFORMATION_SCHEMA tables/views in MySQL to get this data. You can execute the queries and read the results set back like a normal query. For table information: SELECT * FROM INFORMATION_SCHEMA.TABLES For columns: SELECT * FROM INFORMATION_SCHEMA.COLUMNS You can use this form for indexes on InnoDB: SELECT t.name AS `Table`, i.name AS `Index`, GROUP_CONCAT(f.name ORDER BY f.pos) AS `Columns` FROM information_schema.innodb_sys_tables t JOIN information_schema.innodb_sys_indexes i USING (table_id) JOIN information_schema.innodb_sys_fields f USING (index_id) WHERE t.schema = 'sakila' GROUP BY 1,2;

Categories : Mysql

Query Failed!You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
ORDER is a reserved keyword. So, you'll need to escape it in backticks, like so: INSERT INTO `order` ... Not using reserved keywords in your query would be the better solution, but escaping them with backticks works, too.

Categories : PHP

Angularjs how can I unit test a Service which depends on another Service with promises?
If you are just testing Service2 then you should try to eliminate any dependency on Service1 in the test. Your test could have something like: module('foo.services', function($provide) { $provide.value('Service1', MockService1()); }); This will give the return value from the function MockService1 instead of actually using the service, whenever it is injected. Then you have MockService1 function return a skeleton of the actual service with the same function. In your test you can then wait for the promise to be resolved by doing something like this: bar: function(...) { var def = $q.defer(); $timeout(function() { def.resolve('test'); }); return def.promise; } // This is in your test bar.then( // .... some tests); // This executes the timeout and therefor the resolve $root

Categories : Unit Testing

Failed to invoke the service. Possible causes: The service is offline or inaccessible while Invoking
Maybe not the answer you are looking for, but for development on the local machine I always use an HTTP endpoint. I find Net.TCP will only play nice when it is hosted on a server in IIS. It is easy enough to add the NET.TCP endpoints once you deploy to an IIS server. Note: that the base address no longer has any affect as that is set in IIS. To test the new endpoints it is best to start by opening the service in a browser while remoted into the server, that way you get the best error messages. If i understand correctly you are trying to select the endpoint when creating the service reference? Thats now how it works. If you create your service reference using 127.0.0.1/service/Service1.svc You should see in your config file something like the following. (When I create my service endpo

Categories : C#

WSO2 Application Server - REST Service, deploy as Application or Service?
In WSO2 Application Server there are two approaches to create RESTfull services. Create RESTfull service using Axis2, then you should deploy them as "service" Create JAX-RS spec based service using CXF, then you should deploy them as "JAX-RS" applications.

Categories : Wso2

Failed to invoke the service. Possible causes: The service is offline or inaccessible
By seeing your comment (error in detail) I can suggest you to increase the max buffer size & MaxReceivedMessageSize in SvcConfigEditor (through VS command prompt or Wcf Test Client)

Categories : Wcf

MySQL Trigger Error #2013 - Lost connection to MySQL server during query
Change SET cmd=CONCAT('/home/lab/Dropbox/simulator/version_unified/./simulator'); to SET cmd=CONCAT('/home/lab/Dropbox/simulator/version_unified/simulator'); ./ is used when the file is in the current working directory.

Categories : C++

Trying to connect to mysql server for the first time and get an error messange: "mysql: command not found"
Your terminal application doesn't know where to locate the mysql program. For example, if you installed xampp in C:/xampp, you open a command prompt, cd to C:/xampp/mysql/bin and then run your command, which should work now. Edit: Just remembered you mentioned OSX, regardless, use the same principle. In your terminal, cd to the XAMPP install subfolder which contains the mysql executable app

Categories : PHP

Linking different schemas from different mysql servers into only one mysql server so he can manage the queries
MySQL Proxy: The MySQL Proxy is an application that communicates over the network using the MySQL network protocol and provides communication between one or more MySQL servers and one or more MySQL clients. However, note:  Warning MySQL Proxy is currently an Alpha release and should not be used within production environments. The FEDERATED Storage Engine: The FEDERATED storage engine lets you access data from a remote MySQL database without using replication or cluster technology. Querying a local FEDERATED table automatically pulls the data from the remote (federated) tables. No data is stored on the local tables. Replication: Replication enables data from one MySQL database server (the master) to be replicated to one or more MySQL database servers (the slaves).

Categories : Mysql

Need to install mysql in php webserver to access remote server mysql database?
You will not need to install mysql server in your server to access remote mysql. Mysql drivers also come with php preinstalled so you will not need to install those drivers as well. However I am guessing you will need to look in to your mysql host parameter in your app config. It should point to your actual mysql host in remote. May be ip address of the server your remote mysql server is in. And your remote mysql server needs to allow your connections through it as shown in link you provided.

Categories : PHP

mysql query doesn't work correctly in php on server unlike xampp server
I changed the Charset Encoding to Unicode(UTF-8) in browser and then changed the code in Server, I don't know what happened but the problem solved successfully!

Categories : PHP

I am getting mysql error check the manual that corresponds to your MySQL server version for the right syntax to use near '?' at line 4
Try putting quotes around your question mark if it's the value in the database you're filtering by: $query_str = "SELECT cm.user_id, chat_message_content, u.firstname FROM chat_message cm JOIN user u ON cm.user_id = u.user_id WHERE cm.chat_id= '?'";

Categories : Mysql

Frequent, periodic server-side updates to server MySQL database
i would create a cron task (on unix) or scheduled task (on windows) on the server. Have the script run every interval you require populate your db. Cron http://www.pantz.org/software/cron/croninfo.html Windows Schedule Task (obviously you'll need to find to suit your version) http://windows.microsoft.com/en-au/windows7/schedule-a-task Also, cron will only run with every minute of granularity, but i found a simple solution if your wanting to run your script with more frequency than that. #run every minute on the minute * * * * * user /path/to/executable param1 param2 #run every minute on the minute with 30sec pause before exec. * * * * * user ( sleep 30 ; /path/to/executable param1 param2 ) http://stackoverflow.com/a/9619441/1258598

Categories : Mysql

Pooling connection to mysql database server from django application server
Your approach is not amateur at all. The purpose of bouncer in your case would be to eliminate connection time that happens on each request django handles. For example, on Heroku, which is hosted on AWS servers, this could eat up 40-50ms of each request. Now, if you had a master/slave setup or something like that, a connection pool would also provide you a failover functionality (just an example)

Categories : Mysql

Issue when using linked server to pass a parameterized dynamic query from SQL Server to a MySQL database
You need to prepare the a statement and then execute it: SET @Params = '1000001289,1000001294,1000001296,1000001303,1000001304,1000001306,1000001308'; SET @SQL = CONCAT('SELECT LoanNumber FROM plms.vw__bid_dd_overlay WHERE LoanNumber IN (' , @MyParams , ' );'; PREPARE statement FROM @SQL; EXECUTE statement; Reference to the mySQL manual

Categories : Mysql

mysql error Can't connect to local MySQL server through socket '192.168.250.99'
You have to bind your server to that specific IP address So add this to your my.cnf under [mysqld] bind-address=192.168.250.99 or write bind-address = 0.0.0.0 for all ip addresses

Categories : Mysql

How to install mysql server and xampp server both in same operating system
You must need to change the port. In xampp server there has a mysql and use port 3307. If you want to install mysql server on that machine then need to change the port of mysql of xampp server. As a result conflict booth mysql server and xampp server.

Categories : Mysql

Get data from mysql server and upload it into Sql server using Telerik openAcces ORM
You could follow this help article. It explains how to prepare a domain model, reuse it for different backends and switch between them during runtime.

Categories : C#

Installing mysql-libs on server with MySQL-Server5.5
Well, this is a common problem with MySQL packages within CentOS 6. Yum is trying to satisfy requirements by installing mysql-libs-5.1.69-1.el6_4.x86_64. This package conflicts with files from package MySQL55-server-5.5.32-1.cp1136.x86_64. There is a way to fix this without breaking your rpm database or uninstalling mysql55, just download mysql compatibility libs from mysql for el6 (CentOS and RHEL6 are full binary compatible). Get MySQL-shared-compat-5.5.32-2.el6.x86_64.rpm (just google for it) and install this rpm using: rpm -ihv MySQL-shared-compat-5.5.32-2.el6.x86_64.rpm. After this you can install ReviewBoard without yum trying to install mysql51 libs for satisfying dependencies. Here is the link to the official package provided by MySQL: MySQL shared compat

Categories : Mysql

Inserting from remote sql server to local mysql server
As your code stands now, only one row will get inserted into mysql. The second while loop is looping on the select statement's result set. So when it gets there it is just going to exhaust the result set outputting the second, third and so on results. If that while block is not being executed then you might only have one row that matches the select statement.

Categories : Java

DBD-mysql installed ,but still error "install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC"
Perhaps the DBD::mysql perl module hasn't been fully installed ...so install it. cpan DBD::mysql Or since you don't have internet access, perl Makefile.PL make make test make install You'll need MySQL's development header files installed first, as per INSTALL

Categories : Perl

how can I inner join 2 mysql tables on 2 different mysql server
Go read about the federated engine. It is the MySQL version of linked servers. You will be able to query a remote table like a local table using the federated engine. Read this link.

Categories : Mysql

MySQL connection over SSH tunnel - how to specify other MySQL server?
Solved it! The thing was to connect to the correct server when creating the tunnel itself - should've seen that one coming. ssh -f user@ssh.example.com -L 3307:mysql1.example.com:3306 -N Then mysql -h 127.0.0.1 -P 3307 worked as intended. :)

Categories : Mysql

I can't create Link Server to MySQL in SQL Server
I finally solved the problem. The solution is very silly but I can't belive it was the solution. The solution is to simple Remove the space between the MySQL select and the single quote. so it becomes 'SELECT CAST(t.name AS CHAR) AS team_name, ........

Categories : Mysql

Mysql Service Won't Start
Your Mysql configuration seems to be in bad shape. 1- Check if there are strange lines in your my.cnf configuration file starting with 'plugin-load'. Such lines should look like: (should only contain references to .so files) plugin-load=myplugin=somepluglib.so 2- Or maybe you have a corrupted 'mysql.plugin' table (or maybe a filesystem corruption... hope you have backups...)

Categories : Mysql

.NET Server Scheduling Service - How should I go about this?
A windows service is not a bad idea, its perfect for this kind of application. Unless you end up using standard windows scheduled tasks as the trigger for your command, you need some sort of process that is always running to contain your scheduler. A windows service is an excellent candidate for this. Using a windows service in conjunction with Quartz.NET and some sort of persistence layer so you can store your schedules (in case you need to restart the service or it crashes etc) would be a good way to go. Alternatively, you could write an application that just adds and removes windows scheduled tasks, but considering you have existing class libraries, using Quartz.NET will fit in well with your existing libraries.

Categories : C#

SQL Server(SQLEXPRESS) Service
You need to make sure that the account SQL Server is operating under has write permissions to 'C:Program FilesMicrosoft SQL ServerMSSQL10.SQLEXPRESSMSSQLLog, after you've verified that the directory actually exists. First go to Services (Control Panel/Administrative Tools/Services) and check which account SQL Server is running under. Probably NT ServiceMSSQL$SQLEXPRESS Then go to 'C:Program FilesMicrosoft SQL ServerMSSQL10.SQLEXPRESSMSSQL' and right click on the "Log" folder and click properties. Then go to the Security Page. If MSSQL$SQLEXPRESS is listed, ensure that it has "Full Control" if it doesn't, click the "Edit" button and give it full control. If it's not listed, click "Edit" and then on the "Permissions for Log" dialog click add and add MSSQL$SQLEXPRESS.

Categories : Sql Server

can a windows service run a TCP server?
The answer to your specific question is, yes, a windows service can run a TCP server. The answer to why yours does not work is not clear. At first glance the service code looks reasonable. It's possible connections to your service are being blocked by your OS firewall (i.e. your console one is in the accept list but your service one is not). You might convert some of your error printf logic into something that prints to a file instead (e.g. fprintf?) so you can take a look at what's going on...

Categories : C++

Use WCF web service from client and server
The simplest solution might be to factor out the pertinent code in your web service to a class library. Then you can reference this new class library from your web server and call the methods during the post-back.

Categories : C#

Couldn't find MySQL as service
Some of this is supposition, as I am a WAMP user by preference but I have used XAMPP in the past: I think that the Install on E: caused the Apache and MySQL services to be installed from the E:xampp directories, negating the G: installed versions. When you uninstalled the E: version it should have removed both Apache and MySQL services. If you still have the version on G: I seem to remember there is a way of re-installing the Apache and MySQL services so run the XAMMP icon and I think there is a button for each service, somethng like SVC beside the info about Apache and MySQL that tells you its running or not, and that will reinstall the services from whereever you ran the XAMPP controller from. As to the databases you created using the E: version you installed, If the uninstall is wri

Categories : Mysql

MySQL Windows service won't start
find physical database files on disk. back them up. restard host computer. then follow these steps: Click Start, click Run, type regedit.exe, and then click OK. Locate and then click the following registry subkey: HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesTcpipParameters On the Edit menu, point to New, and then click DWORD Value. Type MaxUserPort and then press ENTER. Double-click the MaxUserPort value, and then type the maximum value in decimal or hexadecimal. You must type a number in the range of 500065534 (decimal). Setting this parameter to a value outside of the valid range causes the nearest valid value to be used (5000 or 65534). Click OK. Quit Registry Editor. restart host computer again. you should be fine now. The issue is caused because IIS is complete garba

Categories : Asp Net

web service connection to mysql fails
"fails" doesn't give as much information as an actual error message or stack trace. My guess is that you didn't GRANT permission to connect from all IP addresses in MySQL. You may want to read more about GRANT and how to accomplish there. There's a SO question here that tells you how to make it generic, but that is potentially dangerous.

Categories : Mysql

Deploying a Java Web Service on a server
Endpoint can also serve requests concurrently, you can enable thread pooling by creating a ThreadPoolExecutor and registering it with the endpoint. See Endpoint.setExecutor(Executor executor) If you want to deploy your Web Service on GlassFish you should change it into a WAR project, see http://docs.oracle.com/javaee/6/tutorial/doc/bnayl.html

Categories : Java



© Copyright 2017 w3hello.com Publishing Limited. All rights reserved.