w3hello.com logo
Home PHP C# C++ Android Java Javascript Python IOS SQL HTML videos Categories
Create transaction in GnuCash in response to an email?
Here's a template, along with a couple of account lookup functions which are sorely lacking in the library. You can place all of the transaction code into a function, then hand in whatever data you need to create the two custom transactions. Then just call the transaction function from your email listener, and you should be in business. from gnucash import Session, Account, Transaction, Split, GncNumeric import gnucash from datetime import datetime def lookup_account_by_path(parent, path): acc = parent.lookup_by_name(path[0]) if acc.get_instance() == None: raise Exception('Account path {} not found'.format(':'.join(path))) if len(path) > 1: return lookup_account_by_path(acc, path[1:]) return acc def lookup_account(root, name): path = name.split('

Categories : Python

How to install mysql 5.5 on Azure VM CentOS
There are a few dependencies that you need to get it running. Remi Dependency on CentOS 6 and Red Hat (RHEL) 6 rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm Install MySQL server yum --enablerepo=remi,remi-test install mysql mysql-server Check out update MySQL version from 5.1 to 5.5 in CentOS 6.2 as well.

Categories : Mysql

Migrating a wordpress site from azure sql to Mysql
You should try MySQL Workbench which can easily do a migration from SQL Server (and Azure DB) to MySQL. The migration can be on the fly or it can result in some .sql scripts that you have to load in you MySQL database using your regular client (phpMyAdmin, EMMA or of course, MySQL Workbench). You can find additional information about the migration capabilities of MySQL Workbench here.

Categories : Mysql

mysql command line connection to azure
Key points: -p thepass using password: NO As per the docs: --password[=password], -p[password] The password to use when connecting to the server. If you use the short option form (-p), you cannot have a space between the option and the password. If you omit the password value following the --password or -p option on the command line, mysql prompts for one. So you're asked for a password, but you apparently didn't type anything at the Enter password: prompt. Thus the error.

Categories : Mysql

Failing to connect to MySQL from MVC4 app on Azure Website
From what I am gathering, the issue is that MySQL uses by default reverse DNS lookup, which at the time being is not supported by Azure: Reverse DNS lookup on Windows Azure? Setting up reverse dns on windows azure? It looks like it is possible to turn off MySQL reverse DNS lookup, but I haven't been able to try it yet (the existing DB is not under my control).

Categories : C#

Retrieving MySql connection information using Kudu on Azure Web Sites
Yes, your connection string is available as an environment setting. To experiment with custom scripts use kuduexec (http://blog.amitapple.com/post/45675601255/azurewebsiteterminal)

Categories : Node Js

Is there a way to "migrate" an existing MySQL database used with Wordpress to Azure Blob storage?
Mike, you could create a Clear DB through New -> Store menu in Windows Azure Management Portal. Clear DB is the Microsoft`s partner to provide MySQL. Another option, you could create a Virtual Machine and install MySQL.

Categories : Mysql

Queries to connect Azure Websites with SQL server in Windows Azure Virtual Machine
1) You can simply backup your databases and restore them onto the VM's SQL Server 2) Yes. 3) Correct. 4) Telerik controls are client controls and should have no bearing on your server-side deployment platform 5) OS space on the VM is part of the price of the VM's hourly fee 6) What are you looking to do with virtual network?

Categories : Azure

Azure - customErrors="off" in web.config is not displaying detailed errors in Azure app (cloud service)
A couple of things to try: Are you SURE the customerErrors attribute is set correctly? The Identity and Access tooling in Visual Studio seems to like to reset that back to "Off" (every time you update via the tool). Are you able to connect to the role instance via Remote Desktop? If so, you could inspect the web.config settings for the site? Browsing to the site from the server might also provide a more friendly error message. When you RDP into the cloud service, you can look at the Event Viewer to see the detailed error messages.

Categories : Azure

Will multiple instances of an Azure Role interfere when reading/writing to Azure Caching?
The examples apply to multiple instances of the same web/worker role too. Multiple instances mean distinct processes, which is pretty much the same as distinct roles or clients. You may choose to lock the items. But that is orthogonal to running multiple instances, or multiple clients. Note: Locks are expensive! You need to figure out the trade off depending on your scenario.

Categories : Misc

Publishing Web.Config to Azure removes Azure storage connection string
I had a similar issue to yours. I'm not sure why but when you define the connection strings in the "Configure tab" in the azure portal and associate a "Linked Resource" on the linked resource tab it may override certain properties in the Web.config transform causing unexpected results. One of the options when you set up a new azure website is linking to (or creating a new) database to associate with your website - thereby automatically assigning the related connection string which may try to override your transform operation defined in the Web.Release.config. Check and see if removing all connection strings and linked resources inside the "Azure Portal" fixes your problem. Just make sure that you have both your production database and storage connections strings defined properly in the W

Categories : Azure

Spatial index in Azure Mobile Services and Xamarin Azure component
Spatial indexes are supported in SQL Database (with some restrictions), see: http://msdn.microsoft.com/en-us/library/windowsazure/ff759530.aspx That said, spatial types are not directly supported with Window Azure Mobile Services; however, you can use converter classes to support additional types that are not handled by the client SDKS. See Carlos Figueira's blog for details.

Categories : Azure

Azure Virtual Network Point-to-Site (ex. Azure Connect) name resolution
I solved this problem by using nbtstat. nbtstat will return the NetBios computer name that correspondent with the ip adres given. As a example: nbtstat -A 10.0.0.5 In Java i created a loop that will check if the given ip is reachable. My Azure VPN range is 10.0.0.x. So my loop will check ip 10.0.0.1 untill 10.0.0.20. If the ip is reachable it will look up the computer name. if the computer name is the computername i was looking for then i have the ip adres to connect to. I use a reachable (ping) to speed up the process. Sample code: Use a loop the check if the ip is reachable. Similar as ping: for (byte i = 1; i <= 20; i++) { inet = InetAddress.getByAddress(new byte[] { 10, 0, 0, i }); System.out.println("Sending Ping Request to " + inet

Categories : Networking

Import file.bacpac in Azure blob container to Azure SQL database
The easiest way to import a bacpac file, whether you're on SQL Azure or local SQL, is to use the Import Data-Tier Application wizard, which can be found on the context menu of the database node in SQL Server Management Studio. Follow the steps to select the bacpac file, and wizard will create a new database for you.

Categories : C#

Azure Virtual Network Point-to-Site (ex. Azure Connect) autoconnect
To solve this problem you can use rasdial. First time i used rasdial i run into this problem: This function is not supported on this system. Don't get fooled by this message because its just that you didn't give the correct syntax. rasdial "Your VPN name" /phonebook:%userprofile%AppDataRoamingMicrosoftNetworkConnectionsCmYour-VPNYour-VPN.pbk" %userprofile% is de user profiel you used to install Azure vpn with. Your-VPN is de name of the azure vpn connection. A simpel methode is to make a batch script: :loop rasdial azureVPN /PHONEBOOK:C:UsersasAppDataRoamingMicrosoftNetworkConnectionsCmazureVPNazureVPN.pbk timeout 10 goto loop result will be: Connecting to test... Verifying username and password... Registering your computer on the network... Successfully connected to test. Comm

Categories : Networking

Azure - running an app in Azure using ADFS returns the following error: Exception message: ID4014: A SecurityTokenHandler is not
Please ensure that in both the ends(ADFS & WIF) same token type is used. Use SAML token for out of the box support from asp.net. Can you post your federationMetadata.xml with certificate keys removed?

Categories : Asp Net Mvc

Azure blob download is incredibly slow using PowerShell (via Get-AzureStorageBlobContent), but fast via Azure Explorer, etc?
Check out Blob Transfer Utility. It uses the Azure api, and its a good bet that is what Azure Explorer is using as well. BTU is open source so it would be much easier to test if its the cmdlet that is the problem.

Categories : Powershell

azure command line tool for linux machine to upload/download data to/from Azure Storage
there's support for upload and download : azure storage blob upload [options] [file] [container] [blob] azure storage blob download [options] [container] [blob] [destination] if not seeing them try to update your cli tools first: npm install azure-cli -g hope this helps

Categories : Linux

"The underlying provider failed on Open" Error when using EF5 Code First with Unity IoC in Azure Worker Role against SQL Azure
Thanks to Arthur Vickers who commented on my question, I'll go ahead and chalk this on up to transient errors due to Azure SQL Database connectivity. I was never able to fully prove this, however, I brought up a SQL VM on Azure and created my DB there then changed my cloud service app to point to that DB instead. Been monitoring the logs, and haven't seen the same issues yet... One potential option, if I return to Azure SQL Db is to roll my own retry logic using Transient Fault Handling block from Microsoft P&P, or use a project like Rob Moore's ReliableDbProvider (https://github.com/robdmoore/ReliableDbProvider). When EF6 comes out, I'll look into using the built in capabilities for transient errors. Hope this helps someone else.

Categories : Entity Framework

How does one access relational data (sql azure) through azure mobile services?
Adrian, The answer is in your question. The mobile service is an abstract layer; that's why you can't access the tables directly. The request from the phone comes to the mobile service, which allows you to run logic, then turns around and accesses the database on your behalf. It's best that ways for many reasons, including connection pooling and security. For details on how the operations work, check out the MSDN documentation on the Mobile Service REST protocol that makes this work. Thanks Herve

Categories : Azure

What is the difference between an Azure Web Site and an Azure Web Role (July '13 edition)
Nowadays you have the following execution models: -Web Sites -Cloud Services (Worker Role / Web Role) -Mobile Services -Virtual Machines What are the differences between Cloud Services and Web Sites. -Cloud Services: You could integrate with Team Foundation Services and allow it to publish to Azure. (Continuous Delivery). With Cloud Services (Web Role), you have two environments in Azure, staging and production. You can use Staging to validate, and with one click (swap option), apply the new deployment package to production environment. -Web Sites: Web Sites is the right option when you want to create a simple web site. It is also a good choice for creating a low-administration web application, even one that must be quite scalable, or moving an existing IIS web app to the public clo

Categories : Asp Net Mvc

Create Azure Media services Job from Azure Shared Website
Problem that in order to work with certificates which are used by media services sdk to encrypt content asp.net process need to have required permissions to operate with certificates. Unfortunately, the behavior described in question is expected and there is no current way to relax this security policy within the Window Azure Websites. If it is not critical for your case to use any encryption method for assets, Try to explicitly set AssetCreateOptions to AssetCreationOptions.None to avoid operating with certificates IAsset asset = _dataContext.Assets.Create("Test", AssetCreationOptions.None);

Categories : C#

best design solution to migrate data from SQL Azure to Azure Table
I would not recommend using local storage primarily because It is transient storage. You're limited by the size of local storage (which in turn depends on the size of the VM). Local storage is local only i.e. it is accessible only to the VM in which it is created thus preventing you from scaling out your solution. I like the idea of using queues, however I see some issues there as well: Assuming you're planning on storing each row in a queue as a message, you would be performing a lot of storage transactions. If we assume that your row size is 64KB, to store 30 GB of data you would be doing about 500000 write transactions (and similarly 500000 read transactions) - I hope I got my math right :). Even though the storage transactions are cheap, I still think you'll be doing a lot of tr

Categories : Azure

Can I use Neudesic Azure Storage Explorer to access Azure China?
My guess is that Azure Storage Explorer has hard coded URL endpoints for storage. Which when they were all the same, that made sense. I'm ASSUMING that storage endpoints in China are different from all the others. Which would lead me to think that the Storage Explorer tool would need an update to handle the Chinese locations.

Categories : Azure

Azure Diagnostic is not saving logs in azure tables
You don't need to add any custom instrumentation code to your OnStart() method if you deploy a diagnostics.wadcfg file. The problem lies in the ServiceConfiguration.Cloud.cscfg file that contains "DevelopmentStorage=true" -- replace it with your real storage account or make sure that your deployment tool does it.

Categories : Asp Net Mvc

Azure mobile service for Android using Azure database
Check this out. See the "Update the app to use the mobile service for data access" section. private MobileServiceClient mClient; private private MobileServiceTable<ToDoItem> mToDoTable; mClient = new MobileServiceClient("MobileServiceUrl", "AppKey", this) .withFilter(new ProgressFilter()); mToDoTable = mClient.getTable(ToDoItem.class); mToDoTable.where().field("complete").eq(false) .execute(new TableQueryCallback<ToDoItem>() { public void onCompleted(List<ToDoItem> result, int count, Exception exception, ServiceFilterResponse response) { if(exception == null){ mAdapter.clear(); for (ToDoItem item : result) { mAdapter.add(item);

Categories : Android

Azure Cloud Service App trying to connect to (localdb) instead of Azure SQL
Try adding a </clear> before the "add"? <connectionStrings> </clear> <add name="DefaultConnection" connectionString="Server=tcp:xmeg1h7x57.database.windows.net,1433;Database=RS.Core.Objects.RoomScopeData;User ID=RSAdmin@xmeg1h7x57;Password=**********;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;" xdt:Transform="SetAttributes" xdt:Locator="Match(name)" /> </connectionStrings>

Categories : C#

Azure Storage Table with relations stored in Azure SQL
I might be missing something, but frankly I can't see a single good reason to do this. One major reason one would use a relational database is to store relational data, maintain referential integrity, and rely on the query optimizer to make efficient joins. However since you are not storing the related user or book data in the same database, you cannot create a foreign key constraint on either, nor join data across tables since it does not exist. In fact it's worse because first you have to fetch data from the SQL database, then you have to go out to table storage to get the rest of the data, so you would be making a connection to two different services just to retrieve one list of data.

Categories : Azure

Which version of Azure SDK is used on the Azure Platform?
I would venture to say that there are two possibilities (in order of likely-hood): 1) CopyLocal=True for the ServiceRuntime and it should be false. ServiceRuntime is already deployed on the Azure machines. You don't want to deploy your own. 2) Somehow your Cloud service config is configured to use an older version of Azure which is forcing the deployed VM to use SDK 2.0 or lower while your code is expecting v2.1. Make sure that osFamily, osVersion, and schemaVersion all are up to sniff with respect to being on 2.1 (I believe schemaVersion is what defines the proper Azure SDK version)

Categories : Azure

Use Azure Mobile Service Scheduled Task to Access Azure Service Management REST Api
Management certificate is just a standard certificate file (.cer) (X.509 v3). You can put the contents in a string (Don't kill me for suggesting this) or a table which your script would read. Once you have the certificate content in hand as a string, you can attach it to the HTTPS request you are making to the Azure service management API. Nate Good has a nice post on how to achieve this with nodejs. He is reading the certs from files, so you'll have to change that part and replace it with your cert strings.

Categories : Node Js

How to add redirection rule and rewrite rule in Azure for xcart application hosted in azure
You need to look at IIS url rewrite module for redirection and rewrite. See here. This tool basically writes the rules to web.config file. Update:What you can do is, on a machine with IIS installed, install this module. Then run this tool locally and create rules using this tool. This tool will write the changes to web.config file of the app on which you try to run this tool. See this example Google and you may find some migration tool.

Categories : Azure

Window Azure vs Citrix Xenapp vs Citrix XenDesktop over Windows Azure
Yes, Citrix XenDesktop 7 can be deployed on Windows Azure, with support for features such as live session roaming, multiple device types and formats, and rich user-interface media experiences. For the announcement refer to Citrix Enables High-Performance App and Desktop Delivery from Windows Azure. For an explanation refer to Hosting Citrix Desktops from Windows Azure. This ability is supported by Microsoft's RDS (Remote Desktop Services) Subscriber Access Licensing (SAL) available for Azure. For more information about licensing refer to this blog article: Remote Desktop Services are now allowed on Windows Azure and also to the latest Microsoft Product Use Rights docs.

Categories : Azure

Unable to connect to Windows Azure from Powershell Azure Powershell module
To see is there some result from Import-AzurePublishSettingsFile you can call: Get-AzureSubscription By default it select the default to current subscription. If you don't see any result then you don't import your subscription settings right. This Introduction to Windows Azure PowerShell also can help you.

Categories : Windows

How do I migrate an existing Windows Azure VM to a Windows Azure virtual network?
I haven't verified the flow, but it should be working fine. Follow these steps: Make sure you are not using static IP on your AD/DC. The IP Addresses in Azure shall always be DHCP allocated! Shut down the AD/DC Copy the VHD blob to a new blob! I strongly suggest that you have the OS Disk (VHD blob) in a storage account which is in the same affinity group as the Virtual Network. So, if the current OS Disk is not in a Storage Account, which is in the same affinity group as the VNet, create a new storage account and copy the original VHD there. Please note that you should copy the blob only when the VM is shut down! Create the sub-net you want to bring the VM in. (probably you already have created it). Create a new VM using the copied VHD as an OS Disk and selecting the Virtual Network and

Categories : Azure

Azure: Upgrading to Azure SDK v2.1
I would not recommend blindly updating the libraries as there have been significant changes. Storage client library 2.0 (which is part of SDK 2.1) is drastically different (though much better IMHO) from previous versions. There have been namespace changes, some methods were removed. Diagnostics libraries in SDK 2.1 have a dependency on Storage Client library 2.0. Again, I would not recommend upgrading that either. My recommendation would be to evaluate the impact of upgrading libraries from 1.6 to 2.0. Please go through the following blog posts by storage team: http://blogs.msdn.com/b/windowsazurestorage/archive/2012/10/29/introducing-windows-azure-storage-client-library-2-0-for-net-and-windows-runtime.aspx http://blogs.msdn.com/b/windowsazurestorage/archive/2012/10/29/windows-azure-s

Categories : Asp Net Mvc

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

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

Azure ACS Set Up in C#
I too have gone through similar pain in recent past. I was a complete newbie with this and had quite a hard time understanding all this. I found Pluralsight Courses from Dominick Baier quite useful in understanding these concepts. Now coming to your questions. I have got an MVC controller action, I want to tell users here are the Identity Providers (IP) that they can use, and their respective URLs as well as generating the tokens that will be verified in step (3), below. How do I get to this in a C# code? Do take a look at this blog post for creating the login page on your end: https://www.simple-talk.com/cloud/development/creating-a-custom-login-page-for-federated-authentication-with-windows-azure-acs/ Once, the client, ACS, IP are done with their business, I don't care

Categories : Asp Net

Regarding Azure Framework
If you're looking for something similar to storage client library, unfortunately no such thing similar to that exists today for managing VMs. However there're a few options: You can use Windows Azure PowerShell Cmdlets You can use Windows Azure Command Line (CLI) Tools Both of them can be downloaded from here: http://www.windowsazure.com/en-us/downloads/. Furthermore, the source code for both of them is available on Github: https://github.com/WindowsAzure/. Yet another alternative is to use Azure Fluent Management Library by Elastacloud guys. This is again open source and is available via NuGet. More information about this library can be found here: http://fluentmanagement.elastacloud.com/.

Categories : Azure



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